My Oracle Support Banner

Data Missing From OTL: Time Entry Detail Report (Doc ID 2716456.1)

Last updated on DECEMBER 09, 2022

Applies to:

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


On : 12.2.5 HRMS RUP 13 version, in all instances,

When attempting to run the Time Entry Detail Report for an employee, it is observed that only 1
timecard is returned, when the employee actually has 132 timecards

Data from timecards is stored in a new table HXT_DET_HOURS_RPT.
In the case of this employee, she has 132 timecards, but only 1 timecard detail record in this table

It is expected that the table and the report contain all of the employee's timecards

When the report is run with the profile option set to Y,
the following error is seen:

Time and Labor: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

HXTDETRPT: OTL: Time Entry Detail Report

Current system time is 13-APR-2020 15:17:57


XDO Data Engine Version No:
Resp: 22884
Org ID : 101
Request ID: 36691259
All Parameters: P_FROM_DATE="1950/01/01 00:00:00":P_TO_DATE="2020/12/31 00:00:00":P_PERSON_ID=40558:P_ORGANIZATION_ID=:P_PAYROLL_ID=
Data Template Code: HXTDETRPT
Data Template Application Short Name: HXT
Debug Flag: N
{P_ORGANIZATION_ID=, P_PERSON_ID=40558, P_PAYROLL_ID=, P_TO_DATE=2020/12/31 00:00:00, P_FROM_DATE=1950/01/01 00:00:00}
Calling XDO Data Engine...
[041320_151807864][][EXCEPTION] SQLException encounter while executing data trigger....
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.HXT_DET_HRS_WORKED_RPT", line 215
ORA-06512: at "APPS.HXT_DET_HRS_WORKED_RPT", line 43
ORA-06512: at line 4

at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CCallableStatement.doOall8(
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.execute(
at oracle.jdbc.driver.OracleCallableStatement.execute(
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(
at oracle.apps.xdo.dataengine.XMLPGEN.executeTriggers(Unknown Source)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(Unknown Source)
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(Unknown Source)
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(Unknown Source)
at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(Unknown Source)
at oracle.apps.xdo.dataengine.DataProcessor.processData(Unknown Source)
at oracle.apps.xdo.oa.util.DataTemplate.processData(
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(
at oracle.apps.fnd.cp.request.Run.main(

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

1. Run the time entry details report for an employee
2. Observe that only 1 timecard is returned when the employee has 132 timecard

The issue has the following business impact:
Due to this issue, users cannot get accurate report output from the Time Entry Detail report for an employee


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

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