My Oracle Support Banner

Payroll Fails With APP-PAY-51118, ORA-01403 & APP-PAY-06881 in FF_DATABASE_ITEMS (Doc ID 2398372.1)

Last updated on AUGUST 08, 2023

Applies to:

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


When attempting to run payroll, the following error occurs in the process log.

ASGNO <assignment number>
APP-PAY-51118: Error was encountered when processing assignment <assignment number>
SQLERRMC ORA-01403: no data found
TABLE_NAME ff_database_items
APP-PAY-06881: Error ORA-01403: no data found has occurred in table ff_database_items at location <location number>
Cause: an oracle error has occurred. The failure was reported on table ff_database_items at location <location number> with the error text ORA-01403: no data found
Action: Please contact your support representative.

The issue can be reproduced at will with the following steps:

    1. Run payroll.
    2. Check the log.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.