Human Capital Management - EBS (MOSC)

MOSC Banner

How can we retrieve the PIW start date for a period of sickness absence for reporting purposes?

edited Nov 7, 2024 8:30PM in Human Capital Management - EBS (MOSC) 4 commentsAnswered

We 're using Oracle EBS 12.2 RUP18 and have been tasked with writing a report to return sickness absence data with statutory and company sick pay entitlements.

We must include the Period of Incapacity (PIW) start date for each absence with a duration of 4 days or more but cannot find the table and column name where it's being stored.

For linked absences we're using the LINKED_ABSENCE_ID to find the PIW start date.

For absences that aren't linked there isn't an equivalent ID. The column PERIOD_OF_INCAPACITY_ID is NULL in table PER_ABSENCE_ATTENDANCES.

We'd prefer not to have to calculate it in the report query.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center