You are browsing the archive for OTA.

Learning Management Tables

Oracle Learning Management Tables:

  • OTA_ACTIVITY_DEFINITIONS
  • OTA_ACTIVITY_DEFINITIONS_TL
  • OTA_ACTIVITY_VERSIONS
  • OTA_ACTIVITY_VERSIONS_EFC
  • OTA_ACTIVITY_VERSIONS_TL
  • OTA_ACT_CAT_INCLUSIONS
  • OTA_ANNOUNCEMENTS
  • OTA_ANNOUNCEMENTS_TL
  • OTA_ATTEMPTS
  • OTA_BKNG_JUSTIFICATIONS_B
  • OTA_BKNG_JUSTIFICATIONS_TL
  • OTA_BOOKING_DEALS
  • OTA_BOOKING_DEALS_EFC
  • OTA_BOOKING_STATUS_EXCL
  • OTA_BOOKING_STATUS_HISTORIES
  • OTA_BOOKING_STATUS_TYPES
  • OTA_BOOKING_STATUS_TYPES_TL
  • OTA_BULK_ENR_REQUESTS
  • OTA_BULK_ENR_REQ_MEMBERS
  • OTA_CATEGORY_USAGES
  • OTA_CATEGORY_USAGES_TL
  • OTA_CERTIFICATIONS_B
  • OTA_CERTIFICATIONS_TL
  • OTA_CERTIFICATION_MEMBERS
  • OTA_CERT_CAT_INCLUSIONS
  • OTA_CERT_ENROLLMENTS
  • OTA_CERT_MBR_ENROLLMENTS
  • OTA_CERT_PRD_ENROLLMENTS
  • OTA_CHATS_B
  • OTA_CHATS_TL
  • OTA_CHAT_MESSAGES
  • OTA_CHAT_OBJ_INCLUSIONS
  • OTA_CHAT_USERS
  • OTA_CMI_ADAPTERS
  • OTA_COMPETENCE_LANGUAGES
  • OTA_CONFERENCES
  • OTA_CONFERENCE_SERVERS_B
  • OTA_CONFERENCE_SERVERS_TL
  • OTA_CONTENT_SERVERS
  • OTA_COURSE_PREREQUISITES
  • OTA_CROSS_CHARGES
  • OTA_DELEGATE_BOOKINGS
  • OTA_EVENTS
  • OTA_EVENTS_EFC
  • OTA_EVENTS_TL
  • OTA_EVENT_ASSOCIATIONS
  • OTA_FINANCE_HEADERS
  • OTA_FINANCE_HEADERS_EFC
  • OTA_FINANCE_LINES
  • OTA_FINANCE_LINES_EFC
  • OTA_FORUMS_B
  • OTA_FORUMS_TL
  • OTA_FORUM_MESSAGES
  • OTA_FORUM_THREADS
  • OTA_FRM_NOTIF_SUBSCRIBERS
  • OTA_FRM_OBJ_INCLUSIONS
  • OTA_HR_GL_FLEX_MAPS
  • OTA_ILN_XML_PROCESSES
  • OTA_IMPORT_HISTORIES
  • OTA_LEARNING_OBJECTS
  • OTA_LEARNING_PATHS
  • OTA_LEARNING_PATHS_TL
  • OTA_LEARNING_PATH_MEMBERS
  • OTA_LO_FOLDERS
  • OTA_LO_SCORM_OBJECTIVES
  • OTA_LP_CAT_INCLUSIONS
  • OTA_LP_ENROLLMENTS
  • OTA_LP_MEMBER_ENROLLMENTS
  • OTA_LP_SECTIONS
  • OTA_LP_SECTIONS_TL
  • OTA_NOTRNG_HISTORIES
  • OTA_OFFERINGS
  • OTA_OFFERINGS_TL
  • OTA_OPEN_FC_ENROLLMENTS
  • OTA_PERFORMANCES
  • OTA_PREREQUISITES
  • OTA_PRICE_LISTS
  • OTA_PRICE_LISTS_EFC
  • OTA_PRICE_LIST_ENTRIES
  • OTA_PRICE_LIST_ENTRIES_EFC
  • OTA_PROGRAM_MEMBERSHIPS
  • OTA_PVT_FRM_THREAD_USERS
  • OTA_QBANK_QUESTIONS
  • OTA_QUESTIONS
  • OTA_QUESTION_BANKS
  • OTA_RESOURCE_ALLOCATIONS
  • OTA_RESOURCE_BOOKINGS
  • OTA_RESOURCE_BOOKINGS_EFC
  • OTA_RESOURCE_DEFINITIONS
  • OTA_RESOURCE_USAGES
  • OTA_RESPONSE_TYPES
  • OTA_RESPONSE_VALUES
  • OTA_SCORM_OBJECTIVES
  • OTA_SCORM_OBJ_ATTEMPTS
  • OTA_SCORM_OBJ_PERFS
  • OTA_SECTION_RULES
  • OTA_SKILL_PROVISIONS
  • OTA_SUPPLIABLE_RESOURCES
  • OTA_SUPPLIABLE_RESOURCES_EFC
  • OTA_SUPPLIABLE_RESOURCES_TL
  • OTA_TESTS
  • OTA_TEST_QUESTIONS
  • OTA_TEST_SECTIONS
  • OTA_TITLE_CONVERSIONS
  • OTA_TP_MEASUREMENT_TYPES
  • OTA_TRAINING_PLANS
  • OTA_TRAINING_PLANS_EFC
  • OTA_TRAINING_PLAN_COSTS
  • OTA_TRAINING_PLAN_COSTS_EFC
  • OTA_TRAINING_PLAN_MEMBERS
  • OTA_UPGRADE_LOG
  • OTA_UTEST_QUESTIONS
  • OTA_UTEST_RESPONSES
  • OTA_VENDOR_SUPPLIES

Views in Learning Management Module

List of Views in Oracle Learning Management Module

OTA_ACT_CAT_INCLUSIONS_V
OTA_ACTIVITY_DEFINITIONS_DFV
OTA_ACTIVITY_DEFINITIONS_V
OTA_ACTIVITY_DEFINITIONS_VL
OTA_ACTIVITY_VERSIONS_V
OTA_ACTIVITY_VERSIONS_VL
OTA_ANNOUNCEMENTS_VL
OTA_BKNG_JUSTIFICATIONS_VL
OTA_BOOKING_DEALS_V
OTA_BOOKING_STATUS_HISTORIES_V
OTA_BOOKING_STATUS_TYPES_VL
OTA_CATEGORY_USAGES_V
OTA_CATEGORY_USAGES_V1
OTA_CATEGORY_USAGES_VL
OTA_CERTIFICATIONS_VL
OTA_CHATS_VL
OTA_COMPETENCE_LANGUAGES_DFV
OTA_COMPETENCE_LANGUAGES_V
OTA_CONFERENCE_SERVERS_VL
OTA_CROSS_CHARGES_V
OTA_CTRNG_HISTORIES_V
OTA_CUSTOMER_ADDRESSES_V
OTA_CUSTOMER_CONTACTS_V
OTA_DELEGATE_BOOKINGS_V
OTA_DISCOUNT_DEALS_V
OTA_EVENT_ASSOCIAT_BILLING_V
OTA_EVENT_ASSOCIATIONS_V
OTA_EVENT_ASSOCIATIONS_V2
OTA_EVENT_SEARCH_V
OTA_EVENT_SEARCH_V2
OTA_EVENTS_V
OTA_EVENTS_VL
OTA_FINANCE_HEADERS_V
OTA_FINANCE_LINES_V
OTA_FORUMS_VL
OTA_LEARNING_PATHS_VL
OTA_LETTER_REQUEST_LINES_V
OTA_LP_SECTIONS_VL
OTA_NATURAL_LANGUAGES_V
OTA_NOTRNG_HISTORIES_DFV
OTA_NOTRNG_HISTORIES_V
OTA_OFFERINGS_VL
OTA_PRE_PURCHASE_DEALS_V
OTA_PRICE_LIST_ENTRIES_V
OTA_PRICE_LISTS_V
OTA_PROGRAM_MEMBERSHIPS_V
OTA_RESOURCE_BOOKINGS_V
OTA_RESOURCE_DEFINITIONS_KFV
OTA_RESOURCE_USAGES_V
OTA_SKILL_PROVISIONS_V
OTA_SKILLS_V
OTA_STUDENT_TITLES_V
OTA_STUDENTS_V
OTA_SUPPLIABLE_RESOURCES_V
OTA_SUPPLIABLE_RESOURCES_VL
OTA_TEST_SECTIONS_V
OTA_TP_MEASUREMENT_TYPES_DFV
OTA_TP_MEASUREMENT_TYPES_V
OTA_TRAINING_COST_LEVELS_V
OTA_TRAINING_PLAN_BUDGETS_V
OTA_TRAINING_PLAN_COSTS_DFV
OTA_TRAINING_PLAN_COSTS_V
OTA_TRAINING_PLAN_COSTS1_DFV
OTA_TRAINING_PLAN_MEMBERS_DFV
OTA_TRAINING_PLAN_MEMBERS_V
OTA_TRAINING_PLANS_DFV
OTA_TRAINING_PLANS_V
OTA_USER_GROUP_ELEMENTS_DFV
OTA_USER_GROUPS_DFV
OTA_USER_GROUPS_VL
OTA_UTEST_QUESTIONS_V
OTA_VENDOR_ADDRESSES_V
OTA_VENDOR_CONTACTS_V
OTA_VENDORS_V

Learning Management Descriptive Flex Fields

Oracle Learning Management Module DFF list

DFF View DFF CODE NAME DFF name
OTA_USER_GROUPS_DFV OTA_USER_GROUPS Additional Learner Group Information
OTA_CERTIFICATION_MEMBERS_DFV OTA_CERTIFICATION_MEMBERS Add’l Learning Certification Member Info.
OTA_QUESTIONS_DFV OTA_QUESTIONS Add’l Question Information
OTA_CONFERENCE_SERVERS_B_DFV OTA_CONFERENCE_SERVERS Additional Conference Server Information
OTA_TRAINING_PLAN_COSTS_DFV OTA_TRAINING_PLAN_COSTS Additional Plan Cost Details
OTA_LEARNING_PATHS_DFV OTA_LEARNING_PATHS Add’l Learning Path Info
OTA_CATEGORY_USAGES_DFV OTA_CATEGORY_USAGES Add’l Category Information
OTA_ACTIVITY_DEFINITIONS_DFV OTA_ACTIVITY_DEFINITIONS Add’l Activity Information
OTA_ACTIVITY_VERSIONS_DFV OTA_ACTIVITY_VERSIONS Add’l Course Info.
OTA_ACT_CAT_INCLUSIONS_DFV OTA_ACT_CAT_INCLUSIONS Add’l Category Inclusion Det’s
OTA_BOOKING_DEALS_DFV OTA_BOOKING_DEALS Add’l Booking Deal Info.
OTA_BOOKING_STATUS_TYPES_DFV OTA_BOOKING_STATUS_TYPES Add’l Booking Status Info.
OTA_DELEGATE_BOOKINGS_DFV OTA_DELEGATE_BOOKINGS Add’l Delegate Booking Info.
OTA_EVENTS_DFV OTA_EVENTS Additional Class Information
OTA_EVENT_ASSOCIATIONS_DFV OTA_EVENT_ASSOCIATIONS Add’l Learner Access Info.
OTA_FINANCE_HEADERS_DFV OTA_FINANCE_HEADERS Add’l Finance Header Info.
OTA_FINANCE_LINES_DFV OTA_FINANCE_LINES Add’l Finance Line Info.
OTA_FINANCE_HEADERS1_DFV OTA_PAYMENT_METHODS Payment Methods
OTA_PRICE_LISTS_DFV OTA_PRICE_LISTS Add’l Price List Information
OTA_PRICE_LIST_ENTRIES_DFV OTA_PRICE_LIST_ENTRIES Add’l Price List Entry Info.
OTA_PROGRAM_MEMBERSHIPS_DFV OTA_PROGRAM_MEMBERSHIPS Add’l Program Membership Det’s
OTA_RESOURCE_BOOKINGS_DFV OTA_RESOURCE_BOOKINGS Additional Resource Bookings
OTA_RESOURCE_USAGES_DFV OTA_RESOURCE_USAGES Add’l Resource Checklist Info.
OTA_SKILL_PROVISIONS_DFV OTA_SKILL_PROVISIONS Add’l Skill Provision Info.
OTA_SUPPLIABLE_RESOURCES_DFV OTA_SUPPLIABLE_RESOURCES Add’l Suppliable Res’rce Det’s
OTA_FINANCE_LINES1_DFV OTA_TFL_TRANSFER Finance Lines Transfer Details
OTA_VENDOR_SUPPLIES_DFV OTA_VENDOR_SUPPLIES Add’l Vendor Supplies Info.
OTA_LO_FOLDERS_DFV OTA_LO_FOLDERS Additional LO Folder Information
OTA_CERT_ENROLLMENTS_DFV OTA_CERT_ENROLLMENTS Add’l Learning Certification Enrollment Info.
OTA_CERT_CAT_INCLUSIONS_DFV OTA_CERT_CAT_INCLUSIONS Add’l Certification Category Inclusion Info
OTA_TEST_SECTIONS_DFV OTA_TEST_SECTIONS Add’l Test Sections Information
OTA_LEARNING_OBJECTS_DFV OTA_LEARNING_OBJECTS Add’l Learning Object Information
OTA_NOTRNG_HISTORIES_DFV OTA_NOTRNG_HISTORIES Add’l Non OTA Training History Info.
OTA_TRAINING_PLAN_MEMBERS_DFV OTA_TRAINING_PLAN_MEMBERS Additional Plan Member Details
OTA_TRAINING_PLAN_COSTS1_DFV Training Plan Costs Developer Further Plan Cost Information
OTA_USER_GROUP_ELEMENTS_DFV OTA_USER_GROUP_ELEMENTS Additional Learner Group Elements Information
OTA_COMPETENCE_LANGUAGES_DFV OTA_COMPETENCE_LANGUAGES Add’l Competence Language info
OTA_TP_MEASUREMENT_TYPES_DFV OTA_TP_MEASUREMENT_TYPES Additional Plan Measure Details
OTA_TRAINING_PLANS_DFV OTA_TRAINING_PLANS Additional Plan Details
OTA_LP_ENROLLMENTS_DFV OTA_LP_ENROLLMENTS Add’l Learning Path Enrollment Info.
OTA_CERT_MBR_ENROLLMENTS_DFV OTA_CERT_MBR_ENROLLMENTS Add’l Certification Member Enrollment Info.
OTA_ANNOUNCEMENTS_DFV OTA_ANNOUNCEMENTS Add’l Announcements Info
OTA_OFFERINGS_DFV OTA_OFFERINGS Add’l Offering Information
OTA_LP_CAT_INCLUSIONS_DFV OTA_LP_CAT_INCLUSIONS Add’l Learning Path Category Inclusion Info
OTA_LEARNING_PATH_MEMBERS_DFV OTA_LEARNING_PATH_MEMBERS Add’l Learning Path Member Info.
OTA_QUESTION_BANKS_DFV OTA_QUESTION_BANKS Add’l Question Bank Information
OTA_LP_MEMBER_ENROLLMENTS_DFV OTA_LP_MEMBER_ENROLLMENTS Add’l Learning Path Member Enrollment Info.
OTA_CERT_PRD_ENROLLMENTS_DFV OTA_CERT_PRD_ENROLLMENTS Add’l Certification Period Enrollment Info.
OTA_LP_SECTIONS_DFV OTA_LP_SECTIONS Add’l LP Section Info.
OTA_CONFERENCES_DFV OTA_CONFERENCES Additional Conference Information
OTA_CERTIFICATIONS_B_DFV OTA_CERTIFICATIONS Add’l Learning Certification Information