My Oracle Support Banner

ETCG ( Transaction Synchronization Not Working At Model Level (Doc ID 1507327.1)

Last updated on OCTOBER 10, 2023

Applies to:

Oracle Transaction Controls Governor - Version 8.6.4 to 8.6.4 [Release 8]
Information in this document applies to any platform.


On : version, Basic Operations & Functionality

No model results are returned after performing a Synchronize job for one model (from the Manage Models screen). Synchronization appears to complete, but View Results returns zero rows. Model does produce result if ran after Global TCG ETL from Datasource screen.

Model should produce the expected result after TCG ETL run either from Model level or Datasource screen.

The issue can be reproduced at will with the following steps:
1. Created Model.
2. Save and Close. It submits the TCGETL by itself.
3. Ran the model and it did produce the result.
4. Ran the Sync again at model level.
5. Ran the Model and it did not produce any result.
6. Ran the Global TCG Sync from Datasource screen.
7. Ran the Model and it did produce the result.

The issue has the following business impact:
This makes testing transaction models extremely difficult, as a full Transaction Synchronization needs to be performed each time test transactions are created in the datasource.


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.