After patch patch 11894044:R12.FA.B package APPS.FA_RSVLDG_REP_INS_PKG is in invalid
Hi,
We applied patch11894044:R12.FA.B as per metalink note 1309921.1. After application of patch, the package body APPS.FA_RSVLDG_REP_INS_PKG is in invalid status, and when we try to recompile it it is throwing error.
Error(1435,2): PL/SQL: SQL Statement ignored
Error(1456,6): PL/SQL: ORA-00904: "ASSET_NUMBER": invalid identifier
Please advise urgently because all processes which use this package are erroring out.
Package version
--------------------------------------------------------------------------------
/*$Header: farsvins.pls 120.0.12010000.5 2012/03/15 13:44:23 gigupta noship $*/
/*$Header: farsvinb.pls 120.0.12010000.20 2012/03/15 14:15:31 gigupta noship $*/
Errors
--------------------------------------------------------------------------------
1455 PL/SQL: ORA-00904: "ASSET_NUMBER": invalid identifier
1434 PL/SQL: SQL Statement ignored
Thank you,
Eric.