E-Business Tax (MOSC)

MOSC Banner

Is there a report (or SQL query) showing the usage of Tax Rules?

edited Jan 26, 2017 4:00AM in E-Business Tax (MOSC) 5 commentsAnswered

Hi,

I am aware that the diagnostics will tell me everything about a particular transaction ... but I am looking for data on a range of transactions.

For example, I have a Tax Regime with maybe 40 Tax Rules (counting each line in a Rule as a separate Rule).

I suspect that this is overkill ... and that many of these rules have never been used in practice.

Before setting up my next Tax Regime I would like to get a report of, say, all AR transactions in, say, a recent 3 month period, indicating which rules were actually used on each transaction so that I could evaluate which ones I need to replicate in the new Regime ... simply looking at the rates on the transactions is not sufficient as a non standard rate could have been driven by any of a number of rules depending on the Transaction Tax Classification or the Item Tax Classification or the Party Fiscal Classification or ... or ... or ...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center