Search Results gl_daily_conversion_types_v




Overview
Explore in AI Chat

Overview

The view GL_DAILY_CONVERSION_TYPES_V is an Oracle E-Business Suite database object owned by the APPS schema and defined within the General Ledger (GL) product family. Its ETRM metadata designates it as "10SC ONLY," indicating that it is a supplemental or site-specific view associated with a 10SC implementation or configuration rather than a core, universally deployed GL object. The view presents currency conversion (daily) rate types together with row-level privilege information derived from Oracle's data security framework.

Functionally, the view exposes the same conversion type identifiers and descriptions found in GL_DAILY_CONVERSION_TYPES, but augments each row with three calculated privilege flags: VIEW_PRIVILEGE, USE_PRIVILEGE, and MODIFY_PRIVILEGE. These flags allow consumers to determine, per user, whether the current session may view, use, or modify a given conversion type. This security-aware projection makes the view suitable for reporting and integration scenarios where rate type visibility must respect Oracle data security grants.

Underlying Base Objects

Per the documented view text, GL_DAILY_CONVERSION_TYPES_V is defined over the following objects:

  • GL_DAILY_CONVERSION_TYPES (SYNONYM) — the base table (referenced via the alias CT) that stores conversion type definitions, including USER_CONVERSION_TYPE, CONVERSION_TYPE, DESCRIPTION, and SECURITY_FLAG.
  • FND_DATA_SECURITY (PACKAGE) — supplies FND_DATA_SECURITY.CHECK_FUNCTION, which evaluates whether the current user holds a specific privilege on a given conversion type.
  • FND_GLOBAL (PACKAGE) — supplies FND_GLOBAL.USER_NAME, used to pass the current user identity into the security check.

The view is therefore a join-free projection: it selects from the synonym GL_DAILY_CONVERSION_TYPES and applies DECODE logic together with Oracle data security function calls to compute the three privilege columns.

Key Columns

  • USER_CONVERSION_TYPE — the user-facing name of the conversion (daily) rate type; the primary identifier reported to and referenced by users.
  • CONVERSION_TYPE — the internal conversion type code, used for programmatic joins and lookups.
  • DESCRIPTION — the descriptive text associated with the conversion type.
  • VIEW_PRIVILEGE — 'Y' or 'N', indicating whether the current user has view access; determined by FND_DATA_SECURITY.CHECK_FUNCTION against the data security object GL_DAS_RATE_TYPES_V when SECURITY_FLAG is 'Y'.
  • USE_PRIVILEGE — 'Y' or 'N', indicating use access, evaluated against GL_DAS_RATE_TYPES_U.
  • MODIFY_PRIVILEGE — 'Y' or 'N', indicating modify access, evaluated against GL_DAS_RATE_TYPES_M.

Where SECURITY_FLAG is not set to 'Y', the DECODE expression returns 'Y' for each privilege, effectively granting full access.

Common Use Cases and Queries

Typical usage includes security-filtered list-of-values queries, self-service reporting of available rate types, and integration extracts that must exclude rate types a user cannot access. A representative query restricts output to conversion types the current user may use:

  • A simple listing: SELECT user_conversion_type, conversion_type, description FROM apps.gl_daily_conversion_types_v ORDER BY user_conversion_type;
  • A privilege-filtered listing: SELECT user_conversion_type, description FROM apps.gl_daily_conversion_types_v WHERE use_privilege = 'Y';
  • A security audit: SELECT user_conversion_type, view_privilege, use_privilege, modify_privilege FROM apps.gl_daily_conversion_types_v;

Because privilege evaluation depends on the session context (FND_GLOBAL.USER_NAME), results vary by the user executing the query. The view should be treated as a 10SC-specific, security-aware presentation layer over GL_DAILY_CONVERSION_TYPES and is not intended as a substitute for the base table in maintenance operations.