Search Results line_level_activity

Overview

ARP_BAL_UTIL is a utility package in the Oracle Receivables module of Oracle E-Business Suite, owned by the APPS schema and declared with AUTHID CURRENT_USER. It provides the calculation engine that determines transaction and transaction-line balances throughout Receivables. The package aggregates original amounts, remaining balances, discounts, adjustments, receipts, and commitments across invoice lines, tax, freight, and charges, and it supports both Receivables-only and Order Management-integrated transaction flows. Its functions are consumed by Oracle Forms, concurrent programs, and other PL/SQL APIs that must display or evaluate how much of a receivable remains open. The header reference (ARTUBALS.pls, version 120.5.12020000.2, 2012/07/24) confirms the package is a long-standing, shared utility used across the 12.1.1 and 12.2.2 code lines. It is classified as a UTIL API in the ETRM repository and is referenced by 19 other packages, making it a foundational dependency for balance-related processing in Receivables.

Key Procedures and Functions

• GET_LINE_BALANCE — Returns the balance for a given customer transaction line, optionally factoring an extended amount and a related credit memo transaction line. This is the function most commonly associated with the search term "get_line_balance" and the primary entry point for computing a single line's outstanding amount.
• GET_LINE_CM — Overloaded function that returns the credit memo line associated with a previous customer transaction line; one signature includes a return-null flag to control behavior when no credit memo exists.
• GET_COMMITMENT_BALANCE — Returns the commitment balance for a transaction, considering transaction class, order source code, and whether Order Management is installed.
• CALC_COMMITMENT_BALANCE — Calculates the commitment balance for a transaction, with a flag indicating whether to include Order Management transactions.
• GET_TRX_BALANCE — Returns the overall balance of a customer transaction, with a flag controlling whether the open receivables scope is applied.
• TRANSACTION_BALANCES — Procedure that outputs the full breakdown of a transaction's balance components, including original and remaining amounts for lines, tax, freight, and charges, plus discounts and receipts at each category level.
• GET_SUMMARY_TRX_BALANCES — Returns summarized transaction balances across the specified scope.
• GET_APPLIED_COM_BALANCE — Returns the applied commitment balance for a transaction.
• LINE_LEVEL_ACTIVITY — Reports activity at the transaction-line level.
• TRX_LINE_BALANCES — Returns balances aggregated at the transaction-line level.

Tables Accessed

The package reads and derives balances from core Receivables tables accessed through APPS synonyms. RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES supply transaction headers and lines. AR_PAYMENT_SCHEDULES and AR_RECEIVABLE_APPLICATIONS provide remaining balances and cash application detail. AR_ADJUSTMENTS, AR_DISTRIBUTIONS, and AR_ACTIVITY_DETAILS contribute adjustment and accounting activity, while AR_TRANSACTION_HISTORY supports historical evaluation. RA_CUST_TRX_LINE_GL_DIST holds line-level distribution amounts, and RA_CUST_TRX_TYPES and RA_INTERFACE_LINES provide transaction type and interface context. HZ_CUST_ACCOUNTS supplies customer information and FND_CURRENCIES supports currency conversion logic; DUAL is used for singleton evaluations.

Usage Notes

ARP_BAL_UTIL is typically invoked indirectly. Receivables Forms call it when displaying transaction balances and line-level detail, while concurrent programs and other Receivables APIs — including the 19 packages that reference it — rely on it for balance derivation during application, adjustment, and reporting processes. Custom code should call the functions rather than replicate balance logic, since the package encapsulates the interaction of commitments, credit memos, and order source. GET_LINE_BALANCE is best used when a line-level remaining amount is required; TRANSACTION_BALANCES is appropriate when the complete component breakdown is required, and GET_TRX_BALANCE when only the transaction-level figure is needed.