Attempting to Load CTO data ODPM-70446: Failed to update combination (Doc ID 1485526.1)

Last updated on AUGUST 03, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.3.1 and later
Information in this document applies to any platform.
***Checked for relevance on 01-Mar-2016***

Symptoms

On : 7.3.1 version, LoadData

When attempting to loading CTO data,
the following error occurs.

ERROR
-----------------------
ODPM-70446: Failed to update combination:[CTO-2061::207::137, Item-I121, Demand Class-N/A, Organization-TST:M1, Site-N/A, Sales Channel-N/A]

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. From Demand Management System Administrator Collections --> Oracle Systems --> run Shipment and Booking History collection with launch download to No
2. Verify that data was populated successfully into BIIO_CTO_% staging tables
3. Run EBS Full Download workflow to load data from staging tables to demantra internal tables

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