ORA-00904 Invalid Identifier After Migrating From Older Oracle Versions to Newer Versions (Doc ID 1083773.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 9.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Sep-2012***

Symptoms

Objects (Procedures, Packages, Functions etc.) that were working fine in Oracle 9i seems to throw the following exceptions in Oracle 11g Release 1 - 11.1.0.6.0

ERROR at line 1:
ORA-20000: Procedure 'plan.pg_new_sku_forecast.get_export_new_sku_detail' failed with error code: -904, and error message: 
ORA-00904: SYS_TBL_$1$ SPF_DISPLAY_AMT2: invalid identifier.
ORA-06512: at PLAN.PG_NEW_SKU_FORECAST, line 2763
ORA-06512: at line 1

Changes

Migrated from Oracle 9i 9.2 to Oracle 11g Release 1 - 11.1.0.6.0

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