EBS OID Registration Script Fails With java.sql.SQLException: Could not commit with auto-commit set on (Doc ID 2261925.1)

Last updated on MAY 04, 2017

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.1.3 and later
Information in this document applies to any platform.
EBS 12c Database

Symptoms

On : 12.1.3 and Database 12c,

When attempting to run the EBS Applications Oracle Internet Directory registration script, the following error occurs:

java.sql.SQLException: Could not commit with auto-commit set on
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2356)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2403)
at oracle.apps.fnd.txk.ias.FNDPreferences.removeFromDB(FNDPreferences.java:274)
at oracle.apps.fnd.txk.ias.FNDPreferences.remove(FNDPreferences.java:86)
at oracle.apps.fnd.txk.ias.config.Instance.removeFNDPreferences(Instance.java:795)
at oracle.apps.fnd.txk.ias.References.removePreferences(References.java:161)
at oracle.apps.fnd.txk.ias.References.main(References.java:189)


The issue can be reproduced at will with the following steps:
1. Run the EBS Oracle Internet Directory registration script.

Due to this issue, Oracle Internet Directory cannot be de-registered or registered without error.

Changes

 The 12.1.3 EBS Application instance was upgraded to the 12c database release.

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