Invalid object FV_FACTS_TBAL_TRANSACTIONS after applying patch 9000001
Release 12.1.3
I got FV_FACTS_TBAL_TRANSACTIONS package Invalid after applying patch 9000001:
SQL> alter package APPS.FV_FACTS_TBAL_TRANSACTIONS compile body;
Warning: Package Body altered with compilation errors.
SQL> show err
Errors for PACKAGE BODY APPS.FV_FACTS_TBAL_TRANSACTIONS:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1742/6 PL/SQL: SQL Statement ignored
1743/4 PL/SQL: ORA-00918: column ambiguously defined
Version of FV_FACTS_TBAL_TRANSACTIONS:
--$Header: FVFCTRGB.pls 115.45 2002/11/11 17:32:25 ksriniva ship $
We are not a US-FEDERAL Customer but the patch is applied due to other requirement/sr.