Poor Performance in Shipping-Transportation Outbound Interface Caused by Too Many Records in FND_HTTP_TICKETS
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.
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?
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