My Oracle Support Banner

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

Last updated on AUGUST 17, 2023

Applies to:

Oracle Fusion Absence Management Cloud Service - Version 11.13.20.04.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

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