R12: AP: Existing Party Can Not Be Used While Creating a Supplier Using Suppliers Open Interface Import Concurrent Request (Doc ID 2844775.1)

Last updated on JULY 27, 2022

Applies to:

Symptoms

Unable to use an existing party while creating a supplier using Supplier Open Interface Import.  The system creates the supplier with a new row in HZ_PARTIES.  Creating a new supplier using the Suppliers form or the Create Supplier API can use an existing party.

Reproduction steps

1. ID the Party_ID and Party_Number (Registry ID) of an existing Receivables Customer
    
2. Create a row in AP_SUPPLERS_INT.  Run the following SQLs in the APPS schema via SQL*Plus command line:
    
3. Open Requests form (View > Requests).
   Click the "Submit a New Request" button.
   Enter Name: Supplier Open Interface Import.
   In the Parameters section use all default parameters.
   Click Submit button.
   
   
4. When the request complete verify if there were no errors and that a new supplier was created
   Open the Suppliers form (Suppliers > Entry > Suppliers)
   Query Supplier just created by the Open Interface.
   Click on the Organization link on the left.
   
   Note that the Registry ID is different than the Registry ID of the Customer with the same name.  This means a new party was created.
   
   

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.