GL Exchange Rates to AFCS

18.8 GL Exchange Rates to AFCS

AFCS now supports sourcing foreign exchange (FX) rates directly from Oracle ERP General Ledger (GL), in addition to the existing file-based ingestion method. FX rates extracted from ERP GL are automatically mapped to the AFCS data model and made available to downstream AFCS processes, including Netting, Revaluation, and other modules that consume exchange rates. This enables organizations to use ERP GL as the centralized source of FX rates while preserving existing AFCS processing behavior.

Organizations can use Oracle ERP General Ledger as the single source of truth for foreign exchange (FX) rates, eliminating redundant integrations and improving consistency across Oracle financial applications. By automatically making ERP GL exchange rates available to AFCS processes such as Netting and Revaluation through the existing processing framework, this feature reduces operational effort, streamlines FX rate management, and supports scalable enterprise deployments without disrupting established business processes.

Current Behaviour

Where an exchange rate is corrected or replaced in ERP, the revised value is loaded into AFCS and becomes the latest available rate. Where an exchange rate is deleted from ERP without a replacement:

the previously loaded rate is retained by AFCS
the rate may remain available as the last known rate for the currency pair and effective date
deleting the rate in ERP does not automatically remove or deactivate it in AFCS
the retained rate may continue to be available to rate-dependent AFCS processes.

Exchange Rates Deleted from ERP Without Replacement

AFCS retains previously loaded exchange rates to support audit, traceability and backdated processing. If an exchange rate is deleted from ERP without being replaced, the previously loaded rate may remain available in AFCS as the last known rate for the applicable currency pair and effective date.

Users should not assume that deleting a rate in ERP automatically removes or deactivates the rate in AFCS. Where a rate is incorrect, Oracle recommends correcting or replacing the rate in ERP and running the Extract job GL_CURRENCY_EXCHG_RATES before executing rate-dependent AFCS processes.

Note:

Deleting an exchange rate in ERP without replacement does not currently guarantee that the previously loaded rate will stop being available in AFCS.

Recommended User Guidance

It is recommended to use correction or replacement rather than deletion without replacement wherever possible. After changing a rate in ERP, run the Extract job GL_CURRENCY_EXCHG_RATES before executing AFCS processes that depend on exchange rates.

Example

Assume that ERP contains a GBP to EUR rate of 1.15 for 01-Jul-2026 and the rate is loaded into AFCS.

If the GBP to EUR rate is later deleted from ERP without being replaced, the previous value of 1.15 may continue to remain available in AFCS.

Users should not assume that the ERP deletion will automatically remove the rate from AFCS. Before running a rate-dependent process, the user must confirm whether GBP to EUR is still required and validate the rate that AFCS will use.