Process Tax Point Date Adjustments Using a Spreadsheet
You can now make multiple updates to the tax point dates of an Oracle Payables or Oracle Receivables transaction using a spreadsheet.
The Select Transactions for Tax Point Date Adjustment process selects transactions to download to a spreadsheet. You can then upload your changes for processing.
Select Transactions for Tax Point Date Adjustment
Complete these steps to submit the Select Transactions for Tax Point Date Adjustment process:
-
Navigate to the Scheduled Processes work area, and search for the Select Transactions for Tax Point Date Adjustment task.
-
On the Process Details dialog box, enter values for the parameters listed in this table:
Parameter
Description
Legal Entity
The legal entity in which the transactions were created
Tax Registration Number
The first-party tax registration number of the transactions
Source
Payables or Receivables
From Transaction Date
The earliest transaction date to be considered
To Transaction Date
The latest transaction date to be considered
From Accounting Period
The earliest accounting period to be considered
To Accounting Period
The latest accounting period to be considered
Selection Level
Header or Line
-
Click Submit.
-
After the process completes, open the CSV output file in your spreadsheet application.
Columns in the spreadsheet
Consider these points regarding the content of the columns in the spreadsheet:
-
Column headings ending with _ID are important for processing the updated rows. You must not modify the data in these columns, except when they are displayed in scientific format. If they are displayed in scientific format, you should convert such columns to number, with no decimal places, or you may encounter issues during the upload process.
-
Do not change the order, or add or remove columns in the spreadsheet.
-
Due to the possibility of different locale settings on your computer, any date columns that you intend to use must be formatted with the format DD-MM-YYYY. This includes these columns:
-
New_Header_Tax_Point_Date: Populate the new tax point date in this column to modify the tax point date for all the lines of the selected transaction.
-
New_Line_Tax Point_Date: Populate the new tax point date in this column to modify the tax point date for a specific transaction line.
-
When your updates are complete, use Save As to save your data, and select the comma-separated values or CSV file type.
Upload Spreadsheet for Processing
Perform these steps to process your spreadsheet updates:
-
Upload the spreadsheet file from your computer to the server.
-
Transfer the uploaded file to the interface table.
-
Process the data in the interface table to update the appropriate tax lines.
Uploading the spreadsheet to the server
Perform these steps to upload the populated spreadsheet to the server:
-
Navigate to the File Import and Export page.
-
Select the icon to upload a file. The Upload File dialog box appears.
-
Select Browse to select the spreadsheet file containing your data from your computer.
-
From the list of values for the account, select fin/tax/import.
-
Click Save and Close.
Transferring the uploaded data to the interface table
Perform these steps to transfer the uploaded data to the interface table:
-
Navigate to the Scheduled Processes page.
-
Search and select the Load Interface File for Import process.
-
The Process Details page appears. Select Process Tax Point Date Adjustments from the list of values in the Import Process parameter.
-
Select the file you previously uploaded from the list of values for the Data File parameter.
-
Click Submit.
Processing the interface table data
When the Load Interface File for Import process completes successfully, submit the Process Tax Point Date Adjustments process, with Import as the Process Type.
Purge Data From JG_TPD_ADJUSTMENTS_INT Interface Table
To purge the data from the JG_TPD_ADJUSTMENTS_INT interface table, you must submit the Purge Interface Tables ESS job with these parameters:
- Purge Process Intent: File-based data import
- Import Process: Process Tax Point Date Adjustments
- Load Request ID: Request Id of Load Interface File for Import through which the data is loaded into the JG_TPD_ADJUSTMENTS_INT interface table.