Results for “path_source_code”

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

Overview

OTA_LEARNING_PATHS is a core transactional table in the Oracle E-Business Suite Learning Management module (product code OTA). As the documented description states, a learning path defines a sequence of courses that should be completed in order to obtain specific knowledge. The table therefore acts as the master header record for a structured curriculum, grouping individual courses, offerings, and competencies into a single ordered program that learners can enroll in and progress through.

In Oracle EBS 12.1.1 and 12.2.2 the table resides in the OTA schema and is classified as VALID. It is populated and maintained through the Learning Management administrative and self-service flows, including learner path enrollment and competency-driven assignment. From a Data Vault modeling perspective, the metadata heuristically classifies OTA_LEARNING_PATHS as hub-leaning. This suggests it is best treated as a central hub entity keyed by a stable business identifier, with the surrounding enrollment, section, and membership tables acting as link or satellite structures that record relationships and descriptive context over time.

Key Information Stored

The table is documented with 43 columns. The single-column primary key is defined by the OTA_LEARNING_PATHS_PK unique index on LEARNING_PATH_ID, which is the surrogate identifier used by all dependent tables. The remaining columns fall into several functional groups:

• Identity and tenancy: LEARNING_PATH_ID (surrogate PK) and BUSINESS_GROUP_ID, which scopes the record to a specific operating unit or business group.
• Scheduling and duration: DURATION, DURATION_UNITS, START_DATE_ACTIVE, and END_DATE_ACTIVE define how long the path runs and the window during which it is active.
• Source and assignment context: PATH_SOURCE_CODE, SOURCE_FUNCTION_CODE, ASSIGNMENT_ID, and SOURCE_ID identify how the path was created or assigned, supporting competency- or requirement-driven generation.
• Audit and concurrency: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN provide standard EBS audit and optimistic locking columns.
• Descriptive flexfields: ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 supply the DFF segments used for customer-specific extensions.
• Notification and visibility: NOTIFY_DAYS_BEFORE_TARGET, PERSON_ID, CONTACT_ID, DISPLAY_TO_LEARNER_FLAG, and PUBLIC_FLAG control learner-facing behavior and reminder timing.
• Competency integration: COMPETENCY_UPDATE_LEVEL governs how completion of the path updates the learner's competency profile.

Only LEARNING_PATH_ID is documented as a unique business-key candidate; no composite alternate key is recorded in the metadata.

Common Use Cases and Queries

Typical reporting and integration scenarios include listing active learning paths, identifying paths assigned to a specific person, and reconciling path completion against enrollments. A representative query retrieves active paths for a business group:

• SELECT learning_path_id, duration, duration_units, start_date_active, end_date_active FROM ota_learning_paths WHERE business_group_id = :p_bg_id AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE + 1);
• Joining to OTA_LEARNING_PATH_MEMBERS on LEARNING_PATH_ID to enumerate the courses contained in each path.
• Joining to OTA_LP_ENROLLMENTS on LEARNING_PATH_ID to measure learner enrollment and completion rates.
• Filtering on DISPLAY_TO_LEARNER_FLAG and PUBLIC_FLAG to build self-service catalog extracts.
• Using PERSON_ID and NOTIFY_DAYS_BEFORE_TARGET to drive reminder notifications ahead of a target completion date.

Related Objects

The documented foreign key relationships identify the most significant dependent objects:

• OTA_LEARNING_PATH_MEMBERS — references OTA_LEARNING_PATHS via LEARNING_PATH_ID; holds the individual member courses of the path.
• OTA_LP_SECTIONS — references LEARNING_PATH_ID; organizes path content into logical sections.
• OTA_LP_ENROLLMENTS — references LEARNING_PATH_ID; records each learner's enrollment in a path.
• OTA_EVENT_ASSOCIATIONS — references LEARNING_PATH_ID; links events to paths.

The primary key OTA_LEARNING_PATHS_PK (LEARNING_PATH_ID) is the join column shared across these tables, making it the pivot for path-level reporting in the OTA Learning Management module.