ODPM-10418: Invalid Parent Member Value

(Doc ID 1418786.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Demantra Predictive Trade Planning - Version 7.3.1 and later
Information in this document applies to any platform.


When trying to load data for a level using integration interfaces, the records are not loaded into demantra internal tables and are rejected into %_err table.
The following message is meet into ERR_MESSAGE field of %_err table:
ODPM-10418: Invalid Parent Member Value

This is telling us that the value we had populated into the staging table is wrong for the parent level.
This ODPM-10418 is preceded by ODPM-10416 message that is giving us the parent level name and the field from staging table that was wrongly populated.

We are trying to load promotions.
For this, we had loaded data into BIIO_PROMOTION and BIIO_POPULATION tables.
We run the ImportPromotionLevels workflow.
The workflow completed successfully, but data is not loaded into promotion and promotion_data tables.
Checking the BIIO_PROMOTION_ERR table, we see the following messages:

[ODPM-10416: Parent Level Promotion Status, Data Column PROMOTION_STAT_CODE, Error:ODPM-10418: Invalid Parent Member Value]


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