ORA-00904: "ENCRYPTION"."UN_ENCRYPT_STRING": invalid identifier (Doc ID 2057056.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.4 and later
Information in this document applies to any platform.

Goal

After applying demantra DB generic <Patch 18139794> - DM ERROR IN EP_LOAD_SALES ,

When running a custom procedyre, it is giving error as:
Procedure DM.LAUNCH_DEM_WORKFLOW@TOPPS VCPCRP3
Error(60,7): PL/SQL: SQL Statement ignored
Error(60,14): PL/SQL: ORA-00904: "ENCRYPTION"."UN_ENCRYPT_STRING": invalid identifier
Error(60,25): PLS-00302: component 'UN_ENCRYPT_STRING' must be declared


Solution

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