Invalid Objects After Database Upgrade (Doc ID 1276585.1)

Last updated on JUNE 08, 2016

Applies to:

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

Symptoms

After database upgrade the view FV_SLA_PROCESSING_PKG is invalid with the following errors:

Errors for PACKAGE BODY FV_SLA_PROCESSING_PKG: LINE/COL ERROR
-------- -----------------------------------------------------------------
3536/5 PL/SQL: SQL Statement ignored
3546/16 PL/SQL: ORA-00904: "D"."DIST_REF_MF_DIST_FLAG": invalid
identifier 3676/15 PL/SQL: Statement ignored
3676/65 PLS-00364: loop index variable 'REC_REC' use is invalid
3677/15 PL/SQL: Statement ignored
3680/36 PLS-00364: loop index variable 'REC_REC' use is invalid
3734/15 PL/SQL: Statement ignored
3734/62 PLS-00364: loop index variable 'REC_REC' use is invalid

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