Search Results training_title

Overview

OTFV_COMBINED_TRAINING_HISTORY is an APPS-owned database view within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environments, belonging to the OTA (Oracle Training Administration / Learning Management) product family. It is documented in ETRM as a business view template from which the flexfield view is generated, meaning it serves as the canonical foundation that EBS uses to expose training history data for descriptive flexfield and reporting purposes. The view presents a consolidated, denormalized picture of an enterprise's training and learning history records, joining non-training history records to organization, person, and activity metadata. Its status is VALID, and it resides in the APPS schema, making it accessible to standard EBS responsibility and reporting layers.

In practice, the view functions as a reporting and integration surface. Rather than forcing report authors and integration developers to reconstruct multi-table joins manually, it delivers column aliases that map cleanly to business terms such as TRAINING_TITLE, TRAINING_COMPLETION_DATE, TRAINING_PROVIDER, and TRAINING_DURATION. The DATA_SOURCE column identifies the origin of each row, with the base template emitting a literal 'NON_OTA' value, indicating records drawn from OTA_NOTRNG_HISTORIES.

Underlying Base Objects

The documented view text is defined primarily over OTA_NOTRNG_HISTORIES (aliased TNH), which supplies the training history facts. It is joined to HR_ALL_ORGANIZATION_UNITS_TL (ORGT and BGRT) for organization and business group names, PER_ALL_PEOPLE_F (PER and CON) for person and contact names, and OTA_ACTIVITY_VERSIONS (TAV) with OTA_ACTIVITY_DEFINITIONS (TAD) for the learning activity version and type. The outer joins on organization and the language predicate on HR tables ensure only the current session language rows are returned.

ETRM also documents a broader set of referenced objects, including HR_BIS (the business intelligence decode package), OTA_GENERAL, HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES, HZ_PARTIES, HZ_RELATIONSHIPS, OTA_DELEGATE_BOOKINGS, OTA_EVENTS, OTA_EVENTS_TL, OTA_LEARNING_OBJECTS, OTA_OFFERINGS, OTA_PERFORMANCES, OTA_ACTIVITY_DEFINITIONS_TL, OTA_ACTIVITY_VERSIONS_TL, and PO_VENDORS. These support the union-all combined structure and provide columns such as CUSTOMER_NAME, PLAYER_STATUS, and ROC_ID that are stubbed with NULL or TO_NUMBER(NULL) in the template branch. Lookup decoding is delegated to HR_BIS.BIS_DECODE_LOOKUP for training types, frequency/duration units, and training statuses.

Key Columns

• TRAINING_DURATION — sourced directly from TNH.DURATION; the specific column that addresses the "training_duration" search term.
• TRAINING_DURATION_UNITS — decoded from TNH.DURATION_UNITS through the FREQUENCY lookup, giving human-readable units for the duration value.
• TRAINING_TITLE, TRAINING_COMPLETION_DATE, TRAINING_TYPE, TRAINING_STATUS — core descriptive attributes decoded against OTA_TRAINING_TYPES and OTA_TRAINING_STATUSES lookups.
• TRAINING_CENTER, TRAINING_PROVIDER, TRAINING_AWARD, TRAINING_RATING — venue and outcome attributes.
• PERSON_NAME, CONTACT_NAME, ORGANIZATION_NAME, BUSINESS_GROUP_NAME — party and organizational context.
• DATA_SOURCE — literal 'NON_OTA' in the template branch, identifying the record family.
• ACTIVITY_VERSION_ID, ACTIVITY_ID, PERSON_ID, CONTACT_ID, CUSTOMER_ID, ORGANIZATION_ID, BUSINESS_GROUP_ID — surrogate keys enabling joins to transactional tables.
• TOTAL_TRAINING_TIME, PLAYER_STATUS, TEST_SCORE, NUMBER_OF_MODULES_COMPLETED, TOTAL_MODULES — placeholders in the template, populated when combined with OTA e-learning sources.

Common Use Cases and Queries

The most frequent use case is extracting training duration and completion metrics per person or organization for compliance reporting. A representative query is:

• SELECT person_name, training_title, training_completion_date, training_duration, training_duration_units, training_status FROM apps.otfv_combined_training_history WHERE person_id = :p_person_id;
• SELECT organization_name, training_provider, SUM(training_duration) FROM apps.otfv_combined_training_history GROUP BY organization_name, training_provider;

Integrations frequently reference BUSINESS_GROUP_ID and PERSON_ID to reconcile learning records with HRMS data. Because the view template is the basis for the generated flexfield view, customers extending OTA with descriptive flexfields should treat OTFV_COMBINED_TRAINING_HISTORY as the authoritative column contract.