Cannot Load SPs Getting ORA-00904: "D1_SP"."D1_SP_ID": Invalid Identifier For JOB D1SP000I
(Doc ID 2767029.1)
Last updated on NOVEMBER 02, 2022
Applies to:
Oracle Utilities Customer Cloud Service - Version 20A to 20C [Release 20]Oracle Utilities Meter Data Management - Version 2.4.0.0.0 to 2.4.0.0.0 [Release 2.4]
Oracle Utilities Framework - Version 4.4.0.3.0 to 4.4.0.3.0 [Release 4.4]
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 |