Oracle Fusion · Data dictionary
FND_CURRENCIES_B
Common / FoundationUsed in 59 subject areas87 reporting columnsBICC incremental-ready
Foundation / Setup (FND) — base table — language-neutral data (paired with _TL labels and the _VL view).
Primary key: not yet catalogued for FND_CURRENCIES_B — reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ATTRIBUTE1 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE10 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE11 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE12 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE13 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE14 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE15 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE2 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE3 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE4 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE5 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE6 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE7 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE8 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE9 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE1 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE10 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE2 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE3 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE4 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE5 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE6 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE7 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE8 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE9 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER1 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER10 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER2 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER3 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER4 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER5 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER6 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER7 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER8 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER9 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_TIMESTAMP1 | ● | Attribute timestamp1. | |
| ATTRIBUTE_TIMESTAMP10 | ● | Attribute timestamp10. | |
| ATTRIBUTE_TIMESTAMP2 | ● | Attribute timestamp2. | |
| ATTRIBUTE_TIMESTAMP3 | ● | Attribute timestamp3. | |
| ATTRIBUTE_TIMESTAMP4 | ● | Attribute timestamp4. | |
| ATTRIBUTE_TIMESTAMP5 | ● | Attribute timestamp5. | |
| ATTRIBUTE_TIMESTAMP6 | ● | Attribute timestamp6. | |
| ATTRIBUTE_TIMESTAMP7 | ● | Attribute timestamp7. | |
| ATTRIBUTE_TIMESTAMP8 | ● | Attribute timestamp8. | |
| ATTRIBUTE_TIMESTAMP9 | ● | Attribute timestamp9. | |
| CONTEXT | ● | Context. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| CURRENCY_FLAG | ● | Indicator (Y/N) for the currency. | |
| DERIVE_EFFECTIVE | ● | Derive effective. | |
| DERIVE_FACTOR | ● | Derive factor. | |
| DERIVE_TYPE | ● | Type of derive. | |
| DIGITAL_CURRENCY_CODE | ● | Currency code for the digital. | |
| ENABLED_FLAG | ● | Indicator (Y/N) for the enabled. | |
| END_DATE_ACTIVE | ● | End date active. | |
| EXTENDED_PRECISION | ● | Extended precision. | |
| GLOBAL_ATTRIBUTE1 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE10 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE11 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE12 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE13 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE14 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE15 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE16 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE17 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE18 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE19 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE2 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE20 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE3 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE4 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE5 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE6 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE7 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE8 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE9 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE_CATEGORY | ● | Global descriptive flexfield context (structure definition). | |
| ISO_FLAG | ● | Indicator (Y/N) for the iso. | |
| ISSUING_TERRITORY_CODE | ● | Code identifying the issuing territory. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | INCR | ● | Date and time the row was last updated (the incremental-extract key). |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| MINIMUM_ACCOUNTABLE_UNIT | ● | Minimum accountable unit. | |
| PRECISION | ● | Precision. | |
| START_DATE_ACTIVE | ● | Start date active. | |
| SYMBOL | ● | Symbol. |
Used by reports
No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.
- —
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.
- Cash Management - Bank Statement Balances Real Time
- Cash Management - Bank Statement Line Charges Real Time
- Cash Management - Bank Statements Real Time
- Cash Management - External Cash Transactions Real Time
- Costing - Inventory Valuation Real Time
- Costing - Item Cost Real Time
- Costing - Period Inventory Valuation Real Time
- Financials Common Module - Intercompany Transactions Real Time
- Fixed Assets - Asset Balances Real Time
- Fixed Assets - Asset Depreciation Real Time
- Fixed Assets - Asset Financial Information Real Time
- Fixed Assets - Asset Retirements and Reinstatements Real Time
- Fixed Assets - Asset Source Lines Real Time
- Fixed Assets - Asset Transactions Real Time
- General Ledger - Balances Real Time
- General Ledger - Journals Real Time
- General Ledger - Transactional Balances Real Time
- Payables Invoices - Installments Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
Need the extract + dbt staging for FND_CURRENCIES_B?
We ship parameterized SQL, BICC config, and dbt models you own.