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 laterInformation 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 |