My Oracle Support Banner

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

Last updated on JANUARY 29, 2022

Applies to:

Oracle Retail Merchandising System - Version 13.0.3 and later
Information in this document applies to any platform.


After upgrading to Retail Merchandising System (RMS) to version, 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.




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

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