Failure To Produce Retro Element Entry Report
Last updated on MAY 01, 2017
Applies to:Oracle Fusion Global Payroll Cloud Service - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.0 version, Global Payroll
When attempting to run ‘Run XXX Retro Element Entry Report’ for April 2017, the process failed with error.
Cannot access the PDF report. Tried to access the report from OBI but received a java error.
java.sql.SQLDataException: ORA-01830 date format picture ends before converting entire input sting
and Erorr in BI log:
dummy file is deleted
================ BIPJobExecutable Execution Started ============
OutputFile : /u01/APPLTOP/instance/ess/rfd/169020/out/169020.xml
Request ID: 169020 ClassLoader is weblogic.utils.classloaders.GenericClassLoader@22e80d0c finder: weblogic.utils.classloaders.CodeGenClassFinder@22e80d85 annotation: HcmEssApp#V2.0@
ReportID : /Custom/Human Capital Management/XXX Payroll Reports/Reports/Payroll - Retro Element Entry Listing Report.xdo
================ BIPJobExecutable Execution failed with Client received SOAP Fault from server : PublicReportService::generateReportDefinition for reportAbsolutePath [/Custom/Human Capital Management/XXX Payroll Reports/Reports/Payroll - Retro Element Entry Listing Report.xdo] Failure: Due to oracle.xdo.servlet.CreateException: Report definition not found:/Custom/Human Capital Management/XXX Payroll Reports/Reports/Payroll - Retro Element Entry Listing Report.xdo [username=fusion_apps_hcm_ess_appid] ============
dummy file is deleted
The issue can be reproduced at will with the following steps:
1. Run XXX Retro Element Entry Report
2. Click Go to Task on third row
• Processes and Reports tab, click on glasses then the pdf link
The issue has the following business impact:
Due to this issue, payroll department is unable to validate the results and therefore they cannot calculate payroll effecting the whole population,.Employees will not be paid unless they can validate the retro data.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms