Oracle journal approval tables

Oracle journal approval tables

In this post , we will discuss about the oracle r12 journal entry approval and the tables involved in the oracle journal approval. . In Oracle r12, we can use the Standard Super Visor Hierarchy to build the Journal Entry approval. This helps to control manual entering Journals in the System. We can define in the GL setups for which Sources we want to implement the oracle r12 journal entry approval. Here below I am sharing the complete setups to implement oracle r12 journal entry approval and the oracle journal approval tables uses in this process.

Detail SQL Query Using Oracle journal approval tables

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'