Import Goals : There are no rows to process in the staging table, please verify End of cn_srp_goals_upload.goals_upload (Doc ID 1960078.1)

Last updated on OCTOBER 09, 2015

Applies to:

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

Symptoms

Participant Goal import process completed with the following error :
    There are no rows to process in the staging table, please verify
    End of cn_srp_goals_upload.goals_upload

Navigator > Participant Assignments > Import Participant Goals

Request Import participant Goals to Staging completed with Warning status.
Log file ESS_L_22871 shows:
TRAILING NULLCOLS option in effect

  Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
BUSINESS_UNIT                       FIRST     *   ,  O(") CHARACTER            
TERRITORY                            NEXT     *   ,  O(") CHARACTER            
IMPORT_LANG                          NEXT     *   ,  O(") CHARACTER            
MEASURE_NAME                         NEXT     *   ,  O(") CHARACTER            
INTERVAL_NAME                        NEXT     *   ,  O(") CHARACTER            
START_DATE                           NEXT     *   ,  O(") CHARACTER            
   SQL string for column : "to_date(:START_DATE, 'YYYY/MM/DD')"
END_DATE                             NEXT     *   ,  O(") CHARACTER            
   SQL string for column : "to_date(:END_DATE, 'YYYY/MM/DD')"
TARGET                               NEXT     *   ,  O(") CHARACTER    
... etc ...
value used for ROWS parameter changed from 64 to 37
Record 1: Rejected - Error on table CN_SRP_GOALS_STAGING_T, column START_DATE.
ORA-01843: not a valid month
Record 2: Rejected - Error on table CN_SRP_GOALS_STAGING_T, column START_DATE.
ORA-01843: not a valid month
... etc ...
Table CN_SRP_GOALS_STAGING_T:
 0 Rows successfully loaded.
 51 Rows not loaded due to data errors.
 0 Rows not loaded because all WHEN clauses were failed.
 0 Rows not loaded because all fields were null.


Request Collect Participants Goals completed with Error status.
Completion Text shows:
There are no rows to process in the staging table, please verify
Log file shows:  There are no rows to process in the staging table, please verify  End of cn_srp_goals_upload.goals_upload


Sample data from zip file :
*Business Unit,Territory,Language,*Measure (Goal Name),Performance Interval,*Start Date,*End Date,*Goal (Quota),Currency Code,*Unit of Measure,*Participant,Party Number,Party ID,E-Mail Address,Person Number,Participant Measure Alternate Target 1,Participant Measure Alternate Target 2,Participant Measure Alternate Target 3,Participant Measure Alternate Target 4,Participant Measure Alternate Target 5,Update All Occurrences,Participant Plan Name,Participant Plan Component Name,END
MyCompany Inc BU,,,"Accelerator Payout PS with TCV - AC 1.5,2.5,1.25",Month,12/31/13 4:00 PM,1/30/14 4:00 PM,149898.8,,Amount,Tracey F,2006,,,,,,,,,,2014 Plan Group 12 - PS F,"IB1 PS with TCV - AC 1.5,2.5,1.25",
MyCompany Inc BU,,,"Accelerator Payout PS with TCV - AC 1.5,2.5,1.25",Month,1/31/14 4:00 PM,2/27/14 4:00 PM,191870.46,,Amount,Tracey F,2006,,,,,,,,,,2014 Plan Group 12 - PS F,"IB1 PS with TCV - AC 1.5,2.5,1.25",
MyCompany Inc BU,,,"Accelerator Payout PS with TCV - AC 1.5,2.5,1.25",Month,2/28/14 4:00 PM,3/30/14 4:00 PM,257825.94,,Amount,Tracey F,2006,,,,,,,,,,2014 Plan Group 12 - PS F,"IB1 PS with TCV - AC 1.5,2.5,1.25",

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