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

Last updated on MARCH 01, 2017

Applies to:

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

Symptoms

When attempting to run Retropay (enhanced), the following error occurs.
  
Error

  HR_6881_HRPROC_ORA_ERR
  SQLERRMC ORA-1405: fetched column value is NULL
  
  SQL_NO 1572
  TABLE_NAME process_recorded_date
  APP-PAY-6881: Error ORA-1405: fetched column value is NULL  has occurred in table process_recorded_date at location 1572
  
  Cause: an oracle error has occurred. The failure was reported on  table process_recorded_date at location 1572 with the error text ORA-1405:  fetched column value is NULL  .
  
  Action: Please contact your support representative.


Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Use UK HRMS Responsibility
2. Run retropay (enhanced) => observe the error

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