api to create requisition in oracle apps

api to create requisition in oracle apps

In this post, we will discuss about api to create requisition in oracle apps. As such oracle has not provided any api to create the purchase requisitions through API but we have the oracle requisition interface through which we can create the requisitions from the external system. As below I will share the sample code of using requisitions interface which can be use same as api to create requisition in oracle apps to create the PO requisitions from the external system.

As such Oracle has not provided any requisition api in oracle apps r12 to create the PO requisition but Oracle has provided the API to update  or make any new changes in the Purchase requisitions.

Here below is the sample code of api to create requisition in oracle apps but we are using the Interface table in oracle apps r12.

Example of api to create requisition in oracle apps

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,

             122333,                                    

             'VENDOR',                                        

             'Quantity',                                                    

             1,                                   

             1123,                                         

             100,                                                  

             1,                                                    --quantity

             108,                    

             142,

             26876,

             L_EMPLOYEE_NUMBER,                       

             L_EMPLOYEE_NUMBER,                       

             233333,

             223333,

             'Y',

             I.PER_INFORMATION18,

            'eXTERNAL sOURC',

             L_PERSON_ID,

             SYSDATE,

              PO_REQUISITION_HEADERS_S.NEXTVAL

                );