FUSION Payroll: Error Calling Payroll Batch Loader From Web Services

(Doc ID 1928267.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

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

Symptoms

While automating Payroll Batch Loader (PBL) using web service FlowActionsService, getting error:

ERROR
****************************************LOAD BATCH FROM FILE****************************************
Parameters:
batchId:100000001897256
ldgId:300000000912204
ucmId:UCMFA004711
formulaId:null
actionParameterGroupId:300000000106269
docStreamBinder UserDateFormat: iso8601
 UserTimeZone: UTC

responseWithDocStream oracle.stellent.ridc.protocol.ServiceResponse@17dc9c5f
stream oracle.stellent.ridc.common.io.CloseNotifyInputStream@17dc9c67
Got the Doc Streamoracle.stellent.ridc.common.io.CloseNotifyInputStream@17dc9c67
created the batch with header:100000001897256
Attachment initialized...
threadCountSql : 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 = ? )),1) parameter_value FROM dual
encryption Type::1
docStreamBinder UserDateFormat: iso8601
 UserTimeZone: UTC

responseWithDocStream oracle.stellent.ridc.protocol.ServiceResponse@1773f721
stream oracle.stellent.ridc.common.io.CloseNotifyInputStream@1773f729
Reading file content :456
UCM content retreived to /tmp/ucmContent_32922
Decrypting file of type1
Error in CLOB Creation
CLOB Creation Errors :
======================
java.lang.NullPointerException
at oracle.apps.hcm.connect.lite.cryptoprocessor.sdk.service.CryptoService.decrypt(CryptoService.java:185)
at oracle.apps.hcm.interfaces.batch.ess.program.LoadBatchFromFile.decrypt(LoadBatchFromFile.java:636)
at oracle.apps.hcm.interfaces.batch.ess.program.LoadBatchFromFile.populateClob(LoadBatchFromFile.java:589)
...


The web service is called with the following code:

  


Cause

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 hundreds of Community platforms