My Oracle Support Banner

Workflow Background Process Does Not Complete / Infinite Loop When Order Has Open Billing Plan Line(s) And Latest Billed Date Is In The Past (Doc ID 2935802.1)

Last updated on MAY 01, 2023

Applies to:

Oracle Order Management - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.12 version, Transaction Fulfillment

ACTUAL BEHAVIOR
---------------
Workflow Background Process Does Not Complete / Infinite Loop When Order Has Open Billing Plan Line(s) And Latest Billed Date Is In The Past(see ER# 22306097)

Workflow background process did not run in past then subsequent workflow background process keep on
executing the close_header activity as its past due.

Due to this workflow does not progress.

EXPECTED BEHAVIOR
-----------------------
Workflow Background Process should complete when the Open Billing Plan Line(s) And Latest Billed Date Is In The Past

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create orders having recurring billing data
2. When last billed date is more than 30 days in the past (possibly because the Workflow Background Concurrent was not running for a month, e.g. on a test system) the code in procedure OE_Close_WF.close order gets into an infinite loop due to incorrect code
3. see that Workflow is in Infinite Loop

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
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.