My Oracle Support Banner

How To Set The Right Sequence Of Execution Of Scheduled Actions (Doc ID 746075.1)

Last updated on MAY 31, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.0.0.0.0 and later
Information in this document applies to any platform.

Goal

There could be a scenario where two scheduled actions for same account have same when_t and created_t. The first scheduled action is closing service (by changing the status of the service). The second one is creating the new service using the same login.

pin_deferred_act finishes with an error in such a case because the jobs are executed with reverse order. The first executed action for new service creation is not finished because the login exists. The second executed action also has the error because of an existing scheduled action with status 10103 (an error). 

Even if we try to change the number of threads for the pin_deferred_act process to 1, the problem would still surface.

How could one achieve that such deferred actions having the same when_t, created_t, etc are executed in the right sequence to prevent issues like above.


Sample Scenario:

- Create a new account, and subscribe to a service
- Create a schedule action to close the service in the future
- Create a schedule action to create new service with the same login on the account . Ensure it has the same time(when_t) in the future as above
- Run deferred action for the scheduled objects

Solution

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