Percent Distribution Mapping Rule Using Currency Fails with Signal 6 Error (Doc ID 420842.1)

Last updated on DECEMBER 01, 2008

Applies to:

Oracle Profitability Manager - Version: 11.5.10
Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.

Symptoms

In Oracle Profitability Manager, a percent distribution Mapping Rule that uses "Currency" is failing with the following error in the concurrent manager View Log:

select SUM( a.XTD_BALANCE_F ) , a.CHANNEL_ID,
a.COMPANY_COST_CENTER_ORG_ID, a.CUSTOMER_ID, a.LINE_ITEM_ID,
a.NATURAL_ACCOUNT_ID, a.PRODUCT_ID, a.USER_DIM1_ID,
a.USER_DIM2_ID, a.USER_DIM3_ID, a.USER_DIM4_ID, a.USER_DIM5_ID,
a.USER_DIM6_ID, a.USER_DIM7_ID, a.INTERCOMPANY_ID, a.ENTITY_ID,
a.CURRENCY_CODE
from FEM_BALANCES a
where a.PRODUCT_ID=:PRODUCT_ID
and ( ( a.FINANCIAL_ELEM_ID = 455)
AND ( ( ( a.DATASET_CODE =10018) and( a.CAL_PERIOD_ID
=24539790000000000000081000310001) ) OR( ( a.DATASET_CODE =10028)
and( a.CAL_PERIOD_ID =24539790000000000000081000310001) ) )
AND ( a.CREATED_BY_OBJECT_ID NOT IN( 10286) )
AND ( a.LEDGER_ID = 111) ) and( a.CURRENCY_TYPE_CODE IN (
'ENTERED' , 'TOTAL' ) )
group by a.CHANNEL_ID, a.COMPANY_COST_CENTER_ORG_ID,
a.CUSTOMER_ID, a.LINE_ITEM_ID, a.NATURAL_ACCOUNT_ID,
a.PRODUCT_ID, a.USER_DIM1_ID, a.USER_DIM2_ID, a.USER_DIM3_ID,
a.USER_DIM4_ID, a.USER_DIM5_ID, a.USER_DIM6_ID, a.USER_DIM7_ID,
a.INTERCOMPANY_ID, a.ENTITY_ID, a.CURRENCY_CODE


/export2/temfch1/appl/fem/11.5.0/bin/FEMCCE
Program was terminated by signal 6

In the Mapping Rule's percent distribution screen, "Currency" is set to "Matching Dimensions".

Steps to replicate:

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