My Oracle Support Banner

Activities Remain In Pending Status Even After Spawn/Sequence Activities Are Processed Successfully (Doc ID 2824209.1)

Last updated on NOVEMBER 29, 2021

Applies to:

Oracle Insurance Policy Administration J2EE - Version and later
Information in this document applies to any platform.


On : version, General

Activities remain in Pending Status even after Child Activities are successfully processed and in Active Status.
Parent Activities being Pending is causing issues where future Activities cannot be processed due to sequence errors.
Parent Activities remaining in Pending Status and ActivityGMT, ActiveFrom, XMLData columns are null.

Note that this is not happening on all Policies and not happening on all Activities as well.
Similar activities are processed successfully.
No pattern of failure is established yet.
Logs does not show any error or exception.

Occurrences of failure occurred on following Activities:
 1. UpdatePolicyStatus
 2. ScheduleBillingMethodChange
 3. FinalAction
 4. PremiumLock

Parent Activity should be in Active Status when Child Activities (spawn/sequenced) Activities are successfully.

The issue can be reproduced at will with the following steps:
1. Add an Activity which spawns/sequenced Child Activities.
2. Process Parent Activity.
3. Spawned Activities are successful and moved to Active Status.
4. Parent Activity remains in Pending Status.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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