Patch Application Error (for US FEDERAL FINANCIALS ONLY): Patch 8602801 Fails with ORA-00904: "PRORATE_CHARGE": invalid identifier (Doc ID 1095504.1)

Last updated on AUGUST 24, 2016

Applies to:

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

Symptoms

WARNING: This patch is only applicable to US FEDERAL CUSTOMERS. If you do not have a US FEDERAL installation, DO NOT APPLY THIS PATCH.

 

Applying Patch 8602801 fails while running fv_data_cleanup.sql. The log file shows:


sqlplus -s APPS/***** @/erpptch/ERPPTCH/apps/apps_st/appl/fv/12.0.0/patch/115/sql/fv_data_cleanup.sql 3 4

prorate_charge = NVL(prorate_charge, 'N');
*
ERROR at line 33:
ORA-06550: line 33, column 33:
PL/SQL: ORA-00904: "PRORATE_CHARGE": invalid identifier
ORA-06550: line 31, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 36, column 28:
PL/SQL: ORA-00904: "RATE_BASE": invalid identifier
ORA-06550: line 35, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 43, column 43:
PL/SQL: ORA-00904: "B"."FINANCE_CHARGE_GROUP_HDR_ID": invalid identifier
ORA-06550: line 38, column 24:
PL/SQL: SQL Statement ignored
ORA-06550: line 44, column 19:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 44, column 7:
PL/SQL: SQL Statement ignored
ORA-06550: line 71, column 19:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 71, column 7:
PL/SQL: SQL Statement ignored
ORA-06550: line 107, column 14:
PL/SQL: ORA-00904: "A"."FINANCE_CHARGE_GROUP_HDR_ID": invalid identifier
ORA-06550: line 104, column 7:
PL/SQL: SQL Statement ignored

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