Regenerate Forms and Reports With ADADMIN adtasktim.sql Results in SP2-0642: SQL*Plus internal error state 2165
Last updated on APRIL 17, 2017
Applies to:Oracle E-Business Suite Technology Stack - Version 12.1.3 and later
Information in this document applies to any platform.
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:
Running adtasktim.sql ..
SP2-0642: SQL*Plus internal error state 2165, context 4294967295:0:0
Unable to proceed.
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.
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