Territory Details Page Error JBO-27122 On Table JTF_TERRITORY_PVT.get_qual_value

(Doc ID 2283567.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Territory Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On Production: 12.2.4 version, Territory Details

ACTUAL BEHAVIOR
---------------
While searching territory name. Click on the hierarchy symbol. Then click on the territory name and encounter error page


STEPS
-----------------------
1. Search territory:

2. Click on hierarchy icon

3. Click on the name hyper link

FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT JtfTerrQual.TERR_ID,
jsq.name seeded_qual_name,
(JTF_TERRITORY_PVT.get_qual_value(JtfTerrQual.qual_usg_id....



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