My Oracle Support Banner

After enabling SSL on the E-Business Suite Middle Tier, Some Functions are Failing With the Errors java.sql.SQLException ORA-29273 HTTP request failed, ORA-06512: at "SYS.UTL_HTTP" (Doc ID 1265016.1)

Last updated on JUNE 04, 2018

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Checked for relevance on June 4th, 2018


After enabling SSL on the E-Business suite Middle tier, the following error occurs when trying to complete candidate registration in iRecruitment.


Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select nvl2(:1, irc_jps_generator.GenerateJPS(:2,:3), null) as Resume
,'Resume.htm' as FileName,
from dual

## Detail 0 ##
java.sql.SQLException: ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1674
ORA-28759: failure to open file
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1674
ORA-28759: failure to open file
ORA-06512: at "APPS.IRC_JPS_GENERATOR", line 409
ORA-06512: at "APPS.IRC_JPS_GENERATOR", line 423
ORA-06512: at line 1

Note:- The "java.sql.SQLException: ORA-29273: HTTP request failed" error can be reported by any E-Business suite application which calls "SYS.UTL_HTTP"

Steps to Reproduce

The issue can be reproduced at will with the following steps:

1. Enable SSL on the E-Business suite Middle tier following the instructions in

Note 376700.1 Using SSL with Oracle E-Business Suite Release 12

2. Chose option in iRecruitment site to register as new candidate.

3. Enter email,family name and password.

4. Chose the option to upload resume later.

5. Enter basic personal information.

6. Enter qualification and skills details.

7. Enter preferences.

8. Error is coming before resume template selection.

Business Impact

Due to this issue users are unable to proceed with candidate registration when going for auto generation of resume.




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.