Payroll Checkwriter Generic, Errors: 'ORA-01405: fetched column value is NULL' or 'XML Parsing Error: not well-formed'; or Both the XML and PDF files are Printed (Doc ID 1417510.1)

Last updated on JULY 11, 2016

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.

***Checked for relevance on 10-Sep-2013***

This note provides a brief overview of


Symptoms

Problem Statement:

When running the Check Writer(Generic) one of the following issues is seen: 

Issue 1:


Both the XML and PDF output types are being printed

Issue 2:

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01405: fetched column value is NULL

SQL_NO 1620
TABLE_NAME pay_core_files.read_from_clob_raw
APP-PAY-06881: Error ORA-01405: fetched column value is NULL
has occurred in table pay_core_files.read_from_clob_raw at location 1620

Cause: an oracle error has occurred. The failure was reported on
table pay_core_files.read_from_clob_raw at location 1620 with the error text
ORA-01405: fetched column value is NULL


Issue 3:

XML Parsing Error: not well-formed



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