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.
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.
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")
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.
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.
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