No Ouput When Running Customer Profit Aggregation Using Customer Hierarchy (Doc ID 437589.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Profitability Manager - Version: 12.0.0
This problem can occur on any platform.
PFT

Symptoms

When attempting to run Profit Aggregation rule with customer hierarchy selected, the process completed normally but there is no record created with the request_id.

-- Steps To Reproduce:
Use Profitability Manager responsibility.

1. Create Hierarchy with 4 levels: Customer Level -> Level 1 -> Level 2 -> Rollup Level.
2. Assign Customers to each level.
3. Run Account Consolidation to populate FEM_CUSTOMER_PROFIT for the customers in
    the hierarchy.
4. Run Profit Aggregation with Aggregate to customer checked - one row per customer is inserted
    into FEM_CUSTOMER_PROFIT table with created_by_request_id = <request_id of the process>
    and CUSTOMER_AGGREGATION code.
5. Run Profit Aggregation with Aggregate to customer unchecked. Select the hierarchy created,
    select Customer Rollup top level and Customer Level Bottom.
6. Although the process was completed normally and the log shows there were 7 rows being
    processed/loaded, there is no new row being inserted into FEM_CUSTOMER_PROFIT table with
    the created_by_request_id = <request_id of the process>.



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