Action ‘Assign Territories’ Is Erroring Out On Accounts Object (Doc ID 2161288.1)

Last updated on JULY 21, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.10.0.0 to 11.1.11.1.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

On : 11.1.10.0.0 version, Accounts, Contacts, Households

Action ‘Assign territories’ is erroring out on accounts object. The error message is “JBO-56012: SQLException from preparing or executing sql statement with original Jbo error code JBO-27122. Please contact service provider on details.”

ERROR
-----------------------
JBO-56012: SQLException from preparing or executing sql statement with original Jbo error code JBO-27122. Please contact service provider on details.




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Account-> Actions-> Run assignment

 

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