My Oracle Support Banner

UNABLE TO SAVE RECORD IN LOCAL DATABASE WITH MLOV ENABLED (Doc ID 2391977.1)

Last updated on JULY 22, 2018

Applies to:

Siebel Remote Client - Version 15.15 [IP2015] and later
Information in this document applies to any platform.

Symptoms

User is unable to save LOV in local database when MLOV is enabled  . 

Replication Steps :

-1. Implement MLOV on server 

-2. Create Local database ( generate new database + db extract )

-3. Initialize  local database 

-4. Launch CTMS application ->Navigate to Site Management -> drill down on site -> select subject , try to modify status , enrollment etc 

 

The snippet of the log client side log (siebel.log)

DBCLog DBCLogError 1 0000000259631524:0 2017-07-09 19:58:32 OCIStmtExecute: SELECT DISTINCT

T3.PTCL_SITE_ID,
T3.PAR_SUBJ_ID,
T2.PTCL_SITE_ID,
T3.VISIT_TYPE_CD,
T3.STATUS_CD
FROM
SIEBEL.S_LST_OF_VAL T1,
SIEBEL.S_CL_SUBJ_LS T2,
SIEBEL.S_CL_SUBJ_ST_LS T3
WHERE
T3.PAR_SUBJ_ID = T2.ROW_ID AND
T3.STATUS_CD = T1.NAME (+) AND T1.TYPE (+) = 'CLNCL_SUBJECT_STATUS' AND T1.LANG_ID (+) = :1 AND
(T3.PTCL_SITE_ID = :2)
ORDER BY
T3.VISIT_TYPE_CD, T1.VAL

ObjMgrLog Error 1 0000000259631524:0 2017-07-09 19:58:32 (oracon.cpp (3919)) SBL-DBC-00105: An error has occurred executing a Sql statement.

Please continue or ask your systems administrator to check your application configuration if the problem persists.

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!


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