My Oracle Support Banner

Error ORA-06531 is Received when Adding A New Item With XITEM Interface (Doc ID 1195594.1)

Last updated on AUGUST 17, 2020

Applies to:

Oracle Retail Merchandising System - Version 13.0.3 and later
Information in this document applies to any platform.
Checked for relevance on December 3rd, 2013.


Symptoms

After upgrading to Retail Merchandising System (RMS) to version 13.0.3.4, when trying to add new Items into RMS using XITEM Interface the following error is observed.

“ORA-06531: Reference to uninitialized collection returned by program unit RMSSUB_XITEM_SQL.CREATE_MODIFY_ISCD.”


Steps To Recreate:

  1. Create an item using xitem API with RIB_XISCDimDesc_TBL value in element RIB_XItemSupCtyDesc_REC as NULL.
  2. An error is reported : ORA-06531: Reference to uninitialized collection returned by program unit RMSSUB_XITEM_SQL.CREATE_MODIFY_ISCD.




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.