Thursday, September 14, 2017

Supplier Site Creation Error -- ORA-01403: no data found in Package AP_VENDOR_PUB_PKG Procedure Validate_Vendor_Site

It seems there is Payble Option setup for that perticulat OU

Please check:

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 = 123;

 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.

No comments:

Post a Comment