My Oracle Support Banner

The Upload Of Custom Item Template File (Item Master Incl. CFAs.) Is Locked In 'New' Status (Doc ID 2987027.1)

Last updated on NOVEMBER 14, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 23.0 and later
Information in this document applies to any platform.

Symptoms

The upload of the custom Item template file (Item Master incl. CFAs.) is not processing i.e., the processing status stays 'New' forever.

ERROR
-----------------------
LOGGER_LOGS

Text
sql_lib.create_msg message:@0PACKAGE_ERROR@1ORA-06531: Reference to uninitialized collection@2CORESVC_CFLEX.PROCESS_S9T_CFA ORA-06531: Reference to uninitialized collection ORA-06512: at "RMS01.CORESVC_CFLEX", line 361

Action
AQ$_PLSQL_NTFN_823105837

Call stack
object line object handle number name 0x1eecca060 210 package body RMS01.SQL_LIB.CREATE_MSG 0x1da066ff8 406 package body RMS01.CORESVC_CFLEX.PROCESS_S9T_CFA 0x1da066ff8 250 package body RMS01.CORESVC_CFLEX.PROCESS_S9T_SHEETS 0x113aee710 18491 package body RMS01.ITEM_INDUCT_SQL.PROCESS_S9T 0x113aee710 21496 package body RMS01.ITEM_INDUCT_SQL.EXEC_ASYNC 0xa9c78b40 1741 package body RMS01.RMS_ASYNC_PROCESS_SQL.NOTIFY_ITEM_INDUCT 0xfc3bbfd0 1 anonymous block 0x20ef00300 14773 package body SYS.DBMS_AQADM_SYS.RUN_CALLBACK 0x20ef00300 14902 package body SYS.DBMS_AQADM_SYS.DEQ_EXEJOB 0x20ef00300 14993 package body SYS.DBMS_AQADM_SYS.REGISTER_DRIVER ORA-06531: Reference to uninitialized collection ORA-06512: at "RMS01.CORESVC_CFLEX", line 361 ORA-06512: at "RMS01.CORESVC_CFLEX", line 361 ORA-06512: at "RMS01.CORESVC_CFLEX", line 361


RMS_ASYNC_RETRY
@0PACKAGE_ERROR@1ORA-06531: Reference to uninitialized collection@2CORESVC_CFLEX.PROCESS_S9T_CFA


Error cause
"Reference to uninitialized collection" *Cause: An element or member function of a nested table or varray was referenced (where an initialized collection is needed) without the collection having been initialized. *Action: Initialize the collection with an appropriate constructor or whole-object assignment.




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1 - Navigate to Items > Upload Items from File 
2 - Navigate to Data Loading > Review Status
Issue: The processing status stays 'New' forever.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot upload Item Master incl. CFAs induction files.

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
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.