API: PO_ASL_API_PUB CREATES DUPLICATE SEQUENCE_NUM IN PO_ASL_DOCUMENTS
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.
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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms