Applies to:

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

Symptoms

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.

Example: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: