Error when Running the Element Register Report: ORACLE error 6502 in FDPSTP (Doc ID 1931150.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle Payroll - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.0.6 version, Core Reports

When attempting to run the Element Register Report, the following error occurs.

ERROR
-----------------------
+---------------------------------------------------------------------------+

**Starts**24-JUL-2013 16:31:19
ORACLE error 6502 in FDPSTP

Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "APPS.PAY_ELEMENT_EXTRACT_PKG", line 1487
ORA-06512: at line 1
.

The SQL statement being executed at th
+---------------------------------------------------------------------------+


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Element Register Report
Beginning Date PAid : 1-jan-2013
ending Date PAid: 15-Jan-2013
selection criterion: Element Classification
Element Classification: Earnings or Involuntary Deductions
output file : HTML

Parameters:
Beginning date Paid : Mandatory
Ending Date Paid : Mandatory
Selection Criterion : Mandatory

Element Classification
Element Name
Element Set

As per the above list, report fails for all the selection criterion.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms