Aggregate to Management Ledger Functionality Does Not Work for Dynamic Driver Allocations Fails With ORA-00936 (Doc ID 2179713.1)

Last updated on JANUARY 21, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)

Symptoms

On PFT 8.0.2, the Aggregate to Management Ledger (FSI_D_MANAGEMENT_LEDGER) Functionality does not work for Dynamic Driver Allocations.  When creating a Dynamic Driver Allocation and selecting Aggregate to Management Ledger option in the Output Section the system does not aggregate the amounts to the Ledger also.  In the error log file the following message is thrown:

ERROR

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
 oexn() SQL Function: [0] - SQL function not found! Oracle Error:
 ORA- 00936: missing expression Driver Function:
 drv_oci::Execute()

Currently trying to aggregate some expenses from transactions table both to an instrument table and the management ledger table using information from the instrument table as driver. When using the aggregate to ledger functionality in the Output side of the allocation screen, the above error message is thrown.  However, when creating two allocation rules using the exact same specifications - one which aggregates to the instrument and one which aggregates to management ledger the system works properly. Have also noticed that the allocation works when the Ledger Stat table is selected. So, the problem seems to be with the aggregation to the management ledger.

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