My Oracle Support Banner

RDC Onsite PDR fails with ORA-39565: Message 39565 not found error (Doc ID 601732.1)

Last updated on NOVEMBER 01, 2023

Applies to:

Oracle Clinical Remote Data Capture Option - Version 4.5.3 to 4.6.0 [Release 4.5.3 to 4.6.0]
Information in this document applies to any platform.


When attempting to run PDR reports from RDC Onsite, the following error occurs:

Report: d:\opapps45\oc\RXCDMLPD.rep
Logged onto server: <SERVER NAME>
Username: <USERNAME>

ERR REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-39565: Message 39565 not found; product=RDBMS; facility=ORA

ERR Error occurred sending Job output to cache.

The log file might also have the following information:

Notice the process dies after indicating the ‘Patient Specific Case Blnk PDR’ but does not get to ‘Start Calling PATIENTDATAREPORT Setter Methods’.

Examination of the code shows that the subsequent function call fails to complete. Testing the individual queries which feed the function calls which are used as parameters in the call to the java object one can determine that all of the internal calls should have been successful. The problem is in attempting to access the java object (.jar file).


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

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