Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Why do rows still exist for a ledger and period in the GL_BALANCES table after running the purge?

edited May 12, 2022 3:27PM in Core Concurrent Processing - EBS (MOSC) 3 commentsAnswered

I am following the standard purge process for a specific ledger and period and permanently closed the period first, via a SUPER_USER responsibility.

I did a count on the data in the GL_BALANCES table for the specific ledger and period BEFORE the purge, and it was around 60000 rows. I ran the purge balances process and it completed successfully, and then I checked the row count again and found that it had deleted around 30000 and left 30000 still in the table.

By comparison, when running the journal purge for the same ledger and period, there were 80 rows in the GL_JE_HEADERS table before the purge, and 0 rows after the purge.

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