BEN Error Type

Description
Categories: BI Publisher
Application: Advanced Benefits
Source: Error Type Report (XML)
Short Name: BENERTYP_XML
DB package: BEN_BENERTYP_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 a.national_identifier NATIONAL_IDENTIFIER,
          a.rep_typ_cd REP_TYP_CD, a.error_message_code ERROR_MESSAGE_CODEM2,
          b.full_name FULL_NAME,
         substr(a.text,1,255) TEXT
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 
and      a.error_message_code = :ERROR_MESSAGE_CODE
order    by a.national_identifier asc
Parameter Name SQL text Validation
Concurrent Request ID
 
LOV Oracle
Report Sub-Title
 
Char