invalid objects after upgradind 11.5.9 to 12.1.3 and rpc2

Nov 13, 2014 12:17PM

Hello:

After upgrading to 12.1.3 and patching rpc2, i still have 22 invalid objects that i can't compile.

I know most of them would compile if i upgrade to oracle 11g, but this is not planned yet.

I tried to look up any solution on metalink but i did not find anything.

I list all the objects and its error below:

/************************************************

OS Red Hat Enterprise Linux AS release 4 (Nahant Update 8)

RDBMS 10.2.0.4

EBS 11.5.9 TO 12.1.3

*************************************************/

---- INVALID OBJECTS-----

OWNER,OBJECT_NAME,OBJECT_TYPE,STATUS

APPS,AHL_WARRANTY_CONTRACTS_PVT,PACKAGE BODY,INVALID

err: PACKAGE BODY APPS.AHL_WARRANTY_CONTRACTS_PVT

On line: 413

PLS-00357: Table,View Or Sequence reference 'AHL_WARRANTY_CONTRACTS_B_S.NEXTVAL' not allowed in this context

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