3 Replies Latest reply on Sep 8, 2015 7:34 AM by 2774197

    PO Conversion- error in Import Standard Purchase Orders Program

    2774197

      Hi Team ,

       

      I could fetch the data into the interface tables

      1. PO_HEADERS_INTERFACE

      2. PO_LINES_INTERFACE

      3. PO_DISTRIBUTIONS_INTERFACE

      But when i try to submit the Import Standard Purchase Orders Program

      ln_request_id := FND_REQUEST.SUBMIT_REQUEST (

                                  application   => 'PO', -- Application Short Code

                                  program       => 'POXPOPDOI', -- Concurrent Program Short NAme

                                  description   => 'Import Standard Purchase', -- Concurrent Program Description

                                  start_time    => SYSDATE,

                                  sub_request   => FALSE,

      argument1 => null

      , argument2 => 'STANDARD'

      , argument3 => null

      , argument4 => 'N'

      , argument5 => 'N'

      , argument6 => ''INITIAL APPROVAL''

      , argument7 => null

      , argument8 => null

      , argument9 => null

      , argument10 => null

      , argument11 => null

      , argument12 => null

      , argument13 => null

      , argument14 => null

      );

        COMMIT;

       

      its getting completed and output file says :

      Enter value for 8: EXEC FND_CONC_STAT.COLLECT;

      Enter value for 9:

      Enter value for 10: EXIT

      Enter value for 8:

      User requested Interrupt or EOF detected.

       

       

       

       

      Also , I could not see any data in PO_INTERFACE_ERRORS table to get the errors and PO_HEADERS_ALL Table.


      Please Advice.



        • 1. Re: PO Conversion- error in Import Standard Purchase Orders Program
          Bashar.

          Hi,

           

          Enclose the values you pass to the request by single quotes and try again.

           

          If it does not work then please post the complete code you use to submit the request.

           

          Regards,

          Bashar

          • 2. Re: PO Conversion- error in Import Standard Purchase Orders Program
            2774197

            Hi Bashar,

            Thanks for reverting back .

            Tried in difference ways but the program ending up in error.Here is the code.

             

             

            DECLARE

            ln_responsibility_id varchar2(2000);

            ln_application_id     varchar2(2000);

            ln_user_id           varchar2(2000);

            ln_request_id            varchar2(2000);

            BEGIN

            MO_GLOBAL.SET_POLICY_CONTEXT('S',204);

            --  FND_GLOBAL.APPS_INITIALIZE (ln_user_id,ln_responsibility_id,ln_application_id);

                FND_GLOBAL.APPS_INITIALIZE (1014539,50578,201); 

                   -- Submitting Concurrent Request

              ln_request_id := FND_REQUEST.SUBMIT_REQUEST (

                                        application   => 'PO', -- Application Short Code

                                        program       => 'POXPOPDOI', -- Concurrent Program Short NAme

                                        description   => 'Import Standard Purchase', -- Concurrent Program Description

                                        start_time    => SYSDATE,

                                        sub_request   => FALSE,

            argument1 => null

            , argument2 => 'STANDARD'

            , argument3 => null

            , argument4 => 'N'

            , argument5 => 'N'

            , argument6 => 'INITIAL APPROVAL'

            , argument7 => null

            , argument8 => null

            , argument9 => null

            , argument10 => null

            , argument11 => null

            , argument12 => null

            , argument13 => null

            , argument14 => null

            );

              COMMIT;

              IF ln_request_id = 0

              THEN

                 DBMS_OUTPUT.PUT_LINE ('Concurrent Request Failed to Submit.');

              ELSE

                 DBMS_OUTPUT.PUT_LINE('Successfully Submitted the Concurrent Request. Request Id: '||ln_request_id);

              END IF;

             

            EXCEPTION

            WHEN OTHERS THEN

              DBMS_OUTPUT.PUT_LINE('Error While Submitting Concurrent Request '||TO_CHAR(SQLCODE)||'-'||SQLERRM);

            END;

             

             

            Here is the error :

             

             

            To get the log messages for PDOI, please use the following id to query against FND_LOG_MESSAGES table: AUDSID = 21826703 ORA-01403: no data found in Package po.plsql.PO_PDOI_PVT. Procedure init_sys_parameters.0 ORA-01403: no data found in Package po.plsql.PO_PDOI_PVT. Procedure init_startup_values.10 ORA-01403: no data found in Package po.plsql.PO_PDOI_PVT. Procedure start_process.50 User-Defined Exception in Package po.plsql.PO_PDOI_Concurrent. Procedure POXPDOI.30

             

            Thanks.

            • 3. Re: PO Conversion- error in Import Standard Purchase Orders Program
              2774197

              output file error : DECLARE * ERROR at line 1: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at line 133