My Oracle Support Banner

Retropay by Element Errors: APP-PAY-6881: Error ORA-1405: fetched column value is NULL has occurred in table process_recorded_date at location 1572 (Doc ID 2379152.1)

Last updated on MARCH 27, 2018

Applies to:

Oracle Payroll - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Error is received for some assignments when running Retropay by Element.


ERROR
-----------------------
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01405: fetched column value is NULL

SQL_NO 1572
TABLE_NAME process_recorded_date
APP-PAY-06881: Error ORA-01405: fetched column value is NULL
has occurred in table process_recorded_date at location 1572

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run Retropay by Element



Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.