My Oracle Support Banner

DBI Needed For Absence Start/end Datetime Associated With The Absence Deduction Calculation Card (Doc ID 2565387.1)

Last updated on JULY 15, 2019

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.

Goal

We need to access the actual absence start date time and actual absence end date time associated with the absence calculation card component in payroll run, via a fast formula.

Requesting a DBI to:
from clause: anc_per_abs_entries ent, pay_dir_card_components_f comp
where clause:ent.per_absence_entry_id = comp.creator_id
and comp.creator_type = 'ABSXML'
and comp.dir_card_comp_id = (:{PARAMETER.PARENT_DIR_CARD_COMP_ID})

from clause: anc_per_abs_entries ent, pay_dir_card_components_f comp
 

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
References


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