Introduction This Post illustrates the steps required to retrieve Internal Requisition and Internal Sales Order Details in Oracle EBS R12. Script to Query retrive Internal Requisition and Internal Sales Order SELECT prh.segment1 ir_number,…
Read MoreIntroduction This Post illustrates the steps required to delete the employee record using API in Oracle EBS R12 Script to delete the employee record using API –-Create Table create table papf_16082018 (person_id…
Read MoreIntroduction This Post illustrates the steps required to get Cash from Property Manager in oracle Apps Script to get Cash from Property Manager CREATE OR REPLACE FUNCTION APPS.PN_CASH(p_payment_item_id number, p_ccid number)…
Read MoreIntroduction This Post illustrates the steps required to get EMAIL information of the customer in Oracle EBS R12 Script to get EMAIL information of the customer SELECT LISTAGG( cont_point.EMAIL_ADDRESS,’|’) WITHIN GROUP…
Read MoreIntroduction 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 More