Sreekanth Reddy Pothula's Oracle ERP Blog

Enable the Below 2 Profiles at User Level -  Profile Name User Level Value Hide Diagnostics menu entry No Utilities:Diagnostics Yes  

  While trying to import/export Personalizations from 12.2.4 onwards, it fails with the following error:  Error: Cannot Display Page Documents Imported You cannot complete this task because of the following events caused a loss of page data: - Your login session has expired. - A system failure has occurred. Sometimes the Documents are imported and the import is successful, other times the import fails and only the above error is received. Reproducible Steps: The error occurs under the following navigation path: Functional Administration -> Personalizations ->Import/Export -> Exported Personalizations 1. Select a OAF Personalization  2. Click on Import from File System button Solution: To resolve the issue test the following steps in a development instance and then migrate accordingly: 1. Download  Patch 23119976 :R12.FWK.C, "ORACLE APPLICATIO...

If you ever see that the  Personalization is not editable at Site level for Seeded OAF pages, Please set profile option 'FND: Personalization Seeding Mode' to yes and re-test the issue. In Oracle Applications Framework, if the Profile option FND: Personalization Seeding Mode is set to NULL/No, it would not allow Standard Personalizations to be updated. 

Oracle Purchasing – Receipt Accounting (Accrue On Receipt and Accrue at Period End) Inventory Accruals: Inventory and Purchasing provides visibility and control of accrued liabilities for inventory items. Purchasing automatically records the accrued liability for the inventory items at the time of receipt. This transaction is automatically recorded in the general ledger at the time of receipt. The inventory expense is recorded at delivery if Standard Delivery is used and at receipt if Direct Delivery used. Expense Accruals: Purchasing optionally accrues un-invoiced receipts of non-inventory items when a period is closed. Purchasing automatically creates a balanced journal entry for each receipt un-invoiced at period end which can be reversed at the beginning of the next period. Navigation: India Local Purchasing > Oracle Purchasing > Setup > Organizations > Purchasing Options Difference between 'Accrue On Receipt' and 'Accrue at Per...

After upgrading to R12.2.5, Flexfield View Generator concurrent program completed with error while trying to generate some of the standard Descriptive Flexfield (DFF) Below is the error message -  +---------------------------------------------------------------------------+ Application Object Library: Version : 12.2 Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved. FDFVGN: Flexfield View Generator +---------------------------------------------------------------------------+ Current system time is 02-FEB-2017 17:17:25 +---------------------------------------------------------------------------+ Oracle error 1720: ORA-01720: grant option does not exist for 'HR.PER_ALL_PEOPLE_F#' ORA-06512: at "SYSTEM.AD_DDL", line 188 ORA-06512: at line 1 has been detected in afuddl() [3_xdd]. do_ddl(APPLSYS, PER, 2, $statement$, PER_ALL_PEOPLE_F_DFV): private_do_ddl(APPS, APPLSYS, HR, 2, $statement$, PER_ALL_PEOPLE_F_DFV): do_cd_view(0, APPS,...

Lists all products and their Installation Status SELECT   fat . application_name ,           fa . application_id ,           fpi . patch_level ,           Decode ( fpi . status ,   'I' ,   'Licensed' ,                              'N' ,   'Not Licensed' ,                              'S' ,   'Shared' ,                              'Undetermined' )   STATUS   FROM     fnd_product_installations   fpi ,   ...

As per Oracle, Personalizations on Local Login Page No longer applies for 12.2.5, it is applicable till 12.2.4 only and please find the suggestion made by Oracle for one of the customer. Starting on 12.2.5 the login page is no longer a FWK page. Some customer have asked how to retain the old FWK login page and its customizations. Below is the alternative provided in Oracle eBusiness security Guide Documentation –  1)     In case you want to retain the old page, make a copy of the old AppsLocalLogin.jsp (version 120.12); for example to OldAppsLogin.jsp and compile it.               $FND_TOP/patch/115/bin/ojspCompile.pl --compile -s <specific_jsp>.jsp --flush 2)     Then set the profile APPS_LOCAL_LOGIN_URL = http://server:port/OA_HTML/OldAppsLogin.jsp         NOTE: - Do not to modify AppsLocalLogin.jsp, login.js nor login.css - Use of customer owned...