Import SHAAM Interface File Data for Israel

Import SHAAM bookkeeping certificates and withholding tax exemptions data from a flat file received from the Israel tax authority. You can then load the data to the Withholding Tax Registrations and Tax Exemptions tables.

Let's walk through the steps to access the template:

  1. Navigate to the File-Based Data Import for Oracle Financials Cloud guide.

  2. In the Table of Contents, click File-Based Data Imports.

  3. Click SHAAM Interface File for Israel.

  4. In the File Links section, click the link to the control file.

Here are a few things to keep in mind when preparing your data in a flat file.

  • Import flat file data directly from the Israel tax authority SHAAM system. You don't need to manually enter data.

  • Create data in the format specified in the control file.

Settings that Affect the Import SHAAM Interface File Data for Israel Process

The SHAAM Interface File for Israel Control File provides the format to load supplier certification and withholding tax exemptions. You can load data to this table:

Table

Description

JG_REPORTING_TRANSACTION_T

Stores supplier SHAAM certificates and withholding tax exemptions for Israel.

How SHAAM Interface File for Israel Data Is Processed

After you import the flat file from the Israel tax authority SHAAM system, you compress the file as a Zip file and then, load the Zip file to the application.

Here's how you load the Zip file to the application:

  1. Navigate to the Load Interface File for Import page.

  2. Select the Process Received SHAAM Certificates File for Israel process.

  3. In the Data File list, select Upload a new file.

  4. Select the Zip file to upload

  5. Submit the process.

  6. Monitor the import process.

  7. If the Process Received SHAAM Certificates File for Israel process ends in an error or a warning, review the log file. You can find details about the rows that caused the process failure in the log file.