BEN Person Error

Description
Categories: BI Publisher
Columns: Full Name, Person Id, National Identifier, Rep Typ Cd, Error Message Code, Error Message ...
Application: Advanced Benefits
Source: Person Error Report (XML)
Short Name: BENERPER_XML
DB package: BEN_BENERPER_XMLP_PKG
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