Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
PER_HIST_ASG_ASSIGNMENT_ID DBI doesn't return value for an employee with future termination date
Summary:
We are using PER_HIST_ASG_ASSIGNMENT_ID dbi in our formula to get a list of all assignments and their salaries. The formula works fine for an active employee with no future termination date. But fails to enter the loop if the person has a future termination date. We tried using the PER_EXT_HIST_ASG_ASSIGNMENT_ID with no success.
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):
Tagged:
0