1 / 18

Extending the Power of JD Edwards (using RIAF, Reporting Tools and Web Development)

Extending the Power of JD Edwards (using RIAF, Reporting Tools and Web Development). December 2013 Doug Waram County of Wellington. Agenda. About the County of Wellington What’s RIAF? Why we built our Staff Directory Web App Check it out! (and, set it up in JDE) How we built it

nika
Download Presentation

Extending the Power of JD Edwards (using RIAF, Reporting Tools and Web Development)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Extending the Power of JD Edwards (using RIAF, Reporting Tools and Web Development) December 2013 Doug Waram County of Wellington

  2. Agenda • About the County of Wellington • What’s RIAF? • Why we built our Staff Directory Web App • Check it out! (and, set it up in JDE) • How we built it • What’s Next for us? • Questions

  3. County of Wellington • Located in Ontario, Canada about 1 hour west of Toronto • The County is made up of seven lower tier municipalities • 86,672 Residents (2011 Census) • 750 Employees • Budget of $176MM • Responsibilities include: • County Roads • Solid Waste – Waste Collection and Facility Management • Libraries and a Museum / Archives • A Long Term Care Home • Planning and Development Services • Green Legacy Programme

  4. JD Edwards at the County Add Ons • Time Entry System • CAM Time, Equipment and Inventory Entry System • Online Staff Directory • 60+ Crystal Reports outside JD Edwards EnterpriseOne • HR / Payroll • Finance – AR, AP, GL, Fixed Assets • Job Cost • Capital Asset Management (CAM) - a little • Upgraded from 8.12 to 9.1 on July 1st, 2013 • Currently using Tools Release 9.1.2.3

  5. What’s RIAF? • Related Integration Application Framework • Technology to integrate Websites into JDE Forms based on: • URL • Parameters • http://docs.oracle.com/cd/E24705_01/doc.91/e24198.pdf • Examples include: • Showing Google Map based on Address Fields • Showing Fedex Shipment Tracking info based on Tracking Number

  6. Why we built the Staff Directory • Needed online for our Website www.wellington.ca • Employee Contact Information in 3 Systems: • JD Edwards • InfoHR (our HRIS system) • MS Active Directory • Conflicts, Errors and Duplicate Entry in Existing Systems • Too time consuming and expensive to build integrations

  7. Check it out! • Website Versionhttp://www.wellington.ca • Intranet Version http://thewell.wellington.ca • From JDE http://py910/

  8. Questions on the RIAF setup?

  9. Our Hiring Process • Employee Hire Process • An Offer is Accepted • Hiring Manager notifies IT to setup accounts and purchase new equipment • IT sets up the AD / Email Accounts • HR enters new employee into JDE and InfoHR after the employee starts • Therefore AD Accounts are created first 99% of the time, but JDE has the Master Record. • Not all employees have an AD account

  10. How we built it • JD Edwards is the Master List of Employees (as Payroll maintains it) • Easy to extract data if we have a Unique Identifier • JD Edwards and InfoHR both using same Employee Number • But, Active Directory did not have Unique ID with either of the other systems • Implemented 2 Scheduled SQL Tasks create the Unique Relationships between JDE and AD. • Created a 3rd SQL Task to update the Staff Directory on an hourly basis.

  11. SQL Task #1 - Nightly • Grabs all AD Users Accounts • If the AD Account Name matches the Employee Name in the JDE Payroll Record then • Create a user profile record (F0092.ULUSER) in JDE • UserID in JDE is setup with the same format as our AD standard (for the Unique Identifier). • Notifies the JDE Administrator

  12. SQL Task #2 - Weekly • Grabs all AD Users Accounts (not already in JDE) • If the AD User Account does exist in the JDE User Profile table then • Notify the Administrator • These are manually inserted (ie. Mike vs Michael)

  13. SQL Task #3 - Hourly • Pulls all Employee Details into a table based on those unique links between JD Edwards, InfoHR and Active Directory JD Edwards • Employee ID, Employee Name, Job Title, Supervisor InfoHR • Department, Division, Office Location, Photo Active Directory • Telephone #, Cell #, Email Address

  14. Questions on the Staff Directory?

  15. What’s Next for Us? • Integrate More Data to JD Edwards: • Reports created by our End Users • Existing IT Created Reports • Document Management • Mapping Assets via our GIS System • Information from other transactional systems • Next great feature is CafeOne (Composite Application Framework for Enterprise One - available in Tools 9.1.3) • http://www.youtube.com/watch?v=Uu8IWzfw7Ho • Great session on this yesterday (Session #101950), download the slides

  16. April 7-11, 2014 The Venetian and Sands Expo Center Las Vegas, Nevada QuestDirect.org/COLLABORATE Attend COLLABORATE 14 to hear high-level, strategic education for the JD Edwards audience. Register through Quest to receive exclusive JD Edwards updates, materials and networking events. Registration OPEN! Early Bird rates end February 12, 2014.

  17. Questions • Thank you for Attending… • Please fill out the evaluation! Doug Waram Supervisor, Application Services County of Wellington dougw@wellington.ca 519.837.2600 x2888

More Related