Users are always complaint about siebel erp integration performance issue when they are doing push the approval data to erp r12. It will take approximately 2 to 4 minutes.
So I took the awr reports from both database and crosschecked both with some interval, the siebel database performance is good but erp database saying there is integration related packages sql elasped time little bit more.
So i just went to siebel application and look the all components group log level ,How about ? Yes I found out there some of the components groups logging was enabled to 5, It should not be like always, So I have decreased the default log level to 1 and clear that web service cache, and then I tried to push the transaction, it completed within 10 seconds.
And also i have disabled SOA auditing feature from ERP, Now data came within 4 seconds.