Search Results create bank




The OTA_QUESTION_BANKS table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical component of the Oracle Learning Management (OLM) module, which facilitates the creation, management, and administration of training and certification programs. This table serves as a repository for storing metadata related to question banks, which are collections of questions used in assessments, quizzes, and exams. Below is a detailed analysis of its structure, functionality, and integration within Oracle EBS.

1. Table Overview

The OTA_QUESTION_BANKS table stores essential information about question banks, including their names, descriptions, categories, and ownership details. It acts as a parent table for related entities such as questions (OTA_QUESTIONS), answers (OTA_ANSWERS), and assessments (OTA_ASSESSMENTS). Key columns in this table include:
  • QUESTION_BANK_ID: Primary key, uniquely identifying each question bank.
  • NAME: The display name of the question bank.
  • DESCRIPTION: A detailed description of the question bank's purpose or content.
  • CATEGORY_CODE: Categorizes the question bank (e.g., technical, compliance, soft skills).
  • OWNER_ID: References the user or role responsible for maintaining the question bank.
  • START_DATE_ACTIVE and END_DATE_ACTIVE: Define the validity period of the question bank.
  • ENABLED_FLAG: Indicates whether the question bank is active for use.

2. Functional Role in Oracle Learning Management

Question banks are foundational to OLM's assessment capabilities. They enable:
  • Assessment Creation: Instructors or admins can select questions from one or more banks to build exams or quizzes.
  • Reusability: Questions can be reused across multiple assessments, reducing redundancy.
  • Version Control: The table supports versioning through date-active columns, allowing updates without losing historical data.
  • Access Control: Ownership and category columns help restrict access based on roles or departments.

3. Integration with Other Modules

The OTA_QUESTION_BANKS table integrates with several EBS modules:
  • OTA_QUESTIONS: A child table storing individual questions linked via QUESTION_BANK_ID.
  • OTA_ASSESSMENTS: Assessments reference question banks to pull questions dynamically or statically.
  • HRMS: Ownership (OWNER_ID) may link to PER_ALL_PEOPLE_F for user details.
  • FND_LOOKUP_VALUES: Categories (CATEGORY_CODE) often reference lookup values for standardization.

4. Technical Considerations

  • Indexing: The primary key (QUESTION_BANK_ID) is indexed, but additional indexes on CATEGORY_CODE or OWNER_ID may improve query performance.
  • Data Security: Row-level security (RLS) or VPD (Virtual Private Database) policies may restrict access based on user roles.
  • Custom Extensions: Organizations often extend this table with custom columns (e.g., ATTRIBUTE1-15) to capture additional metadata.

5. Common Use Cases

  • Certification Programs: Question banks store exam questions for certifications like Oracle or compliance training.
  • Pre/Post-Training Assessments: Used to evaluate learner knowledge before and after courses.
  • Randomized Tests: Banks enable random question selection to prevent cheating.

6. Limitations and Best Practices

  • Performance: Large question banks may require partitioning or archiving strategies.
  • Data Integrity: Foreign key constraints ensure questions cannot exist without a parent bank.
  • Audit Trails: Consider triggers or Oracle Audit Vault to track changes.
In summary, the OTA_QUESTION_BANKS table is a cornerstone of Oracle Learning Management, enabling scalable, secure, and reusable assessment frameworks. Its design supports complex training workflows while maintaining integration with core EBS functionalities.

  • Lookup Type: OTA_TESTBANK_SELECTION 12.2.2

    product: OTA - Learning Management ,  meaning: Create/Select question bank ,  description: Create/Select question bank , 

  • Lookup Type: OTA_TESTBANK_SELECTION 12.1.1

    product: OTA - Learning Management ,  meaning: Create/Select question bank ,  description: Create/Select question bank , 

  • Table: OTA_QUESTION_BANKS 12.1.1

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_QUESTION_BANKS,  object_name:OTA_QUESTION_BANKS,  status:VALID,  product: OTA - Learning Management ,  description: This table acts as a container for the questions so they can be grouped appropriately. A Question Bank can contain one of more questions. Presently we support at 1:N relation between OTA_QUESTION_BANKS and OTA_QUESTIONS but the design is in ,  implementation_dba_data: OTA.OTA_QUESTION_BANKS , 

  • Table: OTA_QUESTION_BANKS 12.2.2

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_QUESTION_BANKS,  object_name:OTA_QUESTION_BANKS,  status:VALID,  product: OTA - Learning Management ,  description: This table acts as a container for the questions so they can be grouped appropriately. A Question Bank can contain one of more questions. Presently we support at 1:N relation between OTA_QUESTION_BANKS and OTA_QUESTIONS but the design is in ,  implementation_dba_data: OTA.OTA_QUESTION_BANKS , 

  • Table: OTA_SECTION_RULES 12.1.1

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_SECTION_RULES,  object_name:OTA_SECTION_RULES,  status:VALID,  product: OTA - Learning Management ,  description: This table is used to hold the Question Bank Information and the number of questions that should be pulled to generate the test when a user attempts a test. This is only used when the OTA_TEST.TYPE_FLAG is set to D(Rule Based or Dynamic) ,  implementation_dba_data: OTA.OTA_SECTION_RULES , 

  • Table: OTA_SECTION_RULES 12.2.2

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_SECTION_RULES,  object_name:OTA_SECTION_RULES,  status:VALID,  product: OTA - Learning Management ,  description: This table is used to hold the Question Bank Information and the number of questions that should be pulled to generate the test when a user attempts a test. This is only used when the OTA_TEST.TYPE_FLAG is set to D(Rule Based or Dynamic) ,  implementation_dba_data: OTA.OTA_SECTION_RULES , 

  • Lookup Type: OTA_OBJECT_TYPE 12.1.1

    product: OTA - Learning Management ,  meaning: Object types in OTA ,  description: Lookup used to set page titles in Learning Management , 

  • Lookup Type: OTA_OBJECT_TYPE 12.2.2

    product: OTA - Learning Management ,  meaning: Object types in OTA ,  description: Lookup used to set page titles in Learning Management , 

  • Concurrent Program: OTATRANS 12.1.1

    execution_filename: OTATRANS.GL_TRANSFER ,  product: OTA - Learning Management ,  user_name: OTATRANS.GL_TRANSFER ,  description: Create Cross Charging GL Lines Transfer ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: OTATRANS 12.2.2

    execution_filename: OTATRANS.GL_TRANSFER ,  product: OTA - Learning Management ,  user_name: OTATRANS.GL_TRANSFER ,  description: Create Cross Charging GL Lines Transfer ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: OTMANDATORYENR 12.2.2

    execution_filename: ota_mandatory_enroll_util.process_mandatory_event_assoc ,  product: OTA - Learning Management ,  user_name: OTMANDATORYENR ,  description: Mandatory Enrollment Program ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: OTMANDATORYENR 12.1.1

    execution_filename: ota_mandatory_enroll_util.process_mandatory_event_assoc ,  product: OTA - Learning Management ,  user_name: OTMANDATORYENR ,  description: Mandatory Enrollment Program ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: OTAUTOCERTSUBSC 12.2.2

    execution_filename: ota_mandatory_enroll_util.process_automatic_cert_subscr ,  product: OTA - Learning Management ,  user_name: OTAUTOCERTSUBSC ,  description: Certification Automatic Subscription Program ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: OTA_RESOLVE_ELIG_PRF 12.2.2

    execution_filename: ota_elig_profile_util.resolve_eligibility_profile ,  product: OTA - Learning Management ,  user_name: OTA_RESOLVE_ELIG_PRF ,  description: Resolve Eligibility Profile for Learner Groups ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: OTA_RESOLVE_ELIG_PRF_MUL 12.2.2

    execution_filename: ota_elig_profile_util.resolve_elig_profile_multi ,  product: OTA - Learning Management ,  user_name: OTA_RESOLVE_ELIG_PRF_MUL ,  description: Process Eligibility Profile in Multi threaded Concurrent Program ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure ,