BEN Person Error
Description
Categories: BI Publisher
Application: Advanced Benefits
Source: Person Error Report (XML)
Short Name: BENERPER_XML
DB package: BEN_BENERPER_XMLP_PKG
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 |
|
Char |