Search Results rtc_ubr_uer_calc




Overview
Explore in AI Chat

Overview

PA_MCB_REVENUE_PKG is an Oracle Projects revenue-processing package in the APPS schema that supports Multi-Currency Billing (MCB) revenue recognition and amount conversion within Oracle E-Business Suite 12.1.1 and 12.2.2. Its primary business function is to convert raw revenue and event amounts from transaction, project, and functional currencies into the appropriate funding or billing currency, applying the correct exchange rate, rate type, and rate date. The package header (PAXMCRUS.pls, version 120.4) uses standard Oracle Projects global variables such as G_REQUEST_ID, G_PROGRAM_APPLICATION_ID, G_PROGRAM_ID, G_LAST_UPDATED_BY, and G_CREATED_BY to carry concurrent request context, and exposes an FND profile-driven flag for revenue original rate handling (introduced under bug 5907315). Public procedures manage amount conversion for events, expenditure items, and draft revenues, while additional procedures support forecasting and message logging.

Key Procedures and Functions

  • EVENT_AMOUNT_CONVERSION — Converts event amounts to the required currency, taking project, request, event type, calling place, and date context as inputs and returning status and message information through OUT parameters.
  • EI_AMOUNT_CONVERSION — Performs amount conversion for expenditure items, accepting a project identifier, a table of expenditure item identifiers, a request identifier, and a PA date, and returning status, message count, message data, and a rejection reason.
  • RDL_AMOUNT_CONVERSION — Converts draft revenue lines. It accepts tables of expenditure item identifiers and raw revenue amounts (raw revenue, bill transaction raw revenue, project raw revenue, and project functional raw revenue) together with a funding rate date, and returns status and message information.
  • ERDL_AMOUNT_CONVERSION — Converts individual draft revenue amounts using billing transaction code and funding rate context, returning the funding rate type, rate date, and exchange rate through IN OUT parameters.
  • EI_FCST_AMOUNT_CONVERSION — Applies the same conversion logic to forecast expenditure item amounts, supporting revenue forecasting alongside actual revenue processing.
  • RTC_UBR_UER_CALC — The routine surfaced by the user search term “rtc_ubr_uer_calc”. It calculates unbilled receivables (UBR) and unrealized revenue (UER) amounts as part of MCB revenue processing, deriving the values required for revenue and receivable balancing across currencies and periods.
  • LOG_MESSAGE — Writes diagnostic or error messages to the package’s logging mechanism, supporting traceability during concurrent processing.
  • INIT — Initializes the package’s global variables and session-level state before the conversion procedures execute.

Tables Accessed

The package reads and writes through APPS synonyms to the core Oracle Projects revenue, event, and expenditure tables:

  • PA_CUST_REV_DIST_LINES / PA_CUST_REV_DIST_LINES_ALL — Customer revenue distribution lines; the primary target for converted revenue amounts.
  • PA_DRAFT_INVOICES / PA_DRAFT_INVOICE_ITEMS — Draft invoice and invoice item data used when revenue conversion is tied to billing transactions.
  • PA_DRAFT_REVENUES — Draft revenue records whose amounts are converted and stored.
  • PA_EVENTS / PA_EVENT_TYPES — Event and event type definitions driving event amount conversion.
  • PA_EXPENDITURE_ITEMS_ALL — Expenditure items providing the raw amounts converted for revenue and forecast purposes.
  • PA_PERIODS — Period definitions used to validate and derive accrual-through and rate dates.
  • PA_TASKS — Task-level context supporting project and task revenue assignment.
  • PLITBLM — Oracle Projects PL/SQL table/array utility table used for bulk processing and message handling.

Usage Notes

PA_MCB_REVENUE_PKG is invoked internally by Oracle Projects concurrent programs and by other Oracle Projects packages rather than by end users directly. ETRM records it as being referenced by one other package, confirming its role as a shared utility within the revenue generation call stack. Typical invocation points include the Generate Draft Revenue and Multi-Currency Billing concurrent programs, where the amount conversion procedures are called per project, event, expenditure item, or draft revenue line, and the RTC_UBR_UER_CALC routine computes UBR and UER balances. The INIT procedure should be called to initialize session globals before conversion routines execute, and LOG_MESSAGE records errors and debug information when diagnostic mode is enabled. Because the package is classified as an OTHER API rather than a public API, customizations should not call it directly without regression testing; site-specific extensions are better implemented through supported Oracle Projects APIs or custom concurrent programs that respect the same currency and rate-handling rules.