My Oracle Support Banner

INVALID PARAMETER NAME: P_DEVICE_CONFIG_ID (Doc ID 2752493.1)

Last updated on JUNE 03, 2024

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.7.0.1.3 version, System Wide

The following error is faced when customer executes the Configure Source process for MDM:

2020-08-10T08:54:20.983+0300  ERROR   OGG-00350  Oracle GoldenGate Delivery
for Oracle, MDM1AA.prm:  Error in SQLEXEC clause, id
MDM1REP.B1_MDM1AA_HISTORIZE.D1_DVC_CFG: Invalid parameter name:
P_DEVICE_CONFIG_ID.

This issue is faced for D1_DVC_CFG table after applying OUA 2.7.0.1.3 patchset
This is an impact issue resulting out of the fix provided for custom replication
of table CI_SA_REL of CCB.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. After applying the patchset OUA 2.7.0.1.3, run the Configure Source process
2. Notice that the replicat abends with the mentioned error message

Changes

 

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
Changes
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.