SOA 11g - The MODIFY_DATE Column in the CUBE_INSTANCE Table Gets Updated With Wrong Value (Doc ID 1596146.1)

Last updated on OCTOBER 30, 2013

Applies to:

Oracle SOA Suite - Version 11.1.1.4.0 to 12.1.2.0.0 [Release 11gR1 to 12c]
Information in this document applies to any platform.

Symptoms

The MODIFY_DATE column in the CUBE_INSTANCE table seems to get updated with the wrong value, which gives a false impression that the process took longer than expected time to complete.

As part of a composite flow, an asynchronous BPEL process instance is created/started at 11/09/2013 11:54:43 AM. The same gets completed by 11/09/2013 11:54:49 AM, according to the Audit trail messages.

But when you look at the flow trace of the composite, the BPEL process completion time is shown as 11/09/2013 12:54:45 PM. This is the value updated to the MODIFY_DATE Column in the CUBE_INSTANCE table for the instance.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms