Fraud detection in JDE using AI and orchestration

Okay, I’ve posted about it a number of times, but we all just need to admit it – orchestration is cool for JD Edwards.  Yeah, AIS was good, but it’s just got better and better.  This really is a challenge for us (the community that thrives on JD Edwards) to extend the use of JD Edwards beyond the traditional boundaries.  I’d like to challenge people to look outside of the square when they are solving business problems.   I’m going to step you through and really simple example of big gains from small investments using AI, Cloud and orchestration.

I do tend to talk a little more technical than most, unashamedly to be honest.  What I’m promoting in this post is to get the nitty gritty of web-hooks and API’s.  Understand that this is all really easy technology, easy to find and easy to implement.  Let’s say that you wanted a super simple solution that ripped the text of ANY attachment in JDE – no matter if it was a picture, PDF or anything.  You could then create a simple table in JDE and store the text in some sort of text search field (this can be implemented in so many ways, generally triggers over tables  etc etc).  This table could index the text in EVERY attachment.  Therefore every scanned PO, WO, every PDF attachment, every special instruction, every hand written note that was a photo could be converted to the TEXT value and be made searchable.  WOW, that would be great. 

I can only imagine finding a vendors part number or special notes of a PO from a couple of years ago could really save your bacon at some stage.  Being able to search attachments to work orders for serial numbers would be amazing for so many clients.  What if I said that something like this could be cobbled together < 1 week?  Treating your ERP like a searchable DMS – wow!

What if you were to look at an amazing extension of this idea to prevent fraud (I have to thank a good contributor Matthew S for this extension).  What if I took a hash of the resulting text from the scan of every document and looked for duplicate invoices (or fraud).  What if I could search for duplicate anything (let’s not get right into locality sensitive hashing https://en.wikipedia.org/wiki/Locality-sensitive_hashing), but there are some really amazing things that you could do.  This would be a complete bolt on solution that uses orchestration and some “APIs”.  We will talk about said API’s later.

Fusion5 have gone a long way to make this a reality.  We’ve created public facing API’s that are capable of many different interactions with a media object, for example:

• Custom AI algorithm to recognize particular objects that you have trained the algorithm with
• Character recognition algorithm that can turn something like this:

Into this  (My mind boggles that I can do such deep analysis of a photo like this.)

700N $99 TCOME E $45 $66 EACH 57 20% 20 PARTICIPATING BEER, PRE-MIX AND CIDER OFF 1 LITRE Vad Cruiser Captain Morgan Spiced Gold Rum, Smirnoff Red Vodka OR Canadian Club 700mi Whole team over? Covered. Baron Samedi Spiced Rum OR Jack Daniel's Old No 7 700ml HAHN Bombay Sapphire Gin 1 Litre 2 FOR BUY 2 OR MORE CASES OR 10 $28 CASE CASES OR 10 PACKS $41 CASE SA $10 EACH Coron "Extra SEST SERVED OVER VI Dew MAVE UP TO CASE DE PORTO ΚXXX XX GOLD GOLD CERVER MA BOURBON HAHN Heineken WHISKEY MIXED WITH PREMIUM CIDE MERCURY 4 LITRES PERON STRO AZZU Aceand hotely CERVECERIA MODELO, S.A MEXICO, D.F. PREMIUM Cola KOPPARBERI 'BUILT TO LAST 22. SIZ ITU TELS ASTUNDA perDry EST RUM 18 PREMIUM Scotch 700m De Bortoll Premium 4 Litre Casks Excludes fortified Apple IRON JACK 6.3% LARD CIDEI ORIGINAL XXXX Gold Bottles or Cans 24x375ml 24 PACK 6.9% ALC/VOL & COLA 190 mL 45% ALCNVOL HISP AUSTRALIAN LAGER EST 1911 HODART, TAS Heineken Premium Lager Bottles 24x330ml OR Coopers Premium Lager Bottles 24x355ml SUPER Peroni Nastro Azzurro Bottles 24x330ml 10 CANS 24 PACK SUPER SAVER S SUPER SAVER 10 CANS CANS SUPER SAVER SUPER SAVER EACH EACH SA EACH EACH EACH S BREW OOPERS HRB WERY TOOHEYS VODKA COOPERS PURE CI SAD BLONDE Um Low Carb Logo LOW CARU DRY VELVE ARK AL WOODSTOCK CRUISER BOURBON ORCHARD AND COLA THIEVES RASPBERRY Special - FACE GAMUN BOKLESS CARBOHYDRATES Houghton Classic Shingleback Red Knot AUS Twelve New Zealand Pinot Noir CLEAN CRISP TASTE APPLE CIDER Hardys HRB 2750 46% ALCANO Mumm Cordon Rouge Champagne NV 24 6.0 PACK 30 CANS IN-STORE @ your local BWS PICK UP Shop online. Collect instore. WITH YOUR GROCERIES @ woolworths.com.au/bws SIMPLY SHOP, SCAN AND SAVE with Woolworths Rewards at BWS rewards 17" We support the responsible service of alcohol. Available in SA from Wednesday 11 April until Tuesday 17 April 2018 unless sold out prior Savings are based on offers apply to the quantity advertised only. Limit rights reserved. Specials may not be available in all stores including Alice Springs. "Standard local call charges y by store. Wine is 750ml unless otherwise stated. At this great price no further discounts apply Casks not available in Adelaide City or Rundle Mall. See www.woolworthsrewards.com.au for terms and conditions Selected cases may not be available in all stores. WC110418/SA Page 35

• Standard object detection
• Landmark detection

We’ve embodied this in a simple to use GUI, to allow for interactive discovery (before plugging it in).

So all of these options can be plugged into ANY analysis in JD Edwards and scheduled using orchestration.  Extracting more value from the plain old photos.

In action:

My use case is is simply to find duplicate invoices, okay – this is going to be easy.

1. I create my custom table (F55DUPINV) and view combo in my “database of choice” that is going to hold the text retrieved out of any attachment.  Note that there is going to be smarts here, because the text will be long.
2. I create an orchestration that takes a parameter of MO data structure name and calls my API (webhook) via a connection.  This retrieves the text and then inserts this into a JDE form (or via a database connector if too big)
3. This orchestration will also hash the text to a unique value for quick uniqueness checks.
4. I can then have another scheduled orchestration that looks for new duplicates (or fuzzy logic like) and sends an email to the fraud officer of the instance, with a link to the actual transactions.

4 steps which can extract the text out of every attachment in JDE, compare them and automate the delivery of exceptions to your business rules.

I have not changed a single line of standard code, I’ve not contributed to my technical debt.  I’ve got actionable results from the implementation of a couple of nice orchestrations, some smart database features and some scheduling of orchestrations with notifications.

Although similar to a previous post, this shows real transactions and data going into JD Edwards in a different way.  I guess the perspective is more business focused.

Fusion5 are in the API & orchestration space.  If you’d like to trial some of this technology at your site – please do not hesitate to reach out.  We can get demo’s like this running in no time and allow you to harness the power of orchestrations at your organisation to extract real business value.  We can provide you a key to use our API’s and orchestrations that are ready to go.