System Error Is Being Caused By Back Dated Reads From Field Activities (Doc ID 2771563.1)

Last updated on OCTOBER 10, 2022

Applies to:

Goal

System error is being caused by back dated reads from field activities

Found out that the system error is being caused by back dated reads from field activities.
During completion process of the field activity in SOM, SOM will try to create an IMD via Create FA IMD completion event.

However since the date/time is back dated, it causes a system error on creation of IMD as it tries to reconcile the estimation reads.
This issue happened a lot during FA replay a few months back, but can still happen on Production now because of back dated data corrections FAs.

Not sure if oracle already seeing this issue and if there is any available patches to allow Create FA IMD completion event to not automatically transition/process an IMD to Finalized state especially if there is a monitor
process involved in the IMD lifecycle. Doing so will allow the activity to complete in SOM, leaving the IMD in Pending letting the monitor batch pick it up for processing.
If it fails, I believe there is a process to manually cover these kinds of issues as part of Billing.
 

Solution

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