PO Requisition Interface

 Interface tables: PO_REQUISITIONS_INTERFACE_ALL

Base tables:  
PO_REQUISITION_HEADERS_ALL
PO_REQUISITION_LINES_ALL
PO_REQ_DISTRIBUTIONS_ALL

Error Table:
select * from PO_INTERFACE_ERRORS 
                          where Interface_type = 'REQIMPORT'

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