BEN Communications Triggers Audit Log

➜ Back to Library
Description
Categories: BI Publisher
Application: Advanced Benefits
Source: Communications Triggers Audit Log (XML)
Short Name: BENCMAUD_XML
DB package: BEN_BENCMAUD_XMLP_PKG
Run BEN Communications Triggers Audit Log and other Oracle EBS reports with Blitz Report™ on our demo environment
Select 'Name:' || ppf.full_name FULL_NAME,
          rep.person_id PERSON_ID,
          'SSN:' || ppf.national_identifier NATIONAL_IDENTIFIER,
          'Summary Action:' ||  substr(rep.TEXT,1,70) Summary_actn,
          'Person Type:' || ppt.user_person_type person_type
From  ben_reporting rep,
          ben_benefit_actions bft,
          per_people_f ppf,
          per_person_types ppt
Where  bft.request_id = :P_CONCURRENT_REQUEST_ID
and      bft.benefit_action_id = rep.benefit_action_id
and      rep.rep_typ_cd in ( 'ERRCM', 'COMMU', 'NOCOMMU', 'FATAL')
and      rep.person_id = ppf.person_id
and      ppf.person_type_id = ppt.person_type_id 
and      ppt.business_group_id = ppf.business_group_id
and      bft.process_date between 
               ppf.effective_start_date and ppf.effective_end_date 
order    by ppf.national_identifier asc
Parameter Name SQL text Validation
Concurrent Request ID 
 
 LOV Oracle
Download
Related Blitz Reports
BEN Back-out Life Events Audit Log BEN Close Enrollments Audit Log BEN Error By Error Type Report(Comm.) BEN Process Forfeitures Audit Log BEN Error By Person Report(Comm.) BEN Error Type BEN Person Error BEN Back-out Life Events Summary BEN Participation Audit Log
Blitz Report™

Blitz Report™ provides multiple benefits: