Wednesday, November 23, 2011

PO_REQUISITIONS_INTERFACE_ALL

Purchasing
Table Or View: Table

Important columns: 
TRANSACTION_ID :  Transaction unique identifier
PROCESS_FLAG :  Transaction processing state
INTERFACE_SOURCE_CODE VARCHAR2 : Interface transaction source
INTERFACE_SOURCE_LINE_ID :  Interface transaction reference column
SOURCE_TYPE_CODE :  Requisition source
REQUISITION_HEADER_ID : Requisition header unique identifier
AUTHORIZATION_STATUS : Authorization status type

Description: 
PO_REQUISITIONS_INTERFACE_ALL contains requisition information from other applications. Each row includes all the information necessary to create approved or unapproved requisitions in Oracle Purchasing. The Oracle Purchasing Requisition Import feature uses this information to create new requisition headers, lines and distributions.
 
You use the Submit Request window to launch the Requisition Import program for any set of rows. 

You identify the set of rows you want to import by setting the INTERFACE_SOURCE_CODE and BATCH_ID columns appropriately in the interface table.
 
The Requisition Import program validates your data, derives or defaults additional information and writes an error message for every validation that fails into the PO_INTERFACE_ERRORS table. 

Then the program groups and numbers requisition lines according to the criteria you specify in the GROUP_CODE and REQ_NUMBER_SEGMENT1 columns, and creates new requisitions.
 
Most of the columns in the PO_REQUISITIONS_INTERFACE_ALL table are identical to the corresponding columns in the PO_REQUISITIONS_HEADERS_ALL, PO_REQUISITION_LINES_ALL and PO_REQ_DISTRIBUTIONS_ALL tables. You can additionally enter reference information in the INTERFACE_SOURCE_LINE_ID column.

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect