My Oracle Support Banner

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 9.3.2.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
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.

STEPS
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
5. Save

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.