My Oracle Support Banner

Instrument to Ledger Stat Allocation ID Not Writing Results to the LEDGER_STAT Table (Doc ID 421544.1)

Last updated on FEBRUARY 21, 2020

Applies to:

Oracle Profitability Manager - Version 4.5.39 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5.39
Oracle Performance Analyzer (PA) - Version: 4.5 or higher

Symptoms

A simple Allocation ID that takes records from an instrument table and writes them to the Ledger Stat table is not generating any results.  While the Allocation's "Filter On" does retrieve records from the input table, records are not being written to Ledger Stat.  The insert or update on LEDGER_STAT is not working.

An example of the Allocation setup is as follows:

Filter On: FEM_CHECKING
Debit: LEDGER_STAT

No calculation is performed on the Filter On records.

A SQL Trace and tkprof of the Allocation shows a full table scan on the update of LEDGER_STAT:


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
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.