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 laterInformation 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 |