My Oracle Support Banner

Territory Details Page Error JBO-27122 On Table JTF_TERRITORY_PVT.get_qual_value (Doc ID 2283567.1)

Last updated on DECEMBER 19, 2022

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



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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