My Oracle Support Banner

Workflow Background Process Program Pending on This Run: begin GL_AUTO_ALLOC_WF_PKG.WAITING_TO_COMPLETE (Doc ID 2625205.1)

Last updated on JANUARY 14, 2020

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Workflow Background Process program is running long, waiting on Mass Allocation process to complete, where there is a great number of formulas included (over 100).

It has been observed that it is waiting for this SQL: 

This program will have Running status until the whole allocation process is complete.


STEPS:

The sequence of steps is:

1. Parent Program - AutoAllocation Launcher

2. Child programs: Recurring Journal Entry > Posting > Run Mass Allocations with great number of formulas

The parent program will wait for the child requests to complete, the Workflow Background Process will wait for the parent program to complete while workflows are sent in the system from it continuously.

Changes

 New Mass Allocation batch designed, with a great number of formulas (eg. 400).

Cause

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
Symptoms
Changes
Cause
Solution
References


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