Tuesday, 27 May 2025

Oracle Apps : Query to get the Position details of an employee in R12.1.3

›
The below query gives the details of an employee's current position in Oracle Apps R12.1.3. SELECT papf.person_id ,papf.full_...
Saturday, 29 March 2025

Oracle Apps : Query to get the Purchase Order (PO) details along with the Requisition details in R12.1.3

›
  The below gives the details of a Purchase Order (PO) details along with the Requisition details in Oracle Apps R12.1.3. SELECT poh...

Oracle Apps : Query to get the Bill-To, Ship-To and the Location details of a customer in R12

›
The below gives the details of a customer's Bill-To and Ship-To details along with the location/address details in Oracle Apps R12.1.3 ...

Oracle Apps: PO went to Pre-Approved status instead of Approved status

›
The below is an issue which we encountered in our   R12 12.1.3 TEST instance. I am posting this here, just in case it helps anyone else havi...

Oracle Apps : Approval List could not be generated

›
The below is an issue which we encountered in our   R12 12.1.3 TEST instance. I am posting this here, just in case it helps anyone else havi...
Wednesday, 15 May 2024

Oracle Apps : Global Descriptive Flexfield not enabling for Malaysia on AR Transaction Form

›
For one of our customers, we enabled the Global Descriptive Flexfield (GDFF) for India and Malaysia.  The GDFF appeared successfully for Ind...
Saturday, 11 May 2024

PL/SQL: Sample code for submitting a DBMS_SCHEDULER jobs

›
 In this post I will provide a sample simple code to submit a dbms_scheduler job. Create a procedure. You can create a procedure inside a pa...