My Oracle Support Banner

Invalid object view AR_LOC_FLEX_CITY (Doc ID 1280106.1)

Last updated on MAY 25, 2018

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

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
 Still Have Questions?


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.