Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

After patch patch 11894044:R12.FA.B package APPS.FA_RSVLDG_REP_INS_PKG is in invalid

edited Oct 18, 2012 6:43AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered ✓

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.


Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center