Implementing Tiered/Threshold Tax logic in E-Business Tax (R12.2)

Summary:

I'm struggling with a requirement to implement a "Threshold" tax in Oracle E-Business Tax (R12.2).

The Scenario:

We have a regulation where the first $X$ amount of a transaction is tax-exempt, and only the portion above $X$ is taxable at a specific percentage. For example:

• Total Invoice Line: 700,000
• Tax-Exempt Threshold: 500,000
• Taxable Amount: 200,000 (Calculated as $700,000 - 500,000$)
• Tax: 25% of 200,000 = 50,000.

Content (please ensure you mask any confidential information):

The Problem:Standard Tax Rates in EbsTax apply the percentage to the entire Taxable Basis (Line Amount). We are currently using a workaround where we manually calculate the taxable portion and enter it into the "Assessable Value" field, then use a