Introduction: This Post illustrates the steps required to getting customer Bill to Contact in Oracle EBS R12. Script to Script for getting customer Bill to Contact in R12 Oracle Apps FUNCTION xx_get_contact…
Read MoreIntroduction This Post illustrates the steps required to do GL Revaluation Accounts in FUSION Application Script to GL Revaluation Accounts SELECT DISTINCT o101368.book_currency AS c_1, (o101368.converted_journal_total_dr * o101368.currency_conversion_rate ) AS…
Read MoreIntroduction This Post illustrates the steps required to Update the profile value Local to SSO through API in Oracle EBS R12 Script to Update Profile Value – Local to SSO Through…
Read MoreIntroduction: This Post illustrates the steps required to extract the FA details based on the asset book in Oracle EBS R12 Script to Query to extract FA details based on…
Read MoreDescription: You can update information for tasks with the Open status. You can answer questions, add comments, and attach references. You can also view status, priority, owner, assignee, schedule, start…
Read MoreDescription: A blanket sales order is a long-term agreement between a seller and a customer. A blanket order is typically made when a customer has committed to purchasing large quantities that are to be delivered in…
Read MoreDescription: Oracle Database 18c is the same database software that is running on-premises as in the Oracle Cloud. It enables end-users to take their in-house developed Oracle applications and third-party applications and run them on Oracle Cloud without…
Read MoreDescription: ORA-30006 and ORA-00054 errors raised when update operation is performed against a record, that has been locked by the user or some session FOR UPDATE. To fix this, before performing the update, check whether…
Read MoreDescription Introduced in Oracle 10g and having evolved from the Statspack functionality of Oracle 8i/9i, the Automatic Workload Repository report or AWR report (as it is more commonly known as)…
Read MoreDescription: The System Global Area (SGA) is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The SGA…
Read More