My Oracle Support Banner

OBIA 11g GL Balances Not Matching With PSFT Tables (Doc ID 1678487.1)

Last updated on DECEMBER 23, 2019

Applies to:

Business Intelligence Applications Consumer - Version and later
Information in this document applies to any platform.


On : version, DataWarehouse

GL Balances are not matching with PSFT tables

The posted transaction amount from ps_ledger is not matching with w_gl_balance_f for the same set of conditions (Ledger,Account, Fiscal year).
Secondly, it has multiple entries for Budget Ledgers against the Actuals Ledger. So it multiplies by a factor of number of occurrences of budget_ledger_wids


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

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