Introduction This Post illustrates the steps required to extracting the late fee data for customers in Oracle EBS R12. Script to SQL Query for extracting the late fee data for…
Read MoreIntroduction This Post illustrates the steps required to get customers bill to email address in Oracle EBS R12 Script to customers bill to email address in R12 Oracle Apps FUNCTION…
Read MoreIntroduction: 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 More