Security List Maintenance Shows ORA-01403: no data found has occurred in table PAY_CONSOLIDATION_SETS at location 1504 Error when Running from Custom Responsibility

(Doc ID 2127198.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP8 and later
Information in this document applies to any platform.


On : 12.1 HRMS RUP8 version, Security Issues

When attempting to run Security List Maintenance concurrent program with a custom HR responsibility, the following error occurs.

MSL_PERSON_LIST module: Maintain Person Security List information(Internal)

Current system time is 29-MAR-2016 08:57:45


SQLERRMC ORA-01403: no data found

SQL_NO 1504
APP-PAY-06881: Error ORA-01403: no data found
 has occurred in table PAY_CONSOLIDATION_SETS at location 1504

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

Action: Please contact your support representative.

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

  1. Navigation: Custom Responsibility  > Processes and Reports > Submit Processes and Reports > Security List Maintenance



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