Oracle Application Blog

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

OAF Date Converter, Formatter and Validation – Reusable Methods

Various Date Converter, Formatter and Validations Reusable Methods in OAF /**=============================================== * Methods related to Date Operation Starts Here * =================================================*/ /** * Method that returns the current system date.…

Read More

Item Category Creation R12

Introduction  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