Special Actions

There are certain action in HRMS which can make the Inactive rows in the Job data active. Identification of these Actions will be helpful while development phase. Below is the query to identify those actions.

 

SELECT

A.ACTION

, A.ACTION_DESCR

FROM

PS_ACTION_TBL A

, PS_ACTION_STAT_TBL B

WHERE A.ACTION=B.ACTION

AND A.EFF_STATUS='A'

AND A.EFFDT= (SELECT
MAX (C.EFFDT)

FROM PS_ACTION_TBL C
WHERE A.ACTION=C.ACTION)

AND B.HR_STATUS_VALID='I'

The setting is done under
Setup HRMS
 Product related
Workforce Administration
 Actions

Here under the Organizational Relationship scroll, there is field
'Valid if Previous HR Status is: '. Providing Inactive will make
the action capable of
changing the inactive HR status active