Invoice Approval Does Not Work For USA To Canada Shipments and Provides the Following Error: Error Exception Cannot insert the VOUCHER_VAT_ANALYSIS record. VAT_CODE_GID must be set. (Doc ID 1073854.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Freight Payment, Billing, and Claims - Version: 5.5.06 to 5.5.06.02 - Release: 5.5 to 5.5
Information in this document applies to any platform.

Symptoms

On OTM version 5.5.06 when working with Provincial Tax that goes between countries the following error is seen:

ERROR
-----------------------

2010-02-17 20:21:02.793 846257 Error Exception Cannot insert the VOUCHER_VAT_ANALYSIS record. VAT_CODE_GID must be set.
java.sql.SQLException: ORA-01400: cannot insert NULL into ("GLOGOWNER"."VOUCHER_VAT_ANALYSIS"."VAT_CODE_GID")



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Configure Provincial Tax per the OTM Help and documentation available, but within one country.
2. Test this configuration works.
3. Attempt to create and process an invoice which goes from the USA to Canada.
4. The error will be displayed.

Note:
There is a workaround: . When it is an import or export, OTM attempts to create a zero tax record with a VAT code specified by the user on the Provincial VAT Configuration. If this is not done the error is seen.

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