We have been updating our Tax rates through the AR_TAX_INTERFACE table
using Vertex data since 1997 and only recently discovered that there was a
problem. This issue may not be simply a Vertex issue as I believe it
primarily lies in the process Oracle uses to apply the rate changes to the
AR_LOCATION_RATES table. If you have been receiving feeds, applying them,
and assumed that everything is correctly being updated, you need to take a
look at the AR_TAX_INTERFACE table after the 'Sales Tax Rate Interface'
program has been run. Check the STATUS field. What we found after one of
our major customers complained was that we had over 7,000 records in this
table with the 'NARROWER-ZIP-RANGE' status. When a record has this status,
any new rates for the particular location_segment_id will not get updated.
We have had a running TAR with Oracle since January 25th that has failed to
correct this problem. They provided a script to end-date the records, but
it left about 2000 records unchanged with the 'NARROWER-ZIP-RANGE' status.
When we proceeded to apply the next month's data, the number of records
jumped to over 14,000... We are frustrated! We recently tried to work
with Vertex thinking that they could apply knowledge (and pressure) to get
this resolved. Obviously, if we can't rely on the feed from vertex to
correctly update our records, it doesn't make sense to pay an sizable
annual fee to continue this service. The Vertex people were polite, but to
date have not provided any quicker response from Oracle. If anyone has had
this, and has a solution, PLEASE let us know.
Thanks,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
