Tax Interface Report
Review Sales Tax Interface Report
The Tax Interface report provides information on the tax data you have loaded into Receivables or are reviewing for an upload. The report displays each senior location on a separate page. Refer to the Oracle Receivables Tax Manual Release 10.6 for a sample output of this report.
The Tax Interface report is automatically generated when you run the Sales Tax Rate Interface program.
This report is divided into the following sections:
- Summary Section: The summarized section of the Tax Interface report lists each action code that the Sales Tax Rate Interface program has used for the upload, the action code description, and the number of tax interface rows on which the program has executed each action.
- Warning Section: The warning section of the Tax Interface report lists every line of tax interface data that the Sales Tax Rate Interface program has identified with an action code other than 'INSERT' or 'NEW-LOCATION-INSERT'. Each row in this section lists the interface line ID, segment qualifier, location, postal code range, active date range, tax rate, and action for each row in the tax interface table that has a warning action code.
- Locations and Rates Defined for Warnings Section: This section of the report lists all of the locations and tax rates which are defined in Receivables for each location in the Warnings Section. This section includes the postal code and active date ranges of each of these locations' tax rates. Use this section in combination with the Warnings Section of the report to determine whether you need to take further action. If the tax rates are correct, then no further actions are necessary. If they are not, then you many need to update tax rates and locations manually in the Receivables Tax Locations and Rates window. For example, if the Warnings Section of this report includes a tax interface line with an action of 'ALREADY-EXISTS' for a tax rate, then the Locations and Rates Defined for Warning section will show a tax rate for this location with the same postal code and active date range that already exists in Receivables. No action is necessary in this case.
- Orphan Records, Parent_Location_ID Was Invalid Section: The final section on the Tax Interface report lists lines of tax interface data which the Sales Tax Rate Interface program has identified as not having a valid parent location ID value. All locations that are junior to other locations identify their parent location through the parent location ID. The program will not load a tax record into Receivables if it cannot identify a parent location using this ID, or if it is not a senior location. If this section of the report includes a tax interface line that is missing a Parent ID value, you must use SQL*Plus to update the line with the appropriate parent location ID, before it can be loaded into Receivables. For a review of this information, see: Table 1 - 75.
See Also
Running the Tax Rate Interface
Termination of the Tax Rate Interface Report