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

MOSC Banner

Patch RMS RUP6 fails on HXT_RETRO_PROCESS

edited Jun 11, 2014 2:49AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 7 commentsAnswered ✓

Hello,

We had applied HRMS RUP6 patch in production instance. Got one package body invalid . Below is the detail :

Package Name : HXT_RETRO_PROCESS

$ ls -lrt hxtrprc*

-rwxr-xr-x   1 aaplprod   dba           3400 Jan 27  2012 hxtrprc.pkh

-rwxr-xr-x   1 aaplprod   dba          26390 Jul 20  2013 hxtrprc.pkb

$ adident Header hxtrprc.pkh

hxtrprc.pkh:

$Header hxtrprc.pkh 120.2 2007/01/05 18:08:56 nissharm noship $

$

$ adident Header hxtrprc.pkb

hxtrprc.pkb:

$Header hxtrprc.pkb 120.3.12010000.5 2011/08/22 09:53:44 asrajago ship $

Getting error as (after trying to compile the same )

SQL> ALTER PACKAGE HXT_RETRO_PROCESS COMPILE BODY;

Warning: Package Body altered with compilation errors.

SQL> show error

Errors for PACKAGE BODY HXT_RETRO_PROCESS:

LINE/COL ERROR

-------- -----------------------------------------------------------------

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