Monday, August 31, 2009

creation of Purchase order in oracle payable R12

THese are the minimum columns required to creat purchase order in R12.
The three interface tables has to be populated in order to create purchase order in R12.
The tables are as follows
Po_HEaders_Interface
Po_lines_Interface
PO_DISTRIBUTIONS_INTERFACE
The insert into query along with minimum column required are given as follows.

INSERT INTO PO_HEADERS_INTERFACE (
INTERFACE_HEADER_ID
,BATCH_ID
,ACTION
,DOCUMENT_TYPE_CODE
,VENDOR_ID
,VENDOR_SITE_ID
,AGENT_ID
,TERMS_ID
,ORG_ID
,CURRENCY_CODE
,SHIP_TO_LOCATION_ID
,BILL_TO_LOCATION_ID
,APPROVAL_STATUS
-- ,DOCUMENT_NUM
,COMMENTS
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
)




INSERT INTO PO_LINES_INTERFACE (
INTERFACE_HEADER_ID
,INTERFACE_LINE_ID
,LINE_NUM
,ITEM_ID
,UOM_CODE --UNIT_OF_MEASURE
,QUANTITY
,UNIT_PRICE
,PROMISED_DATE
,NEED_BY_DATE
,TERMS_ID
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
,SHIP_TO_ORGANIZATION_ID
,SHIP_TO_LOCATION_ID
)


INSERT INTO PO_DISTRIBUTIONS_INTERFACE(
INTERFACE_HEADER_ID
,INTERFACE_LINE_ID
,INTERFACE_DISTRIBUTION_ID
,QUANTITY_ORDERED
,CHARGE_ACCOUNT_ID
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
)


go to payables and import the po information using po import program.

cheers!!

No comments:

Post a Comment