ODPM-10421: Population Attribute, Error:ODPM-10422: Invalid Population (Doc ID 1582611.1)

Last updated on JUNE 26, 2017

Applies to:

Oracle Demantra Predictive Trade Planning - Version 7.3.1 and later
Information in this document applies to any platform.
***Checked for relevance on 24-May-2016***

Symptoms

When trying to load data for some General Level like Promotion, SOP or CTO 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-10421: Population Attribute, Error:ODPM-10422: Invalid Population,ODPM-%

This is telling us that something is wrong with data we had loaded into population table.


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.

In collaborator.log file we have:

2013-07-11 22:24:16,932 [WFProcess_4] INFO appserver.integration: ODPM-20297: Import Level.
2013-07-11 22:24:16,933 [WFProcess_4] INFO appserver.integration: ODPM-20044: Run Start Time: 07-11-2013 22:24:16
2013-07-11 22:24:16,933 [WFProcess_4] INFO appserver.integration: ODPM-20045: Interface Name: Import Promotion Levels
2013-07-11 22:24:16,933 [WFProcess_4] INFO appserver.integration: ODPM-20046: Profile Name: Import Promotion Levels
2013-07-11 22:24:16,933 [WFProcess_4] INFO appserver.integration: ODPM-20047: Level: Promotion
2013-07-11 22:24:20,340 [WFProcess_4] INFO appserver.integration: ODPM-20182: Rows processed: 0.
2013-07-11 22:24:20,402 [WFProcess_4] INFO appserver.integration: ODPM-20048: Run End Time: 07-11-2013 22:24:20
2013-07-11 22:24:20,403 [WFProcess_4] INFO appserver.integration: ODPM-20049: Run Duration Time (hh:mm:ss:msec):0:0:3.473


Checking the BIIO_PROMOTION_ERR table, we see the following messages:

[ODPM-10421: Population Attribute, Error:ODPM-10422: Invalid Population,ODPM-10071: Member Code '123456789-06' Not Found in Level 424.]

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