My Oracle Support Banner

R12 / 11i FA.M-P RECOMMENDED PATCH LIST (Doc ID 466607.1)

Last updated on APRIL 17, 2020

Applies to:

Oracle Assets - Version 11.5.10.0 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Purpose

The purpose of this document is to provide the FA recommended patch list for R12 and 11i (from FA.M to FA.P).

Scope

Everyone that has one of the FA patch levels that this document addresses is recommended to apply the patches listed below. You should apply ONLY those patches that are recommended for your current FA megapatch level.

It is recommended to apply and test the patches on your TEST instance first.

R 12 FA PATCH LIST

R12 FA Recommended Patch List

Patch # Patch Name Patch Type Recommended By
<Patch 22485014> R12.1: Fixed Assets Recommended Patch Collection, Feb 2016 Rollup Development and Reference <Note 2109254.1>
<Patch 8706840> R12.0 Assets Consolidated Patch Rollup Development and <Note 951284.1>
<Patch 12810804 > R12.1.1 Consolidated Patch Rollup Development and <Note 1317061.1>
<Patch 13340858> R12 FATRACE DOES NOT DISPLAY XLA TRANSFER INFORMATION FOR REINSTATEMENTS RollUp Development

The following script can be used to verify if the R12 FA recommended patches have been applied:

SELECT
DISTINCT RPAD(a.bug_number, 11)|| RPAD(e.patch_name, 11)|| RPAD(TRUNC(c.end_date),
12)|| RPAD(b.applied_flag, 4)
FROM
ad_bugs a, ad_patch_run_bugs b, ad_patch_runs c, ad_patch_drivers d ,
ad_applied_patches e
WHERE
a.bug_id = b.bug_id AND b.patch_run_id = c.patch_run_id AND
c.patch_driver_id = d.patch_driver_id AND d.applied_patch_id = e.applied_patch_id AND
a.bug_number in ('22485014', '13340858', '8706840', '12810804') ORDER BY 1 DESC;

 

11i FA.M-P RECOMMENDED PATCH LIST

FA.P Recommended Patch List

Patch # Patch Name Patch Type Recommended By
<Patch 7427746> Dec 2008 Assets 11i Consolidated RUP Rollup ORACLE DEVELOPMENT*
If you are using group asset functionality you shouldn't apply this patch as it overwrites the branched code fixes that are the latest Group fixes for 11i.
<Patch 7044061>
Or Control Released <Patch 12917904>
1OFF: 7044061 - LATEST CREATE JOURNAL ENTRIES ROLLUP PATCH

FAPOST PROGRAM/EXECUTABLE OUT OF SYNC
Rollup ORACLE DEVELOPMENT
<Patch 18376296> Consolidate Retirement Fixes Rollup ORACLE DEVELOPMENT
<Patch 12400927> BACKPORT:11835635:FA.P:11.5.10.2:FAS480 NO DATA FOUND FOR ASSETS USING BONUS RUL One-Off ORACLE DEVELOPMENT for latest code level used on balance reports to eliminate performances issues. Cost Detail Report, Cost Summary Report, Reserve Detail Report, etc..
<Patch 7667777> FA ROLLUP PATCH FOR UK LOCAL AUTHORITY ACCOUNTING ENHANCEMENT(SORP) Rollup ORACLE DEVELOPMENT and <Note.757937.1>
<Patch 6945425> 1OFF:6893944:11I.FA.P:FIN.G:11.5.1:LATEST GROUP DEPRECIATION FIXES Rollup *GROUP ENABLED ONLY*

ORACLE DEVELOPMENT
<Patch 8349148> INVALID PACKAGE BODY AFTER INSTALLING ROLLUP PATCH 7427746 ON TOP OF FA.O One Off <Note 795133.1> and <Note 858053.1>
<Patch 8727602> DEPRECIATION FAILS WITH SIGNAL 11 ERROR One Off <Note.873686.1>
<Patch 7671313> 1OFF: 7604209 : DEPRECIATION RUN HANGS AFTER APPLYING PATCH 7411267 One Off *GROUP ENABLED ONLY*

<Note.785603.1>
<Patch 8449900> MISSING RETIREMENT ROWS IN FA_MC_ADJUSTMENTS FOR TAX BOOK One Off <Note 814697.1>
<Patch 8263761> MULTIPLE RXI REPORTS ERROR PLS-306 WRONG NUMBER ARUGUMENTS 'GET_REPORT_INFO' One Off  
<Patch 7348096> AFTER FA ROLLUP PATCH: 6883483 ALL RXI REPORTS FAIL WITH FARXPBSH SIGNAL 10 11 One Off  
<Patch 8583764> PC BUG8366107:JOURNAL ENTRY DOES NOT BE BALANCED FOR "BONUS RESERVE" One Off  
<Patch 8364402> 1OFF:8231467:11I.FA.P:FIN.G:11.5.10:OVERSTATED EXPENSE AND NBV RETIRED WITH BACK One Off <Note 858053.1> and <Note 796823.1>
<Patch 8291114> 1OFF:8248290:FA.P + 6317575 + 7427746:G:11.5.10.2:UNABLE TO POST THE IMPAIRMENT One Off <Note 788174.1>
<Patch 8861557> 1OFF:7672348:11I.FA.P:FIN.G:11.5.10.2:ERRORS FRM-41084 AND FRM-41045 WHEN OPENIN One Off  
<Patch 8944426> FADRB RE-SETTING FA_BOOKS.ADJ COST One Off  
<Patch 8320142> 1OFF:7836587:11I.FA.P:11.5.10.2:THE AMOUNT OF DEPRECIATION IS WRONG AND DEPRECIATION IS COMPLETE IN ERROR One Off <Note.802973.1>
<Patch 4551444> 1OFF:4457820:ORA-00001 ON FA_BOOK_CONTROLS_GT_U1 FOR SECURED FA RESPONSIBILITY One Off <Note.218249.1>
<Patch 7559354> 1-OFF:6402316: ME: APP-OFA-48289: UNKNOWN ERROR. AFTER SELECTING FINANCIAL INQUIRY One Off <Note 749444.1>
<Patch 9974826> ASSET RETIREMENT CALCULATION IS INCORRECT One Off  

The following script can be used to verify if the FA.P recommended patches have been applied:

SELECT
DISTINCT RPAD(a.bug_number, 11)|| RPAD(e.patch_name, 11)|| RPAD(TRUNC(c.end_date),
12)|| RPAD(b.applied_flag, 4)
FROM
ad_bugs a, ad_patch_run_bugs b, ad_patch_runs c, ad_patch_drivers d ,
ad_applied_patches e
WHERE
a.bug_id = b.bug_id AND b.patch_run_id = c.patch_run_id AND
c.patch_driver_id = d.patch_driver_id AND d.applied_patch_id = e.applied_patch_id AND
a.bug_number in ('12917904', '7427746', '7044061', '7667777', '6945425', '8349148', '8727602', '7671313', '8449900', '8263761', '7348096', '8583764', '8364402', '8291114', '8861557', '8944426', '8320142', '9974826', '7559354', '4551444', '18376296', '12400927') ORDER BY 1 DESC;

 

FA.M/N/O Recommended Patch List

Patch # Patch Name Patch Type Recommended By
<Patch 7427746> Dec 2008 Assets 11i Consolidated RUP Rollup ORACLE DEVELOPMENT* and <Note 828320.1>
If you are using group asset functionality you shouldn't apply this patch as it overwrites the branched code fixes that are the latest Group fixes for 11i.
<Patch 7667777> FA ROLLUP PATCH FOR UK LOCAL AUTHORITY ACCOUNTING ENHANCEMENT(SORP) Rollup ORACLE DEVELOPMENT and <Note.757937.1> and <Note 828320.1>
<Patch 7044061>
or
Control Relase <Patch 12917904>
1OFF: 7044061 - LATEST CREATE JOURNAL ENTRIES ROLLUP PATCH

FAPOST PROGRAM/EXECUTABLE OUT OF SYNC
Rollup ORACLE DEVELOPMENT
<Patch 6945425> LATEST GROUP DEPRECIATION FIXES for code line FA.O Recommended patching.  See Note for pre-reqs *GROUP ENABLED ONLY*

ORACLE DEVELOPMENT
<Patch 8583764> PC BUG8366107:JOURNAL ENTRY DOES NOT BE BALANCED FOR "BONUS RESERVE" One Off  
<Patch 8349148> INVALID PACKAGE BODY AFTER INSTALLING ROLLUP PATCH 7427746 ON TOP OF FA.O One Off <Note 828320.1> and <Note 795133.1>
<Patch 8263761> MULTIPLE RXI REPORTS ERROR PLS-306 WRONG NUMBER ARUGUMENTS 'GET_REPORT_INFO' One Off <Note 828320.1>
<Patch 7348096> AFTER FA ROLLUP PATCH: 6883483 ALL RXI REPORTS FAIL WITH FARXPBSH SIGNAL 10 11 One Off <Note 828320.1>
<Patch 7559354> 1-OFF:6402316: ME: APP-OFA-48289: UNKNOWN ERROR. AFTER SELECTING FINANCIAL INQUIRY One Off <Note 749444.1>

The following script can be used to verify if the FA.M/N/O recommended patches have been applied:

 

SELECT
DISTINCT RPAD(a.bug_number, 11)|| RPAD(e.patch_name, 11)|| RPAD(TRUNC(c.end_date),
12)|| RPAD(b.applied_flag, 4)
FROM
ad_bugs a, ad_patch_run_bugs b, ad_patch_runs c, ad_patch_drivers d ,
ad_applied_patches e
WHERE
a.bug_id = b.bug_id AND b.patch_run_id = c.patch_run_id AND
c.patch_driver_id = d.patch_driver_id AND d.applied_patch_id = e.applied_patch_id AND
a.bug_number in
('12917904', '7427746', '7667777', '7044061', '8583764', '5903227', '8349148', '8263761', '7348096', '7559354')
ORDER BY 1 DESC;

*Note: The patches that are recommended by Development have many documents that recommend them to be applied for various issues.

 

 

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
 R 12 FA PATCH LIST
 11i FA.M-P RECOMMENDED PATCH LIST
Details
 Community Discussions
 Feedback
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.