Check Writer XML Partially Finishes and Errors with PDFDocMerger Message (Doc ID 2255001.1)

Last updated on APRIL 20, 2017

Applies to:

Oracle HRMS (US) - Version 12.1 HRMS RUP9 and later
Information in this document applies to any platform.

Symptoms

This note address two issues, one with Payroll and one with BI Publisher.
First error is a known issue normally resolved by:  <Doc ID 1401298.1> W2 PDF Errors With: APP-PAY-06882: Assertion Failure Detected At Location pyjavacom:2.
However, the issue does not occur when RUN_XDO and PRINT_FILES are set to N. i.e if we suppress the PDF generation part of the process then it completes successfully. This is the opposite of the note which is used to resolve the first error message (payroll).
The focus of this document is on the second error which occurs as a result of outdated Business Intelligence (BI) files.


Original Error that occurs when attempting to generate the Check Writer XML

1st ERROR
-----------------------
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01403: no data found
ORA-06512: at "APPS.PAY_CORE_FILES", line 622
ORA-06512: at line 1

SQL_NO 1619
TABLE_NAME pay_core_files.close_file
APP-PAY-06881: Error ORA-01403: no data found
ORA-06512: at "APPS.PAY_CORE_FILES", line 622
ORA-06512: at line 1
has occurred in table pay_core_files.close_file at location 1619

Cause: an oracle error has occurred. The failure was reported on table pay_core_files.close_file at location 1619 with the error text ORA-01403: no data found
ORA-06512: at "APPS.PAY_CORE_FILES", line 622
ORA-06512: at line 1
.
Action: Please contact your support representative.

HR_6882_HRPROC_ASSERT
LOCATION pyjavacom:2
APP-PAY-06882: Assertion failure detected at location pyjavacom:2.
Cause: an internal error has occurred at location pyjavacom:2.
Action: please contact your Oracle customer representative.

 =============

2nd Error:  The error that occurs when NOT suppressing the PDF: 

Stack Trace
-----------
020217_043428219][][EVENT] 314th document is merged
[020217_043428258][][STATEMENT] PDF template is being read and parsed......
[020217_043428258][][STATEMENT] PDFParser uses this tempDir ::: null
[020217_043428261][][STATEMENT] PDFParser.readPDFFile ---> contents size :
33177
[020217_043428262][][STATEMENT] This template's PDF version : 1.4
[020217_043428265][][STATEMENT] The template parsing is done......
[020217_043428266][][STATEMENT] FormInfoCollector is being initialized......
[020217_043428268][][STATEMENT] FormInfoCollector is being initialized......
[020217_043428271][][EVENT] 315th document is merged
[020217_043428317][][STATEMENT] PDF template is being read and parsed......
[020217_043428318][][STATEMENT] PDFParser uses this tempDir ::: null
[020217_043428321][][STATEMENT] PDFParser.readPDFFile ---> contents size :
33380
[020217_043428322][][STATEMENT] This template's PDF version : 1.4
[020217_043428325][][STATEMENT]
oracle.apps.xdo.template.pdf.exception.FatalException: The template seems to
be in either corrupted one or newer version than PDF1.4
at oracle.apps.xdo.template.pdf.Xref.initialize(Xref.java:294)
at oracle.apps.xdo.template.pdf.Xref.<init>(Xref.java:72)
at oracle.apps.xdo.template.pdf.PDFParser.initialize(PDFParser.java:262)
at oracle.apps.xdo.template.pdf.PDFParser.<init>(PDFParser.java:138)
at
oracle.apps.xdo.common.pdf.util.PDFDocMerger$PDFUtility.processWithNoOut(PDFDo
cMerger.java:2836)
at
oracle.apps.xdo.common.pdf.util.PDFDocMerger.generateMergedPDF(PDFDocMerger.ja
va:602)
at
oracle.apps.xdo.common.pdf.util.PDFDocMerger.mergeDocs(PDFDocMerger.java:540)
at
oracle.apps.xdo.common.pdf.util.PDFDocMerger.process(PDFDocMerger.java:492)
at
oracle.apps.xdo.common.pdf.util.StreamPDFDocMerger.process(StreamPDFDocMerger.
java:120)
at oracle.apps.pay.core.documents.DocPDFMerger.process(DocPDFMerger.java:86)
.
[020217_043428330][][STATEMENT] Temp File ::: /tmp/020217_043413841/xdo.tmp.0
has been deleted successfully...
[020217_043428330][][STATEMENT] Temp directory ::: /tmp/020217_043413841 has
been deleted successfully...
[020217_043428331][][STATEMENT] java.lang.Exception: Document #316 looks
corrupted.
at
oracle.apps.xdo.common.pdf.util.PDFDocMerger$PDFUtility.processWithNoOut(PDFDo
cMerger.java:2903)
at
oracle.apps.xdo.common.pdf.util.PDFDocMerger.generateMergedPDF(PDFDocMerger.ja
va:602)
at
oracle.apps.xdo.common.pdf.util.PDFDocMerger.mergeDocs(PDFDocMerger.java:540)
at
oracle.apps.xdo.common.pdf.util.PDFDocMerger.process(PDFDocMerger.java:492)
at
oracle.apps.xdo.common.pdf.util.StreamPDFDocMerger.process(StreamPDFDocMerger.
java:120)
at oracle.apps.pay.core.documents.DocPDFMerger.process(DocPDFMerger.java:86)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Generate Payroll Run
2. Generate Prepayments
3. Generate Archive
4. Generate Check Writer XML
5. Get error (s) noted above.

6.  Apply the solution as outlined in:  <Doc ID 1401298.1> W2 PDF Errors With: APP-PAY-06882: Assertion Failure Detected At Location pyjavacom:2. (Setting "Y" on the XDO to print).

7.  Generate the Check Writer XML.

8.  Receive the 2nd Error regarding PDFDocMerger.java.

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