Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Getting the P_DATE as a column — 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

Getting the P_DATE as a column

Received Response
26
Views
1
Comments
edited Apr 3, 2020 12:06PM in Reporting and Analytics for HCM 1 comment

Summary

Getting the prompted date to be the date in a column.

Content

Is there anyway of being able to get the P_DATE that you have set as a prompt to show in a column?

I would like to be able to get a column that shows the P_Date unless the effective start date of an employee is later than the prompted date.

E.g. I want to run a report from 01/12/2019, anybody that started before that date will have that date in said column but anybody that started after said date will have their start date in. I am using "Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Date Start" to get the employee's start date.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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