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