User unable to access API DME_PUB_INITIALIZATION
(Doc ID 2867177.1)
Last updated on MAY 05, 2022
Applies to:Oracle Health Sciences Data Management Workbench - Version 3.1.0 to 3.1.0 [Release 3.1.0]
Information in this document applies to any platform.
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;
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);
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