My Oracle Support Banner

Unusual Volume Observed In F1_MO_UP Table For Few MDM MO For Capturing Ongoing Changes To (Doc ID 2865209.1)

Last updated on MAY 04, 2022

Applies to:

Oracle Utilities Customer Cloud Service - Version 21A and later
Information in this document applies to any platform.


On : NA version, Environment Related

Unusual volume observed in F1_MO_UP table for few MDM MO for capturing ongoing changes to

For the GDE process, user is extracting ongoing/initial extract data from CCS. It can be observed that F1_MO_UPD table, which captures primary keys for ongoing changes, shows unusual volumes for MDM objects and this is causing F1-GEEXO ongoing extract batch with 1 or 5 threads to run for hours, requiring us to terminate the batch and Gas South team is unable to proceed with testing GDE for ongoing extract files. It has been stated by data migration team (Wipro) that they have not added any new data to PROD environment or TEST01 environment the counts are identical, and that this would not be a conversion issue. Requesting the team to confirm on how these MDM related MO records are populated in this table when MDM related MOs are getting created/updated in CCS and how it could be purged.


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

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