Automatic Timecard Generation Process Fails APP-FND-01564 Oracle Error 936 In Fdlget (Doc ID 1914141.1)

Last updated on JULY 15, 2016

Applies to:

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

Symptoms

On : 12.2.3 version, OTL Automatic Timecard Generation Process

After upgrade to 12.2.3
When attempting to run the process "Automatic Timecard Generation" one of the parameters is the Time Period. This field generates it's list of values from the payroll periods as defined in the Payroll description.
The payroll periods are setup, but the error is occuring :

ERROR
-----------------------

APP-FND-01564 Oracle error 936 in fdlget
Cause: fdlget failed due to ORA-00936 missing expression

The SQL statement being executed at the time of the error
was: Select PTP.TIME_PERIOD_ID,PTP.PERIOD_NAME value,
PTP.Period_NAME Description, NVL('N','N'),
NVL(TO_NUMBER(NULL),-1),NULL,NVL('Y','Y'),
NVL(TO_CHAR(TO_DATE(NULL),'J',0),
NVL(TO_CHAR(TO_DATE(NULL),'J',0),  
FND_DATE.DATE_TO_CHARDATE(DATEVAL=>PTP.START_DATE,CALENDAR_AWARE=>1) "Start Date",
FND_DATE.DATE_TO_CHARDATE(DATEVAL=>PTP.END_DATE,CALENDAR_AWARE=>1) "End Date",
FROM PER_TIME_PERIODS PTP WHERE(
PTP.PAYROLL_ID = :A0 ) and 'Y'='Y' AND TO_DATE):A10,
'YYY/MM/DD HH24:MI:SS) BETWEEN NVL(TRUNC(TO_DATE(NULL)),
TO_DATE(:A11,'YYYY/MM/DD HH24:MI:SS')) AND
NVL(TRUNC(TO_DATE(NULL)), TO_DATE(:A12,'YYYY/MM/DD HH24:MI:SS')) ORDER BY PTP.START_DATE

WAS EXECUTED FROM THE FILE &ERRFILE



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. US Time and Labor Rules Manager
> Processes and Reports > Submit Requests (Single Request)
2. Request Name: Automatic Time Card generation
3. Parameter   Name = Automatic Time card Generation
4. Parameter  Time Period (mandatory) = Click on LOV and error occurs

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Cust is not able to submit concurrent manager process Automatic Timecard Generation. This will affect payroll processes if not resolved before go live.
This problem has been experienced in some of upgraded instances but not all.

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