Poor Performance in Shipping-Transportation Outbound Interface Caused by Too Many Records in FND_HTTP_TICKETS

(Doc ID 2291100.1)

Last updated on JULY 27, 2017

Applies to:

Oracle Shipping Execution - Version 12.2.4 and later
Information in this document applies to any platform.

Goal

It is taking an unacceptably long time to run the concurrent process Shipping Transportation Outbound Interface (to send deliveries to OTM). When a trace and tkprof file is provided,  it is seen that most of the elapsed time is consumed with queries on FND_HTTP_TICKETS. Should this table be purged?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms