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 with Redwood for Oracle Cloud HCM   Begin Now

what is the table name to find the Current Plan Term period of the Absence Plan

Received Response
22
Views
2
Comments
edited Feb 5, 2024 7:37AM in Workforce Management 2 comments

Summary:

Hi,


I'd like to know the table name for locating the current term of the absence plan. The table where you can identify the start month of the plan is ANC_ABSENCE_PLANS_F. This works well for absence plans with the term type 'Calendar Year'.

However, it becomes challenging when dealing with absence plans of the 'Anniversary Year' type, as workers may have different anniversary dates, such as 6/12/XXXX for one worker and 5/8/XXXX for another.

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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