My Oracle Support Banner

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

Last updated on JULY 23, 2020

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.


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:






To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.