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.

Symptoms

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.

ERROR
-----------------------
MSL_PERSON_LIST module: Maintain Person Security List information(Internal)
+---------------------------------------------------------------------------+

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

+---------------------------------------------------------------------------+

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01403: no data found

SQL_NO 1504
TABLE_NAME PAY_CONSOLIDATION_SETS
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

 

Cause

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