8.0.5 PFT Allocation Rules For Management Ledger Fail w/ ORA- 00936: Missing Expression Error
(Doc ID 2547193.1)
Last updated on OCTOBER 19, 2020
Applies to:Oracle Financial Services Profitability Management - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
On PFT 8.0.5 version, Allocation Rules for Management Ledger are failing with ORA-00936 error in ofspa log.
As per logs, there seems to be an issue with code generated for MERGE INTO statement - not all columns from FSI_D_MANAGEMENT_LEDGER are stated in there.
Issue might be related to dimensions that are part of Management Ledger.
n_acct_skey column has been added in FSI_D_MANAGEMENT_LEDGER (which is for DIM_ACCOUNT dimension). Should this be registered in some way?
DIM_ACCOUNT is not listed in Dimensions.
STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Run PFT Allocation Rule for Management Ledger.
2. Check ofspa log for errors.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document