My Oracle Support Banner

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 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:

            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.


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.