1. Using Financials for the Americas
  2. Import Fiscal Attributes to Interface Tables

Import Fiscal Attributes to Interface Tables

You can import the fiscal attributes to the respective interface tables to validate and associate the fiscal attributes with the corresponding invoices.

You can use the Inbound Fiscal Document Import file-based data import spreadsheet to import the fiscal attributes data for the fiscal documents captured in Payables.

This data is temporarily stored in these Fiscal Attributes interface tables:

  • Fiscal Attributes for Transaction (Fiscal Attribute Headers): JG_FSCL_HDRS_ATRB_INT
  • Recurring Fiscal Attributes for Transaction (Fiscal Attribute Header Details): JG_FSCL_HDR_DTLS_ATRB_INT

The business unit, supplier, and transaction number are used to uniquely identify the Payables invoice and associate the fiscal attributes to it.

This table displays the fiscal attributes data that you can enter into the Inbound Fiscal Document Import file-based data import spreadsheet.

Fiscal Attributes Entity Sheet

Fiscal Attributes Column Header

Instructions
Fiscal Attribute Headers Business Unit Name Associate a fiscal attribute header with a specific Payables invoice by entering the same business unit of the invoice.
Transaction Number Associate a fiscal attribute header with a specific Payables invoice by entering the same transaction number of the invoice.
Supplier Number or Supplier Name Associate a fiscal attribute header with a specific Payables invoice by entering the same supplier number or supplier name of the invoice.
Fiscal Attribute Header Details

Document

Identifier

Associate a fiscal attribute header detail with a specific fiscal attribute header by using the same value for the document identifier.

After entering the fiscal attributes data into the import spreadsheet, perform these actions:

  • Run the Load Interface File for Import process to import the fiscal attributes to the respective interface tables.
  • Use External Data Integration Services for Oracle Cloud to load data into Oracle Cloud Applications from external sources such as legacy systems and third-party applications.

    The Inbound Fiscal Document Import file-based data import spreadsheet and the Load Interface File for Import scheduled process are both part of the External Integration Services for Oracle Cloud.