View Accounting Performance Issue (Doc ID 984525.1)

Symptoms

View Financial Information Form > View Accounting (either from Asset Workbench or Financial Inquiry form) on a large amount of Subledger Accounting data results in:

Either:
The Web Page Cannot be Found
Or
Error Page:
You have encountered an unexpected error. Please contact the System
Administrator for assistance.

From the SQL Trace the performance is with this statement (only part of the statement is noted here due to the length of the query statement):

SELECT * FROM (SELECT /*+ OPTIMIZER_FEATURES_ENABLE('9.2.0') opt_param('hash_join_enabled','false') */ l.code_combination_id, TE.ENTITY_ID
,fnd_flex_ext.get_segs('SQLGL', 'GL#', gl.chart_of_accounts_id, l.code_combination_id) ACCOUNT
,xla_oa_functions_pkg.get_ccid_description
(gl.chart_of_accounts_id, l.code_combination_id) account_description
,l.accounting_class_code
,nvl(lk7.meaning, l.accounting_class_code) accounting_class
,null completion_acct_seq_name
,h.completion_acct_seq_value
,h.completion_acct_seq_version_id completion_acct_seq_ver_id
,null completion_acct_seq_ver_name
,h.balance_type_code
,null balance_type
,h.budget_version_id
...
..

Cause

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