Oracle® Fusion
Applications Project Management Implementation Guide 11g Release 1 (11.1.2) Part Number E20384-02 |
Contents |
Previous |
Next |
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 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
Third-party application 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:
Oracle Fusion Payables: Supplier costs, expense reports, intercompany invoices, and interproject invoices.
Oracle Fusion Projects: Time cards, usage expenditures, miscellaneous expenditures, inventory expenditures, burden expenditures, summarized burden expenditures, work-in-progress expenditures, capital interest expenditures, and allocation expenditures.
Oracle Fusion Cost Management: Purchase receipts and miscellaneous inventory cost.
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.
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.
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.
Processing set size: When transferring large number of transactions, you can reduce the impact of unexpected errors by processing transactions in sets. Define the set size by providing the set size.
Preprocessing extension: Used for transaction validation before importing, uploading the transactions to Transaction Import Interface, or for other processing tasks before importing.
Postprocessing extension: Used to record the transaction number of the imported expenditure items in the source application.
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.
If the document entry is associated with the expenditure type class, Supplier Invoice or Expense Report, you cannot deselect the Accounted in Source Application and Import raw cost amounts options.
If the document entry is associated with the expenditure type class, Burden Transactions, you cannot deselect the Import raw cost amounts or Import burdened amounts options.
You can select the Import burdened amounts option only when the Import raw cost amounts option is selected.
You can select the Create raw cost accounting journal entries option, if the Accounted in Source Application option is set to No.
You cannot create a document for predefined transaction sources.
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:
Allow interface modifications: After importing the transactions, you can edit the unprocessed transactions.
Create related items: When importing the transactions the Create Related Items extension is used to process the related items.
Cross-charge transaction processing: You can allow cross-charge transactions processing.
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
Document Options
Document Entry Options
Predefined Transaction Sources
You specify the following options when setting up transaction sources.
Processing Set Size
The number of records to be processed in each set. When processing a large amount of data, you can reduce the impact of unexpected errors by processing transactions in sets. The import process saves to the database after each set is complete. If an error occurs and a rollback is issued, only the transactions in the current set are affected.
Preprocessing Extension
Use the Manage Transaction Sources: Preprocessing Extension to perform custom logic at the beginning of Import and Process Cost Transactions process. For example, you can implement custom validation logic before processing the costs.
Postprocessing Extension
Use the Manage Transaction Sources: Postprocessing Extension to record the internal identifiers of imported expenditure items in the source application or perform other custom processing at the end of the Import and Process Cost Transactions process.
You specify the following options when setting up transaction source documents.
Import Raw Cost Amounts
Imports transactions with the raw cost amount of the transaction already calculated. The amount is not modified after the transaction is imported into Oracle Fusion Projects. Designating an imported transaction as costed does not affect burdening or accounting.
Note
If Burden Transaction is the expenditure type class for one or more document entries, you cannot disable the Import Raw Cost Amounts option for the document.
Import Burdened Amounts
Imports burdened costs for transactions. If selected, transactions that do not have a burdened cost amount are rejected. When you select this option, the Import Raw Cost Amounts option is automatically selected.
Note
If Burden Transaction is the expenditure type class for one or more document entries, you cannot disable the Import Burden Amounts option for the document.
Allow Duplicate Reference
Allows this document to have multiple transactions with the same original system reference. If you select this option, you cannot uniquely identify the item by source, document, and original system reference.
Allow Override of Person Organization
Allows the external application to provide an expenditure organization that is different from the owning organization of the person. If no expenditure organization is provided, the import process populates the expenditure organization with the owning organization of the person.
Reconcile with Source
Ties transactions from this document back to the transaction source application.
Archive After Import
Automatically archives successful imported transactions when the import process completes.
Accounted in Source Application
Controls the accounts that are imported and the fields that are required from the transaction source application.
Create Raw Cost Accounting Journal Entries
Interfaces cost accounting journals for the raw cost to the general ledger.
Note
Settings on the project type determine whether accounting journal entries for the burden cost and burdened cost are sent to the general ledger.
Create Adjustment Accounting Journal Entries
Interfaces adjustments to the general ledger.
You specify the following options when setting up transaction source document entries.
Allow Adjustments
Allows adjustments to imported transactions in Oracle Fusion Projects after the import process.
Note
If Burden Transaction is the expenditure type class, you cannot disable the Allow Adjustments option.
Allow Reversals
Allows reversals of expenditure batches or expenditure items for the document entry.
Note
So that the originating external application can be reconciled with Oracle Fusion Projects, you may need to create corresponding reversals in the external application. In addition, if both this option and the Import Raw Cost Amounts option are selected, you may need to create corresponding reversals in the external application for the transactions that you reverse in Oracle Fusion Projects.
Note
If Burden Transaction is the expenditure type class, you cannot select the Allow Reversals option.
Allow Interface Modifications
Allows modifications to rejected transactions after the import process completes. Allows modifications to pending transactions after they are loaded to the interface table and before the import process is submitted.
Create Related Items
Indicates that the Related Transaction Extension is used to create related transactions for expenditure items charged to projects.
Process Cross-Charge Transactions
If this option is selected for a document entry, Oracle Fusion Projects performs cross-charge processing for transactions that originate from the source, document, and document entry.
Expenditure Type Class
Expenditure type class used for this document entry.
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. |
Specify the import and accounting options in the transaction document to define the way in which the transactions are imported and processed.
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. |
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. |
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.
No.You can create documents and document entries only for third-party transaction sources.
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.
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.
No. You cannot change the source, document, and document entry after creating a transaction.