My Oracle Support Banner

R12: AP: ORA-01403 No Data Found Error Occurred When Using API To Update Vendor Site (Doc ID 2374972.1)

Last updated on MARCH 19, 2018

Applies to:

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

Symptoms

When executing API AP_VENDOR_PUB_PKG.update_vendor_site_public, the user sees an error message for several sites - API call failed with error ORA-01403: no data found in Package AP_VENDOR_PUB_PKG Procedure Validate_Vendor_Site. Patches related to this error (as noted in Doc ID 2031366.1, Bug 18455207) are already installed and settings are correct (as noted in Doc ID 2209969.1).

Example:

The API call failed with error. ORA-01403: no data found in Package AP_VENDOR_PUB_PKG Procedure Validate_Vendor_Site Site ID 174788 Site Code HOME

The API call failed with error. ORA-01403: no data found in Package AP_VENDOR_PUB_PKG Procedure Validate_Vendor_Site Site ID 156785 Site Code OFFICE

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.