Human Capital Management - EBS (MOSC)

MOSC Banner

I need a query to show all the times an employee went from fulltime to parftime and vice versa.

in Human Capital Management - EBS (MOSC) 5 commentsAnswered

Oracle HRMS EBS version 12

Anyone have a query that would show all the times an employee went from fulltime to parttime and vice versa?

Example:

Emp 1234 went from FTP to PTP 25-feb-24.

Emp 1234 went from PTP to FTP 13-mar-23

Emp 1234 went from PTT to PTP 13-dec-22

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS HCM Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center