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


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

Emea Vat selection Pre-Process and Selection Process

R12 EMEA VAT Pre-Reporting Process Concurrent Programme

Because we are upgrading, we need to run this request before running the EMEA Vat Selection Process.
This latter programme puts tax data into relevant tax tables so that vat reports can be run for EMEA countries.  The full list of vat reports can be found in chapter 3, 121zxrg.pdf
Issue – not all of our companies are visible in the list of values.

Excerpt from the patch
Continue Reading

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.




Oracle R12 – cannot update legal entity tax registrations

Ever had the issue where you try and access your legal entity to assign the tax registrations to it and it either errors out or shows error messages

the issue is caused by a second tax created because tax rules exist both globally and for an OU/LE.

When the ‘Tax’ is created that has the OU as the owner, it copies the values from the Globally owned ‘Tax’. The issue is caused when a change is made to the globally owned tax but not the OU owner tax and as a reulst there is an inconsistancy int he tables that leads to the error.

contact me if you need further help on this.

Oracle R12 eBTax Tax Zone Issues


so here is the set up,

Tax Zone Type = Economic Regions
Tax Zone Name = European Economic Community – has all 28 EU countries
Tax Zone Name = French Territories – has all the French Territories in it
Tax Zone Name = UK Tax Jurisdiction – has GB and Isle of Man in it

Tax Zone Type = Country Tax Zones Continue Reading

How to free up space on you c drive!

I recently had some major issue with lack of space on my C drive which is used for my operating system. I have a laptop with 16 gig RAM and i found that when i disabled the hibernate feature, I got 16 gig Space back!

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.

Oracle ebtax Tax countries with VAT validation

The following are the list of countries that currently validate the VAT number when it is entered.

Currently, Switzerland has incorrect validation

REM | (26 countries) |
REM | AT – Austria |
REM | BE – Belgium |
REM | DK – Denmark |
REM | EE – Estonia |
REM | FI – Finland |
REM | FR – France |
REM | DE – Germany |
REM | GR – Greece |
REM | IE – Ireland |
REM | IT – Italy |
REM | LU – Luxembourg |
REM | SK – Slovakia |
REM | NL – Netherlands |
REM | PL – Poland |
REM | PT – Portugal |
REM | ES – Spain |
REM | SE – Sweden |
REM | GB – United Kingdom |
REM | CH – Switzerland |
REM | RU – Russia |
REM | HU – Hungary |
REM | BR – Brazil |
REM | AR – Argentina |
REM | CL – Chile |
REM | CO – Colombia |
REM | TW – Taiwan |
REM | |
REM | MT – Malta |
REM | CV – Cyprus |
REM | LV – Latvia |
REM | LT – Lithuania |
REM | SI – Slovenia

Oracle eBTax – Issue when setting up tax zones

Issue when setting up tax zones: 

Once you have set up a tax zone, run the following SQL query – select * from hz_geographies g where g.GEOGRAPHY_USE = ‘TAX’ You will see that the end date is defaulted to 31-DEC-2012 even if you had set no value! On testing it does not appear to have a negative effect on creating tax conditions but its something to be aware of.