Error ORA-06512: at "APPS.PON_AUC_INTERFACE_TABLE_PKG Occurs When Attempting to Upload Lines via Spreadsheet Import for a Sourcing RFQ that has an Outcome of BPA (Doc ID 1562541.1)

Last updated on OCTOBER 30, 2015

Applies to:

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

Symptoms

ORA-06512: at "APPS.PON_AUC_INTERFACE_TABLE_PKG occurs when attempting to upload lines via spreadsheet import for a Sourcing RFQ that has an outcome of BPA

ERROR
Message not found. Application: PON, Message Name: pon.NegotiationItemUpload - could not add ip descriptors: java.sql.SQLException: ORA-01403: no data found ORA-06512: at "APPS.PON_AUC_INTERFACE_TABLE_PKG", line 1508 ORA-06512: at line 1 . Tokens:

STEPS TO REPRODUCE
1. Navigate to Sourcing again
2. Query the RFQ (or create a new RFQ)
3. At the lines level, choose action = Import Lines
4. Specify the file, and do the import
- get the error

Verify that the same category and UOM and other details for an identical line can be specified when adding a line manually within the page, and there is no problem.

IMPACT
Users are not able to mass upload lines for an RFQ. This is required functionality for large RFQs having a large number of lines

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms