My Oracle Support Banner

ORA-01403: No Data Found ORA-06512: at "ESM_OWNER.ESM_IMP_DIFF_REPORT", Line 5020 During XML Import (Doc ID 2825966.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Interchange - Version 8.2.2 and later
Information in this document applies to any platform.

Symptoms

Receive the following error message during E2B R3 message import using the shipped Out of The Box (OOTB) EMA E2B R3 Profile:


ORA-01403: no data foundORA-06512: at "ESM_OWNER.ESM_IMP_DIFF_REPORT, line 5020
. Stored Procedure: ESM_IMP_DIFF_REPORT.p_populate_diff_report_R3.

Error Call Stack:


1446 ESM_UTL.P_INSERT_ERROR_LOG
1471 ESM_UTL.P_INSERT_ERROR_LOG_PRAGMA
5178 ESM_IMP_DIFF_REPORT.P_POPULATE_DIFF_REPORT_R3
3738 ESM_IMP_DIFF_REPORT.P_GET_DIFF_REPORT
1 __anonymous_block"


Examining the SAFETYREPORT table it has the below import errors and comments for this report/import file:

On element C.1.7: Mandatory element missing



Changes

 

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


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