My Oracle Support Banner

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 JANUARY 02, 2018

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.


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

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
Goal
Solution


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