My Oracle Support Banner

R3 Report Is Not Generating due to Error No. 402000632 (Doc ID 2410799.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety Cloud Service - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

Unable to generate R3 Report for certain destinations due to the following errors:

In ICSR Viewer(Draft):
---------------------
Error No. 402000632 Description: Error while generating the HL7
message, refer ERROR_LOG for more details

ERROR_LOG:
---------
Argus Safety.cm:- Oracle error 1 occurred. ORA:02292: integrity constraint
(ESM_OWNER.FK_ICSR_REG_REPORT_ID) violated - child record foundSQL: delete cmn_reg_reports
where reg_report_id = :PG_REG_REPORT_IDPL/SQL Call Stack: SQL673
PKG_CONSOLE_COMMON.P_ERROR_LOG1 _anonymous_block

 

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.