1 Reply Latest reply on Sep 26, 2017 11:26 PM by rp0428

    Payables Open Interface Import - Help Please

    user9048178


      I'm not having any luck getting the Payables Open Interface Import program picking up my entries.

       

      I need to import a file and load into the interface tables.

      I would then like to run Payables Open Interface Import and have those records brought into the main tables.

       

      I have the following insert statements:

       

      INSERT INTO AP_INVOICES_INTERFACE
      (
      INVOICE_ID,
      INVOICE_NUM,
      --INVOICE_DATE,
      VENDOR_ID,
      VENDOR_NAME,
      VENDOR_SITE_CODE,
      INVOICE_AMOUNT,
      INVOICE_CURRENCY_CODE,
      TERMS_ID,
      CREATION_DATE,
      CREATED_BY,
      PAYMENT_METHOD_LOOKUP_CODE,
      INVOICE_RECEIVED_DATE,
      ORG_ID,
      --SOURCE,
      INVOICE_TYPE_LOOKUP_CODE
      ,PO_NUMBER
      -- ,group_id
      )
      Values
      (
      425062, /**** Generated from Sequence Select AP_INVOICES_INTERFACE_S.NEXTVAL FROM Dual*******/
      'LMN99934e', /*** Invoice Number for AP_Invoice****/
      --'25/NOV/2011', /*** Invoice Creation Date *****/
      26381, /*** VENDOR_ID *****/
      'Guhring Ltd', /*** VENDOR_NAME ***/
      'BIRMINGHAM', /*** VENDOR_SITE_CODE ***/
      792.74,
      'USD',
      10180,
      '06/APR/2016',
      1130,
      'CHECK',
      '06/APR/2016',
      102,
      --'ERS',
      'Standard'
      ,31409 /*** Invoice Type lookup code is "STANDARD ' if INVoice Amount >0 else 'CREDIT'******/
      --,'Test1'
      );


      INSERT INTO AP_INVOICE_LINES_INTERFACE
      (
      INVOICE_ID,
      LINE_TYPE_LOOKUP_CODE,
      AMOUNT,
      line_number,
      DIST_CODE_COMBINATION_ID
      )
      Values
      (
      425062,
      'ITEM',
      792.74,
      1,
      171451
      );
      COMMIT;

       

      I then run Payables Open Interface Import from Concurrent Manager.

       

      I do not see the table entries  moving along, nor do I see any entry in the ap_interface_rejections table.

       

      The output from Concurrent Manager looks like this:

       

      Report Date: 06-APR-2016 16:00

        Page: 1

        Payables Open Interface Import Report

        Hold Name:

      Source Name: Manual Invoice Entry Hold Reason:

      Group: GL Date:

        Purge: No

        Summarize Report N

      Report Date: 06-APR-2016 16:00

        Page: 2

        Payables Open Interface Import Report

        Hold Name:

      Source Name: Manual Invoice Entry Hold Reason:

      Group: GL Date:

        Purge: No

        Summarize Report N

       

      Any help / suggestions would be sincerely appreciated.