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 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

Overview of Oracle Apps Purchasing

Oracle purchasing is a comprehensive procurement solution designed to:

         

o    Help purchasing professionals reduce administration costs.

o    Process requisitions, purchase orders, requests for quotation, and receipts quickly and efficiently.

o    Enable you to focus on:

Period Closure Activities For Oracle Apps Implementation

The following is a note on the period closure process entailing the checking of transactional data, running of transfers of transactional data to the General ledger, reviewing/reconciling of reports and closure of periods in Oracle’s modules. These activities can be taken up roughly in the sequence in which they have been detailed below. Several of these activities (like GL transfers, reconciliations) can be performed concurrently prior to the closure of periods. However, the specific activity of closing of periods in respective/relevant modules should take the following order:

Refer the blog post for: 
Oracle Apps Financials period closure monitoring scripts

Closing the AP Month - How it works and what to do

Oracle Purchasing User's Guide

Oracle Purchasing User's Guide
Release 12
Part No. B28669-01

Download PDF Material

Oracle Apps Purchasing FAQs

Q1. What is the difference between 'Accrue On Receipt' and 'Accrue at Period End'?

A: Accrue On Receipt means that when a receipt is saved, accrual transactions are immediately recorded and sent to the general ledger interface. This is also known as "online" accruals. Accrue at Period End means that when a receipt is saved, the accrual transactions are not immediately recorded and sent to the general ledger; instead, the accounting entries are generated and sent at the end of the month by running the Receipt Accruals - Period-End Process.

All items with a destination type of either Inventory and Outside Processing are accrued on receipt. For items with a destination type of Expense, you have the option of accruing on receipt or at period end.