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 JANUARY 16, 2018

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.


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
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


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