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

Will we ever have DFFs as Tax Determining Factors?

We all know the limitations with the tax module, primarily with the limitations that the determining factors give us. Many of us who have worked with eBTax for a while have asked for the ability to have DFFs as determing factors.

But, will we ever have DFFs as Tax Determining Factors?

The answer is probably not. Having spoken with Oracle Product development at this years Oracle Open World, the key issue is that a DFF that maybe linked to a Purchase order line is not going to be available in the AP workbench meaning that the tax engine wont have the same info in AP that it had in PO!

Its a fair comment and I understand the limitations.

 So… Whats the alternative?

At present I am not at liberty to say but Oracle development do have a unique concept that would allow a very similar approach that would get over the issue of DFFs not being available to all modules. So, watch this space for further updates.

Useful Excel Macros for eBTax.

Excel Macros to help with formatting data

This Macro is useful when extracting data from the database and you want to insert a line between groups of data. When ever there is a change int he value, a line is inserted, so if we have the following


then after the Macro is run we get


Insert lines
Sub InsertLine()
Dim i As Long
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
If Cells(i – 1, 1) <> Cells(i, 1) Then
End If
End Sub


The following is particularly useful when you are trying to format the Financials Tax Register. If you have the Financials Tax Register in Excel, you can remove any column which has no entries with this macro.

Remove blank columns when there is a header – if no header change value to 1048576
Sub Delete_Empty_Columns()

first = Selection.Column
last = Selection.Columns(Selection.Columns.Count).Column

For i = last To first Step -1

If WorksheetFunction.CountBlank(ActiveSheet.Columns(i)) = 1048575 Then
End If

Next i

End Sub

Oracle eBTax – How to populate the Tax Date automatically

For some reports for European VAT, the Tax Date of a transaction needs to be populated. This is an unreasonable task to expect users to do as it can only be done manually meaning that for every order that is imported, the transaction would need to be uncompleted and the tax date would have to be manually updated!

Oracle offer a patch for the supported countries to populate the tax date from Orders but this does not work if you do not have the localisations turned on which could be the case if you are a German entity who has a site in Hungary and charges Hungarian VAT when they ship from there. The Operating unit is German and the localisation country would be Germany but the tax in this instance is Hungarian! Another reason why this does not always work is that for any manual transactions, these would also need to be manually updated.

So, how can we automate this?

Very simply!

Create a request that does the following “update jg_zz_vat_trx_details set tax_invoice_date = trx_date where tax_invoice_date is null“. Then create a request set which first has the EMEA VAT SELECTION PROCESS and then your request to update the tax date.

Now there is no need to populate any of the tax dates as these will automatically take the transaction date if the tax date is NULL but is the user does put in a tax date manually, then this will be chosen instead.