Invalid object view AR_LOC_FLEX_CITY (Doc ID 1280106.1)

Last updated on DECEMBER 26, 2012

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

 After upgrade from 11.5.10.1 to R12.1.1 the view apps.AR_LOC_FLEX_CITY is invalid with the following error:

SQL> show errors
Error in PACKAGE BODY OLAP_API_SESSION_INIT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
21/5 PL/SQL: SQL Statement ignored
23/16 PL/SQL: ORA-00942: table or view does not exist
41/9 PL/SQL: SQL Statement ignored
41/25 PL/SQL: ORA-00942: table or view does not exist
68/7 PL/SQL: SQL Statement ignored
68/23 PL/SQL: ORA-00942: table or view does not exist
SQL> alter view apps.AR_LOC_FLEX_CITY compile;
alter view apps.AR_LOC_FLEX_CITY compile
*
ERRORE at line 1:
ORA-01445: cannot select ROWID from, or sample, a join view without a
key-preserved table

 

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