Marsh06usn
Member
I am unclear on how to make a list of valid entries pass / fail. For example, a test such as color could have blue, orange, red, yellow, green but only red passes. Do I put 1 for red and then 2's for the rest of them? thanks!
E9.2 Quality how does the UDC description 2 work for alphanumeric tests
BOster
Legendary Poster
I think you are going to have to expand a little more on your question and explain what you are trying to accomplish. UDC validation simply looks to see if the selected value is a code in the list of codes for the UDC. If there is validation on description 2 for a given UDC that is most likely application specific so you will need to explicitly list the application and UDC you are working with.
Marsh06usn
Member
This is standard JDE P3701. The UDC is arbitrary - its a list of alphanumeric test results that are valid. Based on Oracle documents, https://docs.oracle.com/cd/E16582_01/doc.91/e15134/set_up_quality_mgmnt.htm#EOAQM257
the UDC is what tells the Test Results program P3711 to set the test as Pass or Fail. But how do you set up Description 2 to do this? The Oracle documentation is not clear.
the UDC is what tells the Test Results program P3711 to set the test as Pass or Fail. But how do you set up Description 2 to do this? The Oracle documentation is not clear.
DSauve
Legendary Poster
If you just want to set Description 2 for the UDC records, fastpath to UDC, find the record and enter the value (1 or 2...) in the Description 2 field.
Marsh06usn
Member
Sorry - what I meant was what do the numbers mean? How do I setup like in my scenario above in my original post: a test such as color could have blue, orange, red, yellow, green in the UDC for valid entries but we want only red to pass. Do I put 1 for red and then 2's for the rest of them? thanks!
EDITED NOTE: I finally figured it out!!! For example lets say I want Blue, Red and Orange to be the valid and passing test results for a test called Color. However, Brown, Yellow, Green are valid entries but failing results. The table should look like this:
| Codes | Description 1 | Description 2 |
| Blue | Blue | 1 |
| Orange | Orange | 2 |
| Red | Red | 3 |
| Brown | Brown | 4 |
| Yellow | Yellow | 5 |
| Green | Green | 6 |
Then in the Allowed Minimum (preferred minimum if you are using this in your processing options) you type in "Blue" and Allowed Maximum is "Red". The program now treats the description 2 as Allowed Min "1" and Allowed Max "3" so any codes that fall between these description 2's are valid and pass, (codes Blue, Orange, Red - 1,2,3) anything outside of this range are valid codes but fail (Brown, Yellow, Green - 4,5,6).
Last edited:
