Results for “default_flag”

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

Overview

OTFV_ENROLLMENT_STATUSES is an Oracle E-Business Suite business view owned by the APPS schema and defined within the OTA - Learning Management (Oracle Training Administration) product family. The object is documented as VALID in ETRM for both 12.1.1 and 12.2.2. Its documented description identifies it as a "business view template from which the flexfield view is generated," which places it in the family of descriptive flexfield (DFF) supporting views that Oracle seeds to expose key flexfield and descriptive flexfield data for a specific business entity.

In practice, the view presents enrollment (booking) statuses — the values used to classify a learner's enrollment record, such as Confirmed, Waitlisted, Cancelled, or Completed — together with their business group context, type classification, and the seed flags that control default behavior and seat consumption. Because it resolves the underlying status type identifiers and their business group, the view functions as a reporting and integration layer over the OTA booking status configuration rather than a transactional enrollment table. Report developers, concurrent program queries, and interface extract logic use it to present enrollment status values in a language-resolved, lookup-decoded form without needing to join the OTA booking status tables directly.

Underlying Base Objects

The view is defined over the following documented base objects:

• OTA_BOOKING_STATUS_TYPES (SYNONYM) — the principal base table holding the enrollment/booking status type definitions, including the type code, default flag, place-used flag, active flag, description, and comments.
• OTA_BOOKING_STATUS_TYPES_TL (SYNONYM) — the translation table associated with the booking status types, referenced in the documented metadata set.
• HR_ALL_ORGANIZATION_UNITS (SYNONYM) and HR_ALL_ORGANIZATION_UNITS_TL (SYNONYM) — the organization tables used to resolve the business group name; the translucent table is joined with LANGUAGE = USERENV('LANG') to return the current session language.
• HR_BIS (PACKAGE) — invoked through HR_BIS.BIS_DECODE_LOOKUP to decode the seeded lookup values DELEGATE_BOOKING_STATUS and YES_NO into displayable meanings.
• OTA_GENERAL (PACKAGE) — supplies OTA_GENERAL.GET_BUSINESS_GROUP_ID, which constrains the view to the user's current business group while allowing all business groups when the function returns null.

Joins are established as BST.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID and BGR.ORGANIZATION_ID = BGRT.ORGANIZATION_ID. The view is created WITH READ ONLY, confirming its reporting-only purpose.

Key Columns

• BUSINESS_GROUP_NAME — the name of the business group to which the enrollment status belongs.
• ENROLLMENT_STATUS — the name of the booking/enrollment status (BST.NAME).
• ENROLLMENT_STATUS_TYPE — the decoded classification of the status, derived from the DELEGATE_BOOKING_STATUS lookup applied to BST.TYPE.
• DEFAULT_FLAG — indicates whether the status is the default for new enrollments, decoded through the YES_NO lookup.
• PLACE_USED — indicates whether the status consumes a place/seat in the offering, decoded through YES_NO with a null-preserving DECODE.
• ACTIVE_FLAG — whether the status is active and available for selection.
• DESCRIPTION and COMMENTS — descriptive text maintained on the booking status type.
• "_DF" — the descriptive flexfield reference column, of the form '_DF:OTA:OTA_BOOKING_STATUS_TYPES:BST', which links the row to its DFF context.
• BUSINESS_GROUP_ID and BOOKING_STATUS_TYPE_ID — the identifying keys for the business group and the underlying booking status type.

Common Use Cases and Queries

Typical uses include validating enrollment status lists for a business group, building LOV-driven report parameters, and extracting status configuration for data migration or interface mapping. A representative query follows:

SELECT business_group_name
     , enrollment_status
     , enrollment_status_type
     , default_flag
     , place_used
     , active_flag
  FROM apps.otfv_enrollment_statuses
 WHERE active_flag = 'Yes'
 ORDER BY business_group_name, enrollment_status;

To retrieve the identifier values needed for integration or lookup joins:

SELECT booking_status_type_id
     , business_group_id
     , enrollment_status
     , description
  FROM apps.otfv_enrollment_statuses
 WHERE business_group_id = :p_business_group_id;

Because the view is read-only and already decodes lookup values and resolves language, it is generally preferable to querying OTA_BOOKING_STATUS_TYPES directly, particularly where consistent display values are required across reports and interfaces.