Thursday, 14 September 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.

5 comments:

  1. Wonderful blog I visit this blog it's incredibly awesome. Curiously, in this blog content formed doubtlessly and sensible. The substance of information is helpful.
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training
    Oracle Fusion Financials Online Training
    Big Data and Hadoop Training In Hyderabad

    ReplyDelete
  2. Thank you for sharing such a nice and really very helpful article

    Oracle Fusion HCM Training

    ReplyDelete
  3. Very interesting blog Really excellent information and thank you for giving your valuable information

    Spark and Scala Online Training
    Spark Scala Training
    Hyderabad

    ReplyDelete
  4. Excellent information with unique content and it is very useful to know about the information based on blogs. We are also providing the best services click on below links to visit our website.
    Oracle Fusion HCM Training
    Workday Training
    Okta Training
    Palo Alto Training
    Adobe Analytics Training

    ReplyDelete