Quickpay erroring with : HR_51118_HRPROC_ERR_OCC_ON_ASG Error ORA-01403: no data found in ff_database_items (Doc ID 1499312.1)

Last updated on JULY 11, 2016

Applies to:

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

Goal


User has transfered fast formulas and parameters for setting up a new payroll to a new environment.
The new payroll is running successfully, but the old one (the one already existing in the environment) now errors where before it didn't.


Error Codes
---------------------------------------------------
APP-PAY-51118, APP-PAY-06881, APP-PAY-06882, HR_51118_HRPROC_ERR_OCC_ON_ASG

 

Log file shows :

HR_51118_HRPROC_ERR_OCC_ON_ASG
ASGNO 48
APP-PAY-51118: Error was encountered when processing assignment 48
     In  { pyxipmt
message text = Error was encountered when processing assignment 48
message level = F,F
payroll_id text = 81
source_id text = 6,730523
line_text = 51, Error was encountered when processing assignment 48
     Out } pyxipmt
     In  { pylogpop
     Out } pylogpop
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01403: no data found

SQL_NO 552
TABLE_NAME ff_database_items
APP-PAY-06881: Error ORA-01403: no data found
has occurred in table ff_database_items at location 552

Cause:        an oracle error has occurred.  The failure was reported on table ff_database_items at location 552 with the error text ORA-01403: no data found
.  

Action:        Please contact your support representative.


When running quickpay
 

Solution

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