My Oracle Support Banner

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

Last updated on OCTOBER 01, 2020

Applies to:

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

Symptoms

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

ACTUAL BEHAVIOR
---------------
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


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


NOTED
---------------
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: 10.1.3.4.2
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(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
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(DataTemplate.java:334)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
at oracle.apps.fnd.cp.request.Run.main(Run.java:156)


STEPS
-----------------------
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



BUSINESS IMPACT
-----------------------
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

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
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.