garden1.jpg

8530033 : US HR 2009 Annual Statutory Patch


This is the log file when Applying 8530033. This document lists in detail errors encountered when applying patch 8530033 and all the fixes.

Applying 8530033 : US HR 2009 Annual Statutory Patch for Release R11i

Human Resources Suite Family

Patch size 115M

Requested : HR Annual.

Reading readme file….

TEST:

Before patch:

Prerequisites:

5589335 – –>already there.

3167649 – –>already there.

4894013 – –>already there.

3334985 – –>already there.

2655277 – –>already there.

2949264 – –>already there.

3641831 – –>already there.

3594604 – –>already there.

4068109 – –>already there.

3942438 – –>already there.

3671463 – –>already there.

3554613 – –>already there.

4038964 – –>already there.

3412795 – –>already there.

3313291 – –>already there.

4155265 – –>already there.

3871740 – –>already there.

4030688 – –>already there.

5337777 – –>already there.

Stop Apps.

Applied to TEST on 08-Sep-09 at 4 PM.

Apply u5922545.drv to Node1 the Node2

On node1 it run for 50 minutes no errors.

On node2 it run for 30 minutes no errors.

Logfiles:

Node1: /u08/app/R11i/testappl/admin/TEST/log/adpatch_u8530033.log

Node2: /u03/app/R11i/testappl/admin/TEST/log/adpatch_u8530033.log

Invalid objects:

After the patch I have the following invalid objects:

OWNER OBJECT_NAME OBJECT_TYPE CREATED

STATUS

———- ———————————– ——————– ——— ————————–

APPS BIM_I_LEAD_MGMT_PVT PACKAGE BODY 22-NOV-07

APPS FND_OID_DIAG PACKAGE BODY 01-DEC-07

APPS HRDPP_CREATE_US_APPLICANT PACKAGE BODY 09-AUG-08

APPS HR_CANCEL_HIRE_API PACKAGE BODY 26-OCT-02

Investigating invalid obj:

SQL> set serveroutput on size 100000

SQL> alter PACKAGE HR_CANCEL_HIRE_API compile BODY ;

Warning: Package Body altered with compilation errors.

SQL> show error

Errors for PACKAGE BODY HR_CANCEL_HIRE_API:

LINE/COL ERROR

——– —————————————————————–

434/6 PL/SQL: Statement ignored

434/33 PLS-00302: component ‘CANCEL_EMP_APL_HIRE’ must be declared

SQL> alter PACKAGE HRDPP_CREATE_US_APPLICANT compile BODY ;

Warning: Package Body altered with compilation errors.

SQL> show error

Errors for PACKAGE BODY HRDPP_CREATE_US_APPLICANT:

LINE/COL ERROR

——– —————————————————————–

651/1 PLS-00307: too many declarations of ‘CREATE_US_APPLICANT’ match this call

651/1 PL/SQL: Statement ignored

I found Metalink note 859686.1 describing the same issue.

The note says to verify headers for the following files and make sure it matches

headers on the note:

ident /u08/app/R11i/testappl/per/11.5.0/patch/115/sql/pecahapi.pkb

/u08/app/R11i/testappl/per/11.5.0/patch/115/sql/pecahapi.pkb:

$Header: pecahapi.pkb 115.9 2008/10/01 10:43:23 ghshanka noship $

–>This is a match.

ident /u08/app/R11i/testappl/per/11.5.0/patch/115/sql/pecanhir.pkh

/u08/app/R11i/testappl/per/11.5.0/patch/115/sql/pecanhir.pkh:

$Header: pecanhir.pkh 115.5 2002/12/04 10:00:36 mgettins ship $

–>This is a match.

ident /u08/app/R11i/testappl/per/11.5.0/patch/115/sql/pecanhir.pkb

/u08/app/R11i/testappl/per/11.5.0/patch/115/sql/pecanhir.pkb:

$Header: pecanhir.pkb 115.57 2008/05/19 09:51:57 ktithy ship $

–>This is a match.

Fix:

Patch 7479994 : NEED POSIBILITY TO CORRECT WRONG HIRE DATE OF EMPLOYEE HIRE INTO

Applying 7479994:

Prerequisites:

6699770 : –>Already there.

4337683 : –>Already there.

Applied to TEST on 09/09/09 at 9 AM.

Apply u7479994.drv to Node1 the Node2

On node1 it run for 5 minutes no errors.

On node2 it run for 30 minutes no errors.

Logfiles:

Node1: /u08/app/R11i/testappl/admin/TEST/log/adpatch_u7479994.log

Node2: /u03/app/R11i/testappl/admin/TEST/log/adpatch_u7479994.log

Post: None.

Invalid obj:

This patch fixed invalid obj HR_CANCEL_HIRE_API but HRDPP_CREATE_US_APPLICANT is still invalid.

No additional invalid objects.

Investigating invalid obj HRDPP_CREATE_US_APPLICANT:

SQL> set serveroutput on size 100000

SQL> alter PACKAGE HRDPP_CREATE_US_APPLICANT compile BODY ;

Warning: Package Body altered with compilation errors.

SQL> show error

Errors for PACKAGE BODY HRDPP_CREATE_US_APPLICANT:

LINE/COL ERROR

——– —————————————————————–

651/1 PLS-00307: too many declarations of ‘CREATE_US_APPLICANT’ match this call

651/1 PL/SQL: Statement ignored

I did a metalink search for HRDPP:

HRDPP stands for HR data pump process.

I found Metalink note 1082105.6 which describes what to do with HRDPP invalid objects.

It says to logon as apps and run the following:

execute HR_PUMP_META_MAPPER.GENERATEALL;

PL/SQL procedure successfully completed.

–>This run for less than a minute no error.

–>This fixed invalid object HRDPP_CREATE_US_APPLICANT.

For more information on Data Pump and the Meta Mapper process, please see

Note(Sure) 72564.1 Understanding and Using the HRMS Data Pump

In file $FND_TOP/reports/PSTPL.prt change the line

printer Pasta Portrait Letter”

to

printer “Pasta Portrait Letter”

i.e. insert double quote before ‘Pasta’.

–>This was changed by the patch…..

–>I corrected it.

Completed on 09-Sep-09 at 10:15 AM.

Latest Blog Items

email

Thank you for your interest in idbasolutions.

Contact us using this email: contact.us@idbasolutions.com