Script to get PHONE NO with area code of the customer in Oracle apps
Introduction This Post illustrates the steps required to get PHONE NO with area code of the customer in Oracle EBS R12. Script to get PHONE NO with area code of…
Read MoreOracle API Script for SHIP CONFORMATION Using-(WSH_DELIVERIES_PUB.Delivery_Action)
Introduction This Post illustrates the steps required to ship conform the sales order using Oracle API Script in Oracle EBS R12 Script to Oracle API for SHIP CONFORMATION Using(WSH_DELIVERIES_PUB.Delivery_Action) Declare…
Read MoreOracle API Script for pick Release the Sales order
Introduction This Post illustrates the steps required to pick release for sales order through oracle API script in Oracle EBS R12 Script to Oracle API Script for pick Release for…
Read MoreScript for Create and book sales order in oracle apps
Introduction: This Post illustrates the steps required to create and book sales in Oracle EBS R12 Script to OE_ORDER_PUB.PROCESS_ORDER ( Sample Script Create and Book for Sales Order ) Declare…
Read MoreQuery for retrieve the Internal Requisition and Internal Sales Order Details in oracle apps
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 MoreScript to delete the employee record using API in oracle Apps
Introduction 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 MoreScript to get Cash from Property Manager
Introduction 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 MoreScript for get EMAIL information of the customer in oracle Apps
Introduction 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 MoreSQL Query for extracting the late fee data for customers in R12 Oracle Apps
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 MoreScript for customers bill to email address in R12 Oracle Apps
Introduction 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 More