Search Results ledger_category_code

Overview

FA_ALTERNATE_LEDGERS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the Oracle Assets (OFA) product. It exposes the set of alternate ledgers that have been associated with an asset book, joining the Assets multi-currency book controls to the General Ledger ledger definition. The view presents a denormalized, human-readable projection in which raw foreign keys and coded values are resolved to descriptive labels, making it suitable for reporting, diagnostics, and integration extracts without requiring callers to understand the underlying multi-currency book setup.

The view is particularly relevant when searching on the term ledger_category_code. The GL_LEDGERS.LEDGER_CATEGORY_CODE value drives the derived ALT_LEDGER_TYPE column through a DECODE expression, and the view explicitly filters out the primary ledger (LEDGER_CATEGORY_CODE <> 'PRIMARY'). This confirms that the view is scoped exclusively to non-primary (secondary and reporting) ledgers associated with an asset book.

Underlying Base Objects

The view is defined over the following documented objects:

• FA_MC_BOOK_CONTROLS (synonym) — the Assets multi-currency book controls table. It supplies the alternate book type code, the associated primary ledger identifier, and the enabled flag that indicates whether the alternate ledger is active for the book.
• GL_LEDGERS (synonym) — the General Ledger ledgers table. It provides the ledger name, currency, chart of accounts identifier, GL posting flag, and the ledger category code used to classify the ledger type.
• FND_ID_FLEX_STRUCTURES_VL (view) — used in a scalar subquery to resolve the chart of accounts structure identifier (from GL_LEDGERS.CHART_OF_ACCOUNTS_ID) into a descriptive chart of accounts name, restricted by ID_FLEX_CODE = 'GL#' and APPLICATION_ID = 101.

The join condition links FA_MC_BOOK_CONTROLS.SET_OF_BOOKS_ID to GL_LEDGERS.LEDGER_ID, so each row represents one alternate ledger configured for an asset book.

Key Columns

• LEDGER_ID — identifier of the alternate ledger in GL_LEDGERS. Serves as the linking key back to General Ledger.
• ALT_BOOK_TYPE_CODE — the alternated asset book type code from FA_MC_BOOK_CONTROLS.
• ALT_PRIMARY_LEDGER_ID — the primary set of books / ledger identifier associated with the alternate book.
• ALT_LEDGER — the descriptive ledger name.
• ALT_LEDGER_TYPE — a derived classification produced by DECODE on LEDGER_CATEGORY_CODE: 'ALC' maps to 'REPORTING'; all other non-primary values map to 'SECONDARY'.
• ALT_CURRENCY — the ledger currency code.
• ALT_CHART_OF_ACCOUNTS — the resolved chart of accounts name obtained from the flex structures view.
• ALT_GL_POSTING_ALLOWED_FLAG — indicates whether GL posting is permitted for the alternate ledger.
• ALT_ENABLED_FLAG — indicates whether the alternate ledger is enabled for the book, sourced from FA_MC_BOOK_CONTROLS.ENABLED_FLAG.

Common Use Cases and Queries

Typical applications include reporting the alternate ledgers configured per asset book, validating multi-currency setup, and filtering reporting versus secondary ledgers. Because ALT_LEDGER_TYPE is derived rather than stored, consumers can query directly on the friendly label.

List all enabled secondary and reporting ledgers for a book:

• SELECT alt_book_type_code, alt_ledger, alt_ledger_type, alt_currency FROM fa_alternate_ledgers_v WHERE alt_enabled_flag = 'Y' ORDER BY alt_book_type_code, alt_ledger;

Restrict to reporting ledgers only:

• SELECT alt_ledger, alt_primary_ledger_id, alt_chart_of_accounts FROM fa_alternate_ledgers_v WHERE alt_ledger_type = 'REPORTING';

Because the view already excludes primary ledgers, no additional filtering on ledger category is required; callers need only reference the derived ALT_LEDGER_TYPE column to distinguish reporting from secondary ledgers.