Results for “translate_yatd_flag”

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

Overview

GL_LEDGERS_V is a General Ledger (GL) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its status is VALID. The view presents a flattened, reporting-friendly representation of the ledger definitions stored in the GL_LEDGERS base table, enriching each ledger record with descriptive names and reference information resolved from supporting GL and Application Object Library (AOL) objects such as the chart of accounts structure, period types, suspense accounts, net income accounts, and daily conversion types. Rather than joining across the multiple normalized tables that hold ledger configuration, developers and report authors can query a single view to obtain the complete attribute set of a ledger.

Within Oracle EBS, ledgers are the central accounting containers that determine the chart of accounts, currency, accounting calendar, and subledger accounting (SLA) rules used to record and report transactions. GL_LEDGERS_V therefore serves as a foundational reference source for reporting, integration, and validation logic that must resolve ledger identity, currency, calendar, and control flags. It is commonly used in custom reports, interfaces, conversions, and BI Publisher data models where ledger attributes must be retrieved without directly navigating GL_LEDGERS.

Underlying Base Objects

The ETRM 12.2.2 metadata documents the following referenced base objects, exposed as synonyms: FND_ID_FLEX_STRUCTURES_TL, GL_DAILY_CONVERSION_TYPES, GL_LEDGERS, GL_NET_INCOME_ACCOUNTS, GL_PERIOD_TYPES, GL_SUSPENSE_ACCOUNTS, and GL_TRANSACTION_CALENDAR. The view is defined primarily over GL_LEDGERS (aliased LEDGER), which supplies the ledger ID, name, short name, chart of accounts ID, currency code, period set name, retained earnings account, suspense configuration, intercompany and budgetary control flags, journal approval and automatic tax flags, and consolidation and translation options.

The joins enrich this core record. FND_ID_FLEX_STRUCTURES_TL (aliased FIFS) supplies the chart of accounts structure name (CHART_OF_ACCOUNTS_NAME). GL_PERIOD_TYPES (aliased GPT) supplies the user period type (USER_PERIOD_TYPE). GL_SUSPENSE_ACCOUNTS provides the suspense code combination ID, and GL_NET_INCOME_ACCOUNTS and GL_DAILY_CONVERSION_TYPES contribute additional ledger-level configuration. GL_TRANSACTION_CALENDAR relates to the accounting calendar context. Because these objects are referenced through APPS synonyms, the view remains consistent with standard EBS naming and access conventions.

Key Columns

• ROW_ID, LEDGER_ID — Unique row identifier and the primary ledger identifier.
• NAME, SHORT_NAME — Descriptive ledger name and abbreviated name used in reporting.
• CHART_OF_ACCOUNTS_ID, CHART_OF_ACCOUNTS_NAME — Chart of accounts structure identifier and its translated name.
• CURRENCY_CODE — Functional currency of the ledger.
• PERIOD_SET_NAME, USER_PERIOD_TYPE, ACCOUNTED_PERIOD_TYPE — Accounting calendar, its user period type, and the accounted period type.
• FIRST_LEDGER_PERIOD_NAME — First open period of the ledger.
• RET_EARN_CODE_COMBINATION_ID, SUSPENSE_CCID, SUSPENSE_ALLOWED_FLAG — Retained earnings and suspense account configuration.
• ALLOW_INTERCOMPANY_POST_FLAG — Indicates whether intercompany posting is permitted.
• ENABLE_AVGBAL_FLAG, ENABLE_BUDGETARY_CONTROL_FLAG, REQUIRE_BUDGET_JOURNALS_FLAG — Average balance, budgetary control, and budget journal requirements.
• ENABLE_JE_APPROVAL_FLAG, ENABLE_AUTOMATIC_TAX_FLAG — Journal approval and automatic tax enablement.
• CONSOLIDATION_LEDGER_FLAG, TRANSLATE_EOD_FLAG, TRANSLATE_QATD_FLAG, TRANSLATE_YATD_FLAG — Consolidation and translation (end of day, quarter-to-date, year-to-date) options.
• ALC_LEDGER_TYPE_CODE, LE_LEDGER_TYPE_CODE — Accounting and legal entity ledger type codes.
• BAL_SEG_* and MGT_SEG_* — Balancing and management segment value options, column names, and value set IDs.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — Standard audit columns.

Common Use Cases and Queries

Typical scenarios include retrieving ledger definition details for reporting, validating ledger configuration before interface loads, and driving SLA or consolidation logic. A basic lookup by short name illustrates the pattern:

SELECT ledger_id, name, short_name, currency_code, period_set_name, chart_of_accounts_name FROM gl_ledgers_v WHERE short_name = :p_short_name;

To list all ledgers by currency and calendar:

SELECT ledger_id, name, currency_code, period_set_name FROM gl_ledgers_v WHERE currency_code = 'USD' ORDER BY name;

To identify ledgers with budgetary control or journal approval enabled:

SELECT ledger_id, name FROM gl_ledgers_v WHERE enable_budgetary_control_flag = 'Y' AND enable_je_approval_flag = 'Y';

The view is read-only and should be queried rather than modified; all maintenance of ledger definitions is performed through the standard General Ledger setup forms and APIs against the underlying base tables.