Results for “gl_recurring_lines”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GL_RECURRING_LINES is a General Ledger table in the GL schema that stores the individual target lines associated with recurring journal entry and recurring budget formulas in Oracle EBS 12.1.1 and 12.2.2. Each row represents a single distribution line—defined by an account (code combination) and an entered debit or credit amount—that the recurring formula will generate when the recurring journal batch is executed. The table is the transactional child of GL_RECURRING_HEADERS, which holds the header-level definition of the recurring formula, including its schedule, reversal options, and currency attributes.

Under the heuristic Data Vault classification derived from the foreign-key structure, GL_RECURRING_LINES is satellite-leaning. It records descriptive, attribute-bearing detail (amounts, account assignment, currency, descriptive text) keyed to the parent recurring header, rather than serving as a pure hub or an associative link between independent business entities. This classification is a modeling suggestion and should not be treated as a physical design constraint in EBS itself.

Key Information Stored

The table contains 23 documented columns. The composite primary key, enforced by GL_RECURRRING_LINES_PK, is (RECURRING_HEADER_ID, RECURRING_LINE_NUM), which also corresponds to the unique index GL_RECURRING_LINES_U1 and acts as the business-key candidate for the table.

• RECURRING_HEADER_ID — Foreign key to GL_RECURRING_HEADERS; identifies the parent recurring formula.
• RECURRING_LINE_NUM — Line sequence number within the header, combined with the header ID to form the composite key.
• CODE_COMBINATION_ID — Foreign key to GL_CODE_COMBINATIONS; identifies the accounting flexfield account to which the recurring amount posts.
• ENTERED_CURRENCY_CODE — Foreign key to FND_CURRENCIES; the currency in which the entered amounts are expressed.
• ENTERED_DR — The entered debit amount for the line.
• ENTERED_CR — The entered credit amount for the line.
• DESCRIPTION — Free-text description of the recurring line.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit (WHO) columns tracking creation and modification.
• ATTRIBUTE1–ATTRIBUTE10 and CONTEXT — Descriptive flexfield (DFF) columns supporting customer-defined attributes on the recurring line.

Common Use Cases and Queries

Recurring formulas are commonly used to generate periodic allocations, accruals, and budget entries without manual re-entry. Reporting on GL_RECURRING_LINES typically involves reconciling formulas to their generated journal lines or listing all target accounts and amounts for review.

A representative listing query joining the line to its header and account:

• SELECT l.recurring_header_id, l.recurring_line_num, l.code_combination_id, l.entered_dr, l.entered_cr
• FROM gl_recurring_lines l
• WHERE l.recurring_header_id = :p_header_id
• ORDER BY l.recurring_line_num;

To resolve account segments, join CODE_COMBINATION_ID to GL_CODE_COMBINATIONS and its key flexfield structure. To resolve the entered currency, join ENTERED_CURRENCY_CODE to FND_CURRENCIES. Balancing checks can be built by comparing the sum of ENTERED_DR against ENTERED_CR per RECURRING_HEADER_ID, which surfaces unbalanced formulas before journal generation.

Related Objects

• GL_RECURRING_HEADERS — Parent table joined on RECURRING_HEADER_ID; holds header-level formula definition and schedule.
• GL_CODE_COMBINATIONS — Joined on CODE_COMBINATION_ID to resolve the target account.
• FND_CURRENCIES — Joined on ENTERED_CURRENCY_CODE to resolve currency attributes.
• GL_RECURRING_LINE_CALC_RULES — Child table referencing GL_RECURRING_LINES via (RECURRING_HEADER_ID, RECURRING_LINE_NUM); stores calculation rules that derive line amounts (for example, percentage-of-account or fixed-rate formulas).
• GL_JE_BATCHES / GL_JE_HEADERS / GL_JE_LINES — The generated journal entry tables populated when a recurring formula is run; used for reconciliation against the recurring definition.
• GL_RECURRING_HEADERS API and Journal Import — Programmatic and standard mechanisms used to create or generate recurring journals from these definitions.

Together these objects form the recurring formula framework: GL_RECURRING_HEADERS defines the schedule, GL_RECURRING_LINES defines the target distributions, GL_RECURRING_LINE_CALC_RULES defines the amount derivation logic, and the GL_JE_* tables hold the resulting journal output.