Bugs & Fixes

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 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.


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)


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.


Continue Reading

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 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

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)

Oracle R12 – APPS-SQL-10000: ORA-01400: Cannot insert NULL into


I am facing a strange error that seem to have inter-connections between PO/AP and ETax, and I thought I ask if you might have come across this before??

 The scenario is as follows:
          Standard PO is created in OU = France for a Supplier based in the UK (EXPECTED TAX = OFFSET VAT) 
            Enter Invoice in AP by Matching invoice to PO an Invoice Line is created
          The following Error message is displayed when pressing the Calculate Tax button
Cannot insert Null into Oracle R12 Tax 
If a PO is entered for a Supplier based in the same country than the OU (France in this case), then the PO Match works perfectly, including Tax calculation, and there is no error message.
Similarly, if an invoice is entered against the UK based Supplier without matching to a PO, then the Tax calculation works perfectly, without error message.
Any hint or idea would be greatly appreciated

Solution provided:

 I have come across this issue before. First I would be advising that you turn tax off on the POs, there is no need to have it if you recover 100% VAT and it does cause issues like the one you are seeing.

One of the causes could be that in PO, it cannot calculate offset taxes, only the positive VAT part. So the tax on the PO will be wrong anyway, it will be say FR VAT EU AP GOODS 20% and won’t have the FR OFF EU AP GOODS 20%. If you are forcing the tax rate in from the PO, then it could be causing the issue as AP would want the Offset tax.

Change the settings below to remove the ‘enforce’ options and this should fix your issue.




Row 1 Error – You can use the same determining factor class and class qualifier as often as necessary only with “Not Equal To” operator and with unique values

‘Row 1 Error – You can use the same determining factor class and class qualifier as often as necessary only with “Not Equal To” operator and with unique values’

If you get this error but you know that this is the first time you have created this tax condition then you have hit a bug!

There is an easy work around to this. If this happens, click the ‘Ignore Condition’ and then save the condition.
oracle R12 tax conditions row 1 error

Then navigate away from the page, click on the ‘Tax Zone Type’ for example and then click back to the ‘Tax Condition Sets’ and query back your condition.

Now remove the ‘Ignore Condition’ tick and save – things should save correctly now.

new ebtax patch set from Oracle

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

Oracle eBTax – AGIS and tax/VAT calculation – what is going on?

Tax issues with Oracle intercompany including the Advanced Global Intercompany Solution (AGIS)

In my opinion, it should not matter what type of transaction is taking place, the tax should be independently calculated based on the information is has at the time and never be fed a tax rate to use! AGIS is a classic example of this. When the AR transaction is calculated, the tax should be calculated based on all the determining factors associated to the tax rules for the appropriate tax regime.
Indeed, this is what is happening but the problems start when the intercompany AP transaction is created because it does not appear that the Oracle intercompany solution can handle the processing of the tax in the right way! I have set up AGIS for many clients and the tax used to work fine, i.e. there was no tax rate from AR being forced through and why would I want this? if the AR transaction calculated French tax because it is a French entity, why would I want French VAT calculated on my AP invoice if it is a Germany entity and registered for VAT in Germany? I wouldn’t, I would want a German DE VAT tax rate. So this is what I am currently observing as being a specialist in eBTax, I am lucky to have multiple clients so I get to see multiple scenarios at the same time.

  • Some of my client (mainly those from a year ago backwards) had no issues with the tax calculation – the only issue was that Oracle was not bringing the tax classification code through from AR to AP but it was not bringing any other tax information – which is what we want.


  • A couple of my newer clients, one an upgrade and one a new install are seeing issues with AGIS in that the AP transaction is trying to pull the AR tax information through, not just the tax classification code but the actual tax rate even when the tax regimes are completely different! this is causing errors and I am in the process of trying to resolve things.


  • For those clients where the AGIS (and any intercompany) AP transaction is created without the system trying to force the tax rate from AR, the AP transaction is devoid of any ‘Ship-To’ information making it impossible to correctly calculate the tax is the operating unit has multiple ship to sites in different countries with different VAT registration numbers!

So to me, it seems that Oracle have got the entire intercompany solution wrong when it comes to VAT and rather than trying to be clever and bring the AR tax rate into AP they should back off and only bring the tax information that will allow the tax to be freshly calculated as a standalone transaction in AP. What do I mean by ‘tax information’? I am talking about the data that can be used by the determining factors such as the tax classification code, the intended use, the product type or the user defined fiscal classification code. Bring the information and the rules, if correctly setup can use that data to determine the tax rate for both AP and AR!

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]

No Operating units for Party Tax Profiles

The ledgers and OUs are all set up, You have set the MO Security profiles for the tax manager, added the ledger set, done everything possible but for some reason, you cannot select an OU for the tax managers–>party tax profile.

Try this,

1. Receivables -> Set up -> System -> Organizations.
2. Query the OU used.
3. Check the location tab and the address.
4. See if country and address are populated correctly.

I have blanked out the client info but hopefully you will get the idea

ERROR: You have encountered an unexpected error. Please contact the System Administrator for assistance.

ever get this error when first trying to log into Oracle ebusiness Tax Manager?
“You have encountered an unexpected error. Please contact the System Administrator for assistance”

This is because there is no default Operating unit assigned to the tam manager profile options.