EBS Customizations (MOSC)

MOSC Banner

ap_vendor_pub_pkg.update_vendor_site_public returns Validate_Vendor_SiteNERROR_TEXTORA-01403: no dat

edited May 5, 2018 5:02AM in EBS Customizations (MOSC) 3 commentsAnswered

I am trying to update ap.ap_supplier_sites_all.attribute5 using the API  ap_vendor_pub_pkg.update_vendor_site_public. Each site has a different org_id and the script is returning a status of: U with an error message of:

FNDFND_AS_UNEXPECTED_ERRORNPKG_NAMEAP_VENDOR_PUB_PKGNPROCEDURE_NAMEValidate_Vendor_SiteNERROR_TEXTORA-01403: no data found

I found note #2209969.1 which says the cure for this error message is to set MO: Operating Unit at the site level. We have it set at the site level and the script works when the site org_id matches the value in MO: Operating Unit. However, I need to update sites that do not have the same org_id.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center