PARGDR: PRC: Generate Draft Revenue for a Single Project Errors with 'No Exchange Rate Exists For Re' or PA_NO_EXCH_RATE_EXISTS_RC_RTC as Seen in the Log File.
(Doc ID 2870292.1)
Last updated on JULY 01, 2024
Applies to:
Oracle Project Billing - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
PARGDR_SINGLE: PRC: Generate Draft Revenue for a Single Project errors with the following for a single item in the output file:
No exchange rate exists for Re
Full error is 'No Exchange Rate Exists For Revenue Transaction Currency'
The log file shows:
2022/05/03 10:15:01 rdl_amount_conversion: Expenditure Item Id :12345
2022/05/03 10:15:01 rdl_amount_conversion: Line Num :1
2022/05/03 10:15:01 rdl_amount_conversion: Draft revenue Num :1
2022/05/03 10:15:01 rdl_amount_conversion: Bill Trans Currency Code :USD
2022/05/03 10:15:01 rdl_amount_conversion: Output Bill Trans Amount:18.32
2022/05/03 10:15:01 rdl_amount_conversion: Output Project Amount :17.15
2022/05/03 10:15:01 rdl_amount_conversion: Output Project Func Amount :18.32
2022/05/03 10:15:01 rdl_amount_conversion: Funding Curr Code :EUR
2022/05/03 10:15:01 rdl_amount_conversion: Funding Rate Type :Spot
2022/05/03 10:15:01 rdl_amount_conversion: Funding Rate date :27-APR-22
2022/05/03 10:15:01 rdl_amount_conversion: Funding Echg rate :.93611046103440205944
2022/05/03 10:15:01 rdl_amount_conversion: Funding Amt Rejection Reason :N
2022/05/03 10:15:01 rdl_amount_conversion: Convert Funding Amount :17.15
2022/05/03 10:15:01 rdl_amount_conversion: after Calling convert_amount_bulk API for funding conversion
....
2022/05/03 10:15:01 rdl_amount_conversion: Expenditure Item Id :12345
2022/05/03 10:15:01 rdl_amount_conversion: Line Num :1
2022/05/03 10:15:01 rdl_amount_conversion: Draft revenue Num :1
2022/05/03 10:15:01 rdl_amount_conversion: Bill Trans Currency Code :USD
2022/05/03 10:15:01 rdl_amount_conversion: Bill Trans Amount:18.32
2022/05/03 10:15:01 rdl_amount_conversion: Output Project Func Amount :18.32
2022/05/03 10:15:01 rdl_amount_conversion: Revtrans Curr Code :EUR
2022/05/03 10:15:01 rdl_amount_conversion: Revtrans Rate Type :
2022/05/03 10:15:01 rdl_amount_conversion: Revtrans Rate date :27-APR-22
2022/05/03 10:15:01 rdl_amount_conversion: Revtrans Echg rate :
2022/05/03 10:15:01 rdl_amount_conversion: Revtrans Rejection Reason :N
2022/05/03 10:15:01 rdl_amount_conversion: Convert Revtrans Amount :
2022/05/03 10:15:01 rdl_amount_conversion: Revenue Txn is not equal to PFC and BTC .....
2022/05/03 10:15:01 rdl_amount_conversion: Before convert_amount_bulk to derive rtc amt.....
2022/05/03 10:15:01 rdl_amount_conversion: After convert_amount_bulk to derive RTC Amt.....
2022/05/03 10:15:01 Rev trans rate date after conv is.....27-APR-22
2022/05/03 10:15:01 l_revtrans_status_tab(2) is.....PA_NO_EXCH_RATE_EXISTS_RC_RTC
2022/05/03 10:15:01 rdl_amount_conversion: Line Num :1
2022/05/03 10:15:01 rdl_amount_conversion: Draft revenue Num :1
2022/05/03 10:15:01 rdl_amount_conversion: Bill Trans Currency Code :USD
2022/05/03 10:15:01 rdl_amount_conversion: Output Bill Trans Amount:18.32
2022/05/03 10:15:01 rdl_amount_conversion: Output Project Amount :17.15
2022/05/03 10:15:01 rdl_amount_conversion: Output Project Func Amount :18.32
2022/05/03 10:15:01 rdl_amount_conversion: Funding Curr Code :EUR
2022/05/03 10:15:01 rdl_amount_conversion: Funding Rate Type :Spot
2022/05/03 10:15:01 rdl_amount_conversion: Funding Rate date :27-APR-22
2022/05/03 10:15:01 rdl_amount_conversion: Funding Echg rate :.93611046103440205944
2022/05/03 10:15:01 rdl_amount_conversion: Funding Amt Rejection Reason :N
2022/05/03 10:15:01 rdl_amount_conversion: Convert Funding Amount :17.15
2022/05/03 10:15:01 rdl_amount_conversion: after Calling convert_amount_bulk API for funding conversion
....
2022/05/03 10:15:01 rdl_amount_conversion: Expenditure Item Id :12345
2022/05/03 10:15:01 rdl_amount_conversion: Line Num :1
2022/05/03 10:15:01 rdl_amount_conversion: Draft revenue Num :1
2022/05/03 10:15:01 rdl_amount_conversion: Bill Trans Currency Code :USD
2022/05/03 10:15:01 rdl_amount_conversion: Bill Trans Amount:18.32
2022/05/03 10:15:01 rdl_amount_conversion: Output Project Func Amount :18.32
2022/05/03 10:15:01 rdl_amount_conversion: Revtrans Curr Code :EUR
2022/05/03 10:15:01 rdl_amount_conversion: Revtrans Rate Type :
2022/05/03 10:15:01 rdl_amount_conversion: Revtrans Rate date :27-APR-22
2022/05/03 10:15:01 rdl_amount_conversion: Revtrans Echg rate :
2022/05/03 10:15:01 rdl_amount_conversion: Revtrans Rejection Reason :N
2022/05/03 10:15:01 rdl_amount_conversion: Convert Revtrans Amount :
2022/05/03 10:15:01 rdl_amount_conversion: Revenue Txn is not equal to PFC and BTC .....
2022/05/03 10:15:01 rdl_amount_conversion: Before convert_amount_bulk to derive rtc amt.....
2022/05/03 10:15:01 rdl_amount_conversion: After convert_amount_bulk to derive RTC Amt.....
2022/05/03 10:15:01 Rev trans rate date after conv is.....27-APR-22
2022/05/03 10:15:01 l_revtrans_status_tab(2) is.....PA_NO_EXCH_RATE_EXISTS_RC_RTC
Steps to Reproduce:
Projects responsibility | Other Requests | Run | PRC: Generate Draft Revenue for a Single Project
Changes
Customer is generating revenue of AP transactions for the first time since upgrade to 12.2.
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |