User unable to access API DME_PUB_INITIALIZATION
(Doc ID 2867177.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Data Management Workbench - Version 3.1.0 to 3.1.0 [Release 3.1.0]Information in this document applies to any platform.
Symptoms
The user is unable to run the API DME_PUB_INITIALIZATION from SQL Developer. The same user account has the necessary EXECUTE privileges on the API (DME_PUB_INITIALIZATION) and the user also has access to the respective study in DMW. The error received in SQL Developer is :
ORA-20001: dme_pub_initialization ERROR: No LSH Application user found for user <User Name>.
ORA-06512: at "APPS.CDR_PUB_API_INITIALIZATION", line 50
ORA-06512: at "APPS.DME_PUB_INITIALIZATION", line 193
ORA-06512: at line 11
See the example script below used to run the API.
SET serveroutput ON;
DECLARE
X_RETURN_STATUS VARCHAR2(10);
x_ret_code NUMBER;
x_ret_msg VARCHAR2(100);
BEGIN
DME_PUB_INITIALIZATION.SetupAPIStudyEnvironment ( P_API_VERSION =>1, X_RETURN_STATUS =>X_RETURN_STATUS, X_MSG_COUNT =>x_ret_code, X_MSG_DATA =>x_ret_msg, PI_COMPANY_ID =><company_id>, PI_STUDY_ID =><study_id>, PI_LIFECYCLE =>'$LIFECYCLE$DEV' );
dbms_output.put_line('study env setup --'||X_RETURN_STATUS||'--'||x_ret_msg);
end;
/
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 |