My Oracle Support Banner

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.


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



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.