BSP Incorrect New Business Results for Any Defined Method Due to Fiscal Year Changes and Primary Key Errors

(Doc ID 2301037.1)

Last updated on OCTOBER 06, 2017

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.2.0.9 and later
Information in this document applies to any platform.
Oracle Financial Services Balance Sheet Planning (BSP)

Symptoms

On BSP 8.0.2.0.9, new business is not correctly output for any defined method (Target Growth and New Add both tried).

ACTUAL BEHAVIOR
After clearing the cube for Financial Elements, ran the cash-flows at node level for version 1 and found the following:

Version 1 Output (Config: Forecast Balance Method: Target Growth, Currency Factor: Rupees in Crores, TP Rule Attached)

1) Existing business cash-flows are correctly getting generated for all products.
2) New Business is populating as '0' for first 9 months and there are some values getting populated for the last 3 months.

Without clearing the cube for Financial Elements, re-ran the cash-flows at node level for version 2 and the following are the observations:

Version 2 Output (Config: Forecast Balance Method: Target Growth, Currency Factor: Rupees in Crores, TP Rule Attached)

1) Existing business cash-flows are correctly getting generated for all products.
2) New Business is not getting generated for any products.

The Config_FileCall.log shows the following errors:
ERROR: Cannot calculate file. Essbase Error(1200497): Error parsing formula for [FIX STATEMENT] (line 2): unknown member name ["9999"] in function [@RELATIVE]
Cube dataLoad Final Status :Data loaded but not calculated.

EXPECTED BEHAVIOR
Expect new business results to be generated as defined.

The issue can be reproduced at will with the following steps:
1. Without clearing the cube for Financial Elements, re-ran the cash-flows at node level for version 2.
2. Check res_dtl results

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