FBL Salary VO Load Fails With JBO-29000: Unexpected Exception Caught (Doc ID 1608126.1)

Last updated on SEPTEMBER 14, 2017

Applies to:

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

Symptoms

On : 11.1.5.0.0 version, File Based Loader (FBL)

When attempting to load an employee's salary using File Based Loader, an error occurred indicating that an Assignment ID must be supplied.

The Assignment ID for the person record has been passed in the dat file.

When reviewing the attributes by drilling down to the errored record on the Data Exchange screen, the Assignment ID that was passed in the dat file has been changed to a different value that does not exist for the person.


ERROR
-----------------------
  > Errors
  JBO-29000
Class of Error = You must provide a value for the attribute AssignmentID

Detail shows:

oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.apps.fnd.applcore.messages.ApplcoreException, msg=JBO-FND:::FND_CMN_REQ_ATTRIB_API_SERV: You must provide a value for the attribute AssignmentId. at oracle.apps.hcm.common.batchLoader.core.common.BaseCallback.callServiceMethod(BaseCallback.java:1056) at oracle.apps.hcm.common.batchLoader.core.model.applicationModule.ServiceWriterAMImpl.callServiceMethod(ServiceWriterAMImpl.java:1931) at
...

Detail 1 ## java.lang.Throwable: Calling createSalary in oracle.apps.hcm.compensation.salary.core.salaryService.applicationModule.SalaryAM
name: 'SalaryId', value: '100000000123456';
type: java.lang.Long name: 'ActionId', value: '300000000123456';
type: java.lang.Long name: 'ActionOccurrenceId', value: '0';
type: java.lang.Long name: 'AssignmentId', value: '100000000123456';
type: java.lang.Long name: 'BusinessGroupId', value: '1';
type: java.lang.Long name: 'DateFrom', value: '2013-01-01';
type: java.sql.Date name: 'DateTo', value: '2012-12-31';
type: java.sql.Date name: 'MultipleComponents', value: 'N';
type: java.lang.String name: 'SalaryAmount', value: '1';
type: java.math.BigDecimal name: 'SalaryApproved', value: 'Y';
type: java.lang.String name: 'SalaryBasisId', value: '300000001162760';
type: java.lang.Long at oracle.apps.hcm.common.batchLoader.core.model.applicationModule.ServiceWriterAMImpl.callServiceMethod(ServiceWriterAMImpl.java:1949)

Once the AssignmentID Attribute is corrected and the file is resubmitted, the following error occurs:
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.jbo.JboException, msg=JBO-29115 Unable to construct the error message due to error java.lang.IllegalArgumentException: can't parse argument number END_DATE. Use the exception stack trace and error code to investigate the root cause of this exception. Root cause error code is JBO-. at oracle.apps.hcm.common.batchLoader.core.common.BaseCallback.callServiceMethod(BaseCallback.java:1056)
...
## Detail 1 ##
java.lang.Throwable: Calling createSalary in oracle.apps.hcm.compensation.salary.core.salaryService.applicationModule.SalaryAM
name: 'SalaryId', value: '100000000123456'; type:
java.lang.Long name: 'ActionId', value: '300000000123456'; type:
java.lang.Long name: 'ActionOccurrenceId', value: '0'; type:
java.lang.Long name: 'AssignmentId', value: '30000000123456'; type:
java.lang.Long name: 'BusinessGroupId', value: '1'; type:
java.lang.Long name: 'DateFrom', value: '2013-01-01'; type:
java.sql.Date name: 'DateTo', value: '4712-12-31'; type:
java.sql.Date name: 'MultipleComponents', value: 'N'; type:
java.lang.String name: 'SalaryAmount', value: '1'; type:
java.math.BigDecimal name: 'SalaryApproved', value: 'Y'; type:
java.lang.String name: 'SalaryBasisId', value: '300000001162760'; type:
java.lang.Long at oracle.apps.hcm.common.batchLoader.core.model.applicationModule.ServiceWriterAMImpl.callServiceMethod(ServiceWriterAMImpl.java:1949)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load batch data for Salary_VO
2. Navigator > Data Exchange > Load Batch Data
3. Review details for the batch.
Find error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot load Salary data.



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