Browser version script Skip Headers

Oracle® Fusion Applications Project Management Implementation Guide
11g Release 1 (11.1.2)
Part Number E20384-02
Go to contents  page
Contents
Go to Previous  page
Previous
Go to previous page
Next

34 Project Costing Configuration: Manage Transaction Sources and Documents

This chapter contains the following:

Transaction Sources: Explained

Source, Document, and Document Entry Components: How They Work Together

Setting Up Transaction Sources: Points to Consider

Transaction Document Import and Accounting Options: Points to Consider

FAQs for Manage Transaction Sources and Documents

Transaction Sources: Explained

Transaction sources identify the source of transactions that you import into Oracle Fusion Project Costing. You control the transaction import and processing by the specifying the source, document, and document entry options.

The transaction sources can be classified into two categories:

Predefined Sources

Oracle Fusion Project Costing provides a set of predefined transaction sources that you use to import transactions from other Oracle Fusion applications. The predefined sources and their associated document entries are as follows:

Third-Party Application Sources

You can define additional transaction sources to import transactions from non-Oracle applications. For example, you can define the transaction source Payroll to identify expenditure items imported from an external payroll system. Similarly, you create documents for a specific transaction source and document entries for a specific document.

Source, Document, and Document Entry Components: How They Work Together

When you create a transaction source, you select the transaction source options to control the transaction import processing. Transaction source, document, and document entry definitions determine how the application handles validation, import, processing, adjustment, and accounting of project cost transactions.

Sources

At the transaction source level, you define the source, the processing set size, preprocessing, and postprocessing extensions. The extensions record the internal identifiers of imported expenditure items in the source application or perform other user-defined processing before and at the end of the Import and Process Cost Transactions process. Review and update the transaction sources to call the transaction preprocessing and postprocessing extensions during the import and process cost transactions process.

Documents

Documents represent the transactions that are imported to Oracle Fusion Project Costing. They are associated to a source. You specify the import and accounting options for transactions. Some of the options are interdependent.

Document Entries

Document entries are a further breakdown of the document. They represent different types of transactions that come under a single, specific document. For the Burden Transactions expenditure type class, you specify the Import raw cost amounts and Import burdened amounts options at the document level; however, you cannot specify the Allow adjustments and Allow reversals options at the document entry level. Therefore, to allow adjustments and reversals, you either change the document options or select a different expenditure type class. You can define the following document entry options:

Setting Up Transaction Sources: Points to Consider

Transaction sources identify the source of external transactions and determine how you import them into Oracle Fusion Projects.

Consider the following aspects when you set up transaction sources:

Transaction Source Options

You specify the following options when setting up transaction sources.

Document Options

You specify the following options when setting up transaction source documents.

Document Entry Options

You specify the following options when setting up transaction source document entries.

Predefined Transaction Sources

Oracle Fusion Projects provides a set of predefined transaction sources that you use to import transactions from other Oracle Fusion applications. In addition, Oracle Fusion Projects uses predefined transaction sources to import project allocations, capitalized interest transactions, and summarized burden transactions that are generated internally.

You can define additional transaction sources to import transactions from third-party applications. For example, you can define the transaction source Payroll to identify expenditure items imported from an external payroll application. You control the Transaction Import processing by the options that you select for each transaction source.

The following table lists the predefined transaction sources that you can use to import transactions from Oracle Fusion Payables:


Document

Document Entry

Document Entry Description

Expense Report

Item Cost

Item cost transactions imported for expense reports from Oracle Fusion Payables.

Expense Report

Nonrecoverable Tax

Nonrecoverable tax transactions imported for expense reports from Oracle Fusion Payables.

Intercompany Invoice

Nonrecoverable Tax

Nonrecoverable tax transactions imported for intercompany invoices from Oracle Fusion Payables.

Interproject Invoice

Item Cost

Item cost transactions imported for interproject invoices from Oracle Fusion Payables.

Payment

Discount

Discount transactions imported for payments from Oracle Fusion Payables.

Payment

Exchange Rate Variance Discount

Discount on exchange rate variance transactions imported for payments from Oracle Fusion Payables.

Payment

Invoice Price Variance Discount

Discount on invoice price variance transactions imported for payments from Oracle Fusion Payables.

Payment

Tax Discount

Discount on tax transactions imported for payments from Oracle Fusion Payables.

Payment

Tax Exchange Rate Variance Discount

Discount on tax exchange rate variance transactions imported for payments from Oracle Fusion Payables.

Payment

Tax Invoice Price Variance Discount

Discount on tax invoice price variance transactions imported for payments from Oracle Fusion Payables.

Supplier Invoice

Exchange Rate Variance

Exchange rate variance transactions imported for supplier invoices from Oracle Fusion Payables.

Supplier Invoice

Freight

Freight transactions imported for supplier invoices from Oracle Fusion Payables.

Supplier Invoice

Invoice Price Variance

Invoice price variance transactions imported for supplier invoices from Oracle Fusion Payables.

Supplier Invoice

Item Cost

Item cost transactions imported for supplier invoices from Oracle Fusion Payables.

Supplier Invoice

Miscellaneous

Miscellaneous transactions imported for supplier invoices from Oracle Fusion Payables.

Supplier Invoice

Nonrecoverable Tax

Nonrecoverable tax transactions imported for supplier invoices from Oracle Fusion Payables.

Supplier Invoice

Tax

Tax transactions imported for supplier invoices from Oracle Fusion Payables.

Supplier Invoice

Tax Exchange Rate Variance

Tax exchange rate variance transactions imported for supplier invoices from Oracle Fusion Payables.

Supplier Invoice

Tax Invoice Price Variance

Tax invoice price variance transactions imported for supplier invoices from Oracle Fusion Payables.

Supplier Invoice

Tax Rate Variance

Tax rate variance transactions imported for supplier invoices from Oracle Fusion Payables.

The following table lists the predefined transaction sources that you can use to import transactions from Oracle Fusion Cost Management:


Document

Document Entry

Document Entry Description

Miscellaneous Inventory

Item Cost

Item cost transactions imported for miscellaneous inventory from Oracle Fusion Cost Management.

Miscellaneous Inventory

Overhead

Overhead transactions imported for miscellaneous inventory expenditures from Oracle Fusion Cost Management.

Purchase Receipt

Exchange Rate Variance

Exchange rate variance transactions imported for purchase receipt expenditures from Oracle Fusion Cost Management.

Purchase Receipt

Invoice Price Variance

Invoice price variance transactions imported for purchase receipt expenditures from Oracle Fusion Cost Management.

Purchase Receipt

Item Cost

Item cost transactions imported for purchase receipts from Oracle Fusion Cost Management.

Purchase Receipt

Nonrecoverable Tax

Nonrecoverable tax transactions imported for purchase receipt expenditures from Oracle Fusion Cost Management.

Purchase Receipt

Nonrecoverable Tax Price Adjustment

Nonrecoverable tax price adjustment transactions imported for purchase receipt expenditures from Oracle Fusion Cost Management.

Purchase Receipt

Price Adjustment

Price adjustment transactions imported for purchase receipt expenditures from Oracle Fusion Cost Management.

Purchase Receipt

Tax Exchange Rate Variance

Tax exchange rate variance transactions imported for purchase receipt expenditures from Oracle Fusion Cost Management.

Purchase Receipt

Tax Invoice Price Variance

Tax invoice price variance transactions imported for purchase receipt expenditures from Oracle Fusion Cost Management.

Purchase Receipt

Tax Rate Variance

Tax rate variance transactions imported for purchase receipt expenditures from Oracle Fusion Cost Management.

The following table lists the predefined transaction sources that you can use to import transactions from Oracle Fusion Projects:


Document

Document Entry

Document Entry Description

Allocation Expenditure

Allocation Expenditure Item - Burden

Identifies the burden transactions imported for allocation expenditures from Oracle Fusion Projects.

Allocation Expenditure

Allocation Expenditure Item - Miscellaneous

Identifies the miscellaneous transactions imported for allocation expenditures from Oracle Fusion Projects.

Burden Expenditure

Burden Expenditure Item

Identifies the burden transactions imported for burden expenditures from Oracle Fusion Projects.

Capitalized Interest Expenditure

Capitalized Interest Expenditure Item

Identifies the capitalized interest transactions imported for capitalized interest expenditures from Oracle Fusion Projects.

Inventory Expenditure

Inventory Expenditure Item

Identifies the inventory transactions imported for inventory expenditures from Oracle Fusion Projects.

Miscellaneous Expenditure

Miscellaneous Expenditure Item

Identifies the miscellaneous transactions imported for miscellaneous expenditures from Oracle Fusion Projects.

Summarized Burden Expenditure

Summarized Burden Expenditure Item

Identifies the summarized burden transactions imported for summarized burden expenditures from Oracle Fusion Projects.

Time Card

Overtime

Identifies the overtime transactions imported for time cards from Oracle Fusion Projects.

Time Card

Straight Time

Identifies the straight time transactions imported for time cards from Oracle Fusion Projects.

Usage Expenditure

Usage Expenditure Item

Identifies the usage transactions imported for usage expenditures from Oracle Fusion Projects.

Work-in-Progress Expenditure

Work-in-Progress Expenditure Item

Identifies the work-in-progress transactions imported for work-in-progress expenditures from Oracle Fusion Projects.

Transaction Document Import and Accounting Options: Points to Consider

Specify the import and accounting options in the transaction document to define the way in which the transactions are imported and processed.

Transaction Import Options

The import options that you define for documents impact how the application imports transactions for that document. You specify the following import options for each document:


Import Options

Description

Import raw cost amounts

Select this option to import raw cost amounts on transactions from this document.

Import burdened amounts

Select this option to import burdened cost amounts on transactions from this document.

Allow duplicate reference

Select this option to allow the same original application reference for transactions from this document.

Allow override of person organization

Select this option to override the primary human resources assignment organization of the person on transactions from this document.

Reconcile with source

Select this option to reconcile transactions associated to this document in the source application.

Archive after import

Select this option to archive transactions from this document after importing them successfully.

Transaction Accounting Options

The accounting options that you define for documents impact how the application accounts transactions for that document. You specify the following accounting options for each document:


Accounting Options

Description

Accounted in source application

Select this option to specify that cost transactions can be accounted in the source application. That is, you can account for raw, burden, or burdened costs externally.

Restriction

If the raw cost, burden, or burdened cost is accounted in the source, then the respective general ledger accounts are required to import the transactions successfully.

Create raw cost accounting journal entries

Select this option to create raw cost accounting journal entries on transactions.

Create adjustment accounting journal entries

Select this option to create adjustment accounting journals entries on transactions.

FAQs for Manage Transaction Sources and Documents

Can I assign a document to multiple sources?

You can have a document with the same name in multiple sources but you cannot share documents across sources. For example, a corporation with multiple time capture systems can associate a time card document with Oracle Fusion Projects and a non-Oracle application as sources. The rules on how these transactions are treated may differ depending on how they are processed in the source applications.

Can I create documents and document entries for predefined transactions sources?

No.You can create documents and document entries only for third-party transaction sources.

Can I delete transaction sources, documents, and document entries?

You can delete third-party transaction sources, documents, or document entries only if no cost transactions exist. However, you cannot delete the predefined transaction sources, documents, or document entries.

Can I allow adjustments and reversals for all transactions in the document entry?

No. You decide whether to allow transaction adjustments and reversals for each document entry that you create during implementation. However, you cannot define document entries to allow adjustments and reversals for transactions that are generated by the application such as allocation transactions, capital interest expenditure transactions, summarized burden transactions.

Can I change the source and document for transactions after exporting them to Oracle Fusion Projects?

No. You cannot change the source, document, and document entry after creating a transaction.