Oracle Purchasing Approvals setup

Defining Approval Groups

Use the Approval Groups window to define and update approval groups. Once you have defined an approval group here, you can then use it to assign approval functions to jobs or positions in the Approval Assignments window. You cannot delete an approval group that is used in an active assignment. You can enable or disable the entire approval group, or you can enter inactive dates for individual approval rules.

Define Buyers in Oracle Purchasing

Use the Buyers window to define and maintain your buyers. Buyers can review all requisitions using the Requisitions window, and only buyers can enter and autocreate purchasing documents. See the Document Types window for rules governing access to documents.

Steps:

Note: Creating the Job, Position, Person in US HRMS Manager (Ref: General Ledger Topic name Journal Approval)

Oracle Purchasing Important Queries

--Purchase Order, Requisition and Receipt Details Query

SELECT prh.segment1 requisition_number,

       prl.line_num requisition_line_num,

       ph.segment1 po_num,

       pl.line_num po_line_num,

       rsh.receipt_num receipt_num,

       rsl.line_num receipt_line_num,

       pll.line_location_id,

Oracle Apps R12 Purchasing Financials Options

Financials Options:

Use the Financials Options window to define the options and defaults that you use for your Oracle Financial Application(s). Values you enter in this window are shared by Oracle Payables, Oracle Purchasing, and Oracle Assets. You can define defaults this window to simplify supplier entry, requisition entry, purchase order entry, invoice entry, and automatic payments. Depending on your application, you may not be required to enter all fields.