Results for “gl_autoreverse_options_v”

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

Overview

GL_AUTOREVERSE_OPTIONS_V is an APPS-owned database view in the Oracle E-Business Suite General Ledger (GL) module. It presents automatic journal reversal configuration data, allowing implementers and developers to query the reversal rules defined for journal categories without directly accessing the underlying transactional table. Automatic reversal is a core General Ledger feature that generates a reversing journal entry for a specified category, such as accruals, and the options governing that behavior are stored centrally and exposed through this view. The view carries a status of VALID in the documented environment and is available in both EBS 12.1.1 and 12.2.2.

The view joins reversal option records to journal category definitions, resolving the internal category name to the user-facing category name. Because it exposes descriptive columns including the criteria set identifier, method code, reversal period code, and reversal date code, it serves as a convenient reporting and integration surface for reconciliation, setup auditing, and interface development.

Underlying Base Objects

The documented view text defines GL_AUTOREVERSE_OPTIONS_V over two base objects:

• GL_AUTOREVERSE_OPTIONS (SYNONYM) — aliased as APO, the primary source of reversal configuration rows.
• GL_JE_CATEGORIES (SYNONYM) — aliased as CAT, the journal category definition table.

The two objects are joined on the condition CAT.JE_CATEGORY_NAME = APO.JE_CATEGORY_NAME. This equi-join enriches each reversal option row with the corresponding user-defined journal category name. The view also exposes APO.ROWID as ROW_ID, though this identifier is not intended for update operations through the view itself.

Key Columns

• ROW_ID — the ROWID of the underlying GL_AUTOREVERSE_OPTIONS row.
• USER_JE_CATEGORY_NAME — the user-facing journal category name sourced from GL_JE_CATEGORIES.
• CRITERIA_SET_ID — the identifier of the criteria set associated with the reversal option. This is the column most relevant to users searching for "criteria_set_id," and it links reversal configuration to category-level criteria definitions.
• JE_CATEGORY_NAME — the internal journal category name from GL_AUTOREVERSE_OPTIONS.
• METHOD_CODE — the reversal method applied, such as a switch debit/credit or change sign method.
• REVERSAL_PERIOD_CODE — the period in which the reversal is generated.
• REVERSAL_DATE_CODE — the date rule applied to the reversal entry.
• AUTOREVERSE_FLAG — indicates whether automatic reversal is enabled for the category.
• AUTOPOST_REVERSAL_FLAG — indicates whether the generated reversal is automatically posted.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN track record ownership and change history.
• ATTRIBUTE1 through ATTRIBUTE15 and CONTEXT — the standard descriptive flexfield columns for extensible configuration attributes.

Common Use Cases and Queries

The view is typically used to audit reversal setup, join reversal options to category criteria, and feed custom reports or interfaces. A representative query retrieves reversal configuration for a specific category or criteria set:

• List all reversal options with their user category names.
• Filter by criteria_set_id to isolate the rules tied to a particular criteria set.
• Identify categories where automatic posting of reversals is enabled.

Sample SQL:

SELECT criteria_set_id, user_je_category_name, method_code,
       reversal_period_code, autoreverse_flag, autopost_reversal_flag
FROM apps.gl_autoreverse_options_v
WHERE criteria_set_id = :p_criteria_set_id;

Because the view is read-only in practice and resolves category names through a join, it is well suited for reporting layers and validation logic within concurrent programs, OAF pages, and external integrations.