My Oracle Support Banner

R12: AP: Error "ORA-01403: No Data Found" In Package AP_VENDOR_PUB_PKG.Update_Vendor_Site While Updating the Supplier Site (Doc ID 3005995.1)

Last updated on FEBRUARY 21, 2024

Applies to:

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


Unable to update a supplier site using the Payables Vendors Public APIs.

API procedure AP_VENDOR_PUB_PKG.Update_Vendor_Site_public raises the following error:

ORA-01403: no data found in Package AP_VENDOR_PUB_PKG Procedure Validate_Vendor_Site  

Steps to reproduce:

1. AP_VENDOR_PUB_PKG.Update_Vendor_Site_public was executed to end date a batch of supplier sites.

2. API is ending with the described error for some of the supplier sites. So, not all the supplier sites are updated as expected.



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.