My Oracle Support Banner

Fusion Global Payroll: Error Loading Batch For Automation Payroll Batch Loader Using Flow Action Webservices (Doc ID 2413257.1)

Last updated on APRIL 17, 2019

Applies to:

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


User is integrating SOA with PBL Automation Web service and created custom process flow which includes both Load Batch & Transfer Batch into one flow as per note Fusion Payroll: Payroll Batch Loader - Documentation about Load Batch from File (Doc ID 2014778.1)
When attempting to submit the flow using flow action web services, it returns true but the Load Batch is failing and the following error occurs.

batchErrorModeSql : select nvl(nvl((select papv.PARAMETER_VALUE from PAY_ACTION_PARAM_VALUES papv where papv.parameter_name = ? and papv.ACTION_PARAM_GROUP_ID = ?), (select papdv.PARAMETER_VALUE from PAY_ACTION_PARAM_GROUPS papg, PAY_ACTION_PARAM_VALUES papdv where papg.ACTION_PARAM_GROUP_NAME= ? and papdv.ACTION_PARAM_GROUP_ID=papg.ACTION_PARAM_GROUP_ID and papdv.parameter_name = ? )),'ANY') parameter_value FROM dual
LOAD Status: Error
Errors :

External Bank Account|Create External Bank Account...............
ORA-01403: no data found


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.