My Oracle Support Banner

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 MAY 18, 2022

Applies to:

Oracle Project Billing - Version 12.2.5 and later
Information 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


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


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