Package CS_PARTYMERGE_PKG Is Invalid After Applying Patch 8204291

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    Package CS_PARTYMERGE_PKG Is Invalid After Applying Patch 8204291

Symptoms:

Note.842007.1 content
-------------------------------
Symptoms
Package CS_PARTYMERGE_PKG becomes invalid after applying <<Patch 8204291>> - 11.5.10 CS Feb'09.   

Manually re-compiling the package, using the command "alter package apps.CS_PARTYMERGE_PKG compile body;" ... returned the following errors.

PLS-00201: identifier 'CS_PARTYMERGE_PKG' must be declared 
PLS-00304: cannot compile body of 'CS_PARTYMERGE_PKG' without its specification


Cause
Same issue was reported in <<Note 738740.1>> re: no specification for CS_PARTYMERGE_PKG package body.  The file 'cssrpmns.pls' is missing from the patch.

Internal Bug.8449015 - 11.5.10.7.0 CS.INV.1 INVALID OBJECTS FOUND BY AUTOBUILD addresses this issue.


Solution
The missing package is available as part of (Dev controlled) Patch 4865965.

Analysis
----------------
Having reviewed both Notes 842007.1 and 738740.1 , I find that the 

The file 'cssrpmns.pls'  which is the CS_PARTYMERGE_PKG package specification is missing from the monthly 
service patches in
Patch 8204291 11.5.10: BUG FIXES FOR CS: FEB 09 PATCH
Patch 7309926 11.5.10  BUG FIXES FOR CS: JUL 08 PATCH
and in the one that this customer applied which is  Patch  7581246 11.5.10: BUG FIXES FOR CS: DEC 08 PATCH

In the internal Bug 8449015 the solution given is to apply the control Patch 4865965 which has cssrpmns.pls create the package specs and cssrpmnb.pls create the package body. 

The same solution is given in Notes 842007.1 and .738740.1 .

Reviewing control Patch 4865965 for it's suitability for this Customer environment 11.5.10.

It sets out that this patch might not be suitable for 11.5.10 as it was built for 11.5.10.1 and to get Development advice first.  Also shows that  control Patch 4865965 is actually built to resolve the performance issue for the party merge program.  

Solution:

The package specification file cssrpmns.pls was missing from patch 7581246 

Either apply Patch 6035651 - APPSPERF: CS: USE THE PRIMARY KEY PARAMETER TO PERFORM PARTY MERGE

or Simple solution is for Support to download it from aru, and then email it to customer.

References:

Note.842007.1 Package CS_PARTYMERGE_PKG Is Invalid After Applying Patch 8204291

Note.738740.1 PLS-00201 and PLS-00304 Errors when Compile Package Body CS_PARTYMERGE_PKG

Get Oracle Certifications for all Exams
Free Online Exams.com