Patching

Oracle Patch 9794557 – NULL and NOT NULL conditions

with regards to

Patch 9794557;

I have checked patch on MOS. It is available for EBS 12.1 and there is no superseded info available in patch search which means that patch is not superseded. If it would be then in patch search window you would see that and link to new patch.

Not sure how relevant it is but please check:

What is the Latest E-Business Tax (eBTax) Rule Engine Patch? (Doc ID 1301356.1)

Oracle R12: Patch 21696441: Unable to validate some of the invoices (upgraded & new

We recently had an email from a client about Patch 21696441 and this is what they said;

“Top tip for you – do not install “Patch 21696441: Unable to validate some of the invoices (upgraded & new)”.  It completely messes up the database, and various tax tables will not compile.  We installed this as part of some AGIS trouble shooting.”

So install with caution and throughly test.

Oracle R12 eBTax – EMEA VAT SELECTION PROCESS Finally faster!

This blog should affect every single entity using Oracle in the EU but as we usually find, the majority of tax configuration for Oracle R12 has been badly done by the various integration partners and the EU reporting functionality completely missed and nowhere to be seen! Oracle have provided an excellent solution with the European Tax Reporting Ledger but it is often completely missed. But for those of you who have set your solution up correctly, you will often be frustrated by how long the EMEA VAT: Selection Process takes to run and for some large companies we have done work for, the times can be more than 24 hours! Something completely unacceptable for busy tax departments.

But fear not, Oracle now have a fix.

Patch 17976021: MINIMUM TAX REPORTING DATE PARAMETER REQUIRED IN EMEA VAT SELECTION PROCESS TO AVOID PERFORMANCE ISSUE

Continue Reading

Oracle R12 eBTax – R12.1: E-Business Tax Recommended Patch Collection (ZX), Feb 2015

R12.1: E-Business Tax Recommended Patch Collection (ZX), Feb 2015

Patch 20042161:R12.ZX.B 

  • Contains all recommended fixes on top of 12.1 for eBTax including root cause fixes for data corruption
  • Very small footprint only 158 files
  • Can be applied on top of any 12.1.x instance
  • Also apply Tax Reporting Cumulative Patch. See Document ID 1603669.1 for details.

R12.1: E-Business Tax Reporting Ledger Recommended Patch Collection (ZX), Feb 2015

Patch 20307606:R12.ZX.B

  • Contains all recommended fixes on top of 12.1 for eBTax including root cause fixes for data corruption
  • Very small footprint only 72 files
  • Can be applied on top of any 12.1.x instance
  • Also apply Tax Reporting Cumulative Patch. See Document ID 1603669.1 for details.

Continue Reading

Does patch 12726737 meet all the requirements?

patch 12726737

There is a patch ‘For automated tax date for AP and AR transactions – patch 12726737 – Used for ECE reports’ from Oracle that will apply a tax date to every transaction (subject to the country linked to the OU). What this means is that whilst an invoice, either in AP or in AR can have an invoice (or transaction) date, the tax date will default based on the GL date.

For AP this means that if an invoice was entered in March that has an invoice date of January, whilst the tax rate itself is determined based on the invoice date, the tax date will default to the GL date of March if no manual tax date is entered. This is how Oracle currently do things by using the GL date but this is in fact not correct and an SR will be raised. The issue is that if we close the period within 5 days after 31st Jan, we have not necessarily closed the tax period. With most countries, the tax return has to be done before the end of the next month. This means that most companies can still receive and enter invoices for January in the February GL period and include them on the January return. If we base this on the tax date and the tax date defaults from the GL date and the GL date is based on the system date then those January invoices entered in February only be reported in February. We will need to raise an SR on this.

Oracle R12 Paches requried for eBiz Answers US Rates data file load

Patches for eBTax Upload Process Comments
Patch Number Description Category
Patch 9173819 VANITY CHANGES FOR TAX PARTNERS Upload Process
Patch 9724954 DATAFIX TO CORRECT THE DATA UPLOADED USING DATA UPLOAD Upload Process
Patch 9676886 ERROR IN ZXUPPROCESSDATA MODULE: E-BUSINESS TAX CONTENT UPLOAD PROCESS DATA PROG Upload Process
Patch 7623657 INCORRECT RECORDS ARE INSERTED INTO ZX_ACCOUNTS EBTax Tax Engine Tax Accounting Defaulting Logic
Patch 14544974 Patch to support CCH Tax Partner Data Upload Upload Process Latest version of the Upload Process
Patch 8747425 TAX NOT CALCULATING AFTER UPGRADING TO 12.1.1 FROM 11.5.9 DUE TO MISSING SETUPS eBTax Required for upgraded environments

September 2014 – Latest Oracle Patches for R12 eBTax

Important Patches

August 2014 Tax Recommended Patch 19155343:R12.ZX.B

Minor update to Swiss Registration Number Validation 18798030:R12.ZX.B

Fix to retain same functional currency amount in Oracle and Partner repositories 19221005:R12.ZX.B

eBTax content upload program to ignore Canadian payroll records from Vertex 18347471:R12.ZX.B

eBTax Setup upgrade
How to Perform a Sanity Check To Verify if The Upgrade Was All Fine (Doc ID 1596476.1)

Patch 19155343: R12.1: E-BUSINESS TAX RECOMMENDED PATCH COLLECTION (ZX RPC), AUG 2014

A new patch collection for eBTax has been released but at this time (1st September) there does not seem to be much detailed information about the new changes!

The patch infomation can be found here https://support.oracle.com/epmos/faces/DocumentDisplay?id=1481235.1

Or Oracle Support Document 1336674.2 (Information Center: Oracle E-Business Tax Release 12 ) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1336674.2

Oracle R12 eBTax – Patch to drive Place of Supply rule from POO (Point of Origin) or POA (Point of Acceptance)

Oracle eBTax POS rules Options

Place of Supply (POS) options for Tax Rules

Finally, Oracle have released a patch that allows the place of supply to be driven from the point of origin (POO) or the point of acceptance.

Previously only the ‘ship from’, the ‘ship to’, ‘bill from’ or ‘bill to’ even thought he POA and POO were options, they simply did not do anything.

Continue Reading

Oracle R12 eBusiness Tax suggested patches

We all know Oracle likes its ‘features’ but when we need to remove said features we need to apply a patch. What are the recommended patches needed for ebtax?

Below are some patches that I would suggest are applied for every ebtax solution.

14277162:R12.ZX.B – R12.1: E-Business Tax Recommended Patch Collection (ZX), August 2012 – we needed to apply this one recently to get over some intercompany AP issues where the AP transaction was trying to use the tax fromt he AR transaction.

also, the latest patch set (at time of wrting this) is 

Oracle Support Document 1481235.1 (NEW! R12.1: E-Business Tax Recommended Patch Collection (ZX RPC), March 2013) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1481235.1

New Swiss (CHE) Tax Registration Number [ID 1521534.1]