Search Results check_funding_conv_attributes

Overview

PA_MCB_INVOICE_PKG is a Multi-Currency Billing (MCB) PL/SQL package in the Oracle Projects (PA) module of Oracle E-Business Suite. Its principal responsibility is the currency conversion of billing events and associated revenue distribution lines that feed Oracle Projects invoicing. The package resolves the multiple currency contexts that a single billing event can carry — billing transaction currency, invoice processing currency, project currency, project functional currency, and funding currency — and derives the corresponding exchange rates, rate types, rate dates, and converted amounts required for downstream invoice generation. The package header constants and global variables (G_REQUEST_ID, G_PROGRAM_APPLICATION_ID, G_PROGRAM_ID, G_LAST_UPDATED_BY, G_CREATED_BY, G_LAST_UPDATE_LOGIN, and G_DEBUG_MODE) confirm that it is designed to execute both interactively and under concurrent program control, with standard WHO audit column propagation and an optional debug trace. The header comment dated 2007 identifies the object as long-standing core Projects code carried forward into ETRM 12.1.1 and 12.2.2.

Key Procedures and Functions

• EVENT_CONVERT_AMOUNT_BULK — The primary bulk conversion routine. It processes arrays of events keyed by agreement, project, request, and task, accepting billing transaction amounts and currency codes as input and returning invoice processing, project, project functional, and funding currency attributes together with their exchange rates and converted amounts. The array-based signature reflects its use in set-based processing rather than single-row calls.
• CONVERT_LINE_EVENT_AMOUNT — Performs the equivalent currency conversion for an individual event or distribution line, providing the row-level counterpart to the bulk procedure.
• CHECK_FUNDING_CONV_ATTRIBUTES — Validates the funding-related conversion attributes associated with an event, confirming that funding rate type, rate date, and exchange rate are present and consistent before conversion proceeds. This is the routine most commonly located by searches on funding conversion logic.
• INV_BY_BILL_TRANS_CURRENCY — Groups or resolves invoice and event processing by billing transaction currency.
• LOG_MESSAGE — Writes diagnostic output, typically to the concurrent program log or a debug table, controlled by G_DEBUG_MODE.
• INIT — Initializes package globals such as request, program, and user identifiers prior to processing.

Tables Accessed

The package reads and writes across the core Projects billing and funding schema via APPS synonyms. PA_EVENTS and PA_EVENT_TYPES supply event and event type definitions. PA_CUST_EVENT_RDL_ALL, PA_CUST_REV_DIST_LINES, and PA_CUST_REV_DIST_LINES_ALL hold customer event revenue distribution lines that carry the multi-currency amount columns being converted. PA_DRAFT_INVOICES_ALL and PA_DRAFT_INVOICE_ITEMS represent the invoice and invoice line targets. Currency funding context is drawn from PA_AGREEMENTS_ALL, PA_SUMMARY_PROJECT_FUNDINGS, PA_PROJECTS_ALL, and PA_PROJECT_CUSTOMERS, while PLITBLM provides the Projects multi-currency rate retrieval interface used to obtain exchange rates.

Usage Notes

PA_MCB_INVOICE_PKG is normally invoked from the Oracle Projects Multi-Currency Billing concurrent programs that generate draft invoices and revenue distributions, and it may also be called from Projects forms and from custom extensions that must reproduce standard multi-currency conversion behavior. Because it is referenced by sixteen other packages, it functions as shared infrastructure rather than an entry-point API; customizations should call the documented procedures rather than modify package internals. When diagnosing conversion issues, verify that event funding attributes pass CHECK_FUNDING_CONV_ATTRIBUTES and that Project Multi-Currency setups, rate types, and rate dates are correctly defined, since conversion failures typically originate in missing or inconsistent funding and rate configuration.