No_processingkey_column (Context=Channel_id) Error Running Retrieve Statistic Mapping Rule (Doc ID 368571.1)

Last updated on OCTOBER 31, 2008

Applies to:

Oracle Profitability Manager - Version: 11.5.10.2
This problem can occur on any platform.
FEM

Symptoms

On 11.5.10.2, when attempting to run a Retrieve Statistic mapping rule, the following error occurs.

ERROR
NO_PROCESSINGKEY_COLUMN (CONTEXT=CHANNEL_ID)
DET_PRIMARY_KEY
INVALID_PAGE

STEPS
The issue can be reproduced at will with the following steps:
1. Created user defined lookup table xxofsa_unit_cost having as a processing key (geography_id,
channel_id, user_dim2_id)
2. Registered as statistic and created a return lookup column PRODUCT_COST_DC (EPF responsibility -> Statistic)
3. Defined a retrieve statistic mapping rule multiplying Volume column in FEM_TRANS_CONSUMER with
PRODUCT_COST_DC lookup return column and putting the result in COST column in FEM_TRANS_CONSUMER

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