2 Replies Latest reply on Apr 27, 2011 9:53 AM by Sandeep Gandhi, Consultant

    PO Interface

    Jegan
      Hi All,

      In PO_HEADERS_INTERFACE table a purchase order is available.

      After i run the Import Standard PO concurrent the PO doesnt move to the base table in oracle apps 12.1.

      In PO_INTERFACE_ERRORS table the error is shown as

      INTERFACE_TYPE
      PO_DOCS_OPEN_INTERFACE

      COLUMN_NAME
      SHIP_VIA_LOOKUP_CODE

      ERROR_MESSAGE
      Error: FREIGHT CARRIER (VALUE =NOMINATED TRANSPORTER) specified is inactive or invalid.

      ERROR_MESSAGE_NAME
      PO_PDOI_INVALID_FREIGHT_CARR

      TABLE_NAME
      PO_HEADERS_INTERFACE

      COLUMN_VALUE
      NOMINATED TRANSPORTER

      In the Interface table Freight Carrier field is NULL.
      I cant know from where the value NOMINATED TRANSPORTER is getting picked up.


      Please Advice,

      Thanks in Advance,
      Jegan
        • 1. Re: PO Interface
          Hussein Sawwan-Oracle
          Please see if the solution in these docs is applicable.

          PDOI With Center Led Procurement Fails with PO_PDOI_INVALID_SHIP_TO_LOC_ID [ID 554488.1]
          How to use a Valid / Active Ship-To Organization Id while running PDOI ? [ID 378368.1]

          If not, then you may need to log a SR as no other docs exist on MOS website and address the same error.

          Thanks,
          Hussein
          1 person found this helpful
          • 2. Re: PO Interface
            Sandeep Gandhi, Consultant
            The ship via may be getting defaulted from the Supplier Record (purchasing tab) or the supplier-site record (purchasing tab) or the financial options screen under setup.

            One of these places may have a value of NOMINATED TRANSPORTER. And that freight carrier is probably end-dated now.

            Hope this helps,
            Sandeep Gandhi