Allocation on Management Ledger with Attribute Filter Failed with ORA-00907 (Doc ID 2186297.1)

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)

Symptoms

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.

Error:
ORA- 00907: missing right parenthesis Driver Function: drv_oci::Execute()".

MERGE INTO FSI_D_LOAN_CONTRACTS TARGET USING (
SELECT *
FROM (
SELECT (SOURCE_AMOUNT * 1)TARGET_AMOUNT, SRC_IOVW.*
FROM (
SELECT SUM(IVWSRC_AMOUNT) SOURCE_AMOUNT, IDENTITY_CODE, ID_NUMBER
FROM (
SELECT (Src.src_amount* Drv.drv_factor) IVWSRC_AMOUNT ,
Drv.IDENTITY_CODE, Drv.ID_NUMBER
FROM (SELECT * FROM(SELECT SUM(DECODE( m.FISCAL_YEAR, 2016.000000
, DECODE(m.FISCAL_MONTH, 4.000000 , m.ENTERED_BALANCE, 0), 0))
src_amount
FROM (FSI_D_MANAGEMENT_LEDGER) m
WHERE PRODUCT_ID IN (select PRODUCT_ID
from DIM_PRODUCTS_ATTR
where attribute_id = 5059
and DIM_ATTRIBUTE_NUMERIC_MEMBER in ('1'))FINANCIAL_ELEM_ID =
82100.000000
(...)

there is no "AND" between the attribute information and "FINANCIAL_ELEM_ID=82100". This seems to be the cause of the error.

 


Steps:
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.


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