You are browsing the archive for QA.

Oracle Quality Overview

Oracle Quality is the most generic module that Oracle ever offered with a flexibility to configure anyway to meet your business requirements.


Collection Elements:
Collection elements are the attributes/variable (fields) that captures the information. Eg if you want to capture temperature, height during your inspection then you define them a collection elements. Oracle offers seeded collection elements that supports all major transactions, but you can define unlimited collection elements as you need them.

Collection Plans: Collection Plans are set of collection elements. If you want to capture different set of elements at receiving, shipping & manufacturing, then you define separate collections plans for each of your business process.

Specifications: Specifications are characteristics of items you produce or receive must conform.

Data collections: Once you setup collection elements, plans, specifications you can do data collection in any of your business process. Collected data can be analyzed against specifications and necessary disposition actions can be made.

21 CFR Part-11: Food and Drug Administration (FDA) issued Code of Federal Regulations (CFR) that computer softwares that are used for capturing data eletronically. Part-11 of CFR dictates the need to maintain electronic records (audit trail of every changes) and electronic signatures (online sinatures when certain changes happened). Oracle supports electronic records and electronic signatures (ERES) to meet Part-11 requirements.

Views in Oracle Quality Module

List of Views in Oracle Quality Module

QA_ACTION_LOG_V
QA_BIS_RESULTS_V
QA_CHAR_ACTION_OUTPUTS_V
QA_CHAR_ACTION_TRIGGERS_V
QA_CHAR_ACTIONS_V
QA_CHAR_VALUE_LOOKUPS_DFV
QA_CHAR_VALUE_LOOKUPS_V
QA_CHARS_DFV
QA_CHARS_V
QA_CRITERIA_HEADERS_V
QA_CRITERIA_V
QA_CRITERIA_V1
QA_CUSTOMERS_LOV_V
QA_DEVICE_DATA_VALUES_V
QA_ERES_INTEGRATION_PLANS_V
QA_ERES_PC_RESULTS_REL_V
QA_ERES_PLAN_CHAR_ACTIONS_V
QA_ERES_PLANS_V
QA_ERES_RCV_TRANS_INTERFACE_V
QA_ERES_SPECS_V
QA_ERES_WSH_DELIVERABLES_V
QA_ERES_WSH_NEW_DELIVERIES_V
QA_GLOBAL_RESULTS_V
QA_GRANTED_PRIVILEGES_V
QA_GROUP_V
QA_HZ_PARTY_RELATIONSHIPS_V
QA_IN_LISTS_V
QA_LOOKUPS
QA_MQA_COLLECTION_TRIGGERS_V
QA_PC_CRITERIA_COLUMNS_V
QA_PC_PLAN_COLUMNS_V
QA_PC_RESULT_COLUMNS_V
QA_PC_RESULTS_RELATIONSHIP_V
QA_PLAN_CHAR_ACTION_OUTPUTS_V
QA_PLAN_CHAR_ACTION_TRIGGERS_V
QA_PLAN_CHAR_ACTIONS_V
QA_PLAN_CHARS_DFV
QA_PLAN_CHARS_V
QA_PLAN_COLLECTION_TRIGGERS_V
QA_PLAN_TRANSACTIONS_V
QA_PLANS_DFV
QA_PLANS_V
QA_PLANS_VAL_V
QA_PO_NUMBERS_LOV_V
QA_RESULTS_FULL_V
QA_RESULTS_QWB_V
QA_RESULTS_V
QA_RESULTS_VAL_V
QA_SALES_ORDERS_LOV_V
QA_SAMPLING_PLANS_V
QA_SAMPLING_RCV_CRITERIA_V
QA_SAMPLING_RCV_CRITERIA_VAL_V
QA_SEQ_AUDIT_HISTORY_V
QA_SKIPLOT_PLAN_STATE_V
QA_SKIPLOT_PROCESS_PLANS_V
QA_SKIPLOT_PROCESSES_V
QA_SKIPLOT_RCV_CRITERIA_V
QA_SKIPLOT_RCV_CRITERIA_VAL_V
QA_SKIPLOT_RCV_RESULTS_V
QA_SKIPLOT_STATE_HISTORY_V
QA_SL_CRITERIA_ASSOCIATION_V
QA_SL_SP_RCV_CRITERIA_ALL_V
QA_SL_SP_RCV_CRITERIA_V
QA_SP_CRITERIA_ASSOCIATION_V
QA_SPEC_CHARS_DFV
QA_SPEC_CHARS_V
QA_SPEC_CHARS_VAL_V
QA_SPEC_ORG_ASSIGNMENTS_V
QA_SPEC_ORGS_V
QA_SPECS_DFV
QA_SPECS_V
QA_SPECS_VAL_V
QA_TXN_COLLECTION_TRIGGERS_V
QA_USER_GROUP_V
QABV_COLELMACTN
QABV_COLELMACTT
QABV_COLLECTION_ELEMENTS
QABV_COLLECTION_PLAN_ELEMENTS
QABV_COLLECTION_PLANS
QABV_COLPLNELAC
QABV_COLPLNTXN
QABV_COLPLNTXNT
QABV_PLNELMACTT
QABV_QUALITY_ACTION_TYPES
QABV_QUALITY_SPECIFICATIONS
QABV_QUALSPCELM
QAFV_COLELMACTN
QAFV_COLELMACTT
QAFV_COLLECTION_ELEMENTS
QAFV_COLLECTION_PLAN_ELEMENTS
QAFV_COLLECTION_PLANS
QAFV_COLPLNELAC
QAFV_COLPLNTXN
QAFV_COLPLNTXNT
QAFV_PLNELMACTT
QAFV_QUALITY_ACTION_TYPES
QAFV_QUALITY_SPECIFICATIONS
QAFV_QUALSPCELM