My Oracle Support Banner

CIPVSPCI Using D1_DVC To Resolve FK Instead Of DK_DVC (Doc ID 2898695.1)

Last updated on MARCH 14, 2024

Applies to:

Oracle Utilities Customer Cloud Service - Version 22A and later
Information in this document applies to any platform.


We have Service Point Characteristics that FK reference to the D1_DVC table.
When running the CIPVSPCI job to convert these from staging to production,
the job errors out. Looking at the STDOUT, the SQL statement being used is
trying to resolve the FK Reference to the CX_ID column from the DK_DVC table,
but the FROM clause of the query is referencing the D1_DVC table instead.

Steps to reproduce:
1.  Create a SP Characteristic Type that references the Device table Import SP Characteristic records into staging containing this characteristic type
2.  Run the CIPVSPCI job to convert those SP Chars to production


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.