My Oracle Support Banner

Not Able To Load Data At Aggregate Level For Custom Granularity (Doc ID 2413373.1)

Last updated on JULY 23, 2018

Applies to:

Oracle Sales and Operations Planning Cloud Service - Version 11.13.17.11.0 and later
Oracle Demand Management Cloud Service - Version 11.13.17.11.0 and later
Information in this document applies to any platform.

Symptoms

Customer has following requirements regarding loading data at aggregate level

1) Budget - Product category and market segment (Parent of demand class.Customer has created custom hierarchy for demand class)
2) Average selling price for make to order items - Brand (Product category ), demand class and organization
3) Production capacity - Brand (Product category) and Organization


ERROR
A value must be provided for both attribute ORG_LVL_NAME and attribute ORG_LVL_MEMBER_NAME
The value provided for the attribute TIM_LVL_NAME is invalid.
The attribute CUS_LVL_NAME cannot be null.
The attribute CUS_LVL_MEMBER_NAME cannot be n

STEPS TO REPRODUCE
1.For Budget Measure Load data at category level without specifying Org and Customer Dimension
2.For Average selling price Measure Load data at Brand, demand class and organization
3.For Production capacity Load data at Brand and Organization

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!


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