R12: Supplier Record Is Rejected For Duplicate Supplier Number By Supplier Open Interface Import Even Though The Interface Had Distinct Supplier Numbers (Doc ID 2249513.1)

Last updated on MARCH 31, 2017

Applies to:

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

Symptoms

Supplier record is rejected by Supplier Open Interface Import program incorrectly

Rejection : This Supplier Number already exists.


The issue can be reproduced at will with the following steps:
--------------------------------------------------------------------
1. Load 2 supplier records into ap_supplier_int table. Make sure both supplier numbers (field segment1) are distinct.

2. Log into the Payables Manager responsibility

3. Navigate to Other > Concurrent > Request > Submit Single Request

4. Run the Supplier Open Interface Import

5. Find one supplier is imported and other is rejected with Duplicate number rejection. The duplicate number shown is of the supplier that was imported in same run. The import program seems to mix the numbers of the suppliers

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms