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;

 

Recent Posts

Start typing and press Enter to search