BEN Dependent Eligibility Summary
Description
Categories: BI Publisher
Application: Advanced Benefits
Source: Dependent Eligibility Summary Report (XML)
Short Name: BENDESUM_XML
DB package: BEN_BENDESUM_XMLP_PKG
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 |