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 MoreIntroduction 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 MoreAfter 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 MoreERROR: 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 MoreERROR: 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 MoreIntroduction 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 MoreEnterprise 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 MoreIntroduction 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 MoreVarious Date Converter, Formatter and Validations Reusable Methods in OAF /**=============================================== * Methods related to Date Operation Starts Here * =================================================*/ /** * Method that returns the current system date.…
Read MoreIntroduction An Item category is a logical classification of items that have similar properties. A category set is a distinct group scheme and consists of categories. The flexibility of category sets allows…
Read More