Requisition interface table oracle

Requisition interface table oracle

In this post, we will discuss about Requisition interface table oracle. Requisition interface table oracle helps to import the po requisitions from the external system as well as from other modules in the oracle application to the Purchase requisition base tables. In oracle requisition import api we first insert the requisitions from external system to the oracle requisition interface tables and then after that we run the standard concurrent program ‘requisition import’ to import the requisitions from external system to the Oracle requisitions base tables. Here below I will share the same code using Requisition interface table oracle.

 

Example of Requisition interface table oracle

Step 1:-To create Po requisition in oracle apps we are using the PO_REQUISITIONS_INTERFACE_ALL table to import the Requisitions from External system.

Step2:-Import the Standard Concurrent Program ‘Requisition Import’ to import the requisitions from the interface table to the requisitions bases tables.

Step3:- Verify in the Po requisition base table for specific transactions.

PO_REQUISITION_HEADERS_ALL

PO_REQUISITION_LINES_ALL

PO_REQ_DISTRIBUTIONS_ALL

INSERT INTO PO_REQUISITIONS_INTERFACE_ALL (INTERFACE_SOURCE_CODE,

                                           ORG_ID,

                                           DESTINATION_TYPE_CODE,

                                           AUTHORIZATION_STATUS,

                                           PREPARER_ID,

                                           --PREPARER_NAME,

                                           CHARGE_ACCOUNT_ID,

                                           SOURCE_TYPE_CODE,

                                           UNIT_OF_MEASURE,

                                           LINE_TYPE_ID,

                                           CATEGORY_ID,

                                           UNIT_PRICE,

                                           QUANTITY,

                                           DESTINATION_ORGANIZATION_ID,

                                           DELIVER_TO_LOCATION_ID,

                                           DELIVER_TO_REQUESTOR_ID,

                                           HEADER_DESCRIPTION,

                                           ITEM_DESCRIPTION,

                                           SUGGESTED_VENDOR_ID,

                                           SUGGESTED_VENDOR_SITE_ID,

                                           --ACCRUAL_ACCOUNT_ID ,

                                           --VARIANCE_ACCOUNT_ID,

                                           --BUDGET_ACCOUNT_ID,

                                           HEADER_ATTRIBUTE1,

                                           HEADER_ATTRIBUTE2,

                                           HEADER_ATTRIBUTE3,

                                           HEADER_ATTRIBUTE4,

                                           GL_DATE,

                                           REQUISITION_HEADER_ID                                          

                                           )

     VALUES ('IMPORT_REQ',                                  --Interface Source

             4567,                                             --Operating Unit

             'EXPENSE',                                     --Destination Type

            'INCOMPLETE',       -- 'APPROVED',--                                     --Status

             4455,--6439,                      --This comes from per_people_f.person_id

            -- '???? ??? ????? ????? ?????????',

             122333,                                      --Code Combination ID

             'VENDOR',                                           --Source Type

             'Quantity',                                                     --UOM ok??yes

             1,                                           --Line Type of Goods

             1123,                                           --MISC.MISC Category

             100,                                                       --Price

             1,                                                    --quantity

             108,--102                      --Represents Vision Operations Inv Org.

             142,--162,                                --Represents V1-New York City

             26876,--6439 ,                            --This is the Deliver to Requestor

             L_EMPLOYEE_NUMBER,                        --One Time Header Description

             L_EMPLOYEE_NUMBER,                        --One Time Item Description

             233333,

             223333,

             'Y',

             I.PER_INFORMATION18,

            'eXTERNAL sOURC',

             L_PERSON_ID,

             SYSDATE,

              PO_REQUISITION_HEADERS_S.NEXTVAL

                           );