0 Replies Latest reply on May 14, 2015 5:44 AM by 895624

    Requisition Import Interface Error

    895624

      Hi all,

       

      I an getting the below error while processing Requisition Import Through Interface

       

      The error Populated in PO_INTERFACE_ERRORS is--

      If Oracle Projects is installed and PROJECT_ACCOUNTING_CONTEXT is 'Y' then project, task, expenditure type, expenditure item date and expenditure organization must be valid

      Cause:The project, task, expenditure type, expenditure item date or expenditure organization that you entered is invalid.  These fields are required if the Oracle Projects context is 'Y'

      Action:Enter a valid project, task, expenditure type, expenditure item date and expenditure organization

       

      In Application->Purchasing Screen, I created the Purchase   Requisition With The Project Details Which i have given in the Interface.Requisition Created where as in Interface its Ending with error.

       

      Below Code is for your reference

       

      DECLARE

        L_TRANSACTION_ID NUMBER;

      BEGIN

        SELECT PO_REQUISITIONS_INTERFACE_S.NEXTVAL INTO L_TRANSACTION_ID FROM DUAL;

        INSERT

        INTO PO_REQUISITIONS_INTERFACE_ALL

          (

            INTERFACE_SOURCE_CODE,

            DOCUMENT_TYPE_cODE,

            BATCH_ID,

            transaction_id,

            ORG_ID,

            DESTINATION_TYPE_CODE,

            AUTHORIZATION_STATUS,

            PREPARER_ID,

            SOURCE_TYPE_CODE,

            UOM_CODE,

            LINE_TYPE_ID,

            ITEM_ID,

            UNIT_PRICE,

            QUANTITY,

            DESTINATION_ORGANIZATION_ID,

            DELIVER_TO_LOCATION_ID,

            DELIVER_TO_REQUESTOR_ID,

            multi_distributions,

            req_dist_sequence_id,

            charge_account_id,

            PROCESS_FLAG,

            NEED_BY_DATE,

            LAST_UPDATE_DATE,

            LAST_UPDATED_BY,

            CREATION_DATE,

            CREATED_BY,

            PROJECT_ID,

            TASK_ID,

           PROJECT_ACCOUNTING_CONTEXT,

            EXPENDITURE_TYPE,

            EXPENDITURE_ITEM_DATE,

            expenditure_organization_id

          )

          VALUES

          (

            'MTO REQUISITIONS', --Interface Source

            'PURCHASE',  --DOCUMENT_TYPE_cODE

            1,                               -- batch_id

            L_TRANSACTION_ID,                -- transaction_id

            122,                             --Operating Unit

            'INVENTORY',                     --Destination Type

            'INCOMPLETE',                    --Status

            3498,                            --This comes from per_people_f.person_id

            'VENDOR',                        --Source Type

            'PCS',                           --UOM

            1,                               --Line Type of Goods

            2005,                            -- Item id

            13.66,                             --Price

            5,                               --quantity

            142,                             --dcg

            144,                             --deliver to location id

            3498,                            --This is the Deliver to Requestor

            'Y',                             -- multiple distributions

            PO_REQ_DIST_INTERFACE_S.NEXTVAL, -- dist id

            1003,   

            1,

            SYSDATE+1,

            SYSDATE,

            2533,

            SYSDATE,

            2533,

            2009, --:PRR_BLK.PROJECT_ID,

            18253, --:PRR_BLK.TASK_ID,

          'Y',

          'AL-PROFILES' ,

          SYSDATE,

         142

          );

        INSERT

        INTO po_req_dist_interface_all

          (

            interface_source_code,

            BATCH_ID,

            process_flag,

            transaction_id,

            charge_account_id ,

            distribution_number,

            dist_sequence_id,

            QUANTITY ,

            PROJECT_ID,

            TASK_ID, 

          PROJECT_ACCOUNTING_CONTEXT,

             EXPENDITURE_TYPE,

            EXPENDITURE_ITEM_DATE,

            expenditure_organization_id

          )

          VALUES

          (

            'MTO REQUISITIONS',

            1,

            1 ,

            L_TRANSACTION_ID,

            1003,

            1,

            PO_REQ_DIST_INTERFACE_S.CURRVAL,

            5 ,

            2009, --:PRR_BLK.PROJECT_ID,

            18253, --:PRR_BLK.TASK_ID, 

          'Y',

             'AL-PROFILES' ,

          SYSDATE,

         142   

          ) ;

        COMMIT;

      END;

       

      Please suggest a solution .

      Note:If I exclude Expenditure Details(EXPENDITURE_TYPE, EXPENDITURE_ITEM_DATE,expenditure_organization_id) , I am Able to Create Requisition Through Interface