Error
Address and Site Creation - Unable to create address and sites because of the following error when trying to create the site in operating unit [COMPANY-OU]: [ORA-01403: no data found in Package AP_VENDOR_PUB_PKG Procedure Validate_Vendor_Site]. Either resolve this issue and try again or deselect the operating unit with the error and continue. Note: any new address requires at least one site in order to be created.
In this Document
Applies to:
Oracle Payables - Version 12.0.6 and later
Information in this document applies to any platform.
Symptoms
When creating a new supplier site (address), it cannot be saved and the following error message occurs:
Address and Site Creation - Unable to create address and sites because of
the following error when trying to create the site in operating unit
[Egészségügyi Minisztérium]:
[ORA-01403: no data found in Package AP_VENDOR_PUB_PKG Procedure Validate_Vendor_Site].
Either resolve this issue and try again or deselect the operating unit with the error
and continue. Note: any new address requires at least one site in order to be created.
Cause
Cause Determination:
Invalid accounting combination setup at Financials Options.
Cause Justification:
This is explained in the following bug:
Bug 9360590: CANNOT CREATE SUPPLIER SITE (ADDRESS)
Solution
Correct AP setup.
Do valid the accounting combination setup at Financials Options.
1. The issue appears to be caused because you do not have this org setup in AP. Please confirm this with the following:
select *
from ap_system_parameters_all
where org_id = XX;
If this does not return a row, the problem is an AP org has not been set up.
2. Navigate to Setup > Options > Payables Options and create a record for this operating unit.
Refer to Page 1-49 and following of the Payables Implementation Guide for instructions on how to set up an AP org. Since you do not have a financials implementation, many of these options may not apply to you, but the record in AP is still required.
3. Confirm the query in step 1 now returns a row, and then confirm the supplier page no longer gives an ORA-01403 when attempting to create a supplier site.