Oracle Sales Cloud: Error ORA-06512 When Adding To Territory Proposal (Doc ID 2586504.1)

Last updated on MARCH 18, 2024

Applies to:

Symptoms

On : 11.13.19.01 version, Territory Management, Quotas

When attempting to Create a new territory proposal
the following error occurs.

ERROR
-----------------------
ORA-20101: Profile QSC_SALES_PRODUCTS_INVENTORY_ORG_ID is not set ORA-06512: at "FUSION.MOT_COVERAGE_SYNC", line 151 ORA-06512: at "FUSION.MOT_COVERAGE_SYNC", line 698 ORA-06512: at "FUSION.MOT_COVERAGE_SYNC", line 863 ORA-06512: at "FUSION.MOT_COVERAGE_SYNC", line 1962 ORA-06512: at "FUSION.MOT_TERR_UTIL", line 2298 ORA-06512: at "FUSION.MOT_TERR_UTIL", line 10366 ORA-06512: at line 1
Error
An error occurred. Contact your help desk. (FND-2)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. go to Manage Territory Proposal
2. click on '+' icon to create a new proposal
3. select one of the territories (see attachment) and click 'Add to Proposal'.
4. you will see an error message (see attachment) and a duplicate territory is also created.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create new proposal

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.