2 Replies Latest reply on Mar 12, 2018 5:40 AM by 2953814

    3 way matching in R12.2.6

    3280821

      Hi,

       

      I am uploading PO from third party system to interface table then run the import program to. base table. every time i import the records goes to 3 way matching. how do i set it to 2 way matching. is it picking form Purchasing option? It is not happening in 12.1.3. I am putting the same record in 12.1.3 and 12.2.6. In 12.1.3 when i specify the upload as 2 way matching it goes in as 2 way when i specify 3 way it goes as 3 way. but the same thing is not happening in 12.2.6. Any idea what i have to do.

      Please help.

       

      Thank you

        • 1. Re: 3 way matching in R12.2.6
          Sanjay Desai EBS

          Try with passing,

          RECEIPT_REQUIRED_FLAG = 'N' and INSPECTION_REQUIRED_FLAG = 'N'  for 2-way matching PO

          in table PO_LINES_INTERFACE.

          This is concept of R12.1.3.

          1 person found this helpful
          • 2. Re: 3 way matching in R12.2.6
            2953814

            You can use these fields in the PO_LINE_LOCATIONS_INTERFACE table to control the matching

              1. RECEIPT_REQUIRED_FLAG

              2. INSPECTION_REQUIRED_FLAG

             

            e.g. This would be 3 way match if you set like this

              RECEIPT_REQUIRED_FLAG = 'Y'

              INSPECTION_REQUIRED_FLAG = 'N'

             

              This would be 4 way match if you set like this

              RECEIPT_REQUIRED_FLAG = 'Y'

              INSPECTION_REQUIRED_FLAG = 'Y'

             

              This would be 2 way match if you set like this

              RECEIPT_REQUIRED_FLAG = 'N'

              INSPECTION_REQUIRED_FLAG = 'N'