Oracle Quality - An Introduction

Oracle Quality application can be used to gather user-defined quality data. It is integrated with the Oracle Manufacturing and Distribution applications. Data collected and input into Oracle Quality may come from functions such as purchasing, service, shopfloor inspection or directly from the customer, to name a few. Quality data can also be collected in a totally standalone method or may be linked to third party systems.

The data collection structure in Oracle Quality comprises of:
a) Collection Elements
b) Specifications
c) Collection Plans

The basic building block of this structure is the collection element, which is used in both the specification and the collection plan. Collection elements define the characteristics or the quality parameters of the product or the process, which is being analyzed and for which we collect and report data. Collection Plans are similar to test or inspection plans. Collection plans specify which are the collection elements to be used in collecting data. Collection plans specify when
and how to collect the data as well as the actions to take based on the data collected. Specifications set the quality standards to which the product or the process should conform. These standards can be in the form of absolute values or a specific range within which the results would be acceptable. The type of collection elements being used determines the nature of the specification.

Industry professionals already working in Quality functions (Quality Assurance, Quality Control) might find this interesting to know more?

Oracle Work in Process (WIP) Tables

wip_move_transactions
wip_discrete_jobs
wip_repetitive_schedules
wip_move_txn_interface
wip_cost_txn_interface
wip_job_shedule_interface
wip_job_dtls_interface

Oracle Bills of Material (BOM) Tables

bom_bill_of_materials
bom_inventory_components
bom_reference_designators
bom_substitute_components
mtl_item_revisions
bom_operational_routings
bom_operation_sequences
bom_operation_resources
BOM_BILL_OF_MTLS_INTERFACE
BOM_INVENTORY_COMPS_INTERFACE
BOM_REF_DESGS_INTERFACE
BOM_SUB_COMPS_INTERFACE
MTL_ITEM_REVISIONS_INTERFACE
BOM_OP_ROUTINGS_INTERFACE
BOM_OP_SEQUENCES_INTERFACE
BOM_OP_RESOURCES_INTERFACE
MTL_RTG_ITEM_REVS_INTERFACE

Oracle Order Management Tables

oe_order_headers_all
oe_lines_all
oe_lot_serial_numbers
oe_sales_credits
oe_price_adjustments
oe_headers_iface_all
oe_lines_iface_all
oe_lotserials_iface_all
oe_credits_iface_all
oe_actions_iface_all
oe_price_adjs_iface_all
oe_reservtns_iface_all

Oracle Purchasing Tables

po_requisition_headers_all
po_requisition_lines_all
po_req_distributions_all
po_headers_all
po_lines_all
po_distributions_all
rcv_transactions
po_requisitions_interface_all
po_reschedule_interface
po_headers_interface
po_lines_interface
po_distributions_interface