Currencies

In Scope

Technical: CURRENCIES | ID: OR-FND-CURRENCIES-CURRENCIES

Stores one row for each currency used in the system. Whenever a currency description is used by Oracle Retail, or a currency code is validated, it is always selected from...

See how this object fits into Foundation Data

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: CURRENCIES

Field Definitions(5)

Rules & Considerations(16)

validation

constraint

Sample Load Data(4)

_scenario	CURRENCY_CODERPK	CURRENCY_DESCR	CURRENCY_RTL_FMTR	CURRENCY_COST_DECR	CURRENCY_COST_FMTR	CREATE_ID	CREATE_DATETIME	CURRENCY_RTL_DEC
Example values from field definitions	SAM	SAMPLE	SAMPLE	1	SAMPLE	SAMPLE	2026-01-01	1
default	ALT	Currencies-002-ALT	Currencies-002-ALT	3	Currencies-002-ALT	C LIENT_INFO	2026-01-03	3
default	EDG	Currencies-003-EDGE	Currencies-003-EDGE	5	Currencies-003-EDGE	USE RENV	2026-01-05	5

Example values from field definitions

CURRENCY_CODERPK: SAM
CURRENCY_DESCR: SAMPLE
CURRENCY_RTL_FMTR: SAMPLE
CURRENCY_COST_DECR: 1
CURRENCY_COST_FMTR: SAMPLE
CREATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
CURRENCY_RTL_DEC: 1

default

CURRENCY_CODERPK: ALT
CURRENCY_DESCR: Currencies-002-ALT
CURRENCY_RTL_FMTR: Currencies-002-ALT
CURRENCY_COST_DECR: 3
CURRENCY_COST_FMTR: Currencies-002-ALT
CREATE_ID: C LIENT_INFO
CREATE_DATETIME: 2026-01-03
CURRENCY_RTL_DEC: 3