My Oracle Support Banner

Retropay (Enhanced) Errors: 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 MAY 01, 2018

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:
Run Retropay (Enhanced) => observe the error

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.