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.
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 :
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'),
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
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms