My Oracle Support Banner

Error in viewing Timecard Status Dashboard (Doc ID 2502321.1)

Last updated on SEPTEMBER 08, 2019

Applies to:

Oracle Time and Labor - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Timecard Dashboards

When attempting to access Timecard Status Dashboard, the following error occurs.

ERROR
-----------------------
You have encountered an unexpected error. Please contact the System Administrator for assistance.

And the exception details shows

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM (SELECT
 ppf.person_id,
 ppf.full_name,
 nvl(ppf.employee_number,
 ppf.npw_number) employee_number,
 u.user_id
FROM
 fnd_user u,
 per_people_f ppf,
 per_person_types ppt    ,
 per_person_type_usages_f pptu
WHERE
 TRUNC(SYSDATE) BETWEEN ppf.effective_start_date AND
 ppf.effective_end_date    AND
 TRUNC(SYSDATE) BETWEEN pptu.effective_start_date AND
 pptu.effective_end_date    AND
 u.employee_id(+) = ppf.person_id AND
 pptu.person_id = ppf.person_id  AND
 ppt.person_type_id = pptu.person_type_id   AND
 ppt.system_person_type IN ('EMP','EMP_APL','CWK')) QRSLT  WHERE (person_id = :1)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)

## Detail 0 ##
java.sql.SQLException: ORA-20001: PER_449800_ORA_1436:
ORA-06512: at "APPS.FND_MESSAGE", line 509
ORA-06512: at "APPS.HR_SECURITY_INTERNAL", line 5687
ORA-06512: at "APPS.HR_SECURITY_INTERNAL", line 7918
ORA-06512: at "APPS.HR_SECURITY_INTERNAL", line 8630
ORA-06512: at "APPS.HR_SECURITY", line 623
ORA-06512: at "APPS.HR_SECURITY", line 2765

 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Manager Self Service > Timecard Status Dashboard
2. Get the error

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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