Oracle Application Blog

Fusion – Sample Payload To Update Descriptive Flexfield On Internet Supplier Portal Invoice

Sample Payload to update AP Invoice Header level DFF attribute: Payload: <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/” xmlns:erp=”http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/”> <soapenv:Header/> <soapenv:Body> <typ:updateDffEntityDetails> <typ:operationMode>single</typ:operationMode> <typ:object> <erp:EntityName>Payables Invoice</erp:EntityName> <erp:ContextValue>JLxMXPayablesInformation</erp:ContextValue> <erp:UserKeyA>DFF-1</erp:UserKeyA> <erp:UserKeyB>Vision Operations sample</erp:UserKeyB> <erp:UserKeyC>XXHealth Care</erp:UserKeyC> <erp:UserKeyD>12136</erp:UserKeyD>…

Read More

Open Account Balances Data Manager (XLATBDMG) / Accounts Payable Trial Balance (APTBRPT) Performance Issue in R12

The “Accounts Payable Trial Balance” / “Open Account Balances Data Manager” report having severe performance issues. The rebuild it self taken more than 4 hours. Also there was too much…

Read More

R12.2: OUI CLI Cloning Failed While Running adcfgclone appstier dualfs With Registration Driver regclone.drv Missing.

Error: When attempting to run command adcfgclone.pl appsTier dualfs while cloning the following error occurs. Exception in getting inventory Loc : null StackTrace: java.lang.NullPointerException at java.io.File.<init>(File.java:251) … continuous…. Command returned…

Read More

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