BEN Person Error

➜ Back to Library
Description
Categories: BI Publisher
Application: Advanced Benefits
Source: Person Error Report (XML)
Short Name: BENERPER_XML
DB package: BEN_BENERPER_XMLP_PKG
Run BEN Person Error and other Oracle EBS reports with Blitz Report™ on our demo environment
Select b.full_name FULL_NAME,
          a.person_id PERSON_ID,
          a.national_identifier NATIONAL_IDENTIFIER,
          a.REP_TYP_CD,
          a.ERROR_MESSAGE_CODE,
          substr(a.TEXT,1,255) ERROR_MESSAGE
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 ('ERROR', 'WARNING','ERROR_LF')
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, a.rep_typ_cd
Parameter Name SQL text Validation
Concurrent Request ID 
 
 LOV Oracle
Report Sub-Title 
 
 Char
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 Error By Error Type Report(Comm.) BEN Back-out Life Events Summary BEN Default Enrollment Audit Log
Blitz Report™

Blitz Report™ provides multiple benefits: