My Oracle Support Banner

ODPM-10071: Member Code % Not Found in Level % (Doc ID 1418914.1)

Last updated on AUGUST 17, 2022

Applies to:

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

Symptoms

When trying to load data for some General Level like Promotion 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-10071: Member Code % Not Found in Level %

This is telling us that the value we had not correctly populated the records 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.
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

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
Symptoms
Cause
Solution
References

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