The fcf_replicate_transactions execution time within the alert generation process has surpassed the usual duration, extending beyond 10 hours and beyond. Steps Taken to Address the Issue: Troubleshooting Measures: 1. Examined AGP logs to identify anomalies or errors during processing. 2. Compared logs with regular executions, where the replication step typically completes within 10 minutes. Investigated cases where the duration extends to nearly 12 hours. 3. Conducted a comprehensive analysis of the FCFKC and FCFCORE tables using the fcf_analyze macro. 4. Checked the database server resources, increased redo log files, and added indexes for tables specifically utilized by AGP in the replication process. Outcome: Despite the undertaken measures, AGP remains stuck and continues to consume an excessive amount of time. ... View more

SCD2 table have more than one current record  row (change current indicator) with flag "Y" per business key which is an odd behaviour looking for the root cause, any help please. ... View more