General Ledger - EBS (MOSC)

MOSC Banner

Gl_balances vs gl_balances in consecutive periods

edited Nov 27, 2012 6:35PM in General Ledger - EBS (MOSC) 8 commentsAnswered
Dear All.

I am follow Inconsistent Balances Scripts [ID 101579.1].

3. Gl_balances vs gl_balances in consecutive periods
If you know or suspect the periods in which the corruption exists, you can obtain all the accounts with this problem.
This can only check periods within the same calendar year. It does not check translated balances

Select a.code_combination_id ccid, a.template_id,a.period_name,
a.BEGIN_BALANCE_DR - a.BEGIN_BALANCE_CR
+ a.PERIOD_NET_DR - a.PERIOD_NET_CR end_previous,
b.period_name,
b.BEGIN_BALANCE_DR - b.BEGIN_BALANCE_CR begin_next

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center