My Oracle Support Banner

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, 2018

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Supplier Issues

Customer has a custom SQL script they use to call the following standard APIs to create new Suppliers/Sites.
 APPS.AP_VENDOR_PUB_PKG.Create_Vendor and
 APPS.AP_VENDOR_PUB_PKG.Create_Vendor_Site

The customer custom SQL script uses a custom table to fetches the Suppliers/Sites data to be inserted into the AP% tables
using the standard APIs mentioned above.

The API APPS.AP_VENDOR_PUB_PKG.Create_Vendor_Site does not create all supplier site
The API only creates a handful of supplier sites and stops after that. No Error is generated however not all sites are created .

The customer gets the following error:: ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes

Note:
  Customer IS NOT using/populating the Suppliers/Sites Open Interface Import Tables.
  Customer IS NOT using the any of the standard concurrents programs available to Import Suppliers/Sites.
  .- Supplier Open Interface Import - APXSUIMP
  .- Supplier Sites Open Interface Import - APXSSIMP


ERROR
-----------------------
ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populate a custom table with the Suppliers/Sites data to be inserted into Suppliers/Sites standard AP% tables.
2. Run the custom SQL script that calls Standard APIs AP_VENDOR_PUB_PKG.Create_Vendor and AP_VENDOR_PUB_PKG.create_vendor_site
.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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