OTA — Learning Management
111 documented tables · 102 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
OTA_LO_FOLDERS |
A folder contains learning objects and other folders, and are created in the Content tree by administrators. | hub-leaning |
OTA_ACTIVITY_VERSIONS |
A course is the highest level of learning that can be prescribed to a learner.It also contains the objectives | hub |
OTA_ACTIVITY_DEFINITIONS |
An activity is any educational offering designed to improve a students qualifications, competencies or experie | hub-leaning |
OTA_EVENTS |
An event can be scheduled, one time, developmental, program or session. | hub |
OTA_FINANCE_HEADERS |
A finance header holds generic financial information about dealings you have with particular customers or supp | hub-leaning |
OTA_FORUMS_B |
Forum can belongs to a category or class. Forum can be used to communicate between one or more user online. | hub-leaning |
OTA_CERTIFICATIONS_B |
Certification is an object that belong to a category. Certification can consist of one or more courses. Certif | hub-leaning |
OTA_LEARNING_OBJECTS |
A learning object holds metadata relating to a piece of online content or test, and are created in the Content | hub-leaning |
OTA_QUESTIONS |
This table contains the question definitions. Questions can be reused in different tests. At present there is | hub-leaning |
OTA_BOOKING_STATUS_TYPES |
Booking status types contain a list of user-defined enrollment statuses, along with their corresponding system | hub-leaning |
OTA_CHATS_B |
Chat can belongs to a category or class. Chat can be used to communicate between one or more user online and r | hub-leaning |
OTA_SCORM_OBJECTIVES |
Holds one record for each objective. Objectives are used in both AICCand SCORM. | hub-leaning |
OTA_RESOURCE_DEFINITIONS |
Resource definitions hold the unique key flexfield combinations for supplied resources. | hub-leaning |
OTA_ATTEMPTS |
Every time a learner plays online learning, a row in this table is created for a specific leaner against a lea | satellite-leaning |
OTA_CONTENT_SERVERS |
Content servers define web server machines that contain physical content files, that should be accessible from | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
OTA_CERT_ENROLLMENT_API |
API | 4 | 6 packages |
OTA_TBD_API |
API | 13 | 5 packages |
OTA_LP_ENROLLMENT_API |
API | 4 | 5 packages |
OTA_EVENT_API |
API | 4 | 5 packages |
OTA_DELEGATE_BOOKING_API |
API | 6 | 4 packages |
OTA_CERT_MBR_ENROLLMENT_API |
API | 3 | 4 packages |
OTA_LP_MEMBER_ENROLLMENT_API |
API | 3 | 4 packages |
OTA_TPS_API |
API | 3 | 3 packages |
OTA_OM_UPD_API |
API | 5 | 3 packages |
OTA_ACTIVITY_CATEGORY_API |
API | 3 | 3 packages |