My Oracle Support Banner

Cannot Load SPs Getting ORA-00904: "D1_SP"."D1_SP_ID": Invalid Identifier For JOB D1SP000I (Doc ID 2767029.1)

Last updated on APRIL 14, 2021

Applies to:

Oracle Utilities Customer Cloud Service - Version 20A and later
Oracle Utilities Meter Data Management - Version 2.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : NA version, Meter Data Management

ACTUAL BEHAVIOR
---------------
Cannot Load SPs Getting ORA-00904: "D1_SP"."D1_SP_ID": invalid identifier for JOB D1SP000I

Ran the D1SP000I, NO data loaded checked the logs for errors
The INSERT STATEMENT has a BUG in the FROM CLAUSE developer forgot add a space between 2 Table names

Pease QA your code before releasing to the client

FROM DK_SP K_D1_SPD1_SP LEFT JOIN DR_SP R_D1_SP ON D1_SP.D1_SP_ID=R_D1_SP.D1_SP_ID WHERE D1_SP.D1_SP_ID = K_D1_SP.CX_ID AND K_D1_SP.CI_ID BETWEEN ? AND ?

you are missing a space or a comma here
DK_SP K_D1_SPD1_SP

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.