My Oracle Support Banner

After Upgrading to 12.2, Formulas, Recipes, and Batches Cannot be Retrieved, Even After Turning Off Formula Security (Doc ID 2410122.1)

Last updated on NOVEMBER 02, 2022

Applies to:

Oracle Process Manufacturing Product Development - Version 12.1.3 and later
Information in this document applies to any platform.


After upgrading from 12.1.3 to 12.2.7, duplicate Virtual Private Database (VPD) policies for Formula Security exist. These duplicates have an object_name that ends in #. For example, one policy created by Formula Security has an object_name of FM_FORM_MST_B. After the upgrade, another one is seen with object_name of FM_FORM_MST_B#. These duplicate policies are seen in the output of the following query:

select * from DBA_POLICIES where object_owner = 'GMD'

These duplicate policies are making formulas, recipes, and batches inaccessible. Even after turning off Formula Security they cannot be retrieved.

The select from dba_policies where object_owner = 'GMD' shows these duplicates, which appear to be duplicates of the standard formula security objects but with the # appended.


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

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