Transcript Errors on searching on lot numbers

Add Event or Presentation Title in Master Slide
Errors on searching on lot numbers
• After tabbing out of “start”
field
• Multiple instances of Duplicate
Lot Numbers appear
• Lot Numbers are out of
sequence
Your Imagination, Our Innovation
Add Event or Presentation Title in Master Slide
Your Imagination, Our Innovation
Continuing on with Search it fails to return any
lots with legitimate range
Page 2
Add Event or Presentation Title in Master Slide
Also fails with no range
Page 3
Your Imagination, Our Innovation
Add Event or Presentation Title in Master Slide
Your Imagination, Our Innovation
Observations
For the find feature to work properly
the lot numbers must be real (have inventory), but….
A. Not all inventory loaded in Oracle (or at least not visible in the NC
Flag Find)
• Based on the 102 lots with inventory in SAP in December 2014,
selected the min/max lot numbers from EAP% (Lots assembled by SPIL
in 2012)…
• Oracle finds 69 lots, It did not find 33 lots.. See next slide
B. Many false records
• For the EAP% search almost 300 false records
• All appear to be split lots off a small number of parent lots
• And the find screen doesn’t tell you whether you’re selecting a false
record
• If you pick a false record, the “FIND” won’t work
Page 4
Add Event or Presentation Title in Master Slide
Your Imagination, Our Innovation
• Lot matching in SAP and Oracle on “Find” window
SAP
Oracle
Found
Not Found
In Oracle, but not
SAP
EAP0x
2
2
0
69 – all split lots
EAP1x
31
30
1
~200 – all split lots
EAP2x
56
25
31
19 – all split lots off of
EAP2089xx & EAP2087xx
Page 5
EAP3x
9*
7
2
0
EAP4x
3
3
0
0
EAP5x
3
3
0
0