Payables (AP) patches encounter FV sql script errors or create invalid FV objects (Doc ID 1455162.1)

Last updated on JULY 23, 2012

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

Symptom 1:  FV objects become invalid after applying a patch e.g FV_FACTS_TRX_V APPS, FV_SLA_PROCESSING_PKG, etc...

Symptom 2:  FV sql script errors during patch application e.g.

adpatch log shows:

FAILED: file fv_data_cleanup.sql on worker  8 for product fv  username FV.

ATTENTION: All workers either have failed or are waiting:

FAILED: file fv_data_cleanup.sql on worker  1

adwork001.log shows:

sqlplus -s APPS/*****
PL/SQL procedure successfully completed.

prorate_charge = NVL(prorate_charge, 'N');

ERROR at line 33:
ORA-6550: line 33, column 33:
PL/SQL: ORA-904: "PRORATE_CHARGE": invalid identifier
ORA-6550: line 31, column 5:

...

 

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