Search Results interco_clearing_acct_id

Overview

GLFV_GLOBAL_INTERCO_TRAN_LINES is a General Ledger (GL) reporting view delivered within Oracle E-Business Suite 12.1.1 and 12.2.2 as part of the Global Intercompany System (GIS) functionality. The view is intended to expose the individual intercompany transaction lines that make up global intercompany balancing entries, presenting both the sender and receiver perspectives of each transaction. Its purpose is to provide a consolidated, query-friendly structure for intercompany transaction line data, including the clearing account assignment referenced by the INTERCO_CLEARING_ACCT_ID column — the term the user searched for.

The "FV" prefix convention is commonly associated with financial view objects created for reporting and integration consumption rather than for direct transactional maintenance. Accordingly, GLFV_GLOBAL_INTERCO_TRAN_LINES is a read-only construct. The ETRM documentation explicitly marks it as "Not implemented in this database," and the view definition carries the WITH READ ONLY clause, confirming that no INSERT, UPDATE, or DELETE operations are permitted against it.

Underlying Base Objects

The documented view text defines GLFV_GLOBAL_INTERCO_TRAN_LINES over a single base view: GL_BIS_IEA_TRAN_LINES_V. In the ETRM metadata for 12.2.2, no physical base tables are documented as direct referenced objects; the reference is to the intermediate view GL_BIS_IEA_TRAN_LINES_V, which in turn projects the intercompany transaction line data maintained by the Global Intercompany System. The "BIS" and "IEA" naming elements are consistent with the Business Intelligence / intercompany accounting views that Oracle supplies for intercompany reporting.

The structure of the definition is a UNION of two identical SELECT statements against GL_BIS_IEA_TRAN_LINES_V, differentiated only by the filter on SENDER_RECEIVER_CODE. The first branch selects rows where SENDER_RECEIVER_CODE = 'S' (sender side), and the second selects rows where SENDER_RECEIVER_CODE = 'R' (receiver side). The union presents both sides of each intercompany relationship in a single result set. Because the two branches select the same column list, the union effectively returns all transaction lines regardless of side, while the originating filter values remain implicit in the underlying view.

Key Columns

• TRANSACTION_ID — The unique identifier of the parent intercompany transaction.
• TRANSACTION_NUMBER — The user-visible transaction number used to reference the intercompany transaction.
• LINE_TYPE — Classifies the nature of the transaction line within the intercompany entry.
• TRANSACTION_LINE_NUMBER — The line sequence number within the transaction.
• INTERCO_CLEARING_ACCT_ID — The identifier of the intercompany clearing account assigned to the line. This is the column most relevant to the user's search and the key attribute for reconciling intercompany clearing balances.
• _KF:INTERCO_CLEARING_ACCT — Accompanying key-flexfield descriptor for the clearing account, supporting descriptive flexfield reporting.
• ENTERED_DR / ENTERED_CR — The entered debit and credit amounts for the line in the entered currency, enabling balance analysis.
• _DF — A descriptive-flexfield descriptor column generated by the view definition for downstream reporting.

Common Use Cases and Queries

Typical use cases include intercompany clearing account reconciliation, review of sender versus receiver intercompany lines, and extraction of intercompany transaction detail into reporting or integration layers. Because the view is read-only, it is safe for query-only access.

Sample query to inspect clearing account activity by transaction:

• SELECT TRANSACTION_NUMBER, TRANSACTION_LINE_NUMBER, LINE_TYPE, INTERCO_CLEARING_ACCT_ID, ENTERED_DR, ENTERED_CR FROM GLFV_GLOBAL_INTERCO_TRAN_LINES WHERE INTERCO_CLEARING_ACCT_ID = :acct_id;
• SELECT TRANSACTION_ID, SUM(ENTERED_DR), SUM(ENTERED_CR) FROM GLFV_GLOBAL_INTERCO_TRAN_LINES GROUP BY TRANSACTION_ID;

These queries support identification of lines posting to a given clearing account and verification that intercompany debits and credits balance across the transaction.