How to get the Assignment table based DBI to get the value in the absence Fast Formula (Doc ID 2804872.1)

Last updated on OCTOBER 03, 2021

Applies to:

Goal

 In a fast formula , if you are using a DBI and the DBI query is using a secured view (PER_ASSIGNMENT_SECURED_LIST_V) instead of normal table (PER_ALL_ASSIGNMENTS_M ) then the used DBI is not fetching any value when the FF is run,why?

Example:

DBI:

PER_EXT_ASG_BASIC_HIST_ASSIGNMENT_ID

Query of the DBI:

PER_ASSIGNMENT_SECURED_LIST_V asg,

pay_payroll_assignments ppa

where asg.assignment_id = ppa.hr_assignment_id(+)

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.