2 Replies Latest reply: Nov 7, 2012 10:16 AM by Ibrahim-Oracle RSS

    We have a number of PO(s) failing interface

    Ibrahim-Oracle
      Hi Team,

      Customer has 20-30 PO(s) with the following error:

      PO_PDOI_INVALID_NUM_OF_LINES

      We suggested the followings even-though the issue still persists:


      =======================================================
      It could be an invalid HEADER_INTERFACE_ID that was loaded for the PO_HEADER_ID.

      Check if for the INTERFACE_LINE_ID, PO_HEADER_ID is correct

      As the Standard Import Standard Purchase Order (Import Standard Purchase Orders) is being error out.

      We need to confirm if data were populated correctly

      You can check the above with the followings:

      SELECT * FROM po_lines_interface WHERE INTERFACE_HEADER_ID = & INTERFACE_HEADER_ID;

      SELECT * FROM po_HEADERS_interface WHERE INTERFACE_HEADER_ID = INTERFACE_HEADER_ID;
      =========================================================

      Customer has populated Organization_id = 81 for the followings in po_lines_interface and retest, but the issue still persists:

      INTERFACE_LINE_ID INTERFACE_HEADER_ID
      4441731 3260945
      4441732 3260945
      4441733 3260945

      ===========================================================

      we asked customer to nullify process_code column and run the process again, and check if it will be accepted instead, but the issue still persists

      Any ideas how to resolve this issue

      https://support.us.oracle.com/oip/faces/filedownloadservlet?ObjectType=SR&ObjectNo=3-6385916551&FileName=po_interface_errors.xls

      https://support.us.oracle.com/oip/faces/filedownloadservlet?ObjectType=SR&ObjectNo=3-6385916551&FileName=PO_Import.xls

      https://support.us.oracle.com/oip/faces/filedownloadservlet?ObjectType=SR&ObjectNo=3-6385916551&FileName=INTERFACE_HEADER_ID.xls

      https://support.us.oracle.com/oip/faces/filedownloadservlet?ObjectType=SR&ObjectNo=3-6385916551&FileName=PO_LINES_INTERFACE.xls

      https://support.us.oracle.com/oip/faces/filedownloadservlet?ObjectType=SR&ObjectNo=3-6385916551&FileName=PO_HEADERS_INTERFACE.xls


      Thanks a lot,
      Ibrahim

      Edited by: 969735 on Nov 6, 2012 1:43 AM