My Oracle Support Banner

Regenerate Forms and Reports With ADADMIN adtasktim.sql Results in SP2-0642: SQL*Plus internal error state 2165 (Doc ID 2255058.1)

Last updated on JULY 20, 2023

Applies to:

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

Symptoms

Upgrading to JDK 7 in EBS 12.1.x following the Document: Using JDK 7.0 Latest Update with Oracle E-Business Suite Release 12.0 and 12.1 (Doc ID 1467892.1)

In Step 3.8: Re-generate Oracle E-Business Suite Forms and Reports

   Run Adadmin and select the Forms and Reports regeneration.

In Log File, the following error is generated:

/apps/apps_st/appl/admin/EBS_SID/log/adadmin.log

Running adtasktim.sql ..

SP2-0642: SQL*Plus internal error state 2165, context 4294967295:0:0
Unable to proceed.

Changes

Upgrading to JDK 7 following the Document: Using JDK 7.0 Latest Update with Oracle E-Business Suite Release 12.0 and 12.1 (Doc ID 1467892.1)

** If other changes to EBS and not just the JDK upgrade and the symptom is still with SQLPLUS then DST patches may still be the cause. **

Example: Unable to Enable/Disable Maintenance Mode through ADADMIN. If it fails to do so, it is because of SQLPLUS is not working and the DST may be a fix.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.