AutoInvoice is used to generate invoices from a wide variety of sources. Oracle Applications such as OKS (Contracts), Projects, Order Management and AGIS (Advanced Global Intercompany) are just a few sources that use AutoInvoice to generate invoices.
Taxes can be generated in one of two ways.
-
Transactions can be created with appropriate attributes defined such
as bill_to, ship to, warehouse_id and AutoInvoice can call E-Business
Tax to calculate taxes using your tax rules.
- Transactions can be passed into the interface tables with a pre-calculated tax line.
Taxes are recalculated at the time of invoicing as this is the point where the tax liability is incurred.
If AutoInvoice Ends In Error:
All AutoInvoice Tax errors in R12 are prefaced with the text below.
The error messages are what you find in the tax debug log when captured as previously instructed.
raaebt()+ Current system time is 08-SEP-2008 12:57:54
ERROR: from eBusiness Tax - return code = 2 Current system time is 08-SEP-2008 12:57:59
Please review the plsql debug log for additional details. Current system time is 08-SEP-2008 12:57:59
Error calling raaebt()
Error calling raapic()
raarrt2()+ Current system time is 08-SEP-2008 12:57:59
Commit after cleanup - Current system time is 08-SEP-2008 12:58:00
...
arp_etax_util.calculate_tax_int()+
ZX_API_PUB.import_document_with_tax returns failure | Error Message | Cause | Action |
| The system cannot determine the default tax rate for tax and tax status . Please contact your tax manager either to specify a default tax rate code for this tax status and date <Date> or to define appropriate rate determination rules. | Numerous | Refer to Note 1086129.1 for fixes for this error. |
If AutoInvoice Ends with a Message in the Exception Report:
| Exception Message | Cause | Action | Reference |
| Invalid tax exempt flag (TAX_EXEMPT_FLAG) | In release 12.0, when interfacing an order or RMA from OM to AR with the tax handling set to O for Override, the record is being rejected by AutoInvoice import with the message in the log file shown below: Invalid tax exempt flag (TAX_EXEMPT_FLAG). If the system option Allow Exemptions = No then valid values are S or R, otherwise the valid values are S, R or E (O). This issue was caused by OM allowing the tax handling to be set to Override. The value O was obsoleted in Release 12. | Refer to Note 788047.1 to remove the Override option from the OM list of values. Alternately, you can use these steps: Login as Application Developer (N) Application > Lookup > Application Object Library > ZX_EXEMPTION_CONTROL Delete the value named Override Save As part of the fix for 8626124 this option was officially removed. Any patch containing the fixed file OEXOEORD.fmb 120.177.12000000.67 or higher will also contain this fix and will eliminate the need for the above mentioned manual steps. | Note 1086586.1 contains a full listing of all known causes for this exception |
| This Tax Rate is Not Active This Tax Rate is Not Active on the Transaction Date | Bug 7504455 | Fixed File/Recommended Patch R12 120.73.12000000.16 /Patch 9151034 R12.1 120.80.12010000.14 Baseline 12.1 code. Also, Oracle E-Business Tax - Tax Configuration - Tax Rate - Check the Effective From and Effective To dates and ensure that the provided Tax Rate is active on the transaction date. | Note 745968.1 |