BEN Error By Person Report(Comm.)

➜ Back to Library
Description
Categories: BI Publisher
Application: Advanced Benefits
Source: Error By Person Report(Comm.) (XML)
Short Name: BENCMEPE_XML
DB package: BEN_BENCMEPE_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select b.full_name FULL_NAME,
          a.person_id PERSON_ID,
          a.national_identifier NATIONAL_IDENTIFIER
from  ben_reporting a,
         ben_benefit_actions c,
         per_people_f b
where  c.request_id = :P_CONCURRENT_REQUEST_ID
and      c.benefit_action_id = a.benefit_action_id
and      a.rep_typ_cd in ('ERRCM', 'FATAL')
and      a.person_id = b.person_id
and      c.process_date
            between b.effective_start_date
            and        b.effective_end_date 
order    by a.national_identifier asc
Parameter Name SQL text Validation
Concurrent Request ID 
 
 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 Type BEN Person Error BEN Error By Error Type Report(Comm.) BEN Back-out Life Events Summary BEN Default Enrollment Audit Log
Blitz Report™

Blitz Report™ provides multiple benefits: