Patch 14739862 : R12 . FA : After applying patch, Package Body FA_IMPAIRMENT_POST_PVT is Invalid
(Created by Oracle Support on behalf of Customer)
Hi there
We have applied Patch 14739862:R12.FA.B without missing any pre-requisites, but after
applying the patch Package Body FA_IMPAIRMENT_POST_PVT will not compile.
When we try to compile the object manually we can see that the underlying error is :
PL/SQL: ORA-00904: "ITF"."REVAL_LOSS_BALANCE": invalid identifier
PL/SQL: SQL Statement ignored
Checked the package, there is a cursor which selects ITF.REVAL_LOSS_BALANCE from
table FA_MC_ITF_IMPAIRMENTS - the table has no such column.
Please tell me how to proceed,
Thanks
Sabine
Hi there
We have applied Patch 14739862:R12.FA.B without missing any pre-requisites, but after
applying the patch Package Body FA_IMPAIRMENT_POST_PVT will not compile.
When we try to compile the object manually we can see that the underlying error is :
PL/SQL: ORA-00904: "ITF"."REVAL_LOSS_BALANCE": invalid identifier
PL/SQL: SQL Statement ignored
Checked the package, there is a cursor which selects ITF.REVAL_LOSS_BALANCE from
table FA_MC_ITF_IMPAIRMENTS - the table has no such column.
Please tell me how to proceed,
Thanks
Sabine
Tagged:
0