Fusion Absence Management: No Data Returned in Global Absence Accrual Event Formula that Uses PER_HIST_ASG_EFFECTIVE_START_DATE Dbi
Last updated on JULY 20, 2017
Applies to:Oracle Fusion Absence Management Cloud Service - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
As recommended in the Oracle absence white paper we have configured a Global Absence Accrual Event formula that identifies changes in assignments through using the array DBI PER_HIST_ASG_EFFECTIVE_START_DATE. The issue is that this DBI uses a secure view on the assignments table (PER_ASSIGNMENT_SECURED_LIST_V), and some employees are not being retrieved via this secure view.
What security needs to be setup so that all employees can be seen through the DBI PER_HIST_ASG_EFFECTIVE_START_DATE?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms