Results for “default_currency_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FTE_PRC_PARAMETER_DEFAULTS is a table in the FTE (Transportation Execution) product schema within Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to store default values for pricing parameters used by the transportation pricing engine. In practical terms, this table acts as the configuration layer that supplies fallback values when pricing parameters are not explicitly set within a given pricing context. Each row represents a parameter default keyed by PARAMETER_ID, and the record encodes the parameter's type, applicable lane function, sub-type, data type, and a range of default value attributes.

Based on the foreign key relationship in which FTE_PRC_PARAMETERS.PARAMETER_ID references this table, the heuristic Data Vault classification is hub-leaning. This suggests the table behaves primarily as a hub of parameter identity, with the parameter's descriptive and value attributes serving as dependent context. From a modeling perspective, this classification is advisory and reflects the observed reference pattern rather than a mandated design.

Key Information Stored

The table contains 21 documented columns. The surrogate primary key is PARAMETER_ID, which is enforced by the constraint FTE_PRC_PARAMETER_DEFAULTS_PK. A separate unique index, FTE_PRC_PARAMETER_DEFAULTS_U1, also covers PARAMETER_ID and serves as the documented business-key candidate.

• PARAMETER_ID — Surrogate primary key uniquely identifying each parameter default record.
• PARAMETER_TYPE — Classifies the parameter by category, driving which pricing logic consumes the default.
• PARAMETER_SUB_TYPE — Further refines the parameter classification within its type.
• LANE_FUNCTION — Indicates the lane-related function or context to which the default applies.
• PARAMETER_NAME — Human-readable name of the pricing parameter.
• PARAMETER_DATATYPE — Declares the expected data type of the default value (for example, numeric, date, or character).
• DEFAULT_VALUE_FROM and DEFAULT_VALUE_TO — Define the lower and upper bounds of the default value range.
• DEFAULT_UOM_CLASS and DEFAULT_UOM_CODE — Specify the default unit of measure class and code.
• DEFAULT_CURRENCY_CODE — The default currency applied when the parameter is monetary.
• USER_OVERRIDE_ALLOWED — Flag indicating whether end users may override the default.

The remaining columns are standard EBS audit and concurrency fields: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, and REQUEST_ID.

Common Use Cases and Queries

Typical uses include auditing configured pricing defaults, verifying override policies, and joining defaults back to the parameters that reference them. A representative query joining the hub and its referencing table follows:

• SELECT p.PARAMETER_ID, p.PARAMETER_NAME, d.DEFAULT_VALUE_FROM, d.DEFAULT_VALUE_TO, d.DEFAULT_UOM_CODE, d.DEFAULT_CURRENCY_CODE FROM FTE.FTE_PRC_PARAMETER_DEFAULTS d JOIN FTE.FTE_PRC_PARAMETERS p ON p.PARAMETER_ID = d.PARAMETER_ID;
• Filter defaults by PARAMETER_TYPE and LANE_FUNCTION to review configuration coverage for a specific pricing context.
• Inspect USER_OVERRIDE_ALLOWED to confirm governance rules around user-entered pricing values.
• Report on DEFAULT_CURRENCY_CODE and DEFAULT_UOM_CODE distribution to validate localization and unit consistency.
• Track changes through LAST_UPDATE_DATE, LAST_UPDATED_BY, and REQUEST_ID for audit and troubleshooting.

Related Objects

• FTE_PRC_PARAMETERS — References this table through FTE_PRC_PARAMETERS.PARAMETER_ID → FTE_PRC_PARAMETER_DEFAULTS.PARAMETER_ID; the principal dependent object.
• FTE_PRC_PARAMETER_DEFAULTS_PK — Primary key constraint on PARAMETER_ID.
• FTE_PRC_PARAMETER_DEFAULTS_U1 — Unique index on PARAMETER_ID, the business-key candidate.
• FTE pricing engine components — Consume parameter defaults during rate and charge calculation in Transportation Execution.
• FTE unit of measure and currency reference tables — Provide the valid values resolved through DEFAULT_UOM_CLASS, DEFAULT_UOM_CODE, and DEFAULT_CURRENCY_CODE.