All Ledger Stat Allocations Fail with 'Invalid Debit' & 'Invalid Page' During Monthly Processing

(Doc ID 2040957.1)

Last updated on AUGUST 11, 2015

Applies to:

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

Symptoms

For Oracle Financial Services Profitability Management (PFT), in production, when you execute your Ledger Stat Allocations during the monthly processing cycle, all Allocations fail.  Messages like the following exist in the ofspa.xxxxx.log in $FIC_DB_HOME/log/FusionApps:

Module Logging OFS errors: Invalid Debit

Module Logging OFS errors: Invalid Page

Module Logging OFS errors: No records to allocate Allocation ID is empty 

The following messages exist in FSI_MESSAGE_LOG for the batch:

LEDGER_STAT.USER_DIM1_ID
LEDGER_STAT.USER_DIM2_ID
LEDGER_STAT.USER_DIM3_ID
LEDGER_STAT.USER_DIM4_ID
LEDGER_STAT.USER_DIM5_ID
LEDGER_STAT.USER_DIM6_ID
LEDGER_STAT.USER_DIM7_ID
Invalid Debit.
Page: 1
Allocation ID is empty.
Allocation Preparation Completed

All Ledger Stat Allocations fail as a result of the errors.

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