Search Results org_param_ior_account

Overview

GMF_XLA_ORG_PARAMETERS_V is an APPS-owned database view in Oracle E-Business Suite that exposes Subledger Accounting (SLA) Accounting Derivation Rule (ADR) source values drawn from Inventory Organization parameters. It belongs to the Process Manufacturing Financials (GMF) product family and exists specifically to surface the account and flexfield attribute information that Subledger Accounting requires when deriving accounting entries for process manufacturing transactions. In EBS 12.1.1 and 12.2.2, SLA uses ADR source values to determine how journal entries are constructed; this view supplies those source values at the inventory organization level.

The view is restricted to organizations flagged as process-enabled. Only rows where PROCESS_ENABLED_FLAG equals 'Y' are returned, and each row is enriched with the organization code of its master organization. This makes the view a convenient, ready-made source of organization-level accounting parameters for reporting, integration, and SLA rule configuration without requiring the caller to join MTL_PARAMETERS to itself manually.

Underlying Base Objects

The documented base object for this view is MTL_PARAMETERS, exposed through a synonym in the APPS schema. The view text references MTL_PARAMETERS twice. It reads the primary row (alias MP1) for organizational attributes and account parameters, and it joins to a derived inline subquery (alias MP_MST) that returns the ORGANIZATION_ID and ORGANIZATION_CODE of the master organization. The join condition is:

• MP1.PROCESS_ENABLED_FLAG = 'Y' — restricts output to process-enabled organizations.
• MP_MST.ORGANIZATION_ID = MP1.MASTER_ORGANIZATION_ID — maps each organization to its master organization code.

The inline subquery filters MTL_PARAMETERS by ORGANIZATION_ID = MASTER_ORGANIZATION_ID, effectively identifying the master organization record itself. Because the view is defined entirely over MTL_PARAMETERS, no data is stored in the view; it reflects the current configuration of inventory organization parameters at query time.

Key Columns

The view exposes a broad set of columns. The most commonly referenced include:

• ORGANIZATION_ID, ORGANIZATION_CODE — the inventory organization identifier and its short code.
• MASTER_ORGANIZATION_CODE — the code of the owning master organization.
• CONSIGNED_FLAG, WMS_ENABLED_FLAG — organization flags, defaulted to 'N' when null.
• ORG_PARAM_PPV_ACCOUNT, ORG_PARAM_AP_ACCRUAL_ACCOUNT, ORG_PARAM_ITR_ACCOUNT, ORG_PARAM_IOR_ACCOUNT, ORG_PARAM_IOP_ACCOUNT — purchase price variance, AP accrual, intransit inventory, interorg receivables, and interorg payables accounts.
• ORG_PARAM_COGS_ACCOUNT, ORG_PARAM_XFER_CREDIT_ACCOUNT, ORG_PARAM_IPV_ACCOUNT, ORG_PARAM_EXPENSE_ACCOUNT — cost of sales, interorg transfer credit, invoice price variance, and expense accounts.
• ORG_PARAM_DISTR_ACCOUNT_ID — the distribution account identifier, aliasing MTL_PARAMETERS.DISTRIBUTION_ACCOUNT_ID. This is the column most relevant to users searching on DISTRIBUTION_ACCOUNT_ID.
• ORG_PARAM_DCOGS_ACCOUNT — the deferred cost of sales account.
• INV_ORG_ATTRIBUTE_CATEGORY and INV_ORG_ATTRIBUTE1 through INV_ORG_ATTRIBUTE15 — the descriptive flexfield context and attribute values carried from the organization parameters.

Common Use Cases and Queries

Typical uses include validating SLA account derivation setup, auditing organization-level account assignments, and feeding downstream reconciliations. A simple query to retrieve the distribution account and related parameters for a given organization follows:

• SELECT organization_id, organization_code, master_organization_code, org_param_distr_account_id, org_param_cogs_account FROM apps.gmf_xla_org_parameters_v WHERE organization_id = :p_org_id;
• SELECT organization_code, org_param_distr_account_id FROM apps.gmf_xla_org_parameters_v ORDER BY organization_code;
• SELECT organization_id, organization_code FROM apps.gmf_xla_org_parameters_v WHERE org_param_distr_account_id IS NOT NULL;

These queries confirm the value of DISTRIBUTION_ACCOUNT_ID as configured on the inventory organization and are useful when troubleshooting SLA journal line generation in process manufacturing environments.