1. Using Financials for EMEA
  2. Process Tax Point Date Adjustments Using a Spreadsheet

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:

  1. Navigate to the Scheduled Processes work area, and search for the Select Transactions for Tax Point Date Adjustment task.

  2. 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

  3. Click Submit.

  4. 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:

  1. Navigate to the File Import and Export page.

  2. Select the icon to upload a file. The Upload File dialog box appears.

  3. Select Browse to select the spreadsheet file containing your data from your computer.

  4. From the list of values for the account, select fin/tax/import.

  5. Click Save and Close.

Transferring the uploaded data to the interface table

Perform these steps to transfer the uploaded data to the interface table:

  1. Navigate to the Scheduled Processes page.

  2. Search and select the Load Interface File for Import process.

  3. The Process Details page appears. Select Process Tax Point Date Adjustments from the list of values in the Import Process parameter.

  4. Select the file you previously uploaded from the list of values for the Data File parameter.

  5. 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.
Successful completion of the ESS job Purge Interface Tables deletes the data from the JG_TPD_ADJUSTMENTS_INT interface table.