Db Redaction Policies Cause Wrong Result In Calculated Field
(Doc ID 2900109.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.13.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
After upgraded our DB from 18c to 19c, we are consistently able to replicate this issue across 19c environments (19.13.0.0.211019).
An "insert from select" SQL, give 0 value for calculated field
e.g. Compared to when running it from peoplesoft tools
But same sql return correct non-zero value for the calculated field when run in sqlplus and sql developer.
Found out the cause of this problem is triggered by our db redaction policies, once turn it off, the problem is gone.
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 |
Cause |
Solution |
References |