EBS: R12.1 Oracle Financials Recommended Patches [ID 954704.1]

EBS: R12.1 Oracle Financials Recommended Patches [ID 954704.1]
		Modified 21-JUL-2011 Type ALERT Status PUBLISHED

In this Document
Description
Product-Specific Recommended Patches
R12.1 Pre-Upgrade Patches
Likelihood of Occurrence
Possible Symptoms
Workaround or Resolution
Patches
Modification History
References

---

Applies to:

Oracle Assets - Version: 12.1 to 12.1.2 - Release: 12.1 to 12.1
Oracle Internet Expenses - Version: 12.1 to 12.1.2 [Release: 12.1 to 12.1]
Oracle Receivables - Version: 12.1 to 12.1.2 [Release: 12.0 to 12.1]
Oracle General Ledger - Version: 12.1 to 12.1.2 [Release: 12.1 to 12.1]
Oracle Payables - Version: 12.1.0 to 12.1.2 [Release: 12.0 to 12.0]
Information in this document applies to any platform.

Description

This document contains links to the Release 12.1 Financial products that have released Development Recommended one-off or rollup patches after the EBS suite-wide Release 12.1.x. Information about the patches are provided in the documents listed below.

Attention 11i Customers who are planning their upgrade to Release 12.1.x

If you are planning an upgrade from Release 11i to 12.1.x, please review the README for the
EBS Consolidated Upgrade Patch 7303029 AND Document 1127593.1 -- See information below.
Document 1127593.1 lists a number of Oracle Financials pre-upgrade patches that
are required in order for the Release 12.1 upgrade to complete successfully.

Product-Specific Recommended Patches

Product	Patch	Additional Included Fixes (or previous fixes in same codeline)	Description/Symptoms	Comments	Last Update
E-BUSINESS TAX (EBTAX)	Patch 8877828:R12.ZX.B (8877828:R12.ZX.B)	Bug 8251315, Bug 8307880, Bug 8351127,Bug 8371282, Bug 8394462, Bug 8412899,Bug 8502340, Bug 8540809, Bug 8564908	Bulk invoice validation failed with error - Ora-20001:Summary tax line deleted by ebtax or Ora-20001:Frozen Tax Distributions deleted by ebtax	Included in 12.1.2 (7303033) and above	21-July-11
E-BUSINESS TAX (EBTAX)	Patch 10072294 10072294:R12.ZX.B	Bug 10072294, Bug 8635182	Invoice Workbench will no longer error while saving PO matched invoices when tax amount on multiple lines is updated using Tax Details window (See Note 1288314.1).	Apply on top of any 12.1.x instance	12-Jul-11
E-BUSINESS TAX (EBTAX)	Patch 10296081 10296081:R12.ZX.B	Several, please see Patch Readme	Invoice validation program now successfully revalidates adjusted invoices having manual tax line associated with an offset tax rate code and no longer give 'Summary Tax Line deleted by EBTax' error (See Note 1316316.1).	Apply on top of any 12.1.x instance Further instructions on Patch Readme	12-Jul-11
ORACLE ASSETS (FA)	Document 944315.1 Patch 8706842 (8706842:R12.FA.B)	n.a.	n.a.	Included in 12.1.2 (7303033) and above Very important post-application steps in Patch Readme	21-July-11
PUBLIC SECTOR ACCOUNTING (PSA) - Critical Rollup Patch	Patch 9100984 9100984:R12.PSA.B	n.a.	n.a.	Included in 12.1.3 (9239090) and above Very important pre and post-requisites in Patch Readme	21-July-11
ORACLE PAYMENTS (IBY) Oracle Payment Application Data Security Standard PA-DSS Consolidated Patch	Document 981033.1 / Patch 8937577 8937577:R12.IBY.B	n.a.	n.a.	Included in 12.1.3 (9239090) and above This PA-DSS consolidated patch allows Oracle Payments customers to benefit from the ongoing enhancements made to conform to PA-DSS requirements.	21-July-11
ORACLE RECEIVABLES - Rollup Patches	Patch 11776066 11776066:R12.AR.B	n.a.	n.a.	Apply on top of any 12.1.x instance Important post application steps in Patch Readme	21-Jul-11
ORACLE PAYABLES - General	Patch 8638587 8638587:R12.AP.B	Bug 8264122, Bug 8328412, Bug 7339389,Bug 7831956, Bug 8219586	Not able to create Supplier Contact with Phone having more than 15 chars through the Supplier Site Contacts Import, even though user can entern Contact Phone with 40 characters through the App. Additionally, the Import was not working if the Interface record contained vendor_site_code but not vendor_site_id. Supplier Import does not process URL information.	Included in 12.1.2 (7303033) and above	21-Jul-11
ORACLE PAYABLES - Accounting	Patch 10148895 10148895:R12.AP.B	Several, please see Patch Readme.	For CASH SOB, if invoice is PO matched and Accrue On Receipt Flag is Yes, then during payment accounting the PO Charge Account is being considered as the Accrual account instead of the AP Accrual Account.	Apply on top of any 12.1.x instance Follow Steps on Note 1267188.1 as pre-requisite. Further instructions in Patch Readme.	21-Jul-11
ORACLE PAYABLES - Accounting, Payments	Patch 11777929 11777929:R12.AP.B	Several, please see Patch Readme.	Whenever a payment is voided, accounting will be generated using transaction reversal, which reverses any entry that were created earlier through bypassing the extract/JLTs. For Federal, there is a requirement, where for certain transactions (prior year transactions) a different account must be used for reversal accounting entries.	Apply on top of any 12.1.x instance Follow Steps on Note 1267188.1 as pre-requisite. Further instructions in Patch Readme.	21-Jul-11
ORACLE PAYABLES - Invoices	Patch 10288184 10288184:R12.AP.B	Several, please see Patch Readme.	Invoices that are matched with closed PO's (Changes PO approval from Approved to Approved/Close), cannot be imported and throws the rejection reason as 'Inactive PO'.	Apply on top of any 12.1.x instance Follow Steps on Note 1267188.1 as pre-requisite. Further instructions in Patch Readme.	21-Jul-11
ORACLE PAYABLES - Payments	Patch 11063950 11063950:R12.AP.B	Several, please see Patch Readme	PPR is getting terminated even though Concurrent program Build Payment has not completed. If concurrent program Build Payments is in progress, PPR is should not terminate when clicking the TERMINATE icon.	Apply on top of any 12.1.x instance	21-Jul-11
ORACLE PAYABLES - Payments, Accounting	Patch 11676632 11676632:R12.AP.B	Several, please see Patch Readme	Payment Workbench now successfully creates manual payment for multiple invoices belonging to different supplier sites, without giving the "Check data is out-of-sync for check number: &CHECK_ID" error (See Note 1337426.1). Create Accounting program now successfully accounts manually adjusted refunds accounting events (See Note 1280535.1). Create Acccounting program now successfully accounts the maturity accounting events for foreign currency invoices having Bill Payables payment method and paid through "Pay-in-Full" functionality (See Note 1239323.1).	Apply on top of any 12.1.x instance Important instructions in Patch Readme.	21-Jul-11
ORACLE PAYABLES - Invoices	Patch 9001504 9001504:R12.AP.B	Several, please see Patch Readme	IPV distributions from price corrected credit memo do not get transferred to FA for mass additions.	Included in 12.1.3 (9239090) and above	21-Jul-11
ORACLE PAYABLES - Invoices, Payments	Patch 9643901 9643901:R12.AP.B	Several, please see Patch Readme	System allowed to apply prepayments on a standard invoice for more than the invoice amount, when multiple prepayments were selected from prepayment apply/unapply window in the standard invoice context. This happened when the total sum of the prepayments was more than the standard invoice amount but their individual value was less than equal to the standard invoice.	Apply on top of any 12.1.x instance Follow Steps on Note 1267188.1 as pre-requisite. Further instructions in Patch Readme.	21-Jul-11
ORACLE PAYABLES - Invoices	Patch 9695849 9695849:R12.AP.B	Several, please see Patch Readme	The default distribution account is cleared when user changes the GL date on the Lines tab, after validating the invoice or after the distributions are generated for the invoice.	Apply on top of any 12.1.x instance Follow Steps on Note 1267188.1 as pre-requisite. Further instructions in Patch Readme.	21-Jul-11
ORACLE PAYABLES - Invoices	Patch 10052153 10052153:R12.AP.B	Several, please see Patch Readme	After Allocating Freight and/or Miscellaneous line to Item lines using 'FULLY PRORATED' rule type from allocations window, allocated charges on individual ITEM lines were not visible, when allocation window was opened from ITEM line context.	Apply on top of any 12.1.x instance Follow Steps on Note 1267188.1 as pre-requisite. Further instructions in Patch Readme.	21-Jul-11
ORACLE PAYABLES - Invoices, Payments	Patch 11720134 11720134:R12.AP.B	Several, please see Patch Readme	Format Payment Instruction no longer errors out with "ORA-01422: exact fetch returns more than requested number of rows" when submitted using a responsibility having access to multiple operating units with one or more operating units having automatic offset and payment time withholding enabled (See Note 1308616.1) Payables will no longer generate withholding invoices at the time of invoice cancellation if the 'Create Withholding Invoice' is set to 'Payment' time (See Note 1291134.1)	Apply on top of any 12.1.x instance	21-Jul-11
ORACLE PAYABLES - Invoices	Patch 10431161 10431161:R12.AP.B	Several, please see Patch Readme	Invoice Workbench now prevents saving the invoice when a new invoice line is copied from a previous invoice line that had the GL date in closed period (See Note 1264960.1). Invoice Validation program now exclusively locks the selected invoices and are not available for update from Invoice Workbench (SeeNote 1264960.1). Invoice Workbench no longer allows cancelation of summary tax lines generated as part of prepayment application on standard invoices from Tax Details and displays error message "Cancellation of the Summary line is not allowed" (SeeNote 1216453.1). Invoice Workbench now correctly allows the reversal of a posted invoice distribution without changing the approval status of the parent distribution (See Note 1266869.1). Invoice Workbench no longer allows following actions: a) update amount and distribution type for existing tax distributions b) create manual tax distributions under inclusive tax item lines from the All Distributions window (See Note 1338001.1).	Apply on top of any 12.1.x instance	21-Jul-11
ORACLE PAYABLES - Invoices	Patch 10353568 10353568:R12.AP.B	Several, please see Patch Readme	Payables now successfully calculates payment time withholding tax amounts for invoices having reversed/discarded item lines by successfully allocating withholding amount over cancelled tax distributions (See Note 1338164.1). Invoice Validation program now continues bulk processing of invoices even when the process encounters an error during tax validation on any of the invoices (See Note 1184876.1) Payables now correctly calculates taxes that are based on distribution accounts for imported PO matched invoices (See Note 1338164.1). Payables now correctly populates the GL date on tax distributions by taking the GL date from the credit memo line instead of the standard invoice for credit memos created using Quick Credit functionality (See Note 1338164.1 and Note 1220114.1). Payables now successfully validates existing invoices having system generated tax distributions on item lines that were discarded after accessing "All Distributions" window of the Invoice Workbench (See Note 1338370.1).	Apply on top of any 12.1.x instance Follow Steps on Note 1267188.1 as pre-requisite. Further instructions in Patch Readme.	12-Jul-11
ORACLE PAYABLES - Accounting	Patch 10409166 10409166:R12.AP.B	Several, please see Patch Readme	Create Accounting program now correctly creates payment clearing accounting entries for payments having bank charges associated with them. The program no longer gives the error "The account on the gain or loss line is invalid" while accounting such accounting events (See Note 1323394.1). Create Accounting program now successfully create accounting entries for prepayments that were unapplied after upgrade. The program no longer gives the error ORA-00001: unique constraint (XLA.XLA_DISTRIBUTION_LINKS_U1) violated while processing Invoice_ID :XXX" for such accounting events. (See Note 1205084.1). Create Accounting program now successfully creates accounting entries for foreign currency invoice payments having discounts when the accounting option is set as "Always" and Gain/Loss Calculation option is set to "Clearing" time. The program no longer gives the error "The total debits and the total credits do not balance for this subledger journal entry." (See Note 1296239.1).	Apply on top of any 12.1.x instance Follow Steps on Note 1267188.1 as pre-requisite. Further instructions in Patch Readme.	12-Jul-11
ORACLE PAYABLES - Payments	Patch 11699958 11699958:R12.IBY.B	Several, please see Patch Readme	Invoices no longer remain in selected for payment status when the Payment Process Request fails during payment completion stage (See Note 1338425.1).	Apply on top of any 12.1.x instance	12-Jul-11
ORACLE PAYABLES - Payments	Patch 10234963 10234963:R12.IBY.B	Several, please see Patch Readme	External bank account update page now successfully retains the IBAN updated by user. (See Note 1265328.1).	Apply on top of any 12.1.x instance	12-Jul-11
ORACLE SUBLEDGER ACCOUNTING	Patch 11903966 11903966:R12.XLA.B	Several, please see Patch Readme	Create Accounting program now successfully a) Gives a warning 'No eligible transactions to account' only when transaction details are missing for unprocessed events b) Stops when the Error Limit is reached whenever FND_CONNECTION_TAGGING profile is set to Yes (See Note 1315042.1).	Apply on top of any 12.1.x instance Further instructions in Patch Readme.	12-Jul-11
ORACLE SUBLEDGER ACCOUNTING	Patch 11666797 11666797:R12.XLA.B	Several, please see Patch Readme	Concurrent execution of Online Accounting creating journal entries against Control Accounts no longer ends in error due to locking issues in control account balances calculation. Third Party Control Account Balances report has been modified to display warning if journal entries pending balances computation exist for the period for which the report is executed (See Note 1304736.1).	Apply on top of any 12.1.x instance Further instructions in Patch Readme.	12-Jul-11
ORACLE SUBLEDGER ACCOUNTING	Patch 10649546 10649546:R12.XLA.B	Several, please see Patch Readme	Invoices no longer go on Funds Check holds when there exists multiple entities for the same invoice in Subledger Accounting repository due to prior Funds Check failures (See Note 1338429.1).	Apply on top of any 12.1.x instance Further instructions in Patch Readme.	12-Jul-11

R12.1 Pre-Upgrade Patches

• EBS Consolidated Upgrade Patch - Feb 2010

Customers who are planning to upgrade from Release 11i to 12.1.x, should apply the R12.1 EBS Consolidated Upgrade Patch (CUP) - Patch 7303029. The CUP is only applicable to 11i customers who have NOT already upgraded to 12.1.x. The CUP must be applied on top of an R12.1.1 APPL_TOP.

Release 12.1.x customers need NOT apply the CUP patch.

• Financials Pre-Upgrade Patches - April 2011

There are several Oracle Financials Release 12.1 pre-upgrade patches that were released after the EBS CUP in Feb 2010. We are tracking the list via Document 1127593.1. Please review its content and apply the pre-upgrade patches before you complete your upgrade to Release 12.1.