My Oracle Support Banner

Employee Resource Export JBO-25060: Unexpected error encountered while trying to retrieve the next row from JDBC ResultSet for collection EmployeeResourceExpVO (Doc ID 2401854.1)

Last updated on MAY 22, 2018

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Employee Resource Export error.


ERROR MESSAGE ( from export diagnostic )
Exception while Exporting Object - idHzEmployeeResourceExpVO. Exception - JBO-25060: Unexpected error encountered while trying to retrieve the next row from JDBC ResultSet for collection EmployeeResourceExpVO_104747

 

More details in BATCH__TASK_2018-05-19-16_44_33.csv included in export_300000215731865_2018-05-19-16_44_33_Diagnostics.zip
See the following error:
TASK_ID,PARENT_TASK_ID,EXPORT_JOB_ID,EXPORT_BATCH_ID,TASK_TYPE_CD,OBJECT_CODE,STATUS,ERROR_MESSAGE,START_TM,END_TM,VIEW_NAME,TASK_DETAILS_1,TASK_DETAILS_2,TASK_DETAILS_3,TASK_DETAILS_4,TASK_DETAILS_5,TASK_NUMBER_1,TASK_NUMBER_2,TASK_NUMBER_3,TASK_NUMBER_4,TASK_NUMBER_5,MESSAGE_TYPE,MESSAGE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER
"300000215731866",,"300000215691816","300000215731865","VIEW2CSV","idHzEmployeeResourceExpVO","ERROR","An error occurred while exporting the view 300000215780819.idHzEmployeeResourceExpVO.EmployeeResourceExpVO. (ZCA-210043)","2018-05-19 16:12:10.380000","2018-05-19 16:12:00.000000","EmployeeResourceExpVO",,,,,,"1000","70000","2000",,,,,"2018-05-19 16:12:10.019000","osc.integrations","2018-05-19 16:12:11.777000","osc.integrations","67BAE5A8D4E5EC97E053946F660AE638","5",
"300000215731867",,"300000215691816","300000215731865",,,,,,,,,,,,,,,,,,"ERROR","Exception while Exporting Object - idHzEmployeeResourceExpVO. Exception - JBO-25060: Unexpected error encountered while trying to retrieve the next row from JDBC ResultSet for collection EmployeeResourceExpVO_104747","2018-05-19 16:12:11.771000","osc.integrations","2018-05-19 16:12:11.773000","osc.integrations","67BAE5A8D4E5EC97E053946F660AE638","1",
"300000215731868",,"300000215691816","300000215731865","VIEW2CSV","idHzPersonExpPVO","COMPLETE_WITH_ERRORS",,"2018-05-19 16:12:12.139000","2018-05-19 16:12:43.496000","PersonExpPVO","21",,,,,"86207","11293117","0","4105","537767",,,"2018-05-19 16:12:11.780000","osc.integrations","2018-05-19 16:12:43.152000","osc.integrations","67BAE5A8D4E5EC97E053946F660AE638","91",



STEPS
Navigator > Setup and Maintenance > Schedule Export Processes ( object= idHzEmployeeResourceExpVO )

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.