My Oracle Support Banner

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

Release 12

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.