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

MOSC Banner

R12.1.1 : packages ARP_XLA_EXTRACT_MAIN_PKG invalid PLS-00357: Table,View Or Sequence reference 'AR_

edited May 9, 2013 6:55AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered

hello,

after patching in test instance we have the ackage  ARP_XLA_EXTRACT_MAIN_PKG invalid
 invalid, several notes found here suggests to install patch 10047351, but this have some prereq (9449218, 9172279) that can be applied only on top of 12.1.2, how to solve without upgrading to 12.1.2?

Error and versions for packages ARP_XLA_EXTRACT_MAIN_PKG invalid


/* $Header: ARPXLEXS.pls 120.8.12010000.4 2009/02/23 22:45:25 ankausha ship $ */
/* $Header: ARPXLEXB.pls 120.83.12010000.64 2010/08/19 12:38:59 rmanikan ship $ */

5380 PLS-00357: Table,View Or Sequence reference 'AR_MFAR_EXTRACT_S.NEXTVAL' not allowed in this context
5380 PL/SQL: Statement ignored


5380            l_cm_app_mfar_extract_tab(k).LINE_NUMBER             := -1 * ar_mfar_extract_s.nextval;

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