BEN Error By Person Report(Comm.)
Description
Categories: BI Publisher
Application: Advanced Benefits
Source: Error By Person Report(Comm.) (XML)
Short Name: BENCMEPE_XML
DB package: BEN_BENCMEPE_XMLP_PKG
Source: Error By Person Report(Comm.) (XML)
Short Name: BENCMEPE_XML
DB package: BEN_BENCMEPE_XMLP_PKG
Run
BEN Error By Person Report(Comm.) and other Oracle EBS reports with Blitz Report™ on our demo environment
select b.full_name FULL_NAME, a.person_id PERSON_ID, a.national_identifier NATIONAL_IDENTIFIER 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 order by a.national_identifier asc |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Concurrent Request ID |
|
LOV Oracle |