My Oracle Support Banner

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.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.