Oracle journal approval history

Oracle journal approval history

 

In this post , We will Discuss about oracle journal approval history. This is the most common requirement in oracle application , to track the History of the Journal approvals but unfortunately there is no standard methods in the applications to track the Complete oracle journal approval history but we have some sql tricks and some back end oracle journal approval tables through which we can track the oracle journal approval history.

 

Detail SQL Query for Oracle journal approval history Information's

We can track the Current Approver Id from the GL batches tables. Here below you will get the Person id in the APPROVER_EMPLOYEE_ID of the column of the.

select APPROVER_EMPLOYEE_ID from gl_je_batches

 

For More Information's about setups Click Journal Approval Setup Steps

 

SELECT DISTINCT gjb.NAME batch, default_period_name period,

                   wn.recipient_role approver,

                   DECODE (gjb.approval_status_code,

                           'A', 'Approved',

                           'I', 'In Process',

                           'J', 'Rejected',

                           'R', 'Required',

                           'V', 'Validation Failed',

                           'Z', 'N/A'

                          ) status,

                   wn.begin_date approval_start_date,

                   wn.end_date approval_end_date,

                   wn.due_date approval_due_date

              FROM wf_notifications wn, gl_je_batches gjb

             WHERE wn.user_key = gjb.NAME

             and MESSAGE_TYPE='GLBATCH'