My Oracle Support Banner

On Timecard Dashboard: POST RETRIEVAL DASHBOARD ERRORS WHEN SEARCHING BY ORGANIZATION (Doc ID 2554779.1)

Last updated on MARCH 12, 2021

Applies to:

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

Symptoms

Error encountered on the Post Retrieval area of the Timecard Retrieval Dashboard when passing the following parameters:
Timecard Start/Stop Dates and Organization.


ERROR
-----------------------
Exception Details.
 oracle.apps.fnd.framework.OAException: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
ORA-06512: at "APPS.HXC_RDB_POST_RETRIEVAL", line 1918
ORA-06512: at line 2



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. While accessing the Timecard Retrieval Dashboard with the following parameters:
  Timecard Start/Stop Dates and Organization.

2.  Facing the above mentioned 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.