My Oracle Support Banner

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

Last updated on NOVEMBER 08, 2017

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

To view full details, 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 a vibrant support community of peers and Oracle experts.