Complete/Incomplete In Oracle Receivable

http://receivablesar.blogspot.com/2016/02/we-are-having-issue-that-during.html

we are having issue that during the complete/incomplete of transactions in Oracle Receivables the system got stuck or takes too much time. Kindly review and share the reason to overcome through this problem because whenever user perform this action it irritates too much. 


Please follow the below Document attached and upload it to Support

All About the SQLT Diagnostic Tool (Doc ID 215187.1)
SQLT Usage Instructions (Doc ID 1614107.1

-----------------------------------------------------------------------------------------------------------

The analyze percents of schema of AR, ZX are 10%.
Your database is 11.2.0.1.0. You can use the Auto_Sample_Size when you run the the Gather Schema Statistics.

I suggest you should run the Gather Schema Statistics with Estimate percent
as null (Auto_Sample_Size) and schema name as both AR and ZX after
applying patch 16410424:R12.FND.B according to the document below.

Best Practices for Gathering Statistics with Oracle E-Business Suite ( Doc ID 1586374.1 )

Patch 16410424:R12.FND.B
Fix version:
AFSTATSB.pls 120.12.12010000.19 or higher.

Please test the this issue after running the Gather Schema Statistics.