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 MAY 24, 2024

Applies to:

Symptoms

Failure to create Resource Centric territories


ERROR
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


STEPS
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.

Cause

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