Custom Audit GL Journal Report

Query:

SELECT JE_BATCH_ID,
       ACTION_CODE,
       ACTION_DATE,
       JE_HEADER_ID,
       USER_ID,
       LAST_UPDATE_DATE,
       LAST_UPDATED_BY,
       CREATION_DATE,
       CREATED_BY
  FROM GL_JE_ACTION_LOG
 WHERE TO_DATE(ACTION_DATE, 'DD-MM-YYYY') BETWEEN :P_START_DATE AND :P_END_DATE;  

:p_start_date and :p_end_date must be specified if the report needs to be generated for a specific time range.

Steps to create a BI report using this query:

1. Navigate to Navigator → Tools → Reports and Analytics → Browse Catalog → (Business Intelligence).

2. Select New Data Model → Data Sets.

3. Create a New Data Set and select SQL Query as the type.

4. Enter a Name (e.g., AuditGLJournal).

5. Choose the appropriate Data Source.

6. Add your SQL Query (refer to the provided example).

7. Define the report parameters (e.g., start_date and end_date).

8. Create the Report based on this data model — choose the desired layout, fields, and output format.