Error In CFG_E2B.AE_USER_PROC For Profile {XYZ} DTD Element DRUGSTRUCTUREDOSAGENUMB ORA-01722 (Doc ID 2438134.1)

Last updated on DECEMBER 30, 2024

Applies to:

Symptoms

Argus Safety 8.1.2

There are errors when Importing E2b XML R2 files against EMA R2 standard profile

Error in CFG_E2B.AE_USER_PROC for Profile {XYZ} DTD Element DRUGSTRUCTUREDOSAGENUMB ORA-01722: invalid number ;

CMN_ERROR_LOG table had the following records :

ORA-01722: invalid numberORA-06512: at "ESM_OWNER.ESM_IMP_UTL", line 991
ORA-06512: at line 46
ORA-06512: at "SYS.DBMS_SQL", line 1707
ORA-06512: at "ESM_QUERY.ESM_PKG", line 13494

PL/SQL Call Stack:
13511      ESM_PKG.F_EXECUTE_USER_PROC
397        ESM_IMP.P_IMP_DATA_TRANSLATE
1          __anonymous_block

870        ESM_IMP_UTL.WRITE_ERROR_MSG
13511      ESM_PKG.F_EXECUTE_USER_PROC
397        ESM_IMP.P_IMP_DATA_TRANSLATE
1          __anonymous_block

The XML file has following data :

<DRUGSTRUCTUREDOSAGENUMB>4</DRUGSTRUCTUREDOSAGENUMB>
<DRUGSTRUCTUREDOSAGEUNIT>014</DRUGSTRUCTUREDOSAGEUNIT>
<DRUGSEPARATEDOSAGENUMB>4</DRUGSEPARATEDOSAGENUMB>
<DRUGINTERVALDOSAGEUNITNUMB>1</DRUGINTERVALDOSAGEUNITNUMB>
<DRUGINTERVALDOSAGEDEFINITION>804</DRUGINTERVALDOSAGEDEFINITION>

There is no custom logic applied for DRUGSTRUCTUREDOSAGENUMB element

Changes

Cause

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