GL Recurring Journal and Budget Formulas – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: General Ledger · all General Ledger reports

Overview

Lists Oracle General Ledger recurring journal and budget formula definitions - batches, journal entries, lines and each line’s formula steps - with the account code combinations exploded into one column per Accounting Flexfield segment.

Each row is one formula step. The line account, which is the account the generated journal posts to, and the formula account, which is the account a step reads a balance from, are both shown segment by segment. Company, Department, Account, Sub-Account and the remaining segments of your chart of accounts therefore become individual columns that can be sorted and filtered in Excel.

Replaces the Oracle standard report ‘Other - Recurring Formula Listing’ (GLXRLRFL), which prints concatenated code combinations in a fixed page layout. Definition access set security on recurring batches is applied exactly as in the standard report.

Use the Ledger, Batch Name, Journal Entry Name and Category parameters to focus on a subset, for example intercompany or intracompany batches, and the per segment like, From and To parameters to restrict the accounts.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Ledger, Calendar, Batch Name, Journal Entry Name, Category, Balance Type, Batch Type, MassAllocation Batch, Enabled, Account like, GL_SEGMENT1, GL_SEGMENT1 From, GL_SEGMENT1 To, GL_SEGMENT2, GL_SEGMENT2 From, GL_SEGMENT2 To, GL_SEGMENT3, GL_SEGMENT3 From, GL_SEGMENT3 To, GL_SEGMENT4, GL_SEGMENT4 From, GL_SEGMENT4 To, GL_SEGMENT5, GL_SEGMENT5 From, GL_SEGMENT5 To, GL_SEGMENT6, GL_SEGMENT6 From, GL_SEGMENT6 To, GL_SEGMENT7, GL_SEGMENT7 From, GL_SEGMENT7 To, GL_SEGMENT8, GL_SEGMENT8 From, GL_SEGMENT8 To, GL_SEGMENT9, GL_SEGMENT9 From, GL_SEGMENT9 To, GL_SEGMENT10, GL_SEGMENT10 From, GL_SEGMENT10 To

Oracle EBS Tables Used

gl_je_categories_vl, gl_daily_conversion_types, gl_code_combinations_kfv, gl_recurring_batches, gl_ledgers, gl_recurring_headers, gl_recurring_lines, gl_recurring_line_calc_rules

Report Categories

Enginatics

AP Invoices and Lines, GL Account Distribution Analysis, GL Account Analysis

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output GL Recurring Journal and Budget Formulas 30-Jul-2026 203224.xlsx
Blitz Report™ XML Import GL_Recurring_Journal_and_Budget_Formulas.xml
SQL Source GL Recurring Journal and Budget Formulas.sql
Full Report on Enginatics www.enginatics.com/reports/gl-recurring-journal-and-budget-formulas/

Case Study & Technical Analysis: GL Recurring Journal and Budget Formulas

Executive Summary

GL Recurring Journal and Budget Formulas lists the recurring journal and budget definitions of Oracle General Ledger, with their batches, journal entries, lines and the formula steps behind each line. Every account is split into one column per Accounting Flexfield segment, so the company, department, account, sub-account and other segments can be sorted and filtered in Excel. General Ledger administrators and month-end close teams use it to review what each recurring entry posts and which balances it reads.

Business Challenge

The Solution

Technical Architecture (High Level)

Primary Tables

Logical Relationships

  1. GL_RECURRING_BATCHES is joined to GL_LEDGERS on the ledger identifier.
  2. Batches are joined to GL_RECURRING_HEADERS on the recurring batch identifier.
  3. Headers are joined to GL_RECURRING_LINES on the recurring header identifier.
  4. Lines are outer joined to GL_RECURRING_LINE_CALC_RULES on header and line number, so each line returns one row per formula step.
  5. Each line’s account is joined to GL_CODE_COMBINATIONS_KFV, and each step’s assigned account is looked up in a correlated subquery against the same view.
  6. Category and conversion type names are resolved through correlated subqueries against their definition views.

Parameters & Filtering

Performance & Optimization

FAQ

Q: How do I see every recurring entry that posts to a particular department? A: Enter the department value in the matching GL_SEGMENT parameter, or use the From and To range for that segment. Each row shows the line account segment by segment.

Q: What is the difference between the line account and the formula account? A: The line account is the account the generated journal posts to. The formula account is the account a formula step reads a balance from.

Q: Does this report replace the standard recurring formula listing? A: It covers the same definitions, with segments in separate columns and one row per formula step. The description notes that it replaces the standard Other Recurring Formula Listing.

© Enginatics GmbH