' ORA-20000: 515600-Cannot Update An Omission That Is Not Owned By TMS ' when executing the procedure TMS_user_action.CreateVTAction
(Doc ID 2975707.1)
Last updated on SEPTEMBER 21, 2023
Applies to:
Oracle Thesaurus Management System - Version 5.4.0 and laterInformation in this document applies to any platform.
Symptoms
1. Executing procedure TMS_user_action.CreateVTAction see below example
DECLARE
vActionType varchar2(30):='C' ;
vActionText varchar2(3000):='<TERM_NAME>';
vVtoActionEntryTs date;
vDefActionKey varchar2(50) :='CLARIFY.';
vCreatedBy varchar2(30);
vThiTermId varchar2(30);
BEGIN
TMS_user_action.CreateVTAction(
pDefDomainId => <DEF_DOMAIN_ID>,
pDefDictionaryID => <DICT_ID>,
pVerbatimTerm =>'<TERM_NAME>',
pDefActionKey =>vDefActionKey,
pActionType => vActionType,
pActionText=>vActionText,
pVtoActionEntryTs => vVtoActionEntryTs,
pCreatedBy => vCreatedBy,
pThiTermId =>vThiTermId
);
DBMS_OUTPUT.PUT_LINE(vCreatedBy);
DBMS_OUTPUT.PUT_LINE(vVtoActionEntryTs);
DBMS_OUTPUT.PUT_LINE(vThiTermId);
END;
vActionType varchar2(30):='C' ;
vActionText varchar2(3000):='<TERM_NAME>';
vVtoActionEntryTs date;
vDefActionKey varchar2(50) :='CLARIFY.';
vCreatedBy varchar2(30);
vThiTermId varchar2(30);
BEGIN
TMS_user_action.CreateVTAction(
pDefDomainId => <DEF_DOMAIN_ID>,
pDefDictionaryID => <DICT_ID>,
pVerbatimTerm =>'<TERM_NAME>',
pDefActionKey =>vDefActionKey,
pActionType => vActionType,
pActionText=>vActionText,
pVtoActionEntryTs => vVtoActionEntryTs,
pCreatedBy => vCreatedBy,
pThiTermId =>vThiTermId
);
DBMS_OUTPUT.PUT_LINE(vCreatedBy);
DBMS_OUTPUT.PUT_LINE(vVtoActionEntryTs);
DBMS_OUTPUT.PUT_LINE(vThiTermId);
END;
2. Below example tech-stack error is received:
[Error]: ORA-20000: 515600-Cannot update an omission that is not owned by TMS.
ORA-06512: at "OPA.OPA_USER_MSG", line 302
ORA-06512: at "OPA.OPA_USER_MSG", line 375
ORA-06512: at "TMS.TMS_VT_OMISSIONS_M1", line 951
ORA-06512: at "TMS.TMS_MASTER_ACTION", line 949
ORA-06512: at "TMS.TMS_USER_ACTION", line 817
ORA-06512: at line 16; {'id': 74814994, 'createdby': '<USERNAME>'}
ORA-06512: at "OPA.OPA_USER_MSG", line 302
ORA-06512: at "OPA.OPA_USER_MSG", line 375
ORA-06512: at "TMS.TMS_VT_OMISSIONS_M1", line 951
ORA-06512: at "TMS.TMS_MASTER_ACTION", line 949
ORA-06512: at "TMS.TMS_USER_ACTION", line 817
ORA-06512: at line 16; {'id': 74814994, 'createdby': '<USERNAME>'}
Changes
n/a
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 |
Changes |
Cause |
Solution |