The problem seems to be using a “double alias” format : “W.W.TRANSNO”. It should be “W.TRANSNO”, but for some reason Oracle 11g version seems to accept the invalid syntax, while 12c version rejects it. When you edit the function using “W.TRANSNO” format, it should complete successfully. Please consult with your DBA to get this accomplished.