Results for “okx_set_of_books_v”

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

Overview

OKX_SET_OF_BOOKS_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite. It is shipped as part of the OKX – Contracts Integration product, and its stated purpose in the ETRM metadata is to expose set of books definitions. In release 12.1.1 and 12.2.2 the view remains VALID and is used whenever OKX-related contract integration logic, concurrent programs, or reporting queries require a lightweight, presentation-oriented read of the accounting book (set of books) definition without joining the full General Ledger table structure directly.

The view is deliberately narrow. It does not attempt to represent the complete set of books configuration — no chart of accounts identifier, no period type, no retained earnings account. Instead it surfaces the identifying and descriptive attributes of each book: its internal identifier, its display name, its short name, its functional currency, the MRC set of books type code that classifies the book for Multi-Reporting Currency purposes, and the free-form description. This makes it suitable as a lookup or enumeration view within integration flows where only book identity and currency context are required.

Underlying Base Objects

According to the documented view text, OKX_SET_OF_BOOKS_V is defined over a single referenced base object: GL_SETS_OF_BOOKS. The FROM clause references GL_SETS_OF_BOOKS_11I, which is the underlying synonym/view name resolved as GL_SETS_OF_BOOKS in the APPS schema. The view performs no joins, unions, or aggregations; it is a direct projection of six columns from that base object onto the OKX view. Because it depends on exactly one base object and contains no filter predicate in the documented text, the view returns one row per set of books defined in the ledger/set of books repository visible to the querying responsibility.

Key Columns

• SET_OF_BOOKS_ID — The unique internal identifier of the set of books. This is the primary key value used throughout EBS as the foreign key reference for accounting book context.
• NAME — The full display name of the set of books as defined in GL.
• SHORT_NAME — The abbreviated set of books name, commonly used in reports and concatenated descriptions where space is constrained.
• CURRENCY_CODE — The functional (book) currency of the set of books, for example USD or GBP.
• MRC_SOB_TYPE_CODE — The Multi-Reporting Currency set of books type code. This is the columnmost frequently searched in relation to this view (the user query term was "mrc_sob_type_code"). It distinguishes the primary set of books from its reporting counterparts, which is essential when integration logic must decide which book is authoritative and which is a translated reporting book. Typical values correspond to the primary versus reporting designations.
• DESCRIPTION — Free-form descriptive text associated with the set of books.

Common Use Cases and Queries

The view is most often queried to resolve a set of books identifier into readable name and currency data, to enumerate available books for a picklist or parameter list of values, or to isolate the primary book when multiple reporting currency books exist. A basic lookup is shown below:

SELECT set_of_books_id, name, short_name, currency_code, mrc_sob_type_code, description FROM apps.okx_set_of_books_v ORDER BY name;

To find the primary book for a currency, a predicate on MRC_SOB_TYPE_CODE is applied:

SELECT set_of_books_id, name, currency_code FROM apps.okx_set_of_books_v WHERE mrc_sob_type_code = 'P';

Because the view is unfiltered, integration code should always constrain it by SET_OF_BOOKS_ID or CURRENCY_CODE when a single book is expected, particularly in multi-org and MRC-enabled environments where several reporting books share a common currency and only MRC_SOB_TYPE_CODE separates them.