After Upgrading to 12.2, Formulas, Recipes, and Batches Cannot be Retrieved, Even After Turning Off Formula Security
Last updated on JUNE 12, 2018
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms