BEN Error By Error Type Report(Comm.)
Description
Categories: BI Publisher
Application: Advanced Benefits
Source: Error By Error Type Report(Comm.) (XML)
Short Name: BENCMETY_XML
DB package: BEN_BENCMETY_XMLP_PKG
Source: Error By Error Type Report(Comm.) (XML)
Short Name: BENCMETY_XML
DB package: BEN_BENCMETY_XMLP_PKG
Run
BEN Error By Error Type Report(Comm.) and other Oracle EBS reports with Blitz Report™ on our demo environment
select a.national_identifier NATIONAL_IDENTIFIER, a.error_message_code ERROR_MESSAGE_CODE, b.full_name FULL_NAME, a.text 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 ('ERRCM', 'FATAL') 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 |