Query for API to Update Profile Value – Local to SSO
Introduction 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 MoreQuery to extract FA details based on the asset book
Introduction: 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 MoreUpdate Task Information using PA_TASKS_PKG.UPDATE_ROW, PA_PROJ_TASK_STRUC_PUB.UPDATE_TASK_STRUCTURE2 in Oracle Projects
Description: 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 MoreOracle Blanket Sales Agreement Loader API
Description: 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 MoreOracle 18c- From a Developer’s Perspective
Description: 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 MoreORA-30006: resource busy; acquire with WAIT timeout expired and ORA-00054: resource busy and NOWAIT specified
Description: 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 MoreAWR REPORT
Description 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 MoreSGA Details – JROD COPY
Description: 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 MoreScript to get Aging Bucket Due for Customer
Description: Aging reports help to identify how old the customer Invoice due for the payment. This helps to identify and to decide those Invoice is due last 30 or Last…
Read MoreQA Collection Elements creation
Description: The collection elements that you define can be added to collection plans to determine what quality results data to collect, track, and report. API used for EAM preventive collection…
Read More