Results for “financials_system_params_mrc_v”

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

Overview

FINANCIALS_SYSTEM_PARAMS_MRC_V is a multi-organization reporting (MRC) view in the Oracle E-Business Suite Payables (AP) module. MRC views are legacy constructs that expose multiple reporting (set-of-books) contexts through a single selectable object, and this view specifically provides a reporting-layer projection of the core AP financials system parameters record originally held in FINANCIALS_SYSTEM_PARAMS_ALL. The ETRM documentation flags the object with the description "Retrofitted" and notes "Not implemented in this database," meaning the view is present as a Retrofit/upgrade artifact rather than a guaranteed runtime object — it may not exist in every 12.1.1 or 12.2.2 environment.

The first select-list expression is significant: NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 45, 10)), -99). This extracts an organization identifier from the client session context and represents the MRC set-of-books discriminator used by MRC-enabled financial reporting. The view therefore aligns AP system parameters with the current reporting context when invoked in MRC environments.

Underlying Base Objects

The documented ETRM metadata lists no referenced base objects. The view text, however, reveals the source selection is aliased "AP," consistently referencing columns that belong to the AP system parameters table (FINANCIALS_SYSTEM_PARAMS / _ALL family). No join to GL or other ledgers is documented, which is consistent with MRC views that typically filter or project the parameter record by the client-info reporting organization.

Because the dictionary snippet provided is a partial open, the trailing portion (up to AP.GL...) is truncated. The final columns likely relate to GL-specific encumbrance and accounting settings, including the encumbrance type identifier referenced by the search term.

Key Columns

• MRC discriminator (first expression): the set-of-books/organization identifier derived from CLIENT_INFO, defaulting to -99 when unavailable.
• INVOICE_CURRENCY_CODE / PAYMENT_CURRENCY_CODE: default currencies applied to invoice entry and payment processing.
• ORG_ID: the operating unit context for the parameters row.
• ACCTS_PAY_CODE_COMBINATION_ID, PREPAY_CODE_COMBINATION_ID, DISC_TAKEN_CODE_COMBINATION_ID: default accounting flexfield accounts for Payables transactions.
• RESERVE_AT_COMPLETION_FLAG, RES_ENCUMB_CODE_COMBINATION_ID: encumbrance reservation controls and the associated encumbrance account.
• FUTURE_PERIOD_LIMIT, HOLD_UNMATCHED_INVOICES_FLAG, MATCH_OPTION, TAX_ROUNDING_RULE, MINIMUM_ACCOUNTABLE_UNIT, PRECISION: processing behaviour controls for matching, holds, tax rounding, and currency precision.
• BANK_CHARGE_BEARER, TERMS_ID, PAY_DATE_BASIS_LOOKUP_CODE: payment and terms defaults.
• GLOBAL_ATTRIBUTE_CATEGORY and GLOBAL_ATTRIBUTE1..N: descriptive flexfield segment values.

Common Use Cases and Queries

The view is primarily used in MRC-aware reporting to retrieve AP system defaults for a specific reporting organization without touching the multi-org base table directly. The search term inv_encumbrance_type_id corresponds to the encumbrance type assigned to the Payables system parameters; because the visible select list is truncated at "AP.GL," this column most likely appears in the obscured trailing portion alongside other GL/encumbrance integration columns. Analysts searching for it are typically tracing how invoice encumbrances and reserve-at-completion behaviour are configured.

Typical query patterns include:

• Retrieving AP defaults for the current session organization: SELECT org_id, invoice_currency_code, payment_currency_code, accts_pay_code_combination_id FROM financials_system_params_mrc_v WHERE org_id = :p_org_id;
• Auditing encumbrance configuration, selecting the encumbrance-related columns exposed (reserve flag, reservation CCID, and, where present in the full definition, the encumbrance type): SELECT org_id, reserve_at_completion_flag, res_encumb_code_combination_id FROM financials_system_params_mrc_v;
• Verifying payment and tax defaults per operating unit for data-migration or reconciliation exercises.

Because the object is documented as retrofitted and potentially not implemented, query availability should be validated against the target instance's dictionary before relying on it in custom code.