R12.2

[Sri]

Hi Erman,

We are working on tuning the output post processor.we need your help in finding out

how much time a request spent with OPP processing after its completion,it will be helpful for us if you share any sql query for that.

Thanks,
sri

[ErmanArslansOracleBlog]

Read this -> http://ermanarslan.blogspot.com.tr/2014/12/ebs-output-post-processoropp.html


There are things to be done , which are mentioned in the above post.

[satish]

Hi Erman,

I am following the same blog for reference as your blogs are always unique and best.My client wants to see the difference before and after the tuning,so i need some query which will determine some wait time or time spent by requests with OPP.is this possible?

Thanks

[ErmanArslansOracleBlog]

Did you check the OPP logs?
That logs may contain that info. (date start , date end)

[Sri]

Thanks for the updates erman.
we can get the overall time for requests from fnd concurrent requests table but for opp do we have any query to check only the time spent for OPP requests.i think its tough to check the logfiles for all requests individually.

[Sri]

I think we have to check the overall time from fnd concurrent requests as this also includes opp process time.we cannot have sql query to check the time for requests processed by OPP