Changing EBS user password failed with error “APP-FND-01564: ORACLE error 3113”
Introduction:
Recently while changing password for application user in Oracle EBS version 12.2.6 I faced below issue. Tried multiple options to resolve the issue but nothing helped.
Working…
APP-FND-01564: ORACLE error 3113 in check_apps_parm
Cause: check_apps_parm failed due to ORA-03113: end-of-file on communication channel.
The SQL statement being executed at the time of the error was: begin :r := nvl(fnd_web_sec.get_op_value(:u,:p),’**##_NuLl_##**’); end; and was executed from the file &ERRFILE.
Cause of the issue:
Seeing this issue after we upgraded the EBS DB from 12.1.0.2 to 19c database.
How do we solve:
By setting the below hidden parameter this issue can be resolved.
ALTER SYSTEM SET “_optimizer_gather_stats_on_conventional_dml” = false SCOPE=SPFILE;
