My Oracle Support Banner

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

Last updated on OCTOBER 08, 2019

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 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.

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.]


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.