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

Last updated on AUGUST 17, 2016

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

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 hundreds of Community platforms