Module: GLCurrenciesSeverity: HIGH
Daily Conversion Rate Missing for Foreign Currency Journal
Enterprise troubleshooting playbook from the OAG ADK 5.0 knowledge base. Designed for Oracle Apps DBAs, techno-functional consultants, and support teams.
Recognized Error Signatures & Log Keywords
daily rate missingAPP-FND-02901no conversion rate existsgl_daily_rates missing
Root Cause Analysis
No exchange rate found in GL_DAILY_RATES for {fromCurrency} to {toCurrency} on date {conversionDate}.
Diagnostic SQL Queries (Read-Only)
CHECK_DAILY_RATESCheck if daily conversion rate exists for the specific currency pair and date
SELECT 1 FROM gl_daily_rates
WHERE from_currency = :fromCurrency AND to_currency = :toCurrency
AND conversion_date = :conversionDate AND conversion_type = :rateTypeRemediation Mode: MANUAL_UI
Verification Query
SELECT 1 FROM gl_daily_rates WHERE from_currency = :fromCurrency AND to_currency = :toCurrency AND conversion_date = :conversionDateExecute This Fix Safely with OAG AI Consultant
OAG AI Consultant runs directly on your Windows desktop behind your corporate firewall, connecting to your Oracle TNS tier with zero cloud data exposure.