My Oracle Support Banner

Db Redaction Policies Cause Wrong Result In Calculated Field (Doc ID 2900109.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.13.0.0.0 and later
Information 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


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