Search Results cn_trx_lines

Overview

CN_RAM_ADJUSTMENTS_PKG is an Oracle EBS Applications (APPS) package body that supports the Channel Revenue Management (formerly Channel Management, or "CN") revenue adjustment workflow. Its central purpose is to reconcile Accounts Receivable revenue adjustments — specifically RAM (Revenue Adjustment Management) adjustments — with the Channel Revenue Management collection tables so that subsequent collection runs process each adjustment correctly and do not duplicate prior work. The package identifies customer transactions that have been RAM-adjusted after the last collection run and then, in the companion NEGATE procedure, produces the offsetting or reversing entries required to keep channel revenue data consistent. In the context of the user's search for "UID RAM," the package is relevant because RAM adjustment processing relies on identifying affected transaction lines; the term "UID" commonly appears in connection with the unique identifiers that tie RAM adjustment records to their originating AR transactions, lines, and inventory items.

Key Procedures and Functions

The ETRM metadata documents two procedures in this package:

• IDENTIFY — Locates transactions at the header level that have been RAM-adjusted after the last collection run, within an interested accounting period. It joins CN_NOT_TRX and AR_REVENUE_ADJUSTMENTS to derive the customer_trx_id and related line-level identifiers (from_cust_trx_line_id, from_inventory_item_id, from_category_id, and line_selection_mode). The procedure takes start and end period parameters along with debug controls and an org_id for multi-org (MOAC) filtering.
• NEGATE — Generates the reversing or offsetting adjustment records for the transactions identified by IDENTIFY, so that the channel revenue data reflects the negation of a previously applied RAM adjustment.

Parameter lists are intentionally not reproduced here; consult the package header for exact signatures.

Tables Accessed

• AR_REVENUE_ADJUSTMENTS — The source of revenue adjustment records; supplies customer_trx_id, application_date, and line selection attributes.
• CN_NOT_TRX — Channel Revenue Management notification/transaction table; provides last_collected_date, notified_date, collected_flag, event_id, and source_trx_id used to correlate adjustments to prior collection runs.
• CN_TRX, CN_TRX_LINES, CN_COMM_LINES_API — Channel transaction and commission line structures used when creating or reversing adjustments.
• CN_REPOSITORIES — Stores channel revenue repository data referenced during processing.
• MTL_ITEM_CATEGORIES — Resolves item-to-category relationships for adjusted inventory items.
• RA_CUSTOMER_TRX_LINES — Provides AR transaction line detail for the affected customer transactions.

Usage Notes

This package is an internal program unit within the Channel Revenue Management application. It is typically invoked by concurrent programs or workflow processes that run RAM adjustment collection for a given operating unit and period range, rather than being called directly from an Oracle Forms screen. Its IDENTIFY logic is designed to be re-runnable safely: the use of full timestamps on application_date and last_collected_date (rather than TRUNC) prevents the same adjustment from being handled twice when the collection program is executed more than once on the same day. The MOAC conditions (org_id on both CN_NOT_TRX and AR_REVENUE_ADJUSTMENTS) ensure correct multi-org isolation. The ETRM metadata records no other packaged objects referencing this package, indicating it is called by external concurrent processing rather than by peer PL/SQL APIs. Custom extensions interacting with RAM adjustments should treat this package as a supporting internal utility and rely on the documented concurrent processes for invocation.