Error While Replacing the Refresh Logic Related to RA_SRC_CURRENT_MAX_POSTDATE Variable: "ORA-00903: invalid table name"
Last updated on JULY 19, 2017
Applies to:Oracle Retail Merchandising Insights - Version 14.0 and later
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms