Getting Error ORA-06502,ORA-00936,ORA-00907 in AMHOME.TICKCHGT_PKG While Accessing Workbench -> Apps -> Change Tracker.
Last updated on DECEMBER 06, 2016
Applies to:Oracle Configuration Controls Governor - Version 5.5.1 and later
Information in this document applies to any platform.
-- Problem Statement:
One user is getting error on attempting to get into change tracking screen. Other users have no problem. Web log indicates some type of sql syntax error or buffer overflow in amhome.TICKCHGT_PKG. The error may first appear after a new query has been added.
Error occurs when :
1) Workbench > CCG > press 'Change Tracker' button.
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