Error When Trying to Access the Supplier Products & Services Page - ORA-06502: PL/SQL: numeric or value error: NULL index table key value ORA-06512: at "APPS.POS_PRODUCT_SERVICE_UTL_PKG"
(Doc ID 2632345.1)
Last updated on JANUARY 27, 2020
Applies to:Oracle iSupplier Portal - Version 12.1.3 and later
Information in this document applies to any platform.
In Oracle Purchasing, Oracle Payables, and Oracle iSupplier Portal / Supplier Management, Release 12.1.3 and Release 12.2:
An error occurs when trying to view or maintain the "Products & Services" (Products and Services) information for a selected supplier.
Due to this issue, users cannot maintain or update the Products & Services information for the suppliers.
ORA-06502: PL/SQL: numeric or value error: NULL index table key value ORA-06512: at "APPS.POS_PRODUCT_SERVICE_UTL_PKG", line 188 ORA-06512: at "APPS.POS_PRODUCT_SERVICE_UTL_PKG", line 368 ORA-06512: at "APPS.POS_PRODUCT_SERVICE_UTL_PKG", line 749 ORA-06512: at line 1
Steps To Reproduce
The issue can be reproduced at will with the following steps:
1. Log in to Oracle Applications as the internal supplier admin user.
2. Navigate to Purchasing responsibility > Supply Base > Suppliers.
3. On the Suppliers page, search for the desired supplier, and click the Update icon in the search results.
4. On the Update Supplier page, click the Products & Services link. The error message appears at this point.
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