General Ledger - EBS (MOSC)

MOSC Banner

How to check the number of records to be deleted by GL:Archive & Purge

edited Jun 1, 2017 5:00AM in General Ledger - EBS (MOSC) 1 commentAnswered

Hi

  We are using R12.1.2 We want to run "GL:Archive & Purge".  I know , this program purges data from

- GL_JE_BATCHES

- GL_JE_HEADERS

- GL_JE_LINES

- GL_IMPORT_REFERENCES

I want to make sure

"the number records to be deleted from these source tables"      matches     "the number of records to be archived".

How can I check with a SQL script. For example:

The number of records in the GL_JE_BATCHES to be archived/purged for period=&periodname

-----------------------------------------------------------------------------------

select period_name,ledger_id, actual_flag , count(distinct je_batch_id)

from gl_je_headers

WHERE period_name=&periodname

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