You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can the Database Item ELEMENT_ENTRY_RGE_BASE_ELEMENT_NAME be used in Payroll Formula?

Accepted answer
31
Views
8
Comments
edited Aug 30, 2023 4:39PM in Payroll and Global Payroll Interface (GPI) 8 comments

Summary:

Can the Database Item ELEMENT_ENTRY_RGE_BASE_ELEMENT_NAME be used in Payroll Formula?

Content (required):

Hi,

I'd like to loop through entries between an effective start and end date and collect information from those element entries. The database item ELEMENT_ENTRY_RGE_BASE_ELEMENT_NAME appears to be the correct DBI, however the formula with type Oracle Payroll does not compile.

I can use the DBI ELEMENT_ENTRY_BASE_ELEMENT_NAME which allows me to loop through entries in the pay period, but not between two dates.

Is the DBI ELEMENT_ENTRY_RGE_BASE_ELEMENT_NAME limited to be used in specific formula types like Global Absence Accrual Matrix where start_date and end_date contexts can be set?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!