EPC/ECA- How To Reconcile Currency Conversion Discrepancies Between Billing/Projects/General Ledger? (Doc ID 1290959.1)

Last updated on JUNE 07, 2017

Applies to:

PeopleSoft Enterprise FIN Contracts - Version 9 and later
PeopleSoft Enterprise FIN Project Costing - Version 9 and later
Information in this document applies to any platform.
Checked for relevance on 26-NOV-2012

Goal


How to reconcile currency conversion discrepancies between billing/projects/General Ledger?

Here is the scenario:

  1. Base currency is USD
  2. AP voucher is entered for $100 CAD. The expense is charged to a billable project ID. The invoice date is 12/15/2010 and the accounting date is 1/3/2010.
  3. Currency converasion rate for CAD to USD is .98 as of 12/15/2010 and 1.02 as of 1/3/2010. System uses the 12/15/2010 invoice date as the currency effdt, so 100 CAD is converted to 98 USD.
  4. PC_AP_TO_PC process runs to push this AP expense to PROJ_RESOURCE table. 2 rows are created - analysis type ACT and BIL. Both rows have 98 USD as the resource_amount and 100 CAD as the foreign_amount. The trans_dt is 12/15/2010 and the accounting_dt is 1/3/2010. This is correct and as we wold expect.
  5. CA_BI_INTFC and BIIF0001 processes run to push the BIL row in PROJ_RESOURCE into the BI_LINE table so it can be billed. However, instead of coming into billing at 98 USD, it comes in at 102 USD. CA_BI_INTFC is doing another currency conversion and using the accounting date of 1/3/2010, so it picks up the currency conversion rate of 1.02.
  6. Now we have the BIL row in PROJ_RESOURCE at 98 USD and the matching row in BI_LINE at 102 USD. This is wrong - resource_amount of the BIL row in proj_resource should match the amount on BI_LINE.
  7. Invoice is finalized and billed out at 102 USD. Subsequent process changes the BIL analysis_type row in PROJ_RESOURCE to BLD, but the resource_amount on that row remains at 98 USD.
  8. Reports running against PROJ_RESOURCE meant to show billing activity would wrongly report that 98 USD was billed, when actually 102 USD was billed.



Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms