Fusion Apps, BI Publisher, Performance Issues With The Financial Tax Register Report (Doc ID 2075716.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Financials Common Module - Version 11.1.9.2.0 and later
Oracle Fusion Application Toolkit - Version 11.1.9.2.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms


ACTUAL BEHAVIOR
---------------
Performance Issues With the Financial Tax Register

We have performance issue with this report,
We have analyzed the issue , and found below notes but it is related R12 not for fusion ,Please provide us equivalent note for fusion applications and solve the issue.

1. Make sure you have gather scheme statistics running on a regular basis and that it includes the product short name ZX
2. Make sure that Tax debug logging is not turned on. See Note 417238.1 if you are unsure of how this is checked.
3. Make sure you have the latest TRL code patches applied from Note 737320.1. Several performance bugs have been fixed in later code.
4. Schedule the request "Purge Logs and Closed System Alerts" to run regularly. This will clear out the debug log tables and reduce the size of the tables read by the report.
5. Periodically truncate the tables below:
ZX_REP_CONTEXT_T
ZX_REP_TRX_DETAIL_T
ZX_REP_TRX_JX_EXT_T
ZX_REP_ACTG_EXT_T

These tables store data only when debug is enabled. They can grow large over time and periodically purging them ensures that the size of the table does not interfere with the execution of individual reports. Data in these tables is stored by concurrent request ID and is not used for any purpose except to generate output for individual request submissions.
 
1. I have analyzed purging is not happening on below tables.
ZX_REP_CONTEXT_T
ZX_REP_TRX_DETAIL_T
ZX_REP_TRX_JX_EXT_T
ZX_REP_ACTG_EXT_T

2. How to check Tax debug logging is not turned on.
 

EXPECTED BEHAVIOR
-----------------------
that the report Financial Tax Register would run much faster

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the Financial Tax Register

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, there is an extensive running time of the report.

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