My Oracle Support Banner

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

Last updated on JUNE 20, 2018

Applies to:

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

Symptoms

On : 11.12.1.0.0 version, Global Payroll

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.

ERROR
-----------------------
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







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!


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