My Oracle Support Banner

Fusion Global Payroll - Recalculate Payroll For Retroactive Changes Error - Date format picture ends before converting entire input string (Doc ID 2762573.1)

Last updated on MARCH 22, 2021

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.21.01.0 and later
Information in this document applies to any platform.

Symptoms

Symptoms
-----------
Receiving error message for specific employees when running the Recalculate Payroll for Retroactive Changes process:
 
Error message(s)
-------------
A system error ORA-01830: date format picture ends before converting entire input string ORA-06512: at "FUSION.PAY_RETRO_PKG", line 423 ORA-06512: at line 1 occurred in table pay_retro_pkg.get_retro_act_start_date at location 4578. Contact your help desk.
 
 
Steps to reproduce
---------------
The issue can be reproduced at will with the following steps:
1. Run the Recalculate Payroll for Retroactive Changes process
2. With parameters:
Process Date=3/20/2021
Process Configuration Group=Logging Group
3. Observe, the process ends in error.

Expected Behavior
------------
Recalculate Payroll for Retroactive Changes process should complete without error.

Changes

 

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