My Oracle Support Banner

After Running An FPS - 3 ORA Errors That Do Not Specify What The Issue Is (Doc ID 1946345.1)

Last updated on FEBRUARY 24, 2019

Applies to:

Oracle HRMS (UK) - Version 12.1 and later
Information in this document applies to any platform.


Have applied the latest FPS patchest. Used GB Rollback to rollback the FPS (using latest patches) and have run it again. There are three errors.
Running the RTI - Full Payment Submission Process (FPS) 2014/15 using UK Super HRMS Manager
The report has processed 33580 records successfully but 3 have completed with error
This is all individuals that are multiple assignments in period so they have a terminated non dash and a new -2 that is either still at a status of new hire or is active but no payment run has been made.

The -2 individuals all have an entry for the RTI process on the Assignment Process results screen.

"ORA-06512 at APPS_PAY_ARCHIVE line 1207 (1 individual)
ORA-20001 an error encountered was - ORA 01403 - no data found (2 individuals)"

The issue can be reproduced at will with the following steps:
1. <Patch 18776254:R12.PAY.B> - latest RTI consolidated patch has been applied
2. Use GB Rollback
3. Run FPS
4. Error is raised




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.