My Oracle Support Banner

Performance Issue: 'Tax Reconciliation By Taxable Account' Report Takes Long Time To Complete (Doc ID 2232823.1)

Last updated on MAY 31, 2018

Applies to:

Oracle E-Business Tax - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms


'Tax Reconciliation by Taxable Account' Report Takes a Long time to complete.

Steps To Reproduce :

Navigate To Tax Manager Responsibility > Run Report 'Tax Reconciliation By Taxable Account'

Verify the time taken

Expensive SQL :

SELECT DTL.DETAIL_TAX_LINE_ID, DIST.AMOUNT, DIST.ACCTD_AMOUNT, DTL.TAX_AMT,
DTL.TAX_AMT_FUNCL_CURR, DTL.PRECISION, DTL.MINIMUM_ACCOUNTABLE_UNIT,
DIST.PERCENT/100, DIST.CUST_TRX_LINE_GL_DIST_ID
FROM ZX_REP_TRX_DETAIL_T DTL, RA_CUST_TRX_LINE_GL_DIST_ALL DIST
WHERE 25188052 = 25188052
AND DTL.TRX_ID = :B5
AND DTL.TRX_LINE_ID = :B4
AND DTL.EVENT_CLASS_CODE IN ('INVOICE', 'CREDIT_MEMO', 'DEBIT_MEMO','BR')
AND DTL.REQUEST_ID = :B3
AND DTL.EXTRACT_SOURCE_LEDGER = :B2
AND DTL.TAX_LINE_ID = :B1
AND DTL.ENTITY_CODE = 'TRANSACTIONS'
AND DIST.ORG_ID = DTL.INTERNAL_ORGANIZATION_ID
AND DIST.CUSTOMER_TRX_LINE_ID = DTL.TRX_LINE_ID
AND DIST.CUSTOMER_TRX_ID = DTL.TRX_ID
AND DIST.ACCOUNT_CLASS = 'REV'

 

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
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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