My Oracle Support Banner

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)

Symptoms

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.

 

ERROR

 

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.