Session ID:

Prepared by:

Remember to complete your evaluation for this session within the app!

103010

Maximizing Oracle

Payroll in the Cloud

A Case Study on Developing a

PaaS Extension for HCM Cloud

April 9th, 2019

Chirag Hingrajia

Solution Architect

Grant Thornton

About Grant Thornton

Grant Thornton

Office locations

Reach

Our services

59 offices spread across 30 states and Washington D.C.

Serve 36% of companies on the 2017

Fortune 500 list and 25% of companies

on the Russell 2000 list

• Assurance • Tax • Advisory

More than 8,500 professionals in the U.S.

594 partners serving more than 8,000 clients in the nation

RevenueGT U.S. net revenue equals $1.74 billion

Grant Thornton – a global firm

• Grant Thornton International Ltd is represented through member firms in 704

offices, and 50,000 personnel throughout the world

59U.S. offices

8,340people, including 615 partners

$1.75bnin revenue (5% growth over prior year)

Our Oracle Practice

5

Find your silver lining

gt.com/silverlining

Our session today

• A major trucking company with a large number of contingent workers, recently

implemented a multi-pillar Oracle Cloud solution which included HCM, Payroll,

ERP, OTM and others. Constrained by the limited ability to process contingent

worker payroll in Oracle Cloud Applications, the client leveraged PaaS to

design a solution that meets their needs. This session will highlight how the

solution was developed using Oracle DBCS and Apex which integrates with

HCM and ADP two-ways to process gross earnings for their contingent fleet

owners' settlement payments

Chirag HingrajiaSolution Architect

Special Thanks :

Bill Stratton, Payroll Genius

Brian Leong, Payroll Genius in making

Nitish Kumar, Technical Expert

Roopa MK, Technical Expert

Agenda

Pay calculation for contingent workers in Oracle HCM Cloud — Out-of-the-box

Requirements

Design Decisions

Overall Design

Integration touchpoints

Challenges

Q & A

Pay calculation for contingent workers in Oracle HCM

Cloud — Out-of-the-box

• Contingent Worker type is excluded from payroll processing in Oracle Payroll.

• Element entries can be created for Contingent workers but they can't be

processed in a payroll run

• Global Payroll interface picks up only employees.

• Third Party payroll processing can be imported to Payroll Interface Inbound

Records EIT

Requirements

• Since HCM is record keeping system, data should be sent from HCM

• The custom solution called Settlement Program should not hold any data. Data

will be flushed after one or two payroll runs to make sure the base data gets

populated from HCM always.

• Separate set of Elements should be maintained for Employees and Contingent

Workers.

• There should be minimal intervention from users to run payroll on custom

solution

Requirements

• Calculation rules will be defined at one place which is Cloud HCM and they

need to flow to the custom solution

• Deduction data should be imported from ADP and Pay Statement should be

generated using different sources of information

• Contingent worker pay statement should look like standard HCM Cloud Pay

Slip

• Pay Statement for contingent worker should be loaded as Documents of

Record (DoR) in person profile

• Why Oracle Apex?

– Tightly integrated product with Oracle Ecosystem

– Fast development and deployment

– Client has DBCS and Apex doesn’t need any additional license for development or

deployment.

• Maintain calculation rules in sync between HCM Cloud and Apex

– User Defined Tables (UDT) in HCM

– PBL or HDL can be used to populate UDT

Design Decisions

• Keep the data in sync between HCM Cloud, ADP and Apex.

– One way interface from HCM to Settlement Program

– Strictly no edits in Settlement Program.

• How to keep the security in sync between HCM and Apex?

• Where to generate Contingent Worker Driver payment statement?

– Generate the statement in HCM

– Use Payroll Interface Inbound Records EIT to import deductions to HCM

– Use Element Entries to import earnings to HCM

Design Decisions

Overall Design

Integration touchpoints

• HCM to Settlement Application– Demographics

– Contingent Worker Driver Events

– Rates and Schedules for Pay Calculation Rules

• HCM to ADP– Contingent Worker Driver Demographics

– Contingent Worker Driver Payment Method(s)

– Contingent Worker Driver Earnings

• ADP to Settlement Application to HCM– Deductions

– Payment Information

– Balances

• Settlement Application to HCM– Contingent Worker Driver Earnings & Deductions

– Contingent Worker Driver Pay Statement

Challenges

• How to make an HCM Extract to generate a file in a particular folder in UCM?

Solution : Use the bursting to generate the report in UCM folder, Move files to

Exadata using SOA & MFT

• Generation of Contingent Worker Driver Payment Statement

– XSLT Template is too complex to build and maintain

– APEX BI Server needs additional license to create RTF Template

Solution : Custom BI Report in HCM after importing deduction data in to Payroll

Interface Inbound Records EIT.

Challenges

• Single Sign On

Challenges

• Common issues with Web Service calls and Apex Configuration

– Long running process (> 6 Seconds) locked the database objects

Solution : We are scheduling these long running processes as background jobs.

– Object Corruption

Solution : PGA limit increased

– Web Service calls to REST API are not working

Solution : Oracle Wallet configured with appropriate certificates. The wallet has to be configured with a password. It doesn’t

work if password is not set.

– Number of Web Service calls per day

Solution : Updated the Apex configuration parameter which increased the limit for number of web service calls per day

• Business approach for Contingent Worker Driver Demographic and Payment Method information to ADP

References

• MoS Note - HCM Data Loader: Loading Payroll Interface Inbound Records

(Doc ID 2141697.1)

• REST API Documentation - https://docs.oracle.com/cd/E56351_01/index.htm

• REST API Downloads -

https://www.oracle.com/database/technologies/appdev/rest.html

• APEX Configuration - https://docs.oracle.com/database/apex-

18.1/HTMIG/configuring-embedded-PL-SQL-gateway.htm#HTMIG29203

• SSL wallet does not work after DB Upgrade To 12c (Doc ID 2229851.1)

• https://blogs.oracle.com/apex/apex-https-certificates-and-the-oracle-wallet

Don't miss these insightful sessions

9:15–10:15 a.m.

Monday

ORC strategies for Taleo

Ken Fontenot, Grant Thornton

CC 3rd FL 303A

*Global transformation cloud deployment of HCM, ERP and

more: GP Strategies case study

Dan Mills, Grant Thornton and Sonia Ardeel, GP Strategies

CC 3rd FL 302B

10:30–11:30 a.m.

Tuesday

10:30–11:30 a.m. Maximizing Oracle Payroll in the cloud—a case study on

developing a PaaS extension for HCM CloudChirag Hingrajia, Grant Thornton

CC 3rd FL 303B

12:45–1:45 p.m. You’ve upgraded to JDE 9.1; now what?

Mohammad Shujaat, Grant Thornton

GH 2nd FL Lonestar Salon E

Textile provider with unique E1 9.2 upgrade project from

both JDE World A7.2 & E1 9.0Craig Davied, Grant Thornton

GH 3rd Fl Travis B

*Implementing Oracle Cloud Revenue Management at Valet

Living—the good, the bad, the ugly

Mike Coburn, Grant Thornton and David Boyer, Valet Living

CC 3rd FL 301B

2–3 p.m.

4:30–5:30 p.m.

Wednesday

8–9 a.m. Connecting the empire—a case study of ERP Cloud integration

automation at Caesars EntertainmentLee Huff, Grant Thornton

CC 3rd FL 302C

*Caesars Entertainment’s successful transformation to financial

reporting on Oracle Cloud ERP

Prasanna Ramakrishnan, Grant Thornton

CC 3rd FL 302C

12:45–1:45 p.m.

Leadership & management in projects—two sides of the same coin

David Fuston, Grant Thornton

CC 3rd FL 302B

12:45–1:45 p.m.

Order management/advanced pricing SIG panel discussion: Journey

to the cloudBobby Smith, Grant Thornton

CC 2nd FL 225D

2–3 p.m.

Thursday

*Tax Reporting: Impact of the US tax reform

Julien Coudrette, Grant Thornton

CC 2nd FL 217C

Enhancing business processes with Procurement Cloud document

approvalsBobby Smith Grant Thornton

CC 2nd FL 225D

8–9 a.m.

9:15–10:15 a.m.

*CPE credit offered

Helping customers plan, deploy and optimize

Oracle technology solutions

• The real story: customer stories about victories and pain points along their Oracle journeys

• Career-changing connections: guidance and support from a community of users withshared interests

• Wealth of resources: entire catalog of webinars, blogs, customer stories, community surveys, whitepapers and more

• Virtual and face-to-face events: connect and learn from peers, Oracle teams and thought leaders on global, regional and local scale

• Membership benefits: questoraclecommunity.org/membership

Visit Quest Oracle Community at booth #243

Session ID:

Remember to complete your evaluation for this session within the app!

103010

Q & A

chirag.Hingrajia@us.gt.com