General Ledger - EBS (MOSC)

MOSC Banner

How to restore deleted batch from audit trail shadow tables

edited Nov 18, 2010 1:40AM in General Ledger - EBS (MOSC) 2 commentsAnswered
 I am writing a PL/SQL script to restore a deleted batch and its header and lines from the Audit Trail shadow tables. The problem I have is in retrieving the lines because if I deleted certain lines during the creation of the journal batch, these deleted lines were saved in the GL_JE_LINES_A  table with a AUDIT_TRANSACTION_TYPE of 'D' , a AUDIT_TIMESTAMP and a AUDIT_SESSION_ID.  But during the final deletion of the batch, all the remaing journal lines are also saved  in the GL_JE_LINES_A table with a AUDIT_TRANSACTION_TYPE of 'D',  a AUDIT_TIMESTAMP and a AUDIT_SESSION_ID. How can I distinguish the lines deleted earlier from the one

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