Search Results ar_gl_balacing_segment_value

Overview

The APPS.AR_GL_SEGMENTS_REF_V view is an Oracle E-Business Suite internal database object that resides in the APPS schema and exposes accounting flexfield segment information associated with Receivables (AR) transactions. Its registered FND Design Data identifier is AR.AR_GL_SEGMENTS_REF_V, and its status is VALID in both the 12.1.1 and 12.2.2 releases. The view presents three columns: AR_GL_CODE_COMBINATION_ID, AR_GL_BALACING_SEGMENT_VALUE, and AR_GL_NATURAL_SEGMENT_VALUE. In the context of the user's search term, "ar_gl_code_combination_id", the view functions as a lightweight reference layer for resolving the identification and segment composition of the accounting flexfield combination recorded against AR subledger accounting events. It is primarily consumed by Oracle internal extraction and reporting logic rather than by customer-facing reporting tools. Oracle's documentation carries an explicit note that access to the object is Internal Use Only and is not supported except from standard Oracle Applications programs.

Underlying Base Objects

According to the documented metadata, APPS.AR_GL_SEGMENTS_REF_V references two underlying objects. The first is GL_CODE_COMBINATIONS (accessed through the public synonym in the APPS schema), which is the standard General Ledger key flexfield combinations table storing every valid accounting code combination and its constituent segments. The second is the package ARP_XLA_EXTRACT_MAIN_PKG, which forms part of the Receivables Subledger Accounting extraction infrastructure. The package dependency indicates that the view's segment values are populated through the same extraction mechanisms that prepare AR accounting data for transfer to General Ledger. The view is not referenced by any other database object, confirming that it is a terminal reference object used by application code or ad hoc extraction rather than a dependency of further views.

Key Columns

• AR_GL_CODE_COMBINATION_ID (NUMBER, 15) — Documented as the "Key flexfield combination defining column". This is the primary identifier linking the AR record to a row in GL_CODE_COMBINATIONS, and corresponds directly to the user's search term.
• AR_GL_BALACING_SEGMENT_VALUE (VARCHAR2, 4000) — The captured value of the balancing segment (typically the legal entity / company segment) for the referenced combination.
• AR_GL_NATURAL_SEGMENT_VALUE (VARCHAR2, 4000) — The captured value of the natural account segment for the same combination.

All three columns are non-mandatory and the two segment columns use a very wide VARCHAR2 definition, sized to accommodate a concatenated or descriptive representation of flexible segment values as produced by the extraction package.

Common Use Cases and Queries

The view is useful for joining the numeric code combination identifier against the descriptive balancing and natural segment values when interpreting AR accounting data, reconciliations, and Subledger Accounting extract output. A representative query lists the identifier alongside its segment values:

SELECT AR_GL_CODE_COMBINATION_ID, AR_GL_BALACING_SEGMENT_VALUE, AR_GL_NATURAL_SEGMENT_VALUE FROM APPS.AR_GL_SEGMENTS_REF_V;

A further scenario joins it to GL_CODE_COMBINATIONS using the identifier, for example to filter AR-related combinations by natural account, which suits diagnostic reporting, balances analysis, and reconciliation between AR subledger journals and GL balances. Because access is restricted to Oracle Applications programs, customers are advised to build custom reports against the underlying documented tables rather than depending on this internal view, whose definition may change without notice.