API_CREATE_ORA_DEM_USER Fails With ORA-29273 and ORA-12535 (Doc ID 2303321.1)

Last updated on AUGUST 31, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 to 12.2.4.1 [Release 7.3.0 to 12.2]
Information in this document applies to any platform.

Symptoms

1) Executed the following store procedure:

execute API_CREATE_ORA_DEM_USER ('anewuserl_dm', 'Pass', 'DP', 'FirstName', 'LastName', '37', ' ', ' ', 'newUserEmail@myCompany.com', 9, 4 ,'Demand Management', '' ,'UPDATE');

And got the following error:

execute API_CREATE_ORA_DEM_USER ('anewuserl_dm', 'Pass', 'DP', 'FirstName', 'LastName', '37', ' ', ' ', 'newUserEmail@myCompany.com', 9, 4 ,'Demand Management', '' ,'UPDATE');

ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1817
ORA-12535: TNS:operation timed out
ORA-06512: at "DEMANTRA.HELPER", line 2135
ORA-06512: at "DEMANTRA.API_CREATE_ORA_DEM_USER", line 529
ORA-06512: at line 1
29273. 00000 - "HTTP request failed"
*Cause: The UTL_HTTP package failed to execute the HTTP request.
*Action: Use get_detailed_sqlerrm to check the detailed error message.
  Fix the error and retry the HTTP request.

Subsequent attempts to use new login information fails

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. execute API_CREATE_ORA_DEM_USER
2. Observe the noted error
3. Observe that attempts to log in to collaborator workbench fail using the updated information.

Cause

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