Search Results alt_chart_of_accounts

Overview

APPS.FA_ALTERNATE_LEDGERS_V is a reporting view in Oracle E-Business Suite that exposes the alternate ledger assignments configured for Oracle Assets (Fixed Assets). Its central role is to translate the book-control relationships held in the fixed assets multi-currency tables into a ledger-oriented presentation that also draws descriptive attributes from the General Ledger ledgers table. The view returns one row per alternate ledger that qualifies as a non-primary ledger, so it functions as the principal data source for reporting and integration scenarios that must resolve which secondary or reporting ledgers an asset book is associated with.

The view is particularly relevant to the "alt_ledger_type" search context, because the column ALT_LEDGER_TYPE is derived at runtime from the ledger category rather than stored directly on the underlying table. The view uses a DECODE construct to map the category code value 'ALC' to 'Reporting' and to render 'SECONDARY' as 'Secondary'. Any other non-primary category value therefore falls through to the secondary branch by default, and the filter condition excludes the 'PRIMARY' category entirely. This makes ALT_LEDGER_TYPE a convenient, human-readable classifier without requiring consumers to interpret raw ledger category codes.

Underlying Base Objects

The documented base objects for this view are FA_MC_BOOK_CONTROLS (referenced via a synonym), FND_ID_FLEX_STRUCTURES_VL (a view), and GL_LEDGERS (referenced via a synonym). The view joins FA_MC_BOOK_CONTROLS MCBC to GL_LEDGERS LED on the condition that the book control set of books equals the ledger identifier. In Oracle EBS 12.1.1 and 12.2.2 this reflects the multi-org architecture in which fixed assets book controls reference a GL ledger identifier through the SET_OF_BOOKS_ID column.

FND_ID_FLEX_STRUCTURES_VL is not joined but is instead invoked as a scalar subquery on the chart of accounts identifier. It resolves the accounting flexfield description by matching the ID_FLEX_NUM, the ID_FLEX_CODE value 'GL#', and APPLICATION_ID 101, which is the application identifier for General Ledger. Only rows whose ledger category is not 'PRIMARY' survive the WHERE clause, so the view is intrinsically scoped to the alternate ledger population.

Key Columns

• LEDGER_ID — identifier of the alternate ledger.
• ALT_BOOK_TYPE_CODE — the book type code from the book controls record (aliased from BOOK_TYPE_CODE).
• ALT_PRIMARY_LEDGER_ID — the primary set of books the alternate ledger is subordinate to.
• ALT_LEDGER — the ledger name.
• ALT_LEDGER_TYPE — the derived classification ('Reporting' or 'Secondary') based on the ledger category code.
• ALT_CURRENCY — the ledger currency code from GL_LEDGERS.
• ALT_CHART_OF_ACCOUNTS — the accounting flexfield structure description resolved for the ledger's chart of accounts.
• ALT_GL_POSTING_ALLOWED_FLAG — indicates whether General Ledger posting is permitted for the ledger.
• ALT_ENABLED_FLAG — whether the book-control record for this ledger is enabled.

Common Use Cases and Queries

Typical usage includes identifying all active alternate ledgers available to asset accounting, validating that a secondary ledger is enabled and posting-permitted before configuring asset reporting, and driving reconciliation or diagnostic reports. The following query lists enabled alternate ledgers with their derived type and currency:

SELECT alt_book_type_code, alt_ledger, alt_ledger_type, alt_currency, alt_chart_of_accounts FROM apps.fa_alternate_ledgers_v WHERE alt_enabled_flag = 'Y';

To isolate only reporting ledgers, filter on ALT_LEDGER_TYPE = 'Reporting', and to trace an alternate ledger back to its primary ledger, select ALT_PRIMARY_LEDGER_ID alongside ALT_LEDGER. Because the view already restricts to non-primary ledgers, no additional category predicate is required in consumer queries.