My Oracle Support Banner

Tax Error: Sales Orders are Failing to Create Tax - Error is Raised: ORA-20001: Unable to locate a valid sales tax rate (Doc ID 334580.1)

Last updated on APRIL 06, 2017

Applies to:

Oracle Receivables - Version 11.5.0 to 11.5.0 [Release 11.5.0]
Information in this document applies to any platform.

Symptoms

Randomly the workflow booking process is erroring with ORA-20001. Sales order errored with ORA-20001 when booking the order.
Workflow exception error at header level when booking a Sales Order.
Activity: Book
Result: Exception
Error Name: -20001
Error Message: ORA-20001:
log file showed

ORA-20001: Unable to locate a valid Sales Tax rate for transaction.


Further review of the log file shows:

... O: bill_to_customer_number = 4020789
... O: ship_to_customer_number = 4020789
... O: bill_to_customer_name = PRISCILLA DIAZ DE YANEZ
... O: ship_to_customer_name = PRISCILLA DIAZ DE YANEZ
... O: Audit_Flag =
... O: Trx_Line_Type =
... O: Division Code =
... O: Company Code =
... O: Calculate_tax = Y
... O: Status =
... O: Tax_type =
... O: Sales_tax_id =
... O: Location_segment_id =
... O: Tax_line_number =
... O: Tax_amount =
... O: Tax_vendor_return_code =
... O: Tax_precedence =
... O: Compound_amount =
... O: Tax_header_level_flag = N
... O: Tax_rounding_rule = NEAREST
... O: Trx_type_id = 1020
... O: Ship_From_Warehouse_id = 167
... O: Amount_includes_tax_flag = N
... O: Customer_trx_charge_line_id =
... O: Poo_id = 83
... O: Poa_id = 83
... O: Taxable_amount =
... O: Taxable_basis =
... O: Override Tax Rate =
... O: Party Flag =
dump_tax_info_rec()-
dump_tax_info 2
om_tax_line 31
exiting om_tax_line
tax_line 8
tax_line 9
leaving oe_msg_pub.add
some error occurred ORA-20001: Unable to locate a valid Sales Tax rate for transaction.

Ensure that an active Sales Tax rate exists for the Location.

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

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