Posts by Aashik Arsan

Script to import standard purchase order

Introduction:  This blog contains an plsql interface script to import standard purchase order.   Script: DECLARE CURSOR PHEADER IS SELECT * FROM XX_PO_IMP_STG_TABLE;   CURSOR PLINE (P_PO_NUMBER VARCHAR2) IS SELECT…

Read More

Query to get Journal Entry Reserve Ledger Report

Introduction:  This blog contains an SQL query that can be used to run the Journal Entry Reserve Ledger Report. Cause of the issue:  The business requires a report that contains…

Read More