Import on Sales Quota Plan (Doc ID 1936600.1)

Last updated on NOVEMBER 01, 2016

Applies to:

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

Symptoms

On : 11.1.8.0.0 version, File Import/Export

Not able to import quota successfully in Manage Sales Quotas

We are trying to import quotas for the territory and its resources from compressed csv files. We have followed the format(eg. no. of files, columns in each files etc) recommended by Oracle for Quota Import. But we are not able to import the quotas successfully.

ERROR
-----------------------
File Record Number,Import Job Id,System TaskId,Error Type,Error Message,Comments
1,300000026681940,300000026330082,ERROR,The value of the attribute Quota Plan Name and Territory Number is not valid.
2,300000026681940,300000026330082,ERROR,The value of the attribute Quota Plan Name and Territory Number is not valid.

 

MKT_IMP_ERRORS :

MOT_IMP_TERRITORY_QUOTAS FND_CMN_REQ_ATTRIB_API_SERV ATTRIBUTE_NAME TERRITORY_NUMBER
MOT_IMP_TERR_QUOTA_PERIODS FND_CMN_REQ_ATTRIB_API_SERV ATTRIBUTE_NAME TERRITORY_NUMBER

MOT_IMP_RESOURCE_QUOTAS FND_CMN_REQ_ATTRIB_API_SERV ATTRIBUTE_NAME TERRITORY_NUMBER
MOT_IMP_RESOURCE_QUOTA_PERIODS FND_CMN_REQ_ATTRIB_API_SERV ATTRIBUTE_NAME TERRITORY_NUMBER





STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. Login into Oracle Fusion Sales Cloud Applications.
2. Go to Navigator > Territories and Quotas
3. On left hand side, select Manage Sales Quotas.
4. In Edit Sales Quotas section >  Go to Action > Import > Import Sales Quotas
5. Select the compressed csv file (ZIP file) and upload. Click OK.

To view the import status:

6. In Edit Sales Quotas section
   Go to Action > Import > View Import Status

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import the Sales Quota

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