Project Partners Blog

Unleash the Power of Multi Currency in Oracle E-Business Suite Projects R 12

By Ravi Shankar, PgMP, PMP, PMI-RMP and PMI-SP

Oracle E-Business Suite (EBS) Projects Applications Release 12 provides rich functionality to support multi currency processing capabilities in the areas of accruing revenue and generating invoices.  Revenue is always processed in the project functional currency, as distinct from the project currency and project funding currency.  Revenue amounts derived in the billing transaction currency (invoice processing currency) are converted to project functional, funding and project currency during the revenue generation process.  The Release 12 EBS system tracks and posts the revenue, unbilled receivables and unearned revenue in both the functional and billing transaction currency to the general ledger, thereby giving full visibility, both at the project level and in the general ledger, of the details of revenue in the different currency options.

As regards invoicing, the EBS system provides features to invoice and bill in any currency, independent of the project functional and funding currency.  For this purpose, multi currency billing has to be enabled in the Implementation Options that would facilitate entering funding agreements, bill rate schedules and billing assignments in any currency, independent of the project functional currency.  Invoice by bill transaction currency is the feature to generate invoices based on the transaction currency of expenditure items, event currency and the bill rate schedule currency.  If this feature is implemented, the system does not read the invoice currency defined and chosen in the Project Customers region of the Project, and instead generates an invoice based on the bill transaction currency.

While Budgets and Forecasts can be entered in any transaction currency, we can enter approved revenue budget only in the project functional currency.

Invoicing can be generated either based on the project functional currency, or the project currency or the project funding currency.  The R12 system derives the applicable currency conversion attributes to compute the respective currency amounts if the invoicing currency is different than the project functional currency.  We can also choose to use the project functional currency conversion attributes to derive the Receivables functional currency values when the invoice processing currency is different from the functional currency of the Set Of Books/Ledger.  While funding and invoicing can be in any currency, the revenue budget must still be only in the functional currency of the Set Of Books/Ledger, if they are entered in the Professional forms.  For this purpose, the R12 system uses the exchange rate at the date funding is allocated, using the appropriate rate type defined in the Billing tab of the Currency region for the Project.

If a hard limit is defined for the Funding for revenue and invoice, the R12 system ensures that the revenue amount does not exceed the hard limit both in the funding currency and the corresponding baselined revenue budget.

Funding in foreign currency can be periodically revaluated to align the funding backlog (funded amount less invoice generated) to the current exchange rates to the project functional currency. System creates funding adjustment lines taking into account the funding backlog, paid invoices, its realized gains and losses and unpaid invoices. This additional/decrement funding has to be baselined to ensure the hard limits imposed in the Funding agreement window is complied with. Optionally, the realized gains and losses can be treated as net increase and decrease in the project revenue and posted to GL.

Leave a Reply

You must be logged in to post a comment.