My Oracle Support Banner

R12: FV: Oracle U.S Federal Financials Packages Are Invalid After Applying Oracle E-Business Suite Release 12.1.3+ Recommended Patch Collection 5 [RPC5] (Doc ID 2969404.1)

Last updated on AUGUST 22, 2023

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After applying Oracle E-Business Suite Release 12.1.3+ Recommended Patch Collection 5 [RPC5] - patch 22644544:12.1.0, the following Oracle U.S Federal Financials (FV) database package bodied show as INVALID: 

 FV_CFS_PKG
 FV_FACTS_EDIT_CHECK
 FV_FACTS_TBAL_TRX
 FV_FACTS_TRANSACTIONS
 FV_FACTS_TRX_REGISTER
 FV_SF133_NOYEAR
 FV_SF133_ONEYEAR


When trying to compile the package bodies using ALTER SQL command, all fail with the sdame error "ORA-04043: object ..... does not exist".  Here is an output of these commands:

SQL> ALTER PACKAGE FV_CFS_PKG COMPILE ;
ALTER PACKAGE FV_CFS_PKG COMPILE
*
ERROR at line 1:
ORA-04043: object FV_CFS_PKG does not exist

Elapsed: 00:00:00.01
SQL> SHOW ERR
No errors.
SQL> ALTER PACKAGE FV_FACTS_EDIT_CHECK COMPILE ;
ALTER PACKAGE FV_FACTS_EDIT_CHECK COMPILE
*
ERROR at line 1:
ORA-04043: object FV_FACTS_EDIT_CHECK does not exist

Elapsed: 00:00:00.01
SQL> SHOW ERR
No errors.
SQL> ALTER PACKAGE FV_FACTS_TBAL_TRX COMPILE ;
ALTER PACKAGE FV_FACTS_TBAL_TRX COMPILE
*
ERROR at line 1:
ORA-04043: object FV_FACTS_TBAL_TRX does not exist

Elapsed: 00:00:00.00
SQL> SHOW ERR
No errors.
SQL> ALTER PACKAGE FV_FACTS_TRANSACTIONS COMPILE ;
ALTER PACKAGE FV_FACTS_TRANSACTIONS COMPILE
*
ERROR at line 1:
ORA-04043: object FV_FACTS_TRANSACTIONS does not exist

Elapsed: 00:00:00.00
SQL> SHOW ERR
No errors.
SQL> ALTER PACKAGE FV_FACTS_TRX_REGISTER COMPILE ;
ALTER PACKAGE FV_FACTS_TRX_REGISTER COMPILE
*
ERROR at line 1:
ORA-04043: object FV_FACTS_TRX_REGISTER does not exist

Elapsed: 00:00:00.00
SQL> SHOW ERR
No errors.
SQL> ALTER PACKAGE FV_SF133_NOYEAR COMPILE ;
ALTER PACKAGE FV_SF133_NOYEAR COMPILE
*
ERROR at line 1:
ORA-04043: object FV_SF133_NOYEAR does not exist

Elapsed: 00:00:00.00
SQL> SHOW ERR
No errors.
SQL> ALTER PACKAGE FV_SF133_ONEYEAR COMPILE ;
ALTER PACKAGE FV_SF133_ONEYEAR COMPILE
*
ERROR at line 1:
ORA-04043: object FV_SF133_ONEYEAR does not exist 

 

Steps to reproduce:

  1. Apply Oracle E-Business Suite Release 12.1.3+ Recommended Patch Collection 5 [RPC5] - patch 22644544:12.1.0.
  2. Review the status of the database Objects, package bodies.



Changes

Applied Oracle E-Business Suite Release 12.1.3+ Recommended Patch Collection 5 [RPC5] - patch 22644544:12.1.0.

Cause

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
Symptoms
Changes
Cause
Solution
References


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