BEN Benefits ACA Errors

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Advanced Benefits
Source: Benefits ACA Errors Report
Short Name: BENACAERR
DB package:
Run BEN Benefits ACA Errors and other Oracle EBS reports with Blitz Report™ on our demo environment
 SELECT rar.ben_attribute1||decode(rar.ben_attribute2,NULL,'',' '||rar.ben_attribute2)||' '||rar.ben_attribute3 person_name, rar.person_id, rpa.rep_file_id
FROM ben_rep_person_actions rpa, ben_rep_actions ra, ben_rep_archive rar
WHERE ra.gre_id = rpa.gre_id
AND rar.rep_action_id = ra.rep_action_id
AND ra.locking_rep_action_id = rpa.rep_action_id
AND rpa.person_id = rar.person_id
AND rpa.rec_submission_status = 'E'
AND rar.ben_attribute_category = 'PERSONINFO1'
AND rpa.gre_id = :P_GRE_ID
AND rpa.rep_action_id = :L_REP_ACTION_ID
ORDER BY person_name
Parameter Name SQL text Validation
Year 
 
 LOV Oracle
GRE 
 
 LOV Oracle
Download
Related Blitz Reports
BEN Back-out Life Events Audit Log BEN Close Enrollments Audit Log BEN Process Forfeitures Audit Log BEN Communications Triggers Audit Log BEN Error By Person Report(Comm.) BEN Error Type BEN Person Error BEN Process Forfeitures Summary BEN Error By Error Type Report(Comm.)
Blitz Report™

Blitz Report™ provides multiple benefits: