Cannot Open Existing Or Create New Timecards In OTL After Applying RUP8 (Doc ID 2095345.1)

Last updated on MARCH 30, 2016

Applies to:

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

Symptoms

On : 12.1 HRMS RUP8 version, OTL Setup forms.

After applying RUP8 we can no longer open / update existing OTL timecards nor can we create new ones.

When trying to create a New timecard, Facing the error as shown below:

Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select task_number display_value, task_id value, project_id
from pa_online_tasks_v) QRSLT WHERE (Value = :1 and to_char(DisplayValue) = :2) ORDER BY display_value

When trying to view/update existing timecard:

Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select task_number display_value, task_id value, project_id
from pa_online_tasks_v) QRSLT WHERE (Value = :1 and to_char(DisplayValue) = :2) ORDER BY display_value

 

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

1. Responsibility: Construction Nth AU OTL Payroll Timesheet View
2. NAV: Choose employee from list
3. Enter Project, Task, Type, Start Time and Hours
4. Click continue and see the Exception/error details.


The issue was not happening prior to .

Changes

 Applied 12.1 RUP8

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