This is the log file when Applying 8530033. This document lists in detail errors encountered when applying patch 8530033 and all the fixes.
Disclaimer: Apply to a TEST environment first. Use on production systems is at DBAs own risk.
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.