Support

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)

How to get around the ‘Unable to retrieve content. Additional Information for Remote Region error #6’

During Fusion tax setups, if you come across this error ‘Unable to retrieve content. Additional Information for Remote Region error #6’ when searching for tax rules then the following video should help you out.

 

R12:How to modify/override Recovery Rate in Invoice Workbench (Doc ID 1588011.1)

We recently tried to apply the process to allow for ad-hoc changes to recovery rates and recovery percentages after the recovery tax had been determined. The Oracle note is ‘R12:How to modify/override Recovery Rate in Invoice Workbench (Doc ID 1588011.1)’ and its almost comical in its approach, click here, do that, count to 10, spin around ten times, touch your toes and then click here again. Ok so its not quite as bad as that but not far off.

We have a client who enters invoices for Danish car leasing which usually commands a 50% recovery rate but instead of outlining the exact amount of recovery tax by line, the supplier have an annoying habit of just saying heres the total VAT and here is your recovery tax without linking the two. We desperately wanted to use the ability to change the amount of recovery tax and whilst we were able to change the recovery tax, the percentage was not possible.

The point of this article however is not a ‘how to’ guide but instead to let you know to approach with caution the Oracle note 1588011.1 and in our opinion use a workaround instead where you split the line amount to accommodate this requirement.

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

No Ship to on intercompany invoices – solution

This posting is a direct copy from the Oracle website based on note 1048431.6

For years we have been using a work around but Oracle have now provided the following solution to help with the missing ship-to information badly needed to correctly determine the tax.

Reference INCIAR – Ship-To/Shipto Address Does Not Appear On Intercompany AR Invoices (INCIAR) (Doc ID 1048431.6)

GOAL

The “ship to” address is not appearing on intercompany AR invoices.

The “ship to” address for Intercompany AR Invoices is not populated after the AR Autoinvoice process is completed.

This document includes all version of Oracle E-Business Suite 11i and Release 12.

SOLUTION

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 eBTax – End Dated your tax regime and need to reactivate it?

How to remove the end date from a tax regime

Ever accidentally end dated a tax regime in Oracle R12 and then needed to activate the tax regime again? Oracle wont let you – unless of course you follow this trick.

First, query back the end dated Oracle tax regime.

Oracle tax regime 1

You can see that the ‘effective to’ date is set as ’01-01-2000′.

Continue Reading

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

Oracle R12 Tax: The same tax conditions already exist in another tax condition set error

If you get the following error;

Oracle tax r12

The same tax conditions already exist in another tax condition set

Row 3 Error – The same tax conditions already exist in another tax condition set: CA S2 NULL B2 BC within this determining factor set. Please update the tax conditions to differentiate the details from the existing record.

 

 

 

 

You have either duplicated your condition set as the error indicates or you have simply been caught up in an Oracle bug!

To get around the issue, you have to do a little trick, the steps are as follows. Continue Reading

Oracle R12: The problem with using Legal Entities for Tax!

So, here is my problem. We have a client who has a UK legal entity but has several locations globally that are registered for local indirect tax and some other reporting but are not legal entities in their own right. According to Oracle, these are legal entity Establishments.

Oracle Definition of Legal Entity Establishment

“Legal Establishment: First party legal entities identify your organization to the relevant legal authorities, for example, a national or international headquarters. First party legal establishments identify each office, service center, warehouse and any other location within the organization that has a tax requirement. When you create a legal entity, the system automatically creates a legal entity establishment. You can create additional legal establishments according to your needs. For each legal establishment there are one or more tax registrations, depending upon the tax requirements of the applicable tax authority.”

More can be found at note 1064366.1

So what is wrong?

Continue Reading

Oracle R12 eTax: APP-SQLAP-97733 tax distribution error

If you get the following error when trying to look at distributions or validate your AP invoice, then this is caused by a currency issue.

ZX_GENERIC_TEXT

invoice validation issue

Continue Reading

Oracle R12.2 ‘JBO-25009: Cannot create an object of type: oracle.jbo.domain.Date with value:’ issue

Has the issue ‘JBO-25009: Cannot create an object of type: oracle.jbo.domain.Date with value:01-Jan-2000’ when assigning the tax regime to the Party Tax Profile for an Operating Unit.

I was able to assign one Tax Regime, but when i tried to assign the next it crashed out with the error.

 

tax Continue Reading

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)