My Oracle Support Banner

XItem Throws ORA-00001 Error when Loading Item/Seasons Information for Parent and Child (Doc ID 2227332.1)

Last updated on MARCH 01, 2019

Applies to:

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


When using XItem interface to load a style and associated SKUs, each with it's own item/season information, the following error occurs:

Steps to Reproduce:
1. Using XItem, Create a style (item_level = 1, tran_level = 2) with a single item/season/phase record.
2. Using XItem, Create a SKU (item_level = 2, tran_level = 2) as a child record to the parent in step #1.

2a. Make sure the child has an item season record in the message that does not match the item/season/phase of the parent.
3. Notice the error.


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.