API: PO_ASL_API_PUB CREATES DUPLICATE SEQUENCE_NUM IN PO_ASL_DOCUMENTS (Doc ID 1664665.1)

Last updated on APRIL 23, 2014

Applies to:

Oracle Purchasing - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When adding new Source Document with using API PO_ASL_API_PUB, the API doesn't validate duplicate SEQUENCE_NUM in PO_ASL_DOCUMENTS.
It causes the following error in Approved Supplier List form.

  APP-FND-01206:This record already exists. You encountered a duplicate value or sequence of values that must be unique for every record.


The issue can be reproduced at will with the following steps:

 1.  Add a new source document to ASL using PO_ASL_API_PUB, specifying an existing SEQUENCE_NUM value
 2.  Search the item on Approved Supplier List and the error occurs


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