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

MOSC Banner

Patch10229047:R12.XLA.A 9937149:R12.XLA.A 13717941:R12.XLA.A XLA_AE_LINES_PKG is invalid

edited Jun 20, 2018 10:15AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 15 commentsAnswered

:12.0.4 version, Patch Application Issues

After applying 3 patches:
    10229047:R12.XLA.A
    9937149:R12.XLA.A
    13717941:R12.XLA.A 
XLA_AE_LINES_PKG  is invalid with error:

ERROR
-----------------------
PL/SQL: ORA-00904: "DERIVED_EXH_RATE": incalid identifier
PL/SQL: ORA-00904: "XALG"."DERIVED_EXCH_RATE": invalid identifier

"/* $Header: xlajelns.pkh 120.39.12000000.8 2011/12/09 08:14:26 vgopiset ship $  */
"
"/* $Header: xlajelns.pkb 120.175.12000000.88 2012/04/19 04:46:42 sgullape ship $  */
"

Customer's file versions:
xlaapche.pkh 120.13.12000000.3
xlaapche.pkb 120.54.12000000.2
xla_ae_lines_gt.xdf 120.19.12000000.10

Customer recompiled app schema and (xla) forms & libraries, but and still has the invalid.

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