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