Discrete Quality Setup in Oracle Apps R12
The entire process of defining data collection components, collecting, reporting, and analyzing data is summarized by the following diagram:
Collection Elements
Collection elements are the basic building blocks of collection plans, which are the data structures that you use to collect Quality results. Before you can collect Quality data, you must first create a collection plan. You begin by creating collection elements, which define the characteristics of the product or process that you want to monitor, record, and analyze.
When you define collection elements, you are creating data fields that you can use in collection plans to collect quality results. Once you create a collection element, it becomes available as a selection on a list of values that you can choose from when you set up collection plans.
For example, you can define a collection element called Color that has the values red, yellow, and blue, then use it in a collection plan where you assign it all of these values and also assign it additional values, such as orange, and green.
Collection Element Types
Collection elements are categorized by type so that they can be sorted and grouped in database searches and on reports. You assign collection element types to collection elements when you define them. Thus, you must first set up collection element types before you create collection elements.
· Attributes- Used to stored characteristics of any object
· Variable- Used to numeric measurements
· Reference Information. There reference to common objects in Oracle Applications like PO, SO, WIP etc.
Collection Plan Types
For sorting, grouping, categorizing, and other informational purposes, you must assign a collection plan type to each collection plan that you create
Collection plans
Collection plans are the structure that you use for data collection. Collection plans are composed of collection elements (the fields that you set up for the data that you want to collect), their values and specifications, and any actions that you want to initiate in response to quality results. You can create a collection plan that you can use as the default when you directly enter, view, and update quality results
Before we can collect the data with Oracle Quality, one must define a collection plan. You begin by defining collection elements which define the characteristics of the product, process that you want to record monitor and analyze. The data entry can be validated by static values or SQL statement or creating specifications.
Case Study- Fruit (Apple) Selling Company
Company sells apples which are different kinds and has different properties.
Create collection element type – we’ll use existing element types
Create collection elements - which represent properties of a apple e.g. color, type, grade, size, Decay Present, cut present, Dehydration, External Color, Sampling Location etc.
Define Collection Elements Values- for example color can be red brown green, decay present yes no etc.
Create collection plan type
Define collection plan - Will use the above defined collection elements and set the excepted values.
Finally enter the results and update results
Step#1 Collection Element Type
Quality Vision Enterprises - Navigation: Setups/ Collection Element Type
We are not defining any new collection element type
Step#2 Defining Collection Element
Quality Vision Enterprises - Navigation: Setups/ Collection Element
1. External Color Green, External Color Red – The intention is operator will enter value form 1-10 to achieve this I have defined look up for storing the values
The same lookup I will be using under SQL validation
select a.lookup_code, a.meaning from fnd_lookup_values_vl a where a.lookup_type = 'QA_ORA_NUMBER_RANGE' order by to_number(a.lookup_code)
Note- the element type is the same we are using from step#1.
2. Decay Present - Using value as Yes or No. I can have values right here on the Values screen or I can define it under collection plan as well.
3. Grade - Using value as 1 or 2.
4. Size - Using value as 10,20,30,40,50.
Step#3 Defining Collection Plan Type
Quality Vision Enterprises - Navigation: Setups/ Collection Plan Type
Step#4 Defining Collection Plan
Quality Vision Enterprises - Navigation: Setups/ Collection Plans
Note the plan type earlier we defined we are using that here.
Values definition-
For example we are defining size as 10,20,30,40,50
So click on values of the size element, you can use as pop list.
Similarly for decay we can define as yes/no
And for grade its first and second
Save the work we are now ready to enter results
Step#5 Entering Quality Results
Quality Vision Enterprises - Navigation: Results/Entry/Enter Quality Results
Notice the fields are showing by the collection plan we are using. Also see the Green% field is showing the pop list and we made it mandatory as well. So the results screen is showing all the elements.
Step#5 Updating Quality Results
Quality Vision Enterprises - Navigation: Results/Entry/Update Quality Results
Under update Quality results you can update the values of previously recorded results by selecting the collection plan.
This explains the discrete quality setups.
Thanks,
Ajay