BEN Participation Error Detail Report by Error Type

➜ Back to Library
Description
Categories: BI Publisher
Application: Advanced Benefits
Source: Participation Error Detail Report by Error Type (XML)
Short Name: BENERRTY_XML
DB package: BEN_BENERRTY_XMLP_PKG
Run BEN Participation Error Detail Report by Error Type and other Oracle EBS reports with Blitz Report™ on our demo environment
select a.national_identifier NATIONAL_IDENTIFIER,
          a.error_message_code ERROR_MESSAGE_CODEM2,
          b.full_name FULL_NAME,
         a.text TEXT,
         decode(a.rep_typ_cd,'WARNING',1,0) reptype
from  ben_reporting a,
         per_all_people_f b
where  a.benefit_action_id = :p_benefit_action_id
and      a.rep_typ_cd in ('ERROR','WARNING')
and      a.person_id = b.person_id
and      a.error_message_code = :ERROR_MESSAGE_CODE
and      :p_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 Process Forfeitures Audit Log BEN Error Type BEN Person Error BEN Error By Error Type Report(Comm.) BEN Error By Person Report(Comm.) BEN Communications Triggers Audit Log BEN Close Enrollments Audit Log BEN Participation Audit Log
Blitz Report™

Blitz Report™ provides multiple benefits: