Applying Patch 12362963 Fails With "PL/SQL: ORA-00904: "Prorate_charge": Invalid Identifier" and ORA-02289: sequence does not exist (Doc ID 1338167.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version: 12.0.0 to 12.1.3 - Release: 12.0 to 12.1
Information in this document applies to any platform.

Symptoms

On application version 12.1.1 in Development (FHRDEV) instance, applying <Patch 12362963>:R12.AP.B fails with the following error:

Error message 1
prorate_charge = NVL(prorate_charge, 'N');
*
ERROR at line 33:
ORA-06550: line 33, column 33:
PL/SQL: ORA-00904: "PRORATE_CHARGE": invalid identifier

When this is resolved, the following error message is received:

Error message 2
fv_finance_charge_grp_hdrs_s.nextval,
*
ERROR at line 62:
ORA-06550: line 62, column 9:
PL/SQL: ORA-02289: sequence does not exist
ORA-06550: line 47, column 7:
PL/SQL: SQL Statement ignored
ORA-06550: line 96, column 11:
PL/SQL: ORA-02289: sequence does not exist
ORA-06550: line 78, column 9:
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