Error 402000609 When Generating E2B Report (Doc ID 1669925.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Argus Safety - Version 5.0.3.4 and later
Information in this document applies to any platform.

Symptoms

Oracle Argus Safety Version 5.0.3.4


When attempting to generate and preview draft of an E2B report,error 402000609 occurs

e.g.

"Error No: 402000609
 Description: Case ABCDE1 General error while creating  E2b report. The SGML could not be generated for parent element: PATIENT and child element:
 PATIENTINITIAL. The following error occurred:
 ORA-22992: cannot use LOB locators selected from remote tables
 ORA-02063: preceding line from DLP_TO_ESM
 ORA-06512: at "DLP_OWNER.ESM_PKG",
 line 4182
 ORA-01722: invalid number. Stored Procedure: GENERATE_SAFETYREPORT See report details."

 

Cause

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 hundreds of Community platforms