Download this document : click Here
Interface tables: PO_REQUISITIONS_INTERFACE_ALL
Base tables:
PO_REQUISITIONS_HEADERS_ALL
PO_REQUISITION_LINES_ALL
PO_REQ_DISTRIBUTIONS_ALL
Concurrent program:
REQUISITION IMPORT
Validations:
Check for interface transaction source code, requisition destination type,
quantity ordered, authorization status type.
Some important columns that need to be populated in the interface tables:
PO_REQUISITIONS_INTERFACE_ALL:
INTERFACE_SOURCE_CODE (to identify the source of your imported
Requisitions)
DESTINATION_TYPE_CODE
AUTHORIZATION_STATUS
PREPARER_ID or PREPARER_NAME
QUANTITY
CHARGE_ACCOUNT_ID or charge account segment values
DESTINATION_ORGANIZATION_ID or DESTINATION_ORGANIZATION_CODE
DELIVER_TO_LOCATION_ID or DELIVER_TO_LOCATION_CODE
DELIVER_TO_REQUESTOR_ID or DELIVER_TO_REQUESTOR_NAME
ORG_ID
ITEM_ID or item segment values (values if the SOURCE_TYPE_CODE or
DESTINATION_TYPE_CODE is ‘INVENTORY’)
apps.fnd_request.submit_request
(
application => 'PO',
program => 'REQIMPORT',
description => '',
start_time => TO_CHAR(SYSDATE,'DD-MON-YY HH24:MI:SS'),
sub_request => FALSE,
argument1 => 'INV',--Interface Source code,
argument2 => 1035, ----APPS.SONA_BATCH_ID_S.CURRVAL,--Batch ID,
argument3 => 'ALL',--Group By,
argument4 => '',--Last Req Number,
argument5 => '',--Multi Distributions,
argument6 => 'N'
);
EXAMPLE :
INSERT INTO PO_REQUISITIONS_INTERFACE_ALL(
DELIVER_TO_LOCATION_ID
, DELIVER_TO_REQUESTOR_ID
, AUTHORIZATION_STATUS
, REQUISITION_HEADER_ID
, REQUISITION_TYPE
, CREATION_DATE
, CREATED_BY
, QUANTITY
, UNIT_PRICE
, ITEM_SEGMENT1
, ITEM_DESCRIPTION
, CATEGORY_ID
, CURRENCY_CODE
, PREPARER_ID
, CHARGE_ACCOUNT_ID
, REQ_NUMBER_SEGMENT1
, SOURCE_TYPE_CODE
, HEADER_DESCRIPTION
, BATCH_ID
, DESTINATION_TYPE_CODE
, DESTINATION_ORGANIZATION_ID
, INTERFACE_SOURCE_CODE
, UNIT_OF_MEASURE
,NEED_BY_DATE
,LINE_ATTRIBUTE9
)
VALUES
(
2734 -----> DELIVER_TO_LOCATION_ID
,3336 -----> DELIVER_TO_REQUESTOR_ID
,'INCOMPLETE' -----> AUTHORIZATION_STATUS
,PO_REQUISITION_HEADERS_S.NEXTVAL -----> REQUISITION_HEADER_ID
,'PURCHASE' ----> REQUISITION_TYPE
,SYSDATE ----> CREATION_DATE
,6871 ----> CREATED_BY
,20 ---> QUANTITY
,ln_unit_rate ---> UNIT_PRICE
,ITEM_SEGMENT1 ----->ITEM_SEGMENT1
,ITEM_DESCRIPTION -----> ITEM_DESCRIPTION
,62 ----> CATEGORY_ID
,'INR' -----> CURRENCY_CODE
,3336 -----> PREPARER_ID
,2376 ----> CHARGE_ACCOUNT_ID
,NULL ----> REQ_NUMBER_SEGMENT1
,'VENDOR' ----> SOURCE_TYPE_CODE
,HEADER_DESCRIPTION -----> HEADER_DESCRIPTION
,1035 ---APPS.SONA_BATCH_ID_S.NEXTVAL -----> BATCH_ID
,'INVENTORY' ------> DESTINATION_TYPE_CODE
,DESTINATION_ORGANIZATION_ID -----> DESTINATION_ORGANIZATION_ID
,'INV' ---> INTERFACE_SOURCE_CODE
,ln_unit_measure ----> UNIT_OF_MEASURE
,(sysdate + 10) -----> NEED_BY_DATE
,NULL
);
Download this document : click Here
