My Oracle Support Banner

Invalid Timeline in RPM_FUTURE_RETAIL Caused by NewItemLocBatch; Results in "ORA-32638: Non-Unique Addressing" Error (Doc ID 1588936.1)

Last updated on FEBRUARY 02, 2018

Applies to:

Oracle Retail Price Management - Version 13.2.4 to 13.2.6 [Release 13.2]
Information in this document applies to any platform.

Symptoms

In Oracle Retail Price Management (RPM) 13.2.4, when running the NewItemLocBatch (NIL), invalid timelines are created in the RPM_FUTURE_RETAIL table. The following error then occurs when we approve price events with these invalid records:



Steps to Reproduce:

1. Create a parent item having six diffs (I1-I6) and ranged to three locations (L1-L3), all part of the primary zone group.
2. Run the NIL batch with a few of the child/loc combinations.
3. Run the NIL batch with the rest of the child/loc combinations.

Notice that there are missing timelines in the Future Retail (FR) tables after the second batch is run.

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!


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