Oracle Application Blog

R12.2 cloning process adcfgclone fails with error

 Error: Below Oracle Homes are already registered in the global inventory: /u01/oracle/R122/fs1/FMW_Home/oracle_common /u01/oracle/R122/fs1/FMW_Home/webtier /u01/oracle/R122/fs1/FMW_Home/Oracle_EBS-app1 Cause: The above Oracle Homes are already registered from the global inventory Solution: Make sure that…

Read More

adformsctl.sh: exiting with status 150

Problem: If adoacorectl.sh,adformsctl.sh,adoafmctl.sh not coming up after start the application services adoacorectl.sh: exiting with status 150 adformsctl.sh: exiting with status 150 adoafmctl.sh: exiting with status 150 Check the log file…

Read More

ORA-20100: Error: FND_FILE failure. Unable to create file in the directory

Problem details: The Concurrent program is getting completed successfully, able to view output & logfile. But in the log file, it shows below error. Oracle error 20100: java.sql.SQLException: ORA-20100: Error:…

Read More

Query to get price list details for an item

Introduction This blog explains how to get pricelist details for an item #Code# SELECT QLH_TL.NAME “List Price” ,QLH_TL.DESCRIPTION “Description” ,QLH_TL.VERSION_NO “Version” ,QLH_B.LIST_TYPE_CODE “List Type” ,QLH_B.CURRENCY_CODE “Curr Code” ,MSI.SEGMENT1 “Item Number”…

Read More

Concurrent request receiving Could Not Lock Request when canceling

          After submitting concurrent request, the phase of the request is RUNNING and never completing. When we search for the database session, it is not having…

Read More

FRM-41830 list of values contains no entries

ERROR:   FRM-41830   FRM-41830 list of values contains no entries   SOLUTION:   I have changed the profile option for particular user at the site level so the changes…

Read More

resolving libdb.so.2: cannot open shared object file: No such file or directory issue

ERROR:  libdb.so.2: cannot open shared object file: No such file or directory CAUSE: While creating a new clone with R12.1.3 when starting the Apache i get the errors: error while…

Read More

How to reset apps password

Introduction  This blog explains how to reset the Oracle apps password from the backend. #Code# BEGIN FND_USER_PKG.UPDATEUSER (X_USER_NAME => ‘USERNAME’ , X_OWNER => ‘APPS’ , X_UNENCRYPTED_PASSWORD => ‘Pasword@123’ , X_PASSWORD_DATE…

Read More

Mobile First strategy with Oracle CX Mobile App

Enterprise are emphasizing on building a culture of proactive sales with responsibility of identifying leads,new account openings and agility in closing deals. To achieve this, organizations are looking towards recent…

Read More

Query To get DFF Details

Introduction  A flexfield is a customizable flexible data field that you can customize according to business needs without coding. Oracle Applications uses two types of flexfields, key flexfields and descriptive flexfields. A key flexfield is…

Read More