NOT ABLE TO CREATE ANY TERRITORY UNDER CATCH ALL NODE. (Doc ID 1964222.1)

Last updated on AUGUST 28, 2023

Applies to:

Symptoms

On : 12.1.3 version, Administration

When creating a new territory , and click on the Create button the following error occurs.

ERROR
-----------------------
 

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT JtfTerritoryEO.TERR_ID, JtfTerritoryEO.ORG_ID, JtfTerritoryEO.NAME, JtfTerritoryEO.ENABLED_FLAG, JtfTerritoryEO.START_DATE_ACTIVE, JtfTerritoryEO.END_DATE_ACTIVE, JtfTerritoryEO.PARENT_TERRITORY_ID, JtfTerritoryEO.TERRITORY_TYPE_ID, JtfTerritoryEO.RANK, JtfTerritoryEO.NUM_WINNERS, JtfTerritoryEO.NAMED_ACCOUNT_FLAG, hr.Name AS ORG_NAME, decode(parentTerr.terr_id,1,hr.name,parentTerr.NAME) AS PARENT_TERRITORY_NAME, decode(parentTerr.terr_id, 1, null, parentTerr.start_date_active || ' - ' || parentTerr.end_date_active ) AS PARENT_EFFECTIVE_DATE, JtfTerritoryEO.DESCRIPTION, JtfTerritoryEO.TERR_GROUP_FLAG, JtfTerritoryEO.TERR_GROUP_ID, JtfTerritoryEO.NUM_QUAL AS NumQual, JtfTerritoryEO.UPDATE_FLAG AS UpdateFlag, JtfTerritoryEO.TEMPLATE_FLAG AS TemplateFlag, JtfTerritoryEO.ESCALATION_TERRITORY_FLAG AS EscalationTerritoryFlag, JtfTerritoryEO.CATCH_ALL_FLAG AS CatchAllFlag, JtfTerritoryEO.GEO_TERR_FLAG AS GeoTerrFlag, JtfTerritoryEO.ENABLE_SELF_SERVICE, JtfTerritoryEO.attribute_category, JtfTerritoryEO.attribute1, JtfTerritoryEO.attribute2, JtfTerritoryEO.attribute3, JtfTerritoryEO.attribute4, JtfTerritoryEO.attribute5, JtfTerritoryEO.attribute6, JtfTerritoryEO.attribute7, JtfTerritoryEO.attribute8, JtfTerritoryEO.attribute9, JtfTerritoryEO.attribute10, JtfTerritoryEO.attribute11, JtfTerritoryEO.attribute12, JtfTerritoryEO.attribute13, JtfTerritoryEO.attribute14, JtfTerritoryEO.attribute15, parentTerr.start_date_active parent_start_date, parentTerr.end_date_active parent_end_date FROM JTF.JTF_TERR_ALL JtfTerritoryEO, APPS.HR_OPERATING_UNITS hr, JTF.JTF_TERR_ALL parentTerr WHERE JtfTerritoryEO.org_id = hr.organization_id AND JtfTerritoryEO.parent_territory_id = parentTerr.terr_id AND JtfTerritoryEO.org_id = parentTerr.org_id at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
..
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:619) java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Navigated to Territory Management > Territories
- Selected Usage=Trade Management
- Click Go
- Select the Territory parent node and click Create (B)
- Page displays an error that table/view does not exist. Attached error details.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create any territory for any usage.

Changes

Cause

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