Customer Form Performance Issue: Poor Performance Opening Customers Standard Form Due to Queries Against DR$ Tables
(Doc ID 395322.1)
Last updated on FEBRUARY 12, 2018
Applies to:Oracle Receivables - Version 22.214.171.124 to 126.96.36.199 [Release 11.5.10]
Information in this document applies to any platform.
Queries like the following, are performing poorly when opening the Customers Standard form.
"AR"."DR$HZ_STAGE_PARTY_SITES_T1$I" T WHERE TOKEN_TEXT LIKE :lkexpr and
(TOKEN_TYPE IN (0, 4, 6, 604) OR (TOKEN_TYPE BETWEEN 16 AND 74) OR
(TOKEN_TYPE BETWEEN 616 AND 674))
What can be done to improve performance of queries against DR$ tables?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document