Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
Query provided in the oracle docs for the retro unprocessed is not working.
Query to identify entries that are not processed in RetroPay(Enhanced)
select entry.element_entry_id, element.element_name, entry.creator_type, entry.effective_start_date, entry.effective_end_date, entry.assignment_id
from pay_element_types_f element,
pay_element_entries_f entry
where element.element_type_id = entry.element_type_id
and entry.element_entry_id in (select element_entry_id from pay_retro_entries where retro_assignment_id in (select retro_assignment_id from pay_retro_assignments where retro_assignment_action_id is null)) and to_date('<DATE>','DD-MON-YYYY') between entry.effective_start_date and entry.effective_end_date and element.business_group_id = <BUSINESS_GROUP_ID>;