Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Patch 11872456:R12.AP.B fails on fv_data_cleanup.sql with error : PL/SQL: ORA-00904: "PRORATE_CHARGE

edited Sep 9, 2012 8:09PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 comments
Hi,
Patch 11872456:R12.AP.B fails on fv_data_cleanup.sql with error :
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 30:
PL/SQL: ORA-00904: "B"."FINANCE_CHARGE_GROUP_HDR_ID": invalid identifier
ORA-06550: line 38, column 23:
PL/SQL: SQL Statement ignored
ORA-06550: line 47, column 19:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 47, column 7:
PL/SQL: SQL Statement ignored
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center