Update Substance Attribute Takes Time To Complete Causing Table Fullscan of SUBSTANCE_MAP Table
(Doc ID 2524335.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Agile Product Governance and Compliance - Version 22.214.171.124 and later
Information in this document applies to any platform.
When Edit the Substance object and enter a value to attribute : CAS number and save, the save takes many time to finish around 2 - 5 minutes per substance.
The issue can be reproduced at will with the following steps:
1. Log into Web Client
2. Search a substance
3. On Titleblock click edit
4. Add some value to CAS number
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