Search Results guide for building gantt charts




The QA_CONTROL_LIMITS table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the Quality Management (QM) module, designed to store and manage control limits for quality inspection plans. Control limits are statistical boundaries used to determine whether a process is in a state of control, ensuring product quality meets predefined standards. This table plays a pivotal role in quality assurance by enabling organizations to define, track, and enforce quality thresholds during manufacturing, procurement, and other operational processes.

Key Attributes of QA_CONTROL_LIMITS

The QA_CONTROL_LIMITS table contains several essential columns that define the parameters for quality inspections:
  • CONTROL_LIMIT_ID: A unique identifier for each control limit record, serving as the primary key.
  • PLAN_ID: References the inspection plan (QA_PLANS) to which the control limit applies.
  • CHARACTERISTIC_ID: Links to the quality characteristic (QA_CHARACTERISTICS) being measured (e.g., weight, dimensions).
  • UPPER_SPEC_LIMIT and LOWER_SPEC_LIMIT: Define the acceptable range for the characteristic.
  • UPPER_WARNING_LIMIT and LOWER_WARNING_LIMIT: Optional thresholds that trigger alerts before violating specifications.
  • TARGET_VALUE: The ideal value for the characteristic.
  • ENABLED_FLAG: Indicates whether the control limit is active.

Functional Role in Quality Management

The QA_CONTROL_LIMITS table supports the following functionalities:
  1. Inspection Execution: During quality inspections, collected data is validated against control limits to determine pass/fail status.
  2. Statistical Process Control (SPC): Facilitates real-time monitoring of production processes using control charts.
  3. Nonconformance Management: Triggers corrective actions when measurements exceed defined limits.
  4. Integration with Other Modules: Interfaces with Inventory, Purchasing, and Manufacturing to enforce quality checks at critical stages.

Technical Implementation

In Oracle EBS 12.1.1 and 12.2.2, the table is part of the QA schema and is accessed via:
  • APIs: QA_INSPECTION_PUB and QA_PLANS_PUB for programmatic control.
  • Forms: Quality Management screens (e.g., Inspection Plans form) for manual configuration.
  • Reports: Quality results and SPC reports leverage this table for analytics.

Customization and Extensions

Organizations often extend the table’s functionality by:
  • Adding custom columns via descriptive flexfields (DFFs).
  • Developing workflows to automate responses to limit violations.
  • Integrating with third-party statistical tools for advanced analysis.

Conclusion

The QA_CONTROL_LIMITS table is a cornerstone of Oracle EBS Quality Management, enabling systematic quality control across supply chains. Its integration with core modules and support for statistical methodologies ensures compliance with industry standards while providing actionable insights for continuous improvement. Proper configuration and utilization of this table are essential for maintaining product quality and operational efficiency in manufacturing and distribution environments.

  • Table: QA_CONTROL_LIMITS 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CONTROL_LIMITS,  object_name:QA_CONTROL_LIMITS,  status:VALID,  product: QA - Quality ,  description: Stores control limits for charts ,  implementation_dba_data: QA.QA_CONTROL_LIMITS , 

  • Table: QA_CONTROL_LIMITS 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CONTROL_LIMITS,  object_name:QA_CONTROL_LIMITS,  status:VALID,  product: QA - Quality ,  description: Stores control limits for charts ,  implementation_dba_data: QA.QA_CONTROL_LIMITS , 

  • Lookup Type: QA_SAMPLING_STD 12.1.1

    product: QA - Quality ,  meaning: Quality Sampling Standard ,  description: Quality Sampling Standard , 

  • Lookup Type: QA_SAMPLING_STD 12.2.2

    product: QA - Quality ,  meaning: Quality Sampling Standard ,  description: Quality Sampling Standard , 

  • Concurrent Program: QASDRLINK 12.1.1

    execution_filename: QA_DBLINK_PKG.WRAPPER ,  product: QA - Quality ,  user_name: QADBLINK ,  description: Wrapper to create DB Link for SDR ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: QASDRLINK 12.2.2

    execution_filename: QA_DBLINK_PKG.WRAPPER ,  product: QA - Quality ,  user_name: QADBLINK ,  description: Wrapper to create DB Link for SDR ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Lookup Type: COLLECTION_PLAN_TYPE 12.1.1

    product: QA - Quality ,  meaning: COLLECTION PLAN TYPE ,  description: Quality Collection Plan Type , 

  • Lookup Type: COLLECTION_PLAN_TYPE 12.2.2

    product: QA - Quality ,  meaning: COLLECTION PLAN TYPE ,  description: Quality Collection Plan Type , 

  • Table: QA_SEQ_AUDIT_HISTORY 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_SEQ_AUDIT_HISTORY,  object_name:QA_SEQ_AUDIT_HISTORY,  status:VALID,  product: QA - Quality ,  description: Audit table for sequences ,  implementation_dba_data: QA.QA_SEQ_AUDIT_HISTORY , 

  • Table: QA_CHART_CONTROL 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CHART_CONTROL,  object_name:QA_CHART_CONTROL,  status:VALID,  product: QA - Quality ,  description: Special charting table for control chart type. ,  implementation_dba_data: QA.QA_CHART_CONTROL , 

  • Table: QA_SEQ_AUDIT_HISTORY 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_SEQ_AUDIT_HISTORY,  object_name:QA_SEQ_AUDIT_HISTORY,  status:VALID,  product: QA - Quality ,  description: Audit table for sequences ,  implementation_dba_data: QA.QA_SEQ_AUDIT_HISTORY , 

  • Table: QA_CHART_CONTROL 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CHART_CONTROL,  object_name:QA_CHART_CONTROL,  status:VALID,  product: QA - Quality ,  description: Special charting table for control chart type. ,  implementation_dba_data: QA.QA_CHART_CONTROL , 

  • Table: QA_CHART_CONSTANTS 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CHART_CONSTANTS,  object_name:QA_CHART_CONSTANTS,  status:VALID,  product: QA - Quality ,  description: Stores different costants used for chart calculations ,  implementation_dba_data: QA.QA_CHART_CONSTANTS , 

  • Table: QA_CHART_CONSTANTS 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CHART_CONSTANTS,  object_name:QA_CHART_CONSTANTS,  status:VALID,  product: QA - Quality ,  description: Stores different costants used for chart calculations ,  implementation_dba_data: QA.QA_CHART_CONSTANTS , 

  • Table: QA_AHL_MR_DUMMY 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_AHL_MR_DUMMY,  object_name:QA_AHL_MR_DUMMY,  status:VALID,  product: QA - Quality ,  description: A dummy table to mirror ahl_mr_headers_b. Oracle Internal use only - reserved for future use. ,  implementation_dba_data: QA.QA_AHL_MR_DUMMY , 

  • Table: QA_AHL_MR_DUMMY 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_AHL_MR_DUMMY,  object_name:QA_AHL_MR_DUMMY,  status:VALID,  product: QA - Quality ,  description: A dummy table to mirror ahl_mr_headers_b. Oracle Internal use only - reserved for future use. ,  implementation_dba_data: QA.QA_AHL_MR_DUMMY , 

  • Table: QA_CSI_ITEM_INSTANCES_DUMMY 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CSI_ITEM_INSTANCES_DUMMY,  object_name:QA_CSI_ITEM_INSTANCES_DUMMY,  status:VALID,  product: QA - Quality ,  description: Dummy table that mirrors a subset of csi_item_instances. Oracle Internal use only - reserved for future use ,  implementation_dba_data: QA.QA_CSI_ITEM_INSTANCES_DUMMY , 

  • Table: QA_CSI_ITEM_INSTANCES_DUMMY 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CSI_ITEM_INSTANCES_DUMMY,  object_name:QA_CSI_ITEM_INSTANCES_DUMMY,  status:VALID,  product: QA - Quality ,  description: Dummy table that mirrors a subset of csi_item_instances. Oracle Internal use only - reserved for future use ,  implementation_dba_data: QA.QA_CSI_ITEM_INSTANCES_DUMMY , 

  • Table: QA_RESULTS_INTERFACE 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_RESULTS_INTERFACE,  object_name:QA_RESULTS_INTERFACE,  status:VALID,  product: QA - Quality ,  description: Quality Results Interface table for collection import ,  implementation_dba_data: QA.QA_RESULTS_INTERFACE , 

  • Table: QA_GRANTED_PRIVILEGES 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_GRANTED_PRIVILEGES,  object_name:QA_GRANTED_PRIVILEGES,  status:VALID,  product: QA - Quality ,  description: Granted privileges for data security project ,  implementation_dba_data: QA.QA_GRANTED_PRIVILEGES , 

  • Table: QA_RESULTS_INTERFACE 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_RESULTS_INTERFACE,  object_name:QA_RESULTS_INTERFACE,  status:VALID,  product: QA - Quality ,  description: Quality Results Interface table for collection import ,  implementation_dba_data: QA.QA_RESULTS_INTERFACE , 

  • Table: QA_ACTION_LOG 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_ACTION_LOG,  object_name:QA_ACTION_LOG,  status:VALID,  product: QA - Quality ,  description: Log table for actions ,  implementation_dba_data: QA.QA_ACTION_LOG , 

  • Table: QA_GRANTED_PRIVILEGES 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_GRANTED_PRIVILEGES,  object_name:QA_GRANTED_PRIVILEGES,  status:VALID,  product: QA - Quality ,  description: Granted privileges for data security project ,  implementation_dba_data: QA.QA_GRANTED_PRIVILEGES , 

  • Table: QA_ACTION_LOG 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_ACTION_LOG,  object_name:QA_ACTION_LOG,  status:VALID,  product: QA - Quality ,  description: Log table for actions ,  implementation_dba_data: QA.QA_ACTION_LOG , 

  • Concurrent Program: QLTPLTXR_XML 12.1.1

    product: QA - Quality ,  user_name: Collection Plan Transactions Report (XML) ,  description: Shows all transactions and triggers for a plan ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: QLTPLTXR_XML 12.2.2

    product: QA - Quality ,  user_name: Collection Plan Transactions Report (XML) ,  description: Shows all transactions and triggers for a plan ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Lookup Type: QA_ERES_SPEC_STATUS 12.1.1

    product: QA - Quality ,  meaning: SPEC STATUS CODES ,  description: Quality Specification Status , 

  • Table: QA_CHAR_VALUE_LOOKUPS 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CHAR_VALUE_LOOKUPS,  object_name:QA_CHAR_VALUE_LOOKUPS,  status:VALID,  product: QA - Quality ,  description: Stores set of permissible values for collection elements ,  implementation_dba_data: QA.QA_CHAR_VALUE_LOOKUPS , 

  • File: QA_Tables.html 12.1.1

    product: QA - Quality ,  size: 1.16 MBytes ,  file_type: HTML Report ,  description: QA_Tables.html is an html report that documents the table and view definitions for the QA product. , 

  • Table: QA_SKIPLOT_RCV_RESULTS 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_SKIPLOT_RCV_RESULTS,  object_name:QA_SKIPLOT_RCV_RESULTS,  status:VALID,  product: QA - Quality ,  description: Skip Lot Inspection Results for Receiving ,  implementation_dba_data: QA.QA_SKIPLOT_RCV_RESULTS , 

  • Table: QA_SKIPLOT_RCV_RESULTS 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_SKIPLOT_RCV_RESULTS,  object_name:QA_SKIPLOT_RCV_RESULTS,  status:VALID,  product: QA - Quality ,  description: Skip Lot Inspection Results for Receiving ,  implementation_dba_data: QA.QA_SKIPLOT_RCV_RESULTS , 

  • Table: QA_CRITERIA_HEADERS 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CRITERIA_HEADERS,  object_name:QA_CRITERIA_HEADERS,  status:VALID,  product: QA - Quality ,  description: Header table for Criterias ,  implementation_dba_data: QA.QA_CRITERIA_HEADERS , 

  • Lookup Type: QA_ERES_SPEC_STATUS 12.2.2

    product: QA - Quality ,  meaning: SPEC STATUS CODES ,  description: Quality Specification Status , 

  • View: QA_GROUP_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QA.QA_GROUP_V,  object_name:QA_GROUP_V,  status:VALID,  product: QA - Quality ,  description: TCA Groups for data security ,  implementation_dba_data: APPS.QA_GROUP_V , 

  • Table: QA_CHAR_VALUE_LOOKUPS 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CHAR_VALUE_LOOKUPS,  object_name:QA_CHAR_VALUE_LOOKUPS,  status:VALID,  product: QA - Quality ,  description: Stores set of permissible values for collection elements ,  implementation_dba_data: QA.QA_CHAR_VALUE_LOOKUPS , 

  • File: QA_Tables.html 12.2.2

    product: QA - Quality ,  size: 1.224 MBytes ,  file_type: HTML Report ,  description: QA_Tables.html is an html report that documents the table and view definitions for the QA product. , 

  • Table: QA_CRITERIA_HEADERS 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CRITERIA_HEADERS,  object_name:QA_CRITERIA_HEADERS,  status:VALID,  product: QA - Quality ,  description: Header table for Criterias ,  implementation_dba_data: QA.QA_CRITERIA_HEADERS , 

  • Table: QA_PLAN_COLLECTION_TRIGGERS 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_PLAN_COLLECTION_TRIGGERS,  object_name:QA_PLAN_COLLECTION_TRIGGERS,  status:VALID,  product: QA - Quality ,  description: Defines collection plan triggers for Quality Collection transactions ,  implementation_dba_data: QA.QA_PLAN_COLLECTION_TRIGGERS , 

  • Table: QA_CAR_TYPES 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CAR_TYPES,  object_name:QA_CAR_TYPES,  status:VALID,  product: QA - Quality ,  description: Intended to be used in future for corrective action functionality ,  implementation_dba_data: QA.QA_CAR_TYPES , 

  • Table: QA_TXN_COLLECTION_TRIGGERS 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_TXN_COLLECTION_TRIGGERS,  object_name:QA_TXN_COLLECTION_TRIGGERS,  status:VALID,  product: QA - Quality ,  description: Define information on applicability of a collection plan for a Quality Collection transaction ,  implementation_dba_data: QA.QA_TXN_COLLECTION_TRIGGERS , 

  • Table: QA_CAR_TYPES 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CAR_TYPES,  object_name:QA_CAR_TYPES,  status:VALID,  product: QA - Quality ,  description: Intended to be used in future for corrective action functionality ,  implementation_dba_data: QA.QA_CAR_TYPES , 

  • Table: QA_PLAN_COLLECTION_TRIGGERS 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_PLAN_COLLECTION_TRIGGERS,  object_name:QA_PLAN_COLLECTION_TRIGGERS,  status:VALID,  product: QA - Quality ,  description: Defines collection plan triggers for Quality Collection transactions ,  implementation_dba_data: QA.QA_PLAN_COLLECTION_TRIGGERS , 

  • Table: QA_TXN_COLLECTION_TRIGGERS 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_TXN_COLLECTION_TRIGGERS,  object_name:QA_TXN_COLLECTION_TRIGGERS,  status:VALID,  product: QA - Quality ,  description: Define information on applicability of a collection plan for a Quality Collection transaction ,  implementation_dba_data: QA.QA_TXN_COLLECTION_TRIGGERS , 

  • Table: QA_PC_CRITERIA 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_PC_CRITERIA,  object_name:QA_PC_CRITERIA,  status:VALID,  product: QA - Quality ,  description: This table stores criteria for the child plans to be applicable ,  implementation_dba_data: QA.QA_PC_CRITERIA , 

  • View: QA_GROUP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QA.QA_GROUP_V,  object_name:QA_GROUP_V,  status:VALID,  product: QA - Quality ,  description: TCA Groups for data security ,  implementation_dba_data: APPS.QA_GROUP_V , 

  • Table: QA_PC_CRITERIA 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_PC_CRITERIA,  object_name:QA_PC_CRITERIA,  status:VALID,  product: QA - Quality ,  description: This table stores criteria for the child plans to be applicable ,  implementation_dba_data: QA.QA_PC_CRITERIA , 

  • Table: QA_CRITERIA 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CRITERIA,  object_name:QA_CRITERIA,  status:VALID,  product: QA - Quality ,  description: Stores "show results where" criteria for chart, Quality Dynamic Reportwriter etc. ,  implementation_dba_data: QA.QA_CRITERIA , 

  • Table: QA_CRITERIA 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_CRITERIA,  object_name:QA_CRITERIA,  status:VALID,  product: QA - Quality ,  description: Stores "show results where" criteria for chart, Quality Dynamic Reportwriter etc. ,  implementation_dba_data: QA.QA_CRITERIA , 

  • Concurrent Program: QLTACTWB 12.1.1

    execution_filename: QLTACTWB.WRAPPER ,  product: QA - Quality ,  user_name: QLTACTWB ,  description: Wrapper for calling Quality Actions Concurrently ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Table: QA_SL_SP_RCV_CRITERIA 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_SL_SP_RCV_CRITERIA,  object_name:QA_SL_SP_RCV_CRITERIA,  status:VALID,  product: QA - Quality ,  description: Skip Lot/Sampling Criteria for Receiving ,  implementation_dba_data: QA.QA_SL_SP_RCV_CRITERIA ,