Documentation
Everything you need to get started with FX Bridge and automate exchange rate imports into Oracle Fusion Cloud.
1. Overview
FX Bridge automates the daily import of exchange rates from central banks into Oracle Fusion Cloud ERP. Instead of manually downloading rates, formatting FBDI files, and uploading them to Oracle, FX Bridge handles the entire process automatically.
The flow is simple:
Supported rate sources:
- TCMB (Central Bank of Turkey) — ~30 currencies against TRY, 4 rate types (Forex Buying, Forex Selling, Banknote Buying, Banknote Selling)
- ECB (European Central Bank) — ~40 currencies against EUR, reference mid-rate
2. Getting Started
Step 1: Create an Account
Go to Register and enter your email, password, and company name. You'll get a free plan with USD support immediately.
Step 2: Add Oracle Fusion Connection
Navigate to Connections and add your Oracle Fusion instance URL and integration user credentials. See Oracle Fusion Setup for details.
Step 3: Configure Currencies & Mappings
Select which currencies you want to import and map the source rate types to your Oracle Fusion conversion types.
Step 4: Run Your First Transfer
Go to Transfers and click Transfer Now. FX Bridge will generate the FBDI file, upload it to Oracle, and run the import jobs automatically.
3. Oracle Fusion Setup
Before connecting FX Bridge, you need to create an integration user in your Oracle Fusion instance with the appropriate permissions.
3.1 Create an Integration User
We recommend creating a dedicated user for FX Bridge rather than using a personal account. In Oracle Fusion:
- Go to Security Console → Users
- Create a new user (e.g.,
FXBRIDGE_INTEGRATION) - Assign the following roles:
General Accountant(or a custom role with GL Daily Rate import permissions)Integration Specialist(for UCM upload and ESS job submission)
- Set a strong password for the user
3.2 Verify Access
Ensure the integration user can access:
/fscmRestApi/resources/11.13.18.05/erpintegrations— ERP Integrations REST API- UCM document account:
fin$/generalLedger$/import$ - ESS jobs:
importInterfaceFilesandImportDailyRates
Security Note: FX Bridge encrypts your Oracle Fusion credentials using Fernet (AES-128) encryption at rest. Credentials are only decrypted in memory when executing a transfer. We recommend using an integration user with minimal permissions — only GL daily rate import access is needed.
4. Adding a Connection
Navigate to the Connections page in your dashboard.
Required Fields
| Field | Description | Example |
|---|---|---|
| Connection Name | A friendly name for this connection | Production - ABC Corp |
| Fusion URL | Your Oracle Fusion base URL | https://fa-xxxx.oraclecloud.com |
| Username | Integration user's username | FXBRIDGE_INTEGRATION |
| Password | Integration user's password (encrypted at rest) | Hidden after save |
Testing Your Connection
After adding a connection, click Test Connection. FX Bridge will attempt to reach the ERP Integrations REST API endpoint. A successful test confirms that your credentials and network access are working correctly.
5. Selecting Currencies
On the Currencies page, you can enable or disable individual currencies for import. The available currencies depend on your plan:
| Plan | Available Currencies | Sources |
|---|---|---|
| Free | USD only | TCMB |
| Professional | All (~30 TCMB, ~40 ECB) | TCMB + ECB |
| Enterprise | All currencies | All sources |
Toggle currencies on/off using the switches next to each currency code. Use the TCMB and ECB tabs to browse currencies by source. The Rate Preview section shows today's rates for your selected currencies.
6. Rate Type Mappings
FX Bridge needs to know how to map source rate types to your Oracle Fusion conversion types. Navigate to the Mappings page to configure this.
TCMB Rate Types
TCMB provides 4 rate types for each currency. You map each to an Oracle Fusion conversion type:
| Source Rate Type | Description | Example Fusion Type |
|---|---|---|
| forex_buying | Forex Buying Rate (Döviz Alış) | Corporate |
| forex_selling | Forex Selling Rate (Döviz Satış) | Spot |
| banknote_buying | Banknote Buying Rate (Efektif Alış) | User |
| banknote_selling | Banknote Selling Rate (Efektif Satış) | Disabled by default |
ECB Rate Types
ECB provides a single reference rate per currency. Map it to whichever Oracle Fusion conversion type you need.
Important: The Oracle Fusion conversion type name must match exactly what is defined in your Oracle GL setup. Common types include Corporate, Spot, User, and custom types you may have defined.
7. Running Transfers
A transfer is the full process of importing exchange rates into your Oracle Fusion instance.
What happens during a transfer:
- License Check — Verifies your plan allows the requested currencies and sources
- Rate Fetch — Retrieves the latest rates from TCMB and/or ECB
- CSV Generation — Creates the FBDI-formatted CSV file (headerless,
YYYY/MM/DDdate format) - ZIP Packaging — Packages as
GlDailyRatesInterface.csvinside a ZIP - UCM Upload — Uploads the ZIP to Oracle UCM via REST API
- Load Interface File — Submits the "Load Interface File for Import" ESS job
- Import Daily Rates — Submits the "Import Daily Rates" ESS job
- Status Polling — Monitors both ESS jobs until completion
Manual Transfer
Go to Transfers → click Transfer Now. You can select which connection to use and which date's rates to import.
Transfer Statuses
Click any transfer row in the history table to see details including ESS request IDs, CSV row count, and error messages if applicable.
8. Automatic Scheduling
FX Bridge can automatically transfer rates on a daily schedule. Configure this in Settings.
How it works
When auto-transfer is enabled, FX Bridge runs the transfer pipeline at the configured time each business day. The schedule accounts for central bank publication times:
- TCMB publishes rates at 15:30 Turkish time (UTC+3)
- ECB publishes rates at ~16:00 CET
We recommend scheduling transfers after 16:00 CET to ensure both sources have published their daily rates.
Note: Weekends and public holidays are handled automatically. If no new rates are available (TCMB returns 404 on holidays), the transfer is skipped and logged accordingly.
9. Plans & Limits
| Feature | Free | Professional | Enterprise |
|---|---|---|---|
| Currencies | USD only | All | All |
| Rate Sources | TCMB | TCMB + ECB | All |
| Connections | 1 | 3 | Unlimited |
| Rate Types | 1 (forex_buying) | All 5 | All |
| Transfer History | 7 days | 90 days | Unlimited |
To upgrade your plan, contact us at info@experteamsolutions.com.
10. Troubleshooting
Transfer failed: UCM upload error
Check that your integration user has access to the UCM document account fin$/generalLedger$/import$. Also verify the Fusion URL is correct and accessible from the internet.
Transfer failed: ESS job error
The ESS job may fail if the FBDI data contains invalid currency codes or rate types not defined in your Oracle GL setup. Check the transfer detail page for the ESS request ID and review the job log in Oracle Fusion under Scheduled Processes.
Connection test failed
Verify your Fusion URL (should be https://fa-xxxx.oraclecloud.com without trailing slashes or paths). Ensure the username and password are correct. Check if your Oracle Fusion instance allows REST API access from external IP addresses.
No rates available for today
Central banks do not publish rates on weekends and public holidays. TCMB returns 404 on Turkish holidays, and ECB does not update on ECB holidays. This is normal behavior — FX Bridge will skip the transfer and try again on the next business day.
Rates imported but not visible in Oracle GL
After a successful transfer, rates are loaded into the GL_DAILY_RATES_INTERFACE table first, then imported to GL_DAILY_RATES by the "Import Daily Rates" job. Check both ESS jobs completed successfully. Also verify the conversion rate type in Oracle GL Setup matches exactly what you configured in FX Bridge mappings.
11. FAQ
Is my Oracle Fusion password safe?
Yes. Passwords are encrypted using Fernet (AES-128-CBC) encryption at rest and are only decrypted in memory during transfer execution. We never store or log plaintext passwords.
Can I use FX Bridge with multiple Oracle Fusion instances?
Yes. The Free plan supports 1 connection, Professional supports up to 3, and Enterprise has no limit. Each connection can have its own currency selection and rate type mappings.
What happens if a transfer fails?
Failed transfers are logged with error details. You can view the error message in the transfer detail page. No partial data is committed to Oracle GL — either the full import succeeds or it fails cleanly.
Does FX Bridge modify any other data in Oracle Fusion?
No. FX Bridge only uploads FBDI files for GL Daily Rates and triggers the standard Oracle import process. It does not read, modify, or delete any other data in your Fusion instance.
How do I upgrade from Free to Professional?
Contact us at info@experteamsolutions.com. We'll upgrade your account and you'll have immediate access to all currencies, sources, and rate types.
Can I import historical rates?
Yes. When triggering a manual transfer, you can select a specific date. TCMB provides historical data going back to 1996, and ECB has historical data available as well.
Need Help?
Contact our support team for any questions or issues.
info@experteamsolutions.com