Search Results erdl_amount_conversion

Overview

PA_MCB_REVENUE_PKG is a multi-currency billing (MCB) revenue processing package in Oracle Projects. Its business purpose is to convert transaction amounts recorded in the billing (invoice) currency into the revenue processing currency used by Oracle Projects, and to support the revenue generation cycle for a project. The package body header identifies the primary procedure, EVENT_AMOUNT_CONVERSION, whose stated purpose is "To update the PA_EVENTS table (bill transaction currency to revenue processing currency)." This conversion is a prerequisite step in the revenue recognition flow: amounts captured against draft invoices and draft revenue records must be translated into the functional and project functional currencies before revenue can be generated, accounted, and interfaced to General Ledger.

Header version information ($Header: PAXMCRUB.pls 120.8) indicates the package has been maintained through multiple Oracle Projects releases, and internal comments reference a funding revaluation enhancement that added realized gain and loss event types, as well as a fix for bug 5907315 implemented through a pa_date lookup function over date range arrays. These details confirm the package handles currency revaluation effects, not merely static currency translation.

Key Procedures and Functions

• EVENT_AMOUNT_CONVERSION — The central procedure. It updates PA_EVENTS with amounts converted from billing transaction currency into revenue processing currency. Documented parameters include p_project_id, p_request_id, p_event_type (used to distinguish AUTOMATIC events from other events), p_calling_place, acc_thru_date, p_project_rate_date, and p_projfunc_rate_date, with standard x_return_status, x_msg_count, and x_msg_data OUT parameters.
• EI_AMOUNT_CONVERSION — Performs amount conversion in the context of expenditure items, translating bill amounts to the revenue processing currency for expenditure-based revenue.
• RDL_AMOUNT_CONVERSION — Converts amounts associated with revenue distribution lines.
• ERDL_AMOUNT_CONVERSION — Handles conversion for expenditure-related revenue distribution lines, extending RDL processing to the expenditure side.
• EI_FCST_AMOUNT_CONVERSION — Converts forecast amounts for expenditure items, supporting forecast revenue processing.
• LOG_MESSAGE — Utility procedure that writes debug or error messages, gated by the PA_DEBUG_MODE profile option (g1_debug_mode).
• INIT — Initialization routine invoked before the conversion procedures execute.
• RTC_UBR_UER_CALC — Calculation routine associated with unbilled receivable and unearned revenue processing.

Tables Accessed

• PA_EVENTS and PA_EVENT_TYPES — The principal update targets; events are classified by type before amounts are converted.
• PA_DRAFT_INVOICES and PA_DRAFT_INVOICE_ITEMS — Source billing amounts in transaction currency.
• PA_DRAFT_REVENUES — Revenue records receiving the converted amounts.
• PA_CUST_REV_DIST_LINES and PA_CUST_REV_DIST_LINES_ALL — Customer revenue distribution lines processed by the RDL and ERDL routines.
• PA_EXPENDITURE_ITEMS_ALL — Expenditure items underlying expenditure-based revenue and forecast conversion.
• PA_PERIODS, PA_TASKS, and PLITBLM — Used for period validation, task context, and PL/SQL table (array) handling.

Usage Notes

The package is invoked during revenue generation for a project, typically driven by concurrent programs such as Generate Revenue. The p_calling_place and p_event_type parameters allow the same conversion logic to serve multiple callers — automatic event processing versus ad hoc revenue generation — while p_project_rate_date and p_projfunc_rate_date supply the exchange rate dates needed for currency translation. acc_thru_date bounds the conversion to a specified accounting period.

Because it is classified as OTHER rather than a public API, PA_MCB_REVENUE_PKG should be treated as an internal Oracle Projects component. Custom code should not call it directly; instead, customizations should invoke the supported revenue generation concurrent programs or documented APIs. When debugging conversion discrepancies, DBAs and developers commonly enable the PA_DEBUG_MODE profile option to activate LOG_MESSAGE output. The package is referenced by one other package, reflecting its role as a subordinate utility within the Projects revenue stack rather than a top-level entry point.