Graphic PDR Reports fails while Generating the Cover Page
(Doc ID 387796.1)
Last updated on FEBRUARY 10, 2019
Applies to:Oracle Clinical - Version 4.5.1 and later
Oracle Clinical Remote Data Capture Option - Version 4.5.1 and later
Information in this document applies to any platform.
The execution of the PDR report in graphic mode ends with failure.
The PDR report fails while generating the cover page.
These are the specific symptoms of the problem:
- Reports queue manager displays the standard error rep-1825 for the PDR job:
BACKGROUND is deprecated. See help for more information. MSG-00010: 328900: SRW.RUN_REPORT failed.
Updating faiulre text. REP-1825: Before Report trigger returned FALSE.
- When PDR debug is enabled only the lxxxx.log file is created. The file shows the following:
MSG MSG-00005: rxcdmlpd: entering "after paramater form trigger"
MSG MSG-00005: PDF_MODE = Y
MSG MSG-00005: Distinct_rpt_id = <REPORT_ID>
MSG MSG-00005: INT_PDR_SUBTYPE = UNDEFINED
MSG MSG-00005: ---------------------------------------
MSG MSG-00005: generateCoverPage:
MSG MSG-00005: pdr cover batch file name := D:\Oracle\opapps45\temp\<pdr_cover_server_jobid.bat>
MSG MSG-00005: about to submit a batch job to generate the cover page
MSG MSG-00005: checkFileValidity := D:\Oracle\opapps45\temp\<File_Name.pdf>
MSG MSG-00005: could not generate the cover page. Exiting...
MSG MSG-00001: Report ending ...
ERR REP-1419: 'afterreport': PL/SQL program aborted.
- Execution of the bat file that generates the cover page does not produce any pdf output file.
Since the PDR report fails in the generation of the cover page you will be able to find the bat file that generates the cover page. The file name is c:\opapps45\temp\pdr_cover_server_jobid.bat.
An attempt to manually execute this bat file from a command line prompt (as noted below) will not generate the corresponding cover page.
Manual Execution from Command Line Prompt:
destype=FILE desname="test_out.pdf" USERID="username/pwd@db_string"
File test_out.pdf is not created.
Instead a reports.log file will be created with the following messages, and no errors at all will be registered in the file:
MSG-00005: rxcdmlpd: entering "after paramater form trigger"
MSG-00005: PDF_MODE = Y
MSG-00005: Distinct_rpt_id =
MSG-00005: INT_PDR_SUBTYPE = HEADER
MSG-00005: DATE DISPLAY FORMAT (COMING) =
MSG-00005: DATE DISPLAY FORMAT (DATABASE DEFAULT) = STANDARD
MSG-00005: DATE_TIME DISPLAY = DD-MON-YYYY HH24:MI:SS
MSG-00005: subquery_id = 0
MSG-00005: Test/Prod mode = P
MSG-00005: NLS/ENG mode = NON-NLS
MSG-00005: Customized Boilers := N
MSG-00005: before get_subquery
MSG-00005: After_paramater_trigger return TRUE
The execution of the reports test report did not generate any output file:
Go to directory:
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