Saturday, 2 May 2020

PO requisition Interface in oracle apps r12

PO requisition Interface in oracle apps r12

In this post , We will be discuss about PO requisition Interface in oracle apps r12. PO requisition Interface helps to import the PO requisition from external source or application into the oracle apps r12. We can upload the PO requisition from external sources using the PO requisition interface in oracle apps r12. We have two options to create the PO requisition in oracle apps r12. We can either create the PO requisition manually from the application and we can also create the PO requisition automatically from PO requisition interface in oracle apps r12. PO requisition interface helps to mass upload/create the PO requisitions in oracle apps in a very short time span. Here below we will discuss in detail about PO requisition interface in oracle apps r12.

PO requisition Interface in oracle apps r12
PO requisition Interface in oracle apps r12

3 Important steps for PO requisition Interface in oracle apps r12  

1. Prepare the PO requisition into the format of PO requisition Interface.
2.Insert the PO requisition data into the PO requisition Interface.
3.Run the Oracle apps standard program 'Requisition Import' to import the PO requisition data from Interface tables into the Oracle apps system.

PO requisition Interface Table in oracle apps r12


1.PO_REQUISITIONS_INTERFACE_ALL


2 Options to Import PO Requisition in Oracle apps r12

1.Using the Interface Table as below.


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,                               
             26876,--6439 ,                           
             L_EMPLOYEE_NUMBER,                        --One Time Header Description
             L_EMPLOYEE_NUMBER,                        --One Time Item Description
             233333,
             223333,
             'Y',
             I.PER_INFORMATION18,
            'EXTERNAL SOURCE',
             L_PERSON_ID,
             SYSDATE,
              PO_REQUISITION_HEADERS_S.NEXTVAL
            );



After inserting the Data into the PO requisition Interface table , We need to run the  'Requisition Import'. After Import , We need to verify these below base tables. 

1.PO_REQUISITION_HEADERS_ALL
2.PO_REQUISITION_LINES_ALL
3.PO_REQ_DISTRIBUTIONS_ALL

PO requisition Interface in oracle apps r12


PO requisition Interface in oracle apps r12
PO requisition Interface in oracle apps r12

0 comments:

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *