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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms