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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

How to fetch the time period for fetching the salary details of the employees

edited Feb 6, 2025 4:59PM in Reporting and Analytics for HCM 3 comments

Summary: I am working on a query to fetch the period name as per the payroll name selected from the LOV as parameter to fetch the salary details of the employees . I am not able to fetch the period name from the PAY_TIME_PERIOD table . Can you please help me out with the logic on how to fetch the period name as MM-YY from PAY_TIME_PPERIOD .

For ex I need the period name as DEC-24 if the payroll run month is DECEMBER. Thanks.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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