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

Oracle Inventory Tables

mtl_system_items
mtl_item_revisions
mtl_item_categories
mtl_material_transactions
mtl_transaction_lots_numbers
mtl_serial_numbers
rcv_shipment_headers
rcv_shipment_lines
mtl_system_item_interface
mtl_item_revisions_interface
mtl_item_categories_interface
mtl_transaction_interface
mtl_transaction_lots_interface
mtl_serial_numbers_interface
rcv_headers_interface
rcv_transactions_interface

Order Management Setup Checklist

1 Define Set of Books
2 Define Flexfields
3 Multiple Organization
4 Inventory Organizations
5 Profile Options
6 Parameters
7 Invoicing
8 Salespersons
9 Tax
10 Quick Codes
11 Workflow
12 Document Sequence
13 Order Import Sources
14 Units of Measure
15 Item Information
16 Items
17 Configurations
18 Pricing Formulas
19 Price Lists
20 Customer Class
21 Customers
22 Item Cross-Reference
23 Sourcing
24 Agreements
25 Transaction Types
26 Cost of Goods Sold (COGS)
27 Modifier and Freight Charges
28 Processing Constraints
29 Defaulting Rules
30 Credit Checking
31 Holds
32 Attachments
33 Shipping Setup

*If the text appears mis-aligned in the mail sent on the group, please visit http://applearn.blogspot.com

Purchasing Setup Checklist

1 Define set of books
2 Define descriptive flexfields
3 Define organizations
4 Define cross-reference types
5 Define profile options
6 Define financials options
7 Define accounting flexfield combinations
8 Define tax names
9 Define payment terms
10 Open and close General Ledger (GL) accounting periods
11 Open purchasing and inventory accounting periods
12 Define locations
13 Define location associations
14 Define job flexfield
15 Define jobs
16 Define position flexfield
17 Define positions
18 Define position hierarchies
19 Enter employee
20 Define item categories flexfield
21 Define category
22 Define category sets
23 Define default category set
24 Define control rules and groups
25 Define position controls
26 Fill employee hierarchy
27 Define usernames
28 Define purchasing lookup codes
29 Define freight carriers
30 Define inspection codes
31 Define hazard classes
32 Define United Nations (UN) numbers
33 Define standard notes
34 Define unit of measure classes
35 Define units of measure
36 Define unit of measure conversions
37 Define system items flexfield
38 Define item attribute controls
39 Define item templates
40 Define item catalog flexfield
41 Define item catalog groups
42 Define buyers
43 Define item
44 Define item relationships
45 Define line types
46 Define document controls
47 Start autosubmit
48 Define purchasing options
49 Define receiving options
50 Enter vendors
51 Define your transactions reasons
52 Set up Oracle Workflow
53 Request your receiving transaction processor
54 Define your concurrent process resubmission interval