Import Fiscal Attributes to Interface Tables

Use the Outbound Fiscal Document file-based data import spreadsheet to import the external transaction data for fiscal document generation in Receivables.

You must provide the transaction number (transaction identifier) to associate the fiscal attributes to the Receivables transaction. Make sure that the Automatic Transaction Numbering option is disabled on the transaction source.

Enter the fiscal attributes data in the Outbound Fiscal Document file-based data import spreadsheet based on these table:

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 Entity Sheet	Fiscal Attributes Column Header	Instructions
Fiscal Attribute Headers	Transaction Number	Associate a fiscal attribute header with a specific Receivables transaction by indicating the transaction number of the Receivables transaction. Use the same value as entered in the RA_INTERFACE_LINES_ALL entity sheet of the AutoInvoice Import file-based data import spreadsheet.
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.
Fiscal Attribute Lines	Document Identifier	Associate a fiscal attribute line with a specific fiscal attribute header by using the same value for the document identifier.
	Transaction Line Number	Associate a fiscal attribute line with a specific Receivables transaction line by indicating the Line Transactions Flexfield Segment 1 of the Receivables transaction line. In the Transaction Line Number column, enter the value used in the Line Transactions Flexfield Segment 1 column from the RA_INTERFACE_LINES_ALL entity sheet of the AutoInvoice Import file-based data import spreadsheet.
Fiscal Attribute Line Details	Document Identifier	Associate a fiscal attribute line detail with a specific fiscal attribute header by using the same value for the document identifier.
	Transaction Line Number	Associate a fiscal attribute line detail with a particular Receivables transaction line by indicating the Line Transactions Flexfield Segment 1 of the Receivables transaction line. In the Transaction Line Number column, enter the value used in the Line Transactions Flexfield Segment 1 column from the RA_INTERFACE_LINES_ALL entity sheet of the AutoInvoice Import file-based data import spreadsheet.

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

For more information on external integration services and file-based data imports, see the File-Based Data Import for Oracle Financials Cloud guide at http://docs.oracle.com.

Outbound Fiscal Document Import - Validations

The imported data is validated using the Outbound Fiscal Document file-based data import spreadsheet to check for compatibility with the Fiscal Attributes tables. The data entered in the spreadsheet is validated before loading to the Fiscal Attributes interface tables:

• Setup Values Defined: Ensures that the values pertaining to your setup are already defined in Receivables or in other related applications.
• Cross Validation: Ensures that certain column values agree with each other. These values can be within an interface table or between multiple interface tables.