| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> AR_TAX_INTERFACE - Vertex Issue
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: Ken.Eaton_at_dankasi.com
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: ListGuru_at_fatcity.com (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). Received on Wed Apr 11 2001 - 11:24:16 CDT
 |
 |