BEN Default Enrollment Summary

➜ Back to Library
Description
Categories: BI Publisher
Application: Advanced Benefits
Source: Default Enrollment Summary Report (XML)
Short Name: BENDFSUM_XML
DB package: BEN_BENDFSUM_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 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 Close Enrollments Summary BEN Communications Triggers Audit Log BEN Close Action Items Summary BEN Error By Person Report(Comm.) BEN Error Type BEN Person Error BEN Process Forfeitures Summary BEN Error By Error Type Report(Comm.) BEN Dependent Eligibility Summary
Blitz Report™

Blitz Report™ provides multiple benefits: