Aggregate to Management Ledger Functionality Does Not Work for Dynamic Driver Allocations Fails With ORA-00936
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)
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:
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function:  - oexec(),
oexn() SQL Function:  - SQL function not found! Oracle Error:
ORA- 00936: missing expression Driver Function:
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms