CCG : Transfer job completed with warning - TICK_CHG_TRACK_NOTIFY_PKG.COMPARE_CHANGES: ORA-00936: missing expression
(Doc ID 2269536.1)
Last updated on OCTOBER 10, 2023
Applies to:
Oracle Configuration Controls Governor - Version 5.5.1 and laterInformation in this document applies to any platform.
Symptoms
On : 5.5.1 version, Integra Apps
When attempting to run the Change Tracking Transfer job
the following error occurs.
ERROR
-----------------------
Processing query OSCAR GL 12.2...
TICK_CHG_TRACK_NOTIFY_PKG.COMPARE_CHANGES: ORA-00936: missing expression
Error in Notify Package. ORA-00936: missing expression
End of Change Tracking Transfer process.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to the CCG
2. Run the Change Tracking Transfer Job using Immediate option from View jobs
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get the job status to completed because of issues with Notification Jon of Change Tracking Transfer
Cause
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
Symptoms |
Cause |
Solution |