My Oracle Support Banner

Import Plan Fails With Error "Error In Interval Setup Data" (Doc ID 2726208.1)

Last updated on DECEMBER 08, 2020

Applies to:

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


On : version, Compensation Plans

When attempting to run the Compensation Plan Import Process,
the following error occurs.


From import logs, you will see the below error:

Encountered GoalsVORow. Calling importGoal()
Same Date range, same number of periods, copying targets as-is.
Error in Interval Setup Data. Ensure the Interval Numbers match between the source and target Environments, for the AccumulationInterval 'July-June', for the duration of the Import process' Start and End dates.
Error in method : importGoal()

From ESS_SOAServer you will see the below error:

crmCommon.core.fileImport.util.FileImportEssUtil] java.lang.NullPointerException[[
at oracle.apps.crmCommon.core.fileImport.util.FileImportEssUtil.submitESSSubRequest(
at oracle.apps.crmCommon.core.fileImport.util.FileImportEssUtil.invokeLogGeneration(
at oracle.apps.crmCommon.core.fileImport.ess.program.FileImportDaemonProcess.execute(
at oracle.apps.fnd.applcp.request.exec.ExecutableWrapper.executeHelper(
at oracle.apps.fnd.applcp.request.exec.ExecWrapperBase.execute(
at oracle.apps.fnd.applcp.request.exec.ExecutableWrapper.execute(


The issue can be reproduced at will with the following steps:
1. Export compensation plan from the source instance
2. Import into the target instance
  Navigator > Compensation Plans > Processes > Manage Compensation Plan Import Processes > Create Compensation Plan Import Process

Note: This issue is reproducible ONLY when for any measure which belongs to an interval spanning across 2 years.


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.