Search Results earn_or_unearn

Overview

AR_REVENUE_ADJUSTMENT_PVT is an internal (private) PL/SQL package in the APPS schema that supports Oracle Receivables revenue management and revenue adjustment processing. The _PVT suffix indicates that the package is not a public API; it is designed to be called by other packages rather than directly by external applications. Its primary business function is to create and manage revenue adjustments against transaction lines, including earning and unearning revenue, transferring sales credits and salesperson revenue, generating accounting distributions, and resetting distribution percentages. In Oracle EBS 12.1.1 and 12.2.2, this package is a foundational component of the revenue recognition and adjustment framework used by Revenue Management and related features such as automatic revenue adjustment reason codes and allocation.

Key Procedures and Functions

The ETRM documentation identifies 20 procedures/functions. The core revenue lifecycle operations include EARN_REVENUE, UNEARN_REVENUE, and EARN_OR_UNEARN, which move revenue between earned and unearned states. Distribution and percentage management is handled by INSERT_DISTRIBUTION, DISTS_BY_MODEL, and RESET_DIST_PERCENT. Adjustment creation is performed through CREATE_ADJUSTMENT, with supporting internal routines such as DEBIT_CREDIT, NO_RULE_DEBIT_CREDIT, and NO_RULE_DEBIT_CREDIT_NO_SR. Sales credit and salesperson revenue functions include TRANSFER_SALES_CREDITS, ADD_NON_REVENUE_SALES_CREDITS, TRANSFER_SALESREP_REVENUE, and INSERT_SALES_CREDIT. Line-level revenue movement is handled by TRANSFER_REVENUE_BETWEEN_LINES and CR_TARGET_LINE_UNEARNED. Utility lookups include CATEGORY_SET_ID, INV_ORG_ID, and RECORD_ACCEPTANCE. These routines are typically invoked internally by Revenue Management and public revenue adjustment APIs.

Tables Accessed

Based on the documented dependencies, the package reads and writes several core Receivables tables via APPS synonyms. RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES supply the transaction header and line data being adjusted. RA_CUST_TRX_LINE_GL_DIST and RA_CUST_TRX_LINE_GL_DIST_ALL store the accounting distributions generated and modified by the distribution routines. AR_REVENUE_ADJUSTMENTS is the primary staging and storage table for revenue adjustment records, referenced alongside its sequences AR_REVENUE_ADJUSTMENTS_S1 and AR_REVENUE_ADJUSTMENTS_S2. Supporting setup and reference tables include MTL_SYSTEM_ITEMS, MTL_CATEGORIES, MTL_ITEM_CATEGORIES, RA_BATCH_SOURCES, RA_SALESREPS, JTF_RS_GROUPS_B, FND_CURRENCIES, and AR_SYSTEM_PARAMETERS. The global temporary table AR_LINE_REV_ADJ_GT is used for interim processing.

Usage Notes

AR_REVENUE_ADJUSTMENT_PVT is invoked internally during Receivables revenue adjustment processing. The documented reference list shows it is called by AR_REVENUE_MANAGEMENT_PVT, AR_REVENUEADJUST_PUB, AR_RAAPI_UTIL, ARP_ALLOCATION_PKG, and ARP_DET_DIST_PKG, and is exposed indirectly through the view AR_LINE_DEFERRAL_REASONS_V and RA_CUSTOMER_TRX_LINES_RA_V. Because it is a PVT package, it should not be invoked directly from custom code; developers should instead use the public API AR_REVENUEADJUST_PUB, which wraps this package. Use cases include earning or unearning revenue on transaction lines, applying revenue adjustments with automatic accounting, distributing revenue according to accounting rules or models, and transferring sales credits or salesperson revenue. Direct calls are unsupported and may bypass validation enforced by the public API layer.