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 JULY 19, 2017

Applies to:

Oracle Retail Merchandising Insights - Version 14.0 and later
Information 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:

            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.

Changes

 

Cause

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