Error While Replacing the Refresh Logic Related to RA_SRC_CURRENT_MAX_POSTDATE Variable: "ORA-00903: invalid table name"
(Doc ID 2020304.1)
Last updated on APRIL 08, 2021
Applies to:
Oracle Retail Merchandising Insights - Version 14.0 and laterInformation in this document applies to any platform.
Symptoms
After a new install of Retail Analytics (RA) 14.0 and while executing the step of replacing the refresh logic in RA_SRC_CURRENT_MAX_POSTDATE variable as part of configuring Oracle Data Integrator (ODI) designer, the process fails with the below error:
Steps to Recreate:
1. Perform a New installation of RA 14.0.0.
2. As part of the "Configure ODI Designer" section of the RA installation Guide, try to attempt step #6:
-
From ODI designer, open the variable: RA_SRC_CURRENT_MAX_POSTDATE and replace the refresh logic with the one below.
SELECT TO_CHAR(NVL(MAX(POST_DATE), TO_DATE('19000101', 'YYYY-MM-DD')),'YYYYMMDD') FROM <%=odiRef.getObjectName("L","IM_DOC_HEAD","D") %>;
3. Testing of the query throws the above error.
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 |