Poor Performance Of AUD: Cost Audit Report
(Doc ID 1298140.1)
Last updated on DECEMBER 16, 2024
Applies to:
Oracle Project Costing - Version 12.0.6 and laterInformation in this document applies to any platform.
Symptoms
PAXAUGLT
Performance issue when running AUD: Cost Audit Report with no accounting flexfields specified
eventually errors with ORA-01652.
SELECT /*+ LEADING(cc) */ cst . code_combination_id , project_number ,
task_number , SUBSTR ( expenditure_type , 1 , 22 ) expenditure_type ,
expenditure_item_date , SUBSTR ( emp_or_org_name , 1 , 32 ) emp_or_org_name
, period_name , transferred_date , gl_dr_amount , gl_cr_amount ,
cr_code_combination_id
FROM
PA_GL_COST_XFER_AUDIT_V cst , gl_code_combinations CC WHERE gl_date
BETWEEN nvl ( : cp_gl_start , gl_date ) AND nvl ( : cp_gl_end , gl_date )
AND TRUNC ( transferred_date ) BETWEEN nvl ( TRUNC ( : cf_from_date ) ,
TRUNC ( transferred_date ) ) AND nvl ( TRUNC ( : cf_to_date ) , TRUNC (
transferred_date ) ) AND CC.code_combination_id = cst.code_combination_id
AND CC.SEGMENT1 = '<9999>' AND CC.SEGMENT2 = '<9999>' AND CC.SEGMENT3 =
'<000>' AND CC.SEGMENT4 = '<9999>' AND CC.SEGMENT5 = '<9999>' AND CC.SEGMENT6 =
'<9999>' AND CC.SEGMENT7 = '<9999>' AND CC.SEGMENT8 = '<000>' AND
CC.SEGMENT9 = '<000>' AND CC.SEGMENT10 = '<000>' ORDER BY 1 ASC ,
cst.code_combination_id , project_number , task_number , expenditure_type ,
expenditure_item_date
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 1.23 1.22 0 0 0 0
Fetch 1 5356.82 5402.17 121734 11053412 77334 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 5358.05 5403.39 121734 11053412 77334 0
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 |
| References |