My Oracle Support Banner

On 8.1 Product Hierarchy Not Opening Showing Pages Unresponsive (Doc ID 2747032.1)

Last updated on FEBRUARY 05, 2021

Applies to:

Oracle Financial Services Profitability Management - Version 8.1.0.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

On 8.1.0.0.0 version, a specific Product Hierarchy with large members will not open properly and gave error below.

Error:
Window shows:
Pages Unresponsive

You can wait for them to become responsive or exit the pages
View - Hierarchy Details | twopane
URL
Oracle Financial Services Analytical Applications
Wait/Exit button

FUSIONSUBSYSTEMSService.log ends with below:
[26-01-21 18:57:40,113 GMT PM] [INFO ] [WEB]  [AMHM]  [NA] [HIERARCHYCONFIGCACHE] Looking value in cache for the key..TREE_NODE_LIMIT
[26-01-21 18:57:40,113 GMT PM] [INFO ] [WEB]  [AMHM]  [NA] [AMHMINTERNALCLIENT] tree limit..5000
[26-01-21 18:57:40,113 GMT PM] [INFO ] [WEB]  [AMHM]  [NA] [AMHMINTERNALCLIENT] Query to get Hierarchy node limit :SELECT count(1) depth FROM DIM_PRODUCTS_HIER rev_hier_b WHERE rev_hier_b.hierarchy_id = ? AND  rev_hier_b.single_depth_flag = 'Y' AND rownum <= ?
[26-01-21 18:57:40,114 GMT PM] [INFO ] [WEB]  [AMHM]  [NA] [CONNECTIONS] Getting tomcat connection from pool
[26-01-21 18:57:40,178 GMT PM] [INFO ] [WEB]  [AMHM]  [NA] [HIERARCHYCONFIGCACHE] Looking value in cache for the key..ATTR_DEF_DATE_FORMAT-OFSALMINFO
[26-01-21 18:57:40,354 GMT PM] [INFO ] [WEB]  [AMHM]  [NA] [CONNECTIONS] Getting tomcat connection from pool
[26-01-21 18:57:40,354 GMT PM] [INFO ] [WEB]  [AMHM]  [NA] [CONNECTIONS] Getting tomcat connection from pool
[26-01-21 18:57:40,354 GMT PM] [INFO ] [WEB]  [AMHM]  [NA] [HIERBROWSERHANDLER] serviceId..1
[26-01-21 18:57:40,355 GMT PM] [INFO ] [WEB]  [AMHM]  [NA] [CONNECTIONS] Getting tomcat connection from pool
[26-01-21 18:57:40,398 GMT PM] [INFO ] [WEB]  [AMHM]  [NA] [HIERBROWSERHANDLER] unsecured mode, calling AMHMInternalClient ...
[26-01-21 18:57:40,398 GMT PM] [INFO ] [WEB]  [AMHM]  [NA] [HIERARCHYFUNCTIONS] Build Hierarchy Member Tree Query...SELECT hier_view.parent_id parent_id, hier_view.child_id child_id, hier_view.mem_display_code mem_display_code, hier_view.mem_name mem_name , hier_view.leaf_only_flag leaf_only_flag,hier_view.parent_depth_num parent_depth_num FROM (SELECT rev_hier_b.child_id,rev_mem_b.PRODUCT_CODE mem_display_code,rev_mem_tl.PRODUCT_NAME mem_name,rev_hier_b.parent_id ,rev_mem_b.leaf_only_flag,rev_hier_b.parent_depth_num ,rev_hier_b.display_order_num FROM DIM_PRODUCTS_HIER rev_hier_b,DIM_PRODUCTS_B rev_mem_b,DIM_PRODUCTS_TL rev_mem_tl WHERE rev_hier_b.hierarchy_id = ? AND rev_mem_b.PRODUCT_ID = rev_hier_b.child_id AND rev_mem_tl.PRODUCT_ID = rev_hier_b.child_id AND rev_mem_tl.language = ? AND rev_hier_b.single_depth_flag = 'Y') hier_view START WITH hier_view.parent_id = hier_view.child_id CONNECT BY NOCYCLE PRIOR hier_view.child_id = hier_view.parent_id ORDER SIBLINGS BY display_order_num
[26-01-21 18:57:40,398 GMT PM] [INFO ] [WEB]  [AMHM]  [NA] [CONNECTIONS] Getting tomcat connection from pool
[26-01-21 18:57:40,653 GMT PM] [INFO ] [WEB]  [AMHM]  [NA] [HIERARCHYCONFIGCACHE] Looking value in cache for the key..MAX_DEPTH-OFSALMINFO

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.