Getting Error ORA-06502,ORA-00936,ORA-00907 in AMHOME.TICKCHGT_PKG While Accessing Workbench -> Apps -> Change Tracker. (Doc ID 758762.1)

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.

Symptoms

-- 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.



 .

Cause

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