BEN Dependent Eligibility Summary

➜ Back to Library
Description
Categories: BI Publisher
Application: Advanced Benefits
Source: Dependent Eligibility Summary Report (XML)
Short Name: BENDESUM_XML
DB package: BEN_BENDESUM_XMLP_PKG
Run BEN Dependent Eligibility Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
            select REP.ERROR_MESSAGE_CODE,
                      COUNT(REP.ERROR_MESSAGE_CODE) NUMBER_OF_ERROR_CODES
                      from   BEN_REPORTING REP,
                      BEN_BENEFIT_ACTIONS BFT
            where BFT.BENEFIT_ACTION_ID = REP.BENEFIT_ACTION_ID
            and bft.request_id = :P_CONCURRENT_REQUEST_ID
            and rep.rep_typ_cd in 'ERROR'
            group by REP.ERROR_MESSAGE_CODE
Parameter Name SQL text Validation
Concurrent Request ID 
 
 LOV Oracle
Download
 
Related Blitz Reports
BEN Back-out Life Events Audit Log BEN Error Type BEN Person Error BEN Default Enrollment Summary BEN Error By Error Type Report(Comm.) BEN Error By Person Report(Comm.) BEN Communications Triggers Audit Log BEN Close Enrollments Summary BEN Close Enrollments Audit Log
Blitz Report™

Blitz Report™ provides multiple benefits: