Previous  Next          Contents  Index  Navigation  Glossary  Library

Action Codes of Sales Tax Rate Interface Program

The following lists include all of the possible actions that the Sales Tax Rate Interface program can perform on a row of tax data in the tax interface table.

Success Action Codes

The following codes are for tax rows that the Sales Tax Rate Interface program has successfully loaded into the location or tax rate tables. These codes do not require you to take any additional actions.

Action Code Meaning
INSERT Inserted a new tax rate for a location that already exists
NEW-LOCATION-INSERT Inserted new location and new tax rate information
Table 1 - 77. Success Action Codes (Page 1 of 1)

Warning Action Codes

The following codes are warning action codes. You should verify that the Sales Tax Rate Interface program has performed the updates or adjustments that you require for each record with a warning action code. For example, if a row of tax data from the tax interface table receives an action of 'RATE-ADJUST', then you should verify that the new tax rate for the location associated with this tax rate is correct.

Action Code Meaning
ALREADY-EXISTS This tax rate already exists in Receivables.
NEW-LOCATION Inserted a new location that did not include any tax rate information. You must manually assign a tax rate to this location for Receivables to be able to create a tax line for invoices with this location. If you are only loading locations for address validation purposes, then you do not need to assign a tax rate to this location.
RATE-ADJUST Replaced an existing tax rate with a new tax rate
UPDATE-INSERT Inserted new tax rate information, and adjusted the active dates of existing tax rate information
Table 1 - 78. Warning Action Codes (Table 1 of 1)

Error Action Codes

The following codes indicate that an Oracle error has occurred during the processing of tax data by the Sales Tax Rate Interface program. The program will still produce the Tax Interface report even if an Oracle error occurs during the upload process.

Action Code Meaning
ORACLE_ERROR An Oracle error has occurred. The Oracle error number is listed for this error.
Table 1 - 79. Error Action Codes (Table 1 of 1)

The following action codes indicate that either the tax data in the tax interface table is invalid, or the Sales Tax Rate Interface program did not interpret this data correctly. Although the Sales Tax Rate Interface program may assign these codes to records in the tax interface table, these codes should not appear on the Tax Interface report in normal circumstances.

Note: These codes would, however, appear in the report if you elected to run it in review mode, immediately after using SQL Loader to load your data, but before uploading into Receivables.

Action Code Meaning
IGNORE The Sales Tax Rate Interface program did not upload this record.
<NULL> This record is ready to be loaded by the Sales Tax Rate Interface program.
Table 1 - 80. Error Action Codes (Table 1 of 1)

See Also

Running the Tax Rate Interface Program

Tax Interface Report

Sales Tax Rate Interface Program Updates of AR_TAX_INTERFACE Table

         Previous  Next          Contents  Index  Navigation  Glossary  Library