Create Effort Report Has Errors for Some Employees: "Task Name or Task Number could not be found for Task ID ####. The data corresponding to these records cannot be displayed in the Effort Report." (Doc ID 2848297.1)

Last updated on FEBRUARY 11, 2022

Applies to:

Symptoms

PSP: Create Effort Reports output shows errors for one or more employees. 

ERROR
-----------------------
"Task Name or Task Number could not be found for Task ID ####. The data corresponding to these records cannot be displayed in the Effort Report."

Also, errors are shown in the log file:

ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PAY_ARCHIVE", line 1145
ORA-06512: at "APPS.PSP_CREATE_EFF_REPORTS", line 1334
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PSP_CREATE_EFF_REPORTS", line 1288
ORA-06512: at "APPS.PSP_CREATE_EFF_REPORTS", line 120
ORA-06512: at "APPS.PSP_CREATE_EFF_REPORTS", line 102
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "APPS.PAY_ARCHIVE", line 1135
ORA-06512: at line 3

Cause:        an oracle error has occurred.  The failure was reported on table pay_archive.process_chunk at location 1609 with the error text ORA-06510: PL/SQL: unhandled user-defined exception

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01403: no data found
SQL_NO 1611
TABLE_NAME PAY_ASSIGNMENT_ACTIONS
APP-PAY-06881: Error ORA-01403: no data found has occurred in table PAY_ASSIGNMENT_ACTIONS at location 1611

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

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigation: Labor Distribution SuperUser Responsibility > Configure and Run Effort Report Templates
2. Search for template > Select Template > Enter Parameters > Click Continue
3. Schedule Request: Review > review parameters > Select Submit.
4. Process runs and errors

Changes

Cause

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