If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> Edition highlights:<br /> GDPR Special –<br /> Compliance and Personal<br /> Data<br /> Forms and APEX –<br /> Which Way?<br /> Improving NHS Patient<br /> Care with Big Data<br /> Ask TOM – Tips for<br /> Submitting Questions<br /> OracleScene<br /> #OracleScene Spring 18 | Issue 67<br /> A Customer Case Study<br /> www.ukoug.org<br /> An independent publication not<br /> affiliated with Oracle Corporation<br /> SPRING 18<br /> Welcome to Oracle Scene<br /> Oracle Scene Editorial Team<br /> Editor: Martin Widlake<br /> Email: editor@ukoug.org<br /> Deputy Editor (Apps): Khalil Rehman<br /> Deputy Editor (Apps): Toby Price<br /> Deputy Editor (Tech): Alan McClean<br /> Deputy Editor (Tech): Nicholas Shearer<br /> UKOUG Contact: Deanna Bates<br /> Email: deanna.bates@ukoug.org<br /> Sales: Kerry Stuart<br /> Email: kerry.stuart@ukoug.org<br /> UKOUG Governance<br /> A full listing of Board members, along with<br /> <a title="Oracle Scene Issue 67 page 1" href="http://viewer.zmags.com/publication/591003a3?page=1"> Edition highlights: GDPR Special – Compliance and</a> <a title="Oracle Scene Issue 67 page 2" href="http://viewer.zmags.com/publication/591003a3?page=2"> SPRING 18 Welcome to Oracle Scene Oracle S</a> <a title="Oracle Scene Issue 67 page 3" href="http://viewer.zmags.com/publication/591003a3?page=3"> First Word First word Spring arrives and the na</a> <a title="Oracle Scene Issue 67 page 4" href="http://viewer.zmags.com/publication/591003a3?page=4"> OracleScene SPRING 18 News & Reviews Nominations</a> <a title="Oracle Scene Issue 67 page 5" href="http://viewer.zmags.com/publication/591003a3?page=5"> News & Reviews Paul Fitton, President, UKOUG </a> <a title="Oracle Scene Issue 67 page 6" href="http://viewer.zmags.com/publication/591003a3?page=6"> OracleScene SPRING 18 Technology Why Test Cases </a> <a title="Oracle Scene Issue 67 page 7" href="http://viewer.zmags.com/publication/591003a3?page=7"> A short story about LONGs The LONG data type has </a> <a title="Oracle Scene Issue 67 page 8" href="http://viewer.zmags.com/publication/591003a3?page=8"> SPRING 18 Technology: Chris Saxon What makes a</a> <a title="Oracle Scene Issue 67 page 9" href="http://viewer.zmags.com/publication/591003a3?page=9"> Technology: Chris Saxon a link you can share wi</a> <a title="Oracle Scene Issue 67 page 10" href="http://viewer.zmags.com/publication/591003a3?page=10"> SPRING 18 OUG Ireland OracleScene OU The Gres</a> <a title="Oracle Scene Issue 67 page 11" href="http://viewer.zmags.com/publication/591003a3?page=11"> OUG Ireland LEFT: RON ATKINS RIGHT: JOHN CAULFIE</a> <a title="Oracle Scene Issue 67 page 12" href="http://viewer.zmags.com/publication/591003a3?page=12"> OracleScene SPRING 18 Technology Achieving</a> <a title="Oracle Scene Issue 67 page 13" href="http://viewer.zmags.com/publication/591003a3?page=13"> Our customer had data stored within three systems</a> <a title="Oracle Scene Issue 67 page 14" href="http://viewer.zmags.com/publication/591003a3?page=14"> SPRING 18 Technology: Robert S. Jackson As </a> <a title="Oracle Scene Issue 67 page 15" href="http://viewer.zmags.com/publication/591003a3?page=15"> Issues Initially our data set contained about 12,</a> <a title="Oracle Scene Issue 67 page 16" href="http://viewer.zmags.com/publication/591003a3?page=16"> OracleScene SPRING 18 Technology: Robert S. Jack</a> <a title="Oracle Scene Issue 67 page 17" href="http://viewer.zmags.com/publication/591003a3?page=17"> Technology Continuous Innovation in Oracle S</a> <a title="Oracle Scene Issue 67 page 18" href="http://viewer.zmags.com/publication/591003a3?page=18"> OracleScene SPRING 18 Technology: Darren J Moffa</a> <a title="Oracle Scene Issue 67 page 19" href="http://viewer.zmags.com/publication/591003a3?page=19"> Virtualization live updates/migration Being able </a> <a title="Oracle Scene Issue 67 page 20" href="http://viewer.zmags.com/publication/591003a3?page=20"> OracleScene SPRING 18 Cover Story T</a> <a title="Oracle Scene Issue 67 page 21" href="http://viewer.zmags.com/publication/591003a3?page=21"> Applications: Charlotte Wellington CUSTOMER STORY</a> <a title="Oracle Scene Issue 67 page 22" href="http://viewer.zmags.com/publication/591003a3?page=22"> SPRING 18 Applications: Charlotte Wellington </a> <a title="Oracle Scene Issue 67 page 23" href="http://viewer.zmags.com/publication/591003a3?page=23"> and, during requirements-gathering, a further 75 </a> <a title="Oracle Scene Issue 67 page 24" href="http://viewer.zmags.com/publication/591003a3?page=24"> SPRING 18 Applications: Charlotte Wellington </a> <a title="Oracle Scene Issue 67 page 25" href="http://viewer.zmags.com/publication/591003a3?page=25"> </a> <a title="Oracle Scene Issue 67 page 26" href="http://viewer.zmags.com/publication/591003a3?page=26"> OracleScene SPRING 18 Applications A</a> <a title="Oracle Scene Issue 67 page 27" href="http://viewer.zmags.com/publication/591003a3?page=27"> Applications: Milomir Vojvodic </a> <a title="Oracle Scene Issue 67 page 28" href="http://viewer.zmags.com/publication/591003a3?page=28"> SPRING 18 Applications: Milomir Vojvodic r</a> <a title="Oracle Scene Issue 67 page 29" href="http://viewer.zmags.com/publication/591003a3?page=29"> Applications: Milomir Vojvodic or it </a> <a title="Oracle Scene Issue 67 page 30" href="http://viewer.zmags.com/publication/591003a3?page=30"> SPRING 18 Applications: Milomir Vojvodic G</a> <a title="Oracle Scene Issue 67 page 31" href="http://viewer.zmags.com/publication/591003a3?page=31"> Applications GDPR is Coming How Can You </a> <a title="Oracle Scene Issue 67 page 32" href="http://viewer.zmags.com/publication/591003a3?page=32"> SPRING 18 Applications: Roland Bullivant Howev</a> <a title="Oracle Scene Issue 67 page 33" href="http://viewer.zmags.com/publication/591003a3?page=33"> FIGURE 1: PARTIAL VIEW OF A COMPLETE LIST OF JD E</a> <a title="Oracle Scene Issue 67 page 34" href="http://viewer.zmags.com/publication/591003a3?page=34"> OracleScene SPRING 18 Applications On the 5th </a> <a title="Oracle Scene Issue 67 page 35" href="http://viewer.zmags.com/publication/591003a3?page=35"> Applications: Abigail Giles-Haigh </a> <a title="Oracle Scene Issue 67 page 36" href="http://viewer.zmags.com/publication/591003a3?page=36"> OracleScene SPRING 18 Applications: Abigail Gile</a> <a title="Oracle Scene Issue 67 page 37" href="http://viewer.zmags.com/publication/591003a3?page=37"> The Missing Link Stuart Entwistle, HCM Project Ma</a> <a title="Oracle Scene Issue 67 page 38" href="http://viewer.zmags.com/publication/591003a3?page=38"> SPRING 18 Applications: Stuart Entwistle </a> <a title="Oracle Scene Issue 67 page 39" href="http://viewer.zmags.com/publication/591003a3?page=39"> Applications: Stuart Entwistle either solut</a> <a title="Oracle Scene Issue 67 page 40" href="http://viewer.zmags.com/publication/591003a3?page=40"> OracleScene SPRING 18 Technology Life After For</a> <a title="Oracle Scene Issue 67 page 41" href="http://viewer.zmags.com/publication/591003a3?page=41"> Technology: Alex Nuijten FIGURE 1 </a> <a title="Oracle Scene Issue 67 page 42" href="http://viewer.zmags.com/publication/591003a3?page=42"> SPRING 18 Technology: Alex Nuijten OracleScene </a> <a title="Oracle Scene Issue 67 page 43" href="http://viewer.zmags.com/publication/591003a3?page=43"> Technology: Alex Nuijten FIGURE 4 No tabl</a> <a title="Oracle Scene Issue 67 page 44" href="http://viewer.zmags.com/publication/591003a3?page=44"> OracleScene SPRING 18 Technology Stick = Oracle</a> <a title="Oracle Scene Issue 67 page 45" href="http://viewer.zmags.com/publication/591003a3?page=45"> Technology: Simon Greenwood Whilst Oracle For</a> <a title="Oracle Scene Issue 67 page 46" href="http://viewer.zmags.com/publication/591003a3?page=46"> SPRING 18 Technology: Simon Greenwood Stick = Ora</a> <a title="Oracle Scene Issue 67 page 47" href="http://viewer.zmags.com/publication/591003a3?page=47"> Technology: Simon Greenwood support costs (</a> <a title="Oracle Scene Issue 67 page 48" href="http://viewer.zmags.com/publication/591003a3?page=48"> OracleScene SPRING 18 Technology Securely G</a> <a title="Oracle Scene Issue 67 page 49" href="http://viewer.zmags.com/publication/591003a3?page=49"> Technology: Jay Mehta news is that DBA_USE</a> <a title="Oracle Scene Issue 67 page 50" href="http://viewer.zmags.com/publication/591003a3?page=50"> OracleScene SPRING 18 Technology: Jay Mehta </a> <a title="Oracle Scene Issue 67 page 51" href="http://viewer.zmags.com/publication/591003a3?page=51"> Technology When Company or Business Unit Row </a> <a title="Oracle Scene Issue 67 page 52" href="http://viewer.zmags.com/publication/591003a3?page=52"> OracleScene SPRING 18 Technology: Mary Kay Chris</a> <a title="Oracle Scene Issue 67 page 53" href="http://viewer.zmags.com/publication/591003a3?page=53"> Technology: Mary Kay Christophersen Role Tab</a> <a title="Oracle Scene Issue 67 page 54" href="http://viewer.zmags.com/publication/591003a3?page=54"> What made you want to enter the IT industry? Caro</a> <a title="Oracle Scene Issue 67 page 55" href="http://viewer.zmags.com/publication/591003a3?page=55"> Interview with Caroline Apsey and Lahini Sivagane</a> <a title="Oracle Scene Issue 67 page 56" href="http://viewer.zmags.com/publication/591003a3?page=56"> OracleScene SPRING 18 Interview with Caroline Ap</a> <a title="Oracle Scene Issue 67 page 57" href="http://viewer.zmags.com/publication/591003a3?page=57"> Ask Jonathan ASK JONATHAN ASK JONATHAN ASK JONATH</a> <a title="Oracle Scene Issue 67 page 58" href="http://viewer.zmags.com/publication/591003a3?page=58"> SPRING 18 Ask Jonathan Edition highlights: GDPR S</a> <a title="Oracle Scene Issue 67 page 59" href="http://viewer.zmags.com/publication/591003a3?page=59"> Ask Jonathan Improving NHS Patient Care with Bi</a> <a title="Oracle Scene Issue 67 page 60" href="http://viewer.zmags.com/publication/591003a3?page=60"> Push business in the right direction and maximise</a>