Unexpected Error Trying To Add Categories To A Store In iProcurement Content Zone (Doc ID 1564180.1)

Last updated on APRIL 20, 2023

Applies to:

Goal

Why getting error "You have encountered an unexpected error" while trying to attach Categories to a Store in iProcurement Content Zone?


ERROR
-----------------------
## Detail 0 ##
java.sql.SQLException: ORA-20000: Exception at ICX_CAT_SQE_PVT.create_sqes_for_zone(...), ORA-20000: Exception at ICX_CAT_SQE_PVT.construct_exprs_for_zone(...), ORA-20000: Exception at ICX_CAT_SQE_PVT.construct_category_expr(...), ORA-06531: Reference to uninitialized collection
ORA-06512: at "APPS.ICX_CAT_SQE_PVT", line 131
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

Steps:
-------
1. Log in to Oracle Applications, using an iProcurement Catalog Administration responsibility.
2. Click the Content Zones subtab.
3. On the Manage Content Zones page, click the Update icon (pencil) for the zone that needs to be updated (or click Create to create a new content zone).
4. On the Update Local Content Zone page, in the Categories region, the options currently enabled are "Include Items from all categories" and "Include items without shopping categories". Change the value to "Include items from specific categories".
5. Click the Add Categories button and find/select a browsing category to add.
6. Click the Apply button to save the changes.
7. See the error.

Solution

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