R09705 Performance Issue

JDE_DH1

Member
Hi All,

We are having problems with the integrity report R09705. The report keeps on processing for more than 2-3 days but does not complete. The report was completing for FY 15 in about 5 hours for a given period through Processing options but after the Annual close, the report has never completed for FY16 for a single period. We have extensive data for F0902 and F0911. Could you please share your experience if you have had similar issues.

Any Input is highly appreciated.

Thanks in advance.
Dan
E910 TR 9.1.4
AIX, Oracle 11g
 
Have you evaluated this...............

Bug 10815197 : R09705 - PERFORMANCE - SAR: 6685400
 
Hi All,

We are having problems with the integrity report R09705. The report keeps on processing for more than 2-3 days but does not complete. The report was completing for FY 15 in about 5 hours for a given period through Processing options but after the Annual close, the report has never completed for FY16 for a single period. We have extensive data for F0902 and F0911. Could you please share your experience if you have had similar issues.

Any Input is highly appreciated.

Thanks in advance.
Dan
E910 TR 9.1.4
AIX, Oracle 11g
Hi, how do you solve it? we have the same issue, we found that sometimes the process uses a specific index (F0911_32) which uses a ban plan. How did you resolve the issue?
 
Back
Top