SOA 11g - The MODIFY_DATE Column in the CUBE_INSTANCE Table Gets Updated With Wrong Value
Last updated on OCTOBER 30, 2013
Applies to:Oracle SOA Suite - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 11gR1 to 12c]
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms