My Oracle Support Banner

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:

Oracle Payables - Version 12.2.10 and later
Information in this document applies to any platform.


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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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