My Oracle Support Banner

OTL: Rollback OTLR Timecards' Is Ending In Error: ORA-06502: PL/SQL: numeric or value error ORA-06512: at "APPS.HXT_RETRIEVAL_ROLLBACK", line 3134 - Bug 20424160 (Doc ID 1969128.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Configured Timecard Layouts

When attempting to run the concurrent request: 'OTL: Rollback OTLR Timecards ,
the following error occurs.

ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.HXT_RETRIEVAL_ROLLBACK", line 3134
ORA-06512: at "APPS.HXT_RETRIEVAL_ROLLBACK", line 3458


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the Concurrent Request: OTL Rollback OTLR Timecards with the following parameters:

Request Details
Name: OTL Rollback OTLR Timecards
Parameters:
Phase: Completed
Status: Error
Date Submitted:
Requestor:
Date Started:
Date Completed:
Completion Text: ORACLE error 6502 in FDPSTP Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric


2. Receive error:

ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.HXT_RETRIEVAL_ROLLBACK", line 3134
ORA-06512: at "APPS.HXT_RETRIEVAL_ROLLBACK", line 3458


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot rollback timecard batches

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.