Foreign Exchange Rates for Revenue and Costs for Material Transaction In Projects
(Doc ID 2502031.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Project Billing - Version 12.0.0 and later
Information in this document applies to any platform.
Briefly describe the symptoms of the problem. Remember to delete any customer specific information
In Oracle Projects, the foreign exchange rates cost and revenue are different for 3-way matched receipts.
Cost and revenue currency exchange rate dates are different for transactions with source PJM_CSTBP_INV_NO_ACCOUNTS.
1. Create 3-Way match PO in foreign currenc - use Project/Task that is Billable - Project and Functional Currencies should be different
2. Receive PO
3. Run Cost Collector to interface PJM_CSTBP_INV_NO_ACCOUNTS to projects.
4. The cost process takes the expenditure item date, since the project implementation is set to use exchange rate date as of expenditure item date.
5. Run Generate Draft Invoice process. Revenue process uses exchange rate date of PA/Invoice date.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document