My Oracle Support Banner

12.2 E-Business Suite Diagnostic Tests Fail With 'The executable for the test is corrupted ' And 'Invalid test(s) selected' Due To Error 'java.sql.SQLException: ORA-01427: single-row subquery returns more than one row' (Doc ID 2427099.1)

Last updated on JULY 30, 2018

Applies to:

Oracle Applications Manager - Version 12.2 and later
Oracle E-Business Suite Diagnostics - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.2 Applications Diagnostics, Diagnostic Interface related issues

 

 

 

 

The following errors are observed when running diagnostic tests for E-Business Suite applications:


Error messages:

Invalid test(s) selected. Error information is provided along with the test 
name. 
<Test Name> - The executable for the test is corrupted 


The concurrent program  "Diagnostics Patching CP" also fails with the below error messages in log file:

[main][22:51:45:846, 5/4/17] java.sql.SQLException: ORA-01427: single-row 
subquery returns more than one row 

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) 
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405) 
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931) 
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481) 
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205) 
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548) 
at 
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217) 

at 
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatemen 
t.java:947) 
at 
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1 
283) 
at 
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1 
441) 
at 
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedState 
ment.java:3769) 

....

 

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