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.

Oracle Purchasing AME Tables and APIs

 Main Tables:

·         ame_calling_apps – This table stores application_name and transaction_type_id for a particular document_type.

For example: For Purchase Requisition, this table has transaction_type_id of PURCHASE_REQ, which is a seeded  value. Only if we setup the  Approval Transaction Type as PURCHASE_REQ for Purchasing Requisition document type(as seen in setup screen shot in the previous slide), AME will be called for building approver list