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 laterInformation 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'
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 |