BIP report for worker time entry profile — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

BIP report for worker time entry profile

Hello,

I am trying to draft a query to fetch time entry profile for all employee.

But the below query seems to be fetching incomplete results.

Can you please suggest some changes that can be made

SELECT
PPNF.DISPLAY_NAME AS EMPLOYEE_NAME,
PU.USERNAME AS UserName,
CASE
WHEN PU.ACTIVE_FLAG = 'Y' AND PU.SUSPENDED = 'N' THEN 'ACTIVE'
WHEN PU.ACTIVE_FLAG = 'Y' AND PU.SUSPENDED = 'Y' THEN 'INACTIVE'
WHEN PU.ACTIVE_FLAG = 'N' AND PU.SUSPENDED = 'Y' THEN 'INACTIVE'
WHEN PU.ACTIVE_FLAG = 'N' AND PU.SUSPENDED = 'N' THEN 'INACTIVE'
ELSE 'INACTIVE'
END AS USER_ACCOUNT_STATUS,
HGT.GROUP_NAME AS HCM_GROUP_NAME,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!