PAY Dynamic Triggers missing from Database

➜ Back to Library
Description
Categories: BI Publisher
Application: Payroll
Source: Dynamic Triggers missing from Database (XML)
Short Name: PAYRPTMD_XML
DB package: PAY_PAYRPTMD_XMLP_PKG
Run PAY Dynamic Triggers missing from Database and other Oracle EBS reports with Blitz Report™ on our demo environment
select  short_name, table_name, generated_flag
from pay_trigger_events 
where enabled_flag = :P_enabled_flag_1
and NOT EXISTS (select 'A'
from hr_trigger_status_v
where to_char(event_id) = RTRIM(SUBSTR(trigger_name,(INSTR(trigger_name,'_')+1)),'UID_DYT'))
ORDER BY table_name
Parameter Name SQL text Validation
Dynamic Trigger Enabled Flag 
 
 LOV Oracle
Download
 
Related Blitz Reports
PAY Dynamic Triggers Status PAY Functional Area CE General Ledger Reconciliation PON Solicitation data template PAY Database Triggers Status ECC Projects, Projects Costing: Transactions, SQL1 GL Account Analysis (Distributions) QA Collection Element Action Rules QA Collection Plan Action Rules
Blitz Report™

Blitz Report™ provides multiple benefits: