My Oracle Support Banner

12.2 Data Masking With OEM 13C Fails On Verification Job From Application Data Modeling Page Actions Menu With Error ' ORA-04067: not executed, package body "DBSNMP.MGMT_DDRM_EBS_DRV" does not exist' (Doc ID 2225822.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Applications Manager - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

12.2 E-Business Suite Applications Manager, Data Masking Pack related issues

 

 

An error is received while implementing Data Masking with E-Business Suite 12.2 via the following document:

<Note 2076834.1> - Oracle E-Business Suite Data Masking Pack Release 12.2 with Oracle Enterprise Manager Cloud Control 13c

The following error is received when attempting to complete Section 2.1.7 : Task 1 : Step 2:

 Processing Job for action: VerifyADM
Running driver discovery for EBS: id: 20, name: EBS-V1.1 - TEST, app-suite: Oracle EBS
ADM source: EBS_TEMPLATE
Retrieving data for application: APPLSYS(APPLSYS)
Error while running driver discovery:
java.sql.SQLException: ORA-04067: not executed, package body "DBSNMP.MGMT_DDRM_EBS_DRV" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "DBSNMP.MGMT_DDRM_EBS_DRV"
ORA-06512: at line 1

 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)

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.