WebADI Export Functionality Is Not Working After Applying RUP4 Patches (Doc ID 2176607.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Administration

Territory Export functionality is not working
Before applying RPC4 the export functionality worked fine.
Now we cannot use the webadi export functionality at all as it errors immediately

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

Exception Details.
 oracle.apps.fnd.framework.OAException: 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, jqu.display_type,jqu.convert_to_id_flag,JtfTerrValue.COMPARISON_OPERATOR,jqu.display_sql1,jqu.display_sql2,jqu.display_sql3,JtfTerrValue.low_value_char_id,JtfTerrValue.low_value_char,JtfTerrValue.interest_type_id,JtfTerrValue.primary_interest_code_id,JtfTerrValue.secondary_interest_code_id,JtfTerrValue.value1_id,JtfTerrValue.value2_id,JtfTerrValue.currency_code,'CO')) COMPARISON_OPERATOR,
  (JTF_TERRITORY_PVT.get_qual_value(JtfTerrQual.qual_usg_id, jqu.display_type,jqu.convert_to_id_flag,JtfTerrValue.COMPARISON_OPERATOR,jqu.display_sql1,jqu.display_sql2,jqu.display_sql3,JtfTerrValue.low_value_char_id,JtfTerrValue.low_value_char,JtfTerrValue.interest_type_id,JtfTerrValue.primary_interest_code_id,JtfTerrValue.secondary_interest_code_id,JtfTerrValue.value1_id,JtfTerrValue.value2_id,JtfTerrValue.currency_code,'1')) value1,
  DECODE(NVL(JtfTerrValue.HIGH_VALUE_CHAR, JtfTerrValue.HIGH_VALUE_NUMBER),NULL,JTF_TERRITORY_PVT.get_qual_value(JtfTerrQual.qual_usg_id, jqu.display_type,jqu.convert_to_id_flag,JtfTerrValue.COMPARISON_OPERATOR,jqu.display_sql1,jqu.display_sql2,jqu.display_sql3,JtfTerrValue.low_value_char_id,JtfTerrValue.low_value_char,JtfTerrValue.interest_type_id,JtfTerrValue.primary_interest_code_id,JtfTerrValue.secondary_interest_code_id,JtfTerrValue.value1_id,JtfTerrValue.value2_id,JtfTerrValue.currency_code,'2'),NVL(JtfTerrValue.HIGH_VALUE_CHAR, JtfTerrValue.HIGH_VALUE_NUMBER)) value2,
  jqu.display_sql1,
  jqu.display_sql2,
  jqu.display_sql3,
  jqu.display_type,
  jqu.convert_to_id_flag,
  JtfTerrQual.TERR_QUAL_ID,
  JtfTerrQual.qual_usg_id,
  JtfTerrValue.low_value_char_id,
  JtfTerrValue.interest_type_id,
  JtfTerrValue.primary_interest_code_id,
  JtfTerrValue.secondary_interest_code_id,
  JtfTerrValue.value1_id,
  JtfTerrValue.value2_id,
  JtfTerrValue.value3_id,
  JtfTerrValue.value4_id,
  JtfTerrValue.low_value_char,
  JtfTerrValue.low_value_number,
  JtfTerrValue.high_value_char,
  JtfTerrValue.high_value_number,
  (JTF_TERRITORY_PVT.get_qual_value(JtfTerrQual.qual_usg_id, jqu.display_type,jqu.convert_to_id_flag,JtfTerrValue.COMPARISON_OPERATOR,jqu.display_sql1,jqu.display_sql2,jqu.display_sql3,JtfTerrValue.low_value_char_id,JtfTerrValue.low_value_char,JtfTerrValue.interest_type_id,JtfTerrValue.primary_interest_code_id,JtfTerrValue.secondary_interest_code_id,JtfTerrValue.value1_id,JtfTerrValue.value2_id,JtfTerrValue.currency_code,'3')) value3,
  JtfTerrValue.currency_code,
  JtfTerrQual.org_id,
  jqu.Hierarchy_type
FROM JTF_TERR_QUAL_ALL JtfTerrQual,
  --jtf_seeded_qual_usgs_v qual_usg,
  JTF_TERR_VALUES_ALL JtfTerrValue,
  JTF_QUAL_USGS_ALL jqu ,
  JTF_SEEDED_QUAL_ALL jsq ,
  JTF_QUAL_TYPE_USGS_ALL jqtu ,
  JTF_QUAL_TYPES_ALL jqt ,
  JTF_SOURCES_ALL js
WHERE JtfTerrQual.qual_usg_id = jqu.qual_usg_id
  AND JtfTerrQual.org_id = jqu.org_id
  AND JtfTerrQual.TERR_QUAL_ID = JtfTerrValue.TERR_QUAL_ID
  AND jqu.seeded_qual_id = jsq.seeded_qual_id
  AND jqu.qual_type_usg_id = jqtu.qual_type_usg_id
  AND jqtu.qual_type_id = jqt.qual_type_id
  AND jqtu.source_id = js.source_id) QRSLT WHERE (HIERARCHY_TYPE IS NULL AND TERR_ID = :1) ORDER BY seeded_qual_name
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)

  [...]

## Detail 0 ##
java.sql.SQLException: ORA-20001: An error was encountered while executing the Function QualValue- -6502 -ERROR- ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.JTF_TERRITORY_PVT", line 10981

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4568)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:751)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:900)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:814)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:808)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3674)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:441)
at oracle.apps.jtf.territory.manageTerritory.webui.TerritoryViewCO.processFormRequest(TerritoryViewCO.java:1119)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:827)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1217)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1039)






STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to: Territory Management > Territory Administration > Territories >
2. Navigate to territory to export > select node to export > click on export button
3. Error appears


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use the webadi functionality to administer territories

Changes

 

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