Accounting Project Costs Externally

You can integrate Oracle Fusion Project Costing with external financial applications, such as Oracle E-Business Suite or third-party applications. Export project cost transactions and interface them to an external application where they can be accounted.

The following table describes the processes used to export project cost transactions.

Process Name

Process Description

Extract Cost Distributions for External Accounting

Extracts cost distributions to be accounted in an external application and updates the export status of such cost distributions.

Extract Cross-Charge Distributions for External Accounting

Extracts cross-charge distributions to be accounted in an external application and updates the export status of such cross-charge distributions.

The distribution lines are exported into a CSV file that can be imported into the external application and used to create accounting.

Tip: You can report on these exported transactions in Oracle Transactional Business Intelligence and reconcile them with the external application. Use the Export Status attribute available in the Project Costing - Actual Cost Real Time subject area to filter transactions that have been extracted.

Parameters

Business Unit

Business unit that owns the project transaction. This is a mandatory parameter.

Period

Period for which you want to export the transactions. This is a mandatory parameter.

Transactions Selected for Extraction

Available options are previously extracted transactions, new transactions that have not been extracted, and all transactions. This is a mandatory parameter which ensures that transactions are exported only once.

Expenditure Type Class

Category of transactions, such as supplier invoice, inventory, or miscellaneous.

Cost Distribution Line Type

Available options are original transactions, adjustment transactions, and all transactions. This is a mandatory parameter. For example, if you have already accounted the original transactions and want to account only adjustments made in Oracle Fusion Project Costing, then select the option Adjustment Cost Distribution Lines.