My Oracle Support Banner

Refresh Territories from Resources Failure To Create Resource Centric Territories JBO-FND:::FND_CMN_SYS_ERR: An error occurred. Contact your help desk. (Doc ID 2919893.1)

Last updated on JANUARY 08, 2023

Applies to:

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


Failure to create Resource Centric territories

JBO-FND:::FND_CMN_SYS_ERR: An error occurred. Contact your help desk.
begin MOT_TERR_UTIL.PopulateRuleToBndryDenorm(?,?,?); end;, Error Msg = ORA-14400: inserted partition key does not map to any partition
JobID:16815866:ORA-06512: at "FUSION.MOT_TERR_UTIL", line 372
JobID:16815866:ORA-06512: at "FUSION.MOT_TERR_UTIL", line 1078
JobID:16815866:ORA-06512: at "FUSION.MOT_TERR_UTIL", line 991
JobID:16815866:ORA-06512: at "FUSION.MOT_TERR_UTIL", line 361
JobID:16815866:ORA-06512: at line 1

The issue can be reproduced at will with the following steps:
1. The organizational hierarchy was modified.
2. The following jobs were executed without errors:
    a. Retrieve Latest LDAP Changes
    b. Send Pending LDAP Requests
    c. Import User and Role Application Security Data
    d.Synchronize User GUID
    e. Reporting Hierarchy Generation
3. Executing the last job "Refresh Territories from Resources" ends with an error and no territory is created.


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.