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

Last updated on DECEMBER 09, 2022

Applies to:

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

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