Search Results accounting_rule_duration




Overview
Explore in AI Chat

Overview

APPS.ARBV_REVENUES is a database view owned by the APPS schema in Oracle E-Business Suite, documented in ETRM with status VALID and design data reference AR.ARBV_REVENUES. It presents a consolidated projection of revenue-related information derived from Receivables transaction lines. The view is classified internally (View Type: Internal), and the Oracle documentation accompanying the object carries the standard warning that it is for Oracle Internal Use Only and is not supported for direct access except through standard Oracle Applications programs.

In practice, ARBV_REVENUES is queried by Oracle Receivables and adjacent revenue-recognition logic to surface revenue amounts alongside the recognition context of each transaction line. Because it exposes accounting rule attributes — most notably ACCOUNTING_RULE_DURATION — together with sales order, item, and quantity data, it serves as a convenient reporting and integration surface for revenue schedules, deferred revenue analysis, and reconciliation between order management and Receivables. The distinct object type (VIEW) means it stores no data itself; it is a read-only projection over transaction line tables.

Underlying Base Objects

Per the documented dependency metadata, APPS.ARBV_REVENUES references the following base objects:

RA_CUSTOMER_TRX_LINES is the Receivables transaction line table and the primary source of revenue line attributes such as TRANSACTION_LINE_ID, AMOUNT, CUSTOMER_TRX_ID, and the accounting rule references. The view therefore inherits its transactional grain — one row per transaction line — directly from that table. The metadata further states that ARBV_REVENUES is not referenced by any other database object, indicating it is a terminal reporting view rather than a building block consumed by other views or packages. No additional base tables are documented, so the view's column set is best understood as a filtered/joined projection sourced from RA_CUSTOMER_TRX_LINES in the APPS schema.

Key Columns

Common Use Cases and Queries

The view is typically used to analyze revenue amounts by accounting rule and duration, to reconcile invoiced versus ordered quantities, and to trace revenue lines back to originating transactions. A representative query retrieving revenue lines with their recognition duration for a given transaction follows:

  • SELECT TRANSACTION_LINE_ID, CUSTOMER_TRX_ID, AMOUNT, ACCOUNTING_RULE_ID, ACCOUNTING_RULE_DURATION, ORG_ID FROM APPS.ARBV_REVENUES WHERE CUSTOMER_TRX_ID = :p_trx_id;
  • Aggregating revenue by rule and duration: SELECT ACCOUNTING_RULE_ID, ACCOUNTING_RULE_DURATION, SUM(AMOUNT) FROM APPS.ARBV_REVENUES GROUP BY ACCOUNTING_RULE_ID, ACCOUNTING_RULE_DURATION;
  • Reconciling order versus invoice quantities: SELECT SALES_ORDER_NUMBER, SALES_ORDER_LINE, QUANTITY_ORDERED, QUANTITY_INVOICED, UNIT_PRICE FROM APPS.ARBV_REVENUES WHERE SALES_ORDER_NUMBER = :p_so_number;

Because the object is documented as Oracle Internal Use Only, direct querying should be confined to reporting and diagnostic activity, with any integration relying on supported APIs wherever possible.