My Oracle Support Banner

Adadmin Generate Jar Files Fails with Error "ORA-01422: exact fetch returns more than requested number of rows" and ORA-06512: at "APPS.AD_TSPACE_UTIL" (Doc ID 2983300.1)

Last updated on OCTOBER 30, 2023

Applies to:

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


While executing adadmin generate jar files, it fails with errors "ORA-01422: exact fetch returns more than requested number of rows" and ORA-06512: at "APPS.AD_TSPACE_UTIL".

The below errors are recorded in the adadmin log file:

ORA-01422: exact fetch returns more than requested number of rows     
ORA-06512: at "APPS.AD_TSPACE_UTIL", line 23
ORA-06512: at "APPS.AD_TSPACE_UTIL", line 452
ORA-06512: at line 2

AD Administration error:

Error in aictsuGetTSName while EXECUTE statement:

aduoprcInitCloneSchemaInfo(): Unable to get tablespace for the table
specifications schema.

Unable to login into EBS application and the login page does not come up with "Error 500--Internal Server Error". Also the database alert log reported errors as "ORA-03137: malformed TTC packet from client rejected: [3146] [147] [] [] [] [] [] []. To fix these errors, referred to document "ORA-3137 [3146] Errors in the Alert Log (Doc ID 2807044.1)" and ran regenerate jar files which failed.

1. Try to login into EBS application.
2. Regenerate jar files through adadmin.
Generate Applications Files menu > Generate product JAR files


 Performed export (expdp) operations on GL schema.


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

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