Oracle R12 procurement receipt process (PR-PO-RCV-AP-Payment)

Source: Internet
Author: User


1. Requisitions

Path: Purchasing> Requisitions


There are only two types of requisitions. One is Internal Requisition, which is used for material application between Internal organizations; the other is Purchase Requisition, which is used to generate PO, apply for procurement from external suppliers.

Tables

The procurement application mainly involves the following three tables: PO_REQUISITION_HEADERS_ALL, PO_REQUISITION_LINES_ALL, PO_REQ_DISTRIBUTIONS_ALL.

The header table and the lines table are associated through REQUISITION_HEADER_ID. header <-1... *-> lines

The lines table and the distributions table are correlated through REQUISITION_LINE_ID. lines <-1... *-> distributions


PO_REQUISITION_HEADERS_ALL

PO_REQUISITION_HEADERS_ALL stores information about requisition headers. You need one row for each requisition header you create. Each row contains the requisition number, preparer, status, and description.
.
REQUISITION_HEADER_ID is the unique system-generated requisition number. REQUISITION_HEADER_ID is invisible to the user. SEGMENT1 is the number you use to identify the requisition
In forms and reports. Oracle Purchasing generates SEGMENT1 using the PO_UNIQUE_IDENTIFIER_CONTROL table if you choose to let Oracle Purchasing generate requisition numbers for you.
.
PO_REQUISITION_HEADERS_ALL is one of three tables storing requisition information. PO_REQUISITION_HEADERS_ALL corresponds to the Header region of the Requisitions window.
.
SEGMENT1 provides unique values for each row in the table in addition to REQUISITION_HEADER_ID.

PO_REQUISITION_LINES

PO_REQUISITION_LINES stores information about requisition lines. you need one row for each requisition line you create. each row contains the line number, item number, item category, item description, need-by date, deliver-to location, item quantities, units, prices, requestor, notes, and suggested supplier information for the requisition line.
.
LINE_LOCATION_ID identifies the purchase order shipment line on which you placed the requisition. LINE_LOCATION_ID is null if you have not placed the requisition line on a purchase order.
BLANKET_PO_HEADER_ID and BLANKET_PO_LINE_NUM store the suggested blanket purchase agreement or catalog quotation line information for the requisition line.
PARENT_REQ_LINE_ID contains the REQUISITION_LINE_ID from the original requisition line if you exploded or multisourced this requisition line.
.
PO_REQUISITION_LINES is one of three tables storing requisition information. This table corresponds to the Lines region of the Requisitions window


PO_REQ_DISTRIBUTIONS_ALL

PO_REQ_DISTRIBUTIONS_ALL stores information about the accounting distributions associated with each requisition line. Each requisition line must have at least one accounting distribution.
You need one row for each requisition distribution you create. Each row where the Accounting Flexfield ID and requisition line quantity.
.
PO_REQ_DISTRIBUTIONS_ALL is one of three tables storing your requisition information. This table corresponds to the requisition Distributions window, accessible through the Requisitions window


Fields in the PO_REQ_DISTRIBUTIONS_ALL table corresponding to the three Account information in Distribution

Debit (DR): CODE_COMBINATION_ID,

Credit (CR): ACCRUAL_ACCOUNT_ID,

Variance: VARIANCE_ACCOUNT_ID

All three accounts can be found in GL_CODE_COMBINATIONS_KFV.

Queries

SELECT * FROM PO_REQUISITION_HEADERS_ALL WHERE segment1 = '20140901 ';

SELECT line. * FROM PO_REQUISITION_HEADERS_ALL header, PO_REQUISITION_LINES_ALL line
WHERE header. REQUISITION_HEADER_ID = line. REQUISITION_HEADER_ID
AND header. segment1 = '20140901 ';

SELECT * FROM PO_REQUISITION_LINES_ALL line, PO_REQ_DISTRIBUTIONS_ALL dis
WHERE line. REQUISITION_LINE_ID = dis. REQUISITION_LINE_ID
AND line. REQUISITION_HEADER_ID IN (SELECT REQUISITION_HEADER_ID FROM PO_REQUISITION_HEADERS_ALL WHERE segment1 = '20140901 ');


2. AutoCreate

AutoCreate is used to convert PR to PO


Path: Purchasing> AutoCreate

NOTE: If PR cannot be found, check whether the Buyer or Ship-To inputs are correct. You can clear the two fields and check again.

Here we use the Automatic mode to generate the PO, and then the window will pop up, enter necessary information about the necessary purchase order, such as the supplier, currency...

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • Next Page

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.