Pending Redo Activities Are Being Deleted From AsActivity Table (Doc ID 3065633.1)

Last updated on JANUARY 06, 2025

Applies to:

Symptoms

On : 11.3.1.33B Version, Activity

ACTUAL BEHAVIOR

---------------

In OIPA v11.0.2.14, the Bug 27759076 - Pending Redo Activities are being Deleted from AsActivity table) was delivered to modify "deletes" of Pending AsActivity (and related records) to Pending Shadow status.

So rather than a physical delete of the records in the tables, the status of the AsActivity record was updated.

Following the deployment of OIPA v11.3.1, the business noticed that the Auditor Step in the Production Batch Cycle is failing because the count of AsActivity and AsActivityField records in OIPA_PAS does not

match the count of records in AsActivity and ActivityField tables in ODS_TARGET.

This causes the nightly Batch Cycle to fail and requires a manual cleanup and restart.

EXPECTED BEHAVIOR

-----------------------

The fix from Bug 27759076 should be applied to OIPA v11.3.1 so that the Pending Activities are modified to Pending Shadow and not physically deleted.

STEPS

-----------------------

The issue can be reproduced at will with the following steps:

1. This can be recreated by reversing a Spawned Activity such that the Activity is in a Pending Redo Status. 

2. Then when the parent for the Spawned Child Activity is reversed, the Child Activity is deleted from OIPA.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.