API: PO_ASL_API_PUB CREATES DUPLICATE SEQUENCE_NUM IN PO_ASL_DOCUMENTS
(Doc ID 1664665.1)
Last updated on MARCH 13, 2019
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
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
| Symptoms |
| Cause |
| Solution |
| References |