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.

Symptoms

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:
[BEGIN
 AD_TSPACE_UTIL.get_tablespace_name(
    :l_product_short_name,
    :l_logical_ts_name,
'Y',
    :l_ts_exists,
    :l_tspace);
END;].


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.


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

Changes

 Performed export (expdp) operations on GL schema.

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.