Gather Schema Statistics on R12.2

Posted by ali evrim on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Gather-Schema-Statistics-on-R12-2-tp96.html

I am getting an error when running Gather Schema Statistics on EBS R12.2

In GATHER_SCHEMA_STATS , schema_name= ALL percent=  degree = 4 internal_flag= NOBACKUP
stats on table AQ$_WF_CONTROL_P is locked
stats on table WF_CONTROL is locked
stats on table WF_NOTIFICATION_OUT is locked
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=GL.JE_BE_LINE_TYPE_MAP***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
Error #2: ERROR: While GATHER_TABLE_STATS:
object_name=GL.JE_BE_LOGS***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
Error #3: ERROR: While GATHER_TABLE_STATS:
object_name=GL.JE_BE_VAT_REP_RULES***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***