1. Using Financials for the Americas
  2. Import Outbound Fiscal Documents

Import Outbound Fiscal Documents

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

The template contains an instruction sheet to help guide you through the process of entering the required information.

You can import Fiscal Documents from other systems using the Import AutoInvoice with Fiscal Attributes process. Use the Import AutoInvoice with Fiscal Attributes process to import fiscal document Attributes that are related to Receivables transactions, therefore, outbound 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 Outbound 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 Outbound Fiscal Document Attributes Import Process

The Import Fiscal Document Attributes template contains an instructions tab, plus four tabs 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 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.

Fiscal Attribute Lines

(JG_FSCL_LINES_ATRB_INT)

Captures Fiscal Document Lines information for imported transactions. Data in this sheet is linked to the parent entity sheet, Fiscal Attribute Headers, using Document Id.

Fiscal Attribute Line Details

(JG_FSCL_LN_DTLS_ATRB_INT)

Captures the Fiscal Document Line Details data that you intend to assign to imported transactions. Data in this sheet is linked to the parent entity sheet, Fiscal Attribute Lines, using Document Id and Transaction Line Number.

How Outbound 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 Process Import AutoInvoice with Fiscal 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 AutoInvoice process to create the Receivables transactions

  • Use the Import AutoInvoice with Fiscal Attributes process to create the Outbound Fiscal Document Attributes related to the Receivables transactions

For more information on the Receivables AutoInvoice Import process, refer to Oracle Enterprise Repository for Fusion Applications.

To submit the Import AutoInvoice with Fiscal Attributes process:

  1. Navigate to the Scheduled Processes page.

  2. Click Schedule New Process in the Search Results table.

  3. Select the Import AutoInvoice with Fiscal Attributes process and click OK.

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

  5. Submit the process.

  6. Monitor the process in the Scheduled Process page.

  7. If the Import AutoInvoice with Fiscal 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 the Billing work area.

  2. From the Fiscal Document Generation menu, go to Spreadsheet for Fiscal Attribute Corrections.

  3. Review the AutoInvoice with Fiscal Attribute Errors table to view the errors.

  4. Click the Number of Errors link to open the Manage AutoInvoice with Fiscal Attributes Lines spreadsheet to review and correct the errors in the imported data.

  5. After all the incorrect rows are corrected, resubmit the import data for validation by clicking Submit AutoInvoice with Fiscal Attributes.

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