R12: AP: Supplier Site Creation API (AP_VENDOR_PUB_PKG.CREATE_VENDOR_SITE) Is Not Updating VAT_REGISTRATION_NUM Column in AP_SUPPLIER_SITES_ALL (Doc ID 3046738.1)

Last updated on SEPTEMBER 17, 2024

Applies to:

Symptoms

Supplier site creation API (ap_vendor_pub_pkg.create_vendor_site) does not populate vat_registration_num in ap_supplier_sites_all whereas update API (ap_vendor_pub_pkg.update_vendor_public) updates the same when registration number is passed as parameter. This is confirmed as Tax Registration number is blank under "Tax and Reporting" details for the supplier site on Supplier workbench.

The issue can be reproduced at will with the following steps:
1. Run the script by calling API ap_vendor_pub_pkg.create_vendor_site and passing appropriate parameters along with vat_registration_num.
2. Observe that vendor site is created successfully but vat_registration_num in ap_supplier_sites_all is NULL.
3. Query the supplier setup.
    Navigate : Suppliers > Inquiry
4. Look for tab Tax and Reporting and click Update Transaction tax for the site.
5. Observe that Tax Registration number is not populated.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.