Script to get Oracle i-expense Line attachments
Introduction This Post illustrates steps required to get Oracle i-expense Line attachments in Oracle EBS R12. SELECT fl.* FROM apps.fnd_documents_tl fdtl, apps.fnd_documents …
Read MoreReceivables to GL Link in 11i
Introduction This Post is about to Receivables to GL Link in 11i. SELECT je_header_id, line_number, trx_number, myrank, item_number,customer_number, customer_name, SOURCE, CATEGORY, batch_name,transaction_date, posted_date, period_name, currency_code,account_number, description, CASE WHEN my…
Read MoreFunction to calculate Item Cost
Introduction This Post illustrates the steps required Function to calculate Item Cost in Oracle EBS R12. Script to Function to calculate Item Cost. CREATE OR REPLACE FUNCTION XXTTK_ITEM_COST (P_INV_ITEM_ID IN…
Read MoreQuery to get Detail Customer Information
Introduction This Post illustrates the steps required to get Detail Customer Information query in Oracle EBS R12. Script to get Detail Customer Information. SELECT DISTINCT hp.party_name “Customer Name”, hca.account_number,…
Read MoreQuery to Get Employee Supervisor Relationships
Introduction This Post is about to Get Employee Supervisor Relationships Query in oracle R12. Query to Get Employee Supervisor Relationships. SELECT DISTINCT LPAD(‘ ‘,5*(LEVEL-1)) || PPF.FULL_NAME, PERA.SUPERVISOR_ID, PERA.PERSON_ID, PER_JOBS.NAME JobName,…
Read MoreAPI To end date the user and responsibilities in Oracle apps
Introduction This Post illustrates the steps required to through API(Application program interface) end date the user and their responsibilities in Oracle EBS R12. Script to through API end date the user and their responsibilities…
Read MoreScript 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 More