Allocation on Management Ledger with Attribute Filter Failed with ORA-00907
Last updated on SEPTEMBER 23, 2016
Applies to:Oracle Financial Services Profitability Management - Version 8.0.2 to 8.0.2 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On : 8.0.2 version, Allocation Entries
When attempting to run Dynamic Driver Allocation on Management Ledger with Attribute Filter on Financial Element, it fails with error below.
ORA- 00907: missing right parenthesis Driver Function: drv_oci::Execute()".
MERGE INTO FSI_D_LOAN_CONTRACTS TARGET USING (
SELECT (SOURCE_AMOUNT * 1)TARGET_AMOUNT, SRC_IOVW.*
SELECT SUM(IVWSRC_AMOUNT) SOURCE_AMOUNT, IDENTITY_CODE, ID_NUMBER
SELECT (Src.src_amount* Drv.drv_factor) IVWSRC_AMOUNT ,
FROM (SELECT * FROM(SELECT SUM(DECODE( m.FISCAL_YEAR, 2016.000000
, DECODE(m.FISCAL_MONTH, 4.000000 , m.ENTERED_BALANCE, 0), 0))
FROM (FSI_D_MANAGEMENT_LEDGER) m
WHERE PRODUCT_ID IN (select PRODUCT_ID
where attribute_id = 5059
and DIM_ATTRIBUTE_NUMERIC_MEMBER in ('1'))FINANCIAL_ELEM_ID =
there is no "AND" between the attribute information and "FINANCIAL_ELEM_ID=82100". This seems to be the cause of the error.
The issue can be reproduced at will with the following steps:
1. Define Dynamic Driver Allocation on FSI_D_MANAGEMENT_LEDGER as the source and specify Attribute Filter on Financial Element.
2. Driver on instrument table column.
3. Output instrument table.
4. Remove the filter and allocation is successful
5. Management Ledger to Management Ledger with attribute filter allocations are successful.
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