Import Inbound Fiscal Documents

Use the Import Inbound Fiscal Document Attributes Template to populate your Inbound Fiscal Document Attributes and upload them into Oracle Fusion Cloud Applications. Prepare the required Inbound Fiscal Document Attributes offline in the applicable spreadsheet templates.

You do not need to access any Fusion Applications while creating the spreadsheet. The template contains an instruction sheet to help guide you through the process of entering the required information.

You can import Inbound Fiscal Documents from other systems using the Import Inbound Fiscal Document Attributes process. Use the Import Inbound Fiscal Document Attributes process to import fiscal document attributes that are related to Payables Transactions, therefore inbound fiscal documents.

To access the template, complete these steps:

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 Inbound Fiscal Document Import.

4. In the File Links section, click the link to the Excel template.

Follow these guidelines when preparing your data in the worksheet:

• Enter the required information for each column. Refer to the tool tips on each column header for detailed instructions.

• Do not change the order of the columns in the template.

• You can hide or skip the columns you do not use, but do not delete them.

Settings That Affect the Inbound Fiscal Document Attributes Import Process

The Import Inbound Fiscal Document Attributes template contains an instructions tab, plus one tab that represent the table where the data is loaded:

Spreadsheet Tab	Description
Instructions and CSV Generation	Contains instruction information about preparing and loading data, the format of the template, submitting the Import Outbound Fiscal Document Attributes process, and correcting import errors.
Fiscal Attribute Headers (JG_FSCL_HDRS_ATRB_INT)	Captures Fiscal Document Header data from which Fiscal Documents headers are created after successful import. Fiscal Document header is created and tied to a Receivables or Payables Transaction.
Fiscal Attribute Header Details (JG_FSCL_HDR_DTLS_ATRB_INT)	Captures the Fiscal Document Header Details data that you intend to assign to imported transactions. Data in this sheet is linked to the parent entity sheet Fiscal Attribute Headers using Document Id.

How Inbound Fiscal Document Attributes Import Data Is Processed

Loading the Data

After you finish preparing the data, you must load the data. To load the data:

1. On the Instructions and CSV Generation tab of the template, click the Generate CSV File button to generate a Zip file containing one or more CSV files.

2. From Scheduled Process, use Load Interface File for Import and select Import Inbound Fiscal Document Attributes as the import process.

3. In Data File, select Upload a new file and then select the Zip file you created.

Importing the Loaded Data

After you successfully load your data, you must submit the AutoInvoice processes to import the data into the application tables and create the transactions.

• Use the Import Payables Invoices process to create the Payables transactions

• Use the process Import Inbound Fiscal Document Attributes to create the Inbound Fiscal Document Attributes related to the Payables transactions

For more information on the Payables Invoice Import Interface process, refer to Oracle Enterprise Repository for Fusion Applications.

To submit the Import Inbound Fiscal Document Attributes process:

1. Navigate to Payables > Invoices work area.

2. Click the Import Inbound Fiscal Document Attributes link in the Tasks section.

3. Enter the input parameters as needed:

   Input Parameter	Description
   Batch Name	The batch name used in the Load File for Import Process
   From Transaction Number / To Transaction Number	The range of transactions to be processed
   From Date / To Date	The range of documents in between those dates to be processed

4. Submit the process.

5. Monitor the process in the Scheduled Process page.

6. If the Import Inbound Fiscal Document Attributes process ends in error or warning, review the log file for details about the rows that caused the failure.

To correct import errors:

1. Navigate to Payables > Invoices work area.

2. In the Task section, click Correct Import Inbound Fiscal Document Attributes Errors. This will download a spreadsheet with the name CorrectInterfaceTransaction.xlsx.

3. Open the spreadsheet CorrectInterfaceTransaction.xlsx.

4. Enter the login details.

5. Review and correct the import errors in the spreadsheet.

6. After all incorrect rows are corrected, resubmit the process by clicking the Save and Submit Import Inbound Fiscal Document Attributes button.

7. Repeat the submit and error correction steps in this section until all rows are imported successfully and the transactions are created.