Search Results distribution_meaning




Overview
Explore in AI Chat

Overview

APPS.AR_CORRECT_GL_ACCOUNTS_V is a supplementary Oracle EBS view owned by the APPS schema and registered in FND Design Data as AR.AR_CORRECT_GL_ACCOUNTS_V. It is classified as a "supplementary view used to simplify forms coding," which means Oracle does not recommend querying or altering data through it directly, and its definition may change dramatically across minor or major releases. In the 12.1.1 and 12.2.2 environments documented here, the view has a status of VALID and is not referenced by any other database object, confirming its role as a terminal, presentation-layer construct for the Receivables GL account correction form rather than a building block for further application logic.

The view supports the Accounts Receivable functionality that allows correction of the GL account (code combination) assigned to accounting distributions on transactions, receipts, and related subledger entries. It exposes paired "distribution" and "category" attributes alongside old and new code combination identifiers, enabling the concurrent program and form logic to present human-readable meanings rather than raw IDs.

Underlying Base Objects

The documented dependency list for APPS.AR_CORRECT_GL_ACCOUNTS_V contains two objects:

The view therefore sits over correction data supplied by AR_CCID_CORRECTIONS, enriched at runtime by ARPT_SQL_FUNC_UTIL for lookup/meaning derivation. Because it is a supplementary, forms-oriented view, it should be treated as a read-only reporting surface and never as a DML target.

Key Columns

  • DISTRIBUTION_MEANING (VARCHAR2, 4000) — the descriptive meaning associated with a distribution type; this is the column most commonly surfaced when users search on "distribution_meaning."
  • DISTRIBUTION_TYPE (VARCHAR2, 20) — the internal lookup code for the distribution category involved in the correction.
  • CATEGORY_MEANING (VARCHAR2, 4000) — the descriptive meaning of the correction category.
  • CATEGORY_TYPE (VARCHAR2, 20) — the internal category code.
  • CODE_COMBINATION_ID (NUMBER, 15) — the existing GL account code combination being corrected.
  • NEW_CODE_COMBINATION_ID (NUMBER, 15) — the replacement GL account code combination.

Common Use Cases and Queries

Typical use is auditing or troubleshooting GL account corrections in Receivables: identifying which distributions were remapped, confirming the old and new accounts, and reporting the correction category in user-friendly terms. The canonical published query is:

  • SELECT DISTRIBUTION_MEANING, DISTRIBUTION_TYPE, CATEGORY_MEANING, CATEGORY_TYPE, CODE_COMBINATION_ID, NEW_CODE_COMBINATION_ID FROM APPS.AR_CORRECT_GL_ACCOUNTS_V;

To join the identifiers to readable account strings, link CODE_COMBINATION_ID and NEW_CODE_COMBINATION_ID to GL_CODE_COMBINATIONS. For filtered diagnostics, constrain on DISTRIBUTION_TYPE or CATEGORY_TYPE when the internal codes are known. Because the view is forms-oriented and unsupported for direct querying, production integrations should prefer the underlying Receivables correction tables and public APIs, reserving this view for ad hoc investigation only.