R12: When Entering Operating Unit (OU) for Supplier Gets Error ORA-01403 (Doc ID 813205.1)

Last updated on JULY 03, 2017

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

-- Problem Statement:
For an existing Supplier and Site, when trying to make it available to another Operating Unit (OU)
gets error. The error is received also when creating new suppliers and sites.


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


Changes

MO initialization is not happening in validate_vendor_site.

This initialization strategy has been implemented in Procedure 'Create_vendor_site', but not in
'Validate_vendor_site' (This the the point of entry for ISP call when creating vendor sites), which is causing the
AP_SYSTEM_PARAMETERS table to be empty.

This is corrected in Validate_vendor_site Procedure now, just like in Create_vendor_site.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms