Manage Validations Screen Shows Very Bad Performance When Click On Apply
Last updated on MAY 03, 2012
Applies to:Oracle Trading Community - Version 12.1.0 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Manage validations screen is having performance issues when you click on the Apply button
Steps to reproduce:
Responsibility: Trading Community Manager
Navigation: Geography Hiararchy
- After you have set up the Structure and View Details section go to Manage validations.
- In The Manage validations screen click on the Add Another Row button and select HZ_LOCATIONS field.
- Click on the Tax validation and APPLY
- When clicking on the APPLY button it takes a few minutes to save and then you may get a blank screen
Sorted tkprof shows the following query as the top one causing the issue:
HZ_GEO_NAME_REFERENCE_LOG GEO WHERE EXISTS ( SELECT 'Y' FROM HZ_LOCATIONS
LOC WHERE LOC.COUNTRY = :B1 AND GEO.LOCATION_ID = LOC.LOCATION_ID) AND
LOCATION_TABLE_NAME = 'HZ_LOCATIONS' AND ROWNUM = 1
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