R12: AP: Unable To Create New Suppliers Or Sites Using Standard APIs AP_VENDOR_PUB_PKG.Create_Vendor_Site And AP_VENDOR_PUB_PKG.Create_Vendor, Called From Custom PLSQL Script
(Doc ID 2439383.1)
Last updated on AUGUST 28, 2023
Applies to:Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
A custom SQL script that calls the following Payables Vendors Public APIs to create new Suppliers/Sites:
APPS.AP_VENDOR_PUB_PKG.Create_Vendor and APPS.AP_VENDOR_PUB_PKG.Create_Vendor_Site
The custom SQL script uses a custom table to fetch the Suppliers/Sites data to be inserted into the AP% tables using the APIs mentioned above.
The custom SQL script is executed in a SQL session via SQL*Plus command line. When executed, the script only creates a handful of supplier sites before it stops and displays the following Error:
STEPS TO REPRODUCE:
- Populate a custom table with the Suppliers/Sites data to be inserted into Suppliers/Sites standard AP% tables.
- Run the custom SQL script that calls Standard APIs AP_VENDOR_PUB_PKG.Create_Vendor and AP_VENDOR_PUB_PKG.create_vendor_site
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document