My Oracle Support Banner

Custom Tax Formula and No Tax Calculated for iStore or Quoting (Doc ID 412520.1)

Last updated on MARCH 23, 2021

Applies to:

Oracle iStore - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

A custom tax formula has been setup for the tax calculation in iStore, Quoting and Order Management.
When an order is placed from iStore, the order amount does not include the tax. The order total does show tax when viewing the order in Order Management.

This impacts the credit card authorization amount for it is being done from iStore and incorrect amount.

In the tax debug log file, it can be seen that taxable_basis is set as FORMULA during the Place Order flow which calculate the tax.

 

GET CUSTOMER TRANSACTION TYPE ( 1 ) : 1286
Customer trx type id is:1286
om_tax_line 5.2
om_tax_line 6
tax_code : MYTAX
amount_includes_tax_flag : N
taxable_basis : FORMULA
tax_plsql_block : SITE.SS_TAX_PKG.LINE_CALC

 

The Quoting debug log shows the following also for the Place Order from Quote flow

 

************************
** Tax Info Record **
************************
...
... O: Taxable_basis = FORMULA

 

When the tax is NOT being calculated there is no value seen for Taxable_basis in tax details. This is from the Quoting, add line and save quote flow.

 

ASO ** Begining of Tax Info Record ** 
ASO ************************************
...
ASO arp_tax.tax_info_rec: Taxable_basis =

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.