Project Costs Capture

You can capture project-related costs from both Oracle Cloud and third-party applications, and then transfer them to Oracle Projects. You can also capture costs manually by creating uncosted, costed, and accounted transactions for third-party application sources in Projects.

Transaction Sources

Here's a table that lists the cost types and the corresponding source applications.

Source Name	Transaction Type
Oracle Payables	Supplier invoice Self-Assessed Tax Create self-assessed tax transactions from Payables as payable commitments in Projects.
Oracle Purchasing	Self-Assessed Tax Create self-assessed tax transactions from Purchasing as PO commitments in Projects. Purchase Orders Purchase Requisitions Purchase orders and purchase requisitions are available as committed costs for reporting in Projects.
Oracle Cost Management	Expense-Based Receipts Inventory Miscellaneous Transactions Inventory Movement Requests
Oracle Projects	Costs in Unreleased Expenditure Batches Adjustment Transactions Unprocessed Transactions
Third-Party Applications	External costs imported using Desktop-Excel Integration, web services, or the Oracle Cloud interface.

How Costs are Captured

Here's a figure that illustrates how you can capture different types of costs from internal and external applications, and then transfer them to Projects.

Flowchart illustrating how you can capture project costs from different
internal and external applications in Oracle Projects.

Here's a table that shows how you can export transactions from various sources to Oracle Projects.

Source of Cost Transactions	Description
Other Oracle Cloud applications	Enter and process project-related transactions, and then submit the Import Costs process. For example, you enter invoices with project-related distributions in Oracle Payables. You can then validate, account, and import them to Oracle Projects.
Third-party applications	Import costs using one of the following: Desktop-Excel integration Web services Load data to the interface table in Oracle Cloud You can load data to interface tables using predefined templates and the Load Interface File for Import scheduled process, which are both part of the External Data Integration Services for Oracle Cloud feature. For more information, see the File Based Data Import guide for your cloud services.
Individual third-party transactions created in Oracle Projects	You can create individual transactions with a third-party application source directly from the Manage Unprocessed Costs page in the Costs work area. Let's say you're approaching period close and have to create a few third-party transactions. Rather than wait to receive the transactions from the third-party application, you can create them directly using this method.

Source of Cost Transactions

Description

Other Oracle Cloud applications

Enter and process project-related transactions, and then submit the Import Costs process. For example, you enter invoices with project-related distributions in Oracle Payables. You can then validate, account, and import them to Oracle Projects.

Third-party applications

Import costs using one of the following:

Desktop-Excel integration
Web services
Load data to the interface table in Oracle Cloud

You can load data to interface tables using predefined templates and the Load Interface File for Import scheduled process, which are both part of the External Data Integration Services for Oracle Cloud feature. For more information, see the File Based Data Import guide for your cloud services.

Individual third-party transactions created in Oracle Projects

You can create individual transactions with a third-party application source directly from the Manage Unprocessed Costs page in the Costs work area.

Let's say you're approaching period close and have to create a few third-party transactions. Rather than wait to receive the transactions from the third-party application, you can create them directly using this method.

Foreign Keys to Important PJC_EXPENDITURE_ITEMS_ALL Table Fields

Here is a table that lists the foreign keys of the ORIGINAL_HEADER_ID, ORIGINAL_DIST_ID, and ORIGINAL_LINE_NUMBER fields in the PJC_EXPENDITURE_ITEMS_ALL table in some of the most commonly-used transaction sources and documents.

Source / Document	ORIGINAL_HEADER_ID	ORIGINAL_DIST_ID	ORIGINAL_LINE_NUMBER
Column Attribute / Key Description	NA	NA	NA
Oracle Payables / Supplier invoice / Expense report / Intercompany invoice / Interproject Invoice	AP_INVOICES_ALL.INVOICE_ID	AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID	AP_INVOICE_LINES_ALL.LINE_NUMBER
Oracle Payables / Payments	AP_INVOICE_PAYMENTS_ALL.INVOICE_PAYMENT_ID	AP_PAYMENT_HIST_DISTS.PAYMENT_HIST_DIST_ID	NA
Oracle Cost Management / Purchase Receipt	CMR_RCV_TRANSACTIONS.EXTERNAL_SYSTEM_REF_ID (Expense)	CMR_RCV_DISTRIBUTIONS.CMR_SUB_LEDGER_ID (Expense)	NA
Oracle Cost Management / Purchase Receipt	CST_TRANSACTIONS.TRANSACTION_ID (Inventory)	CST_COST_DISTRIBUTION_LINES.DISTRIBUTION_LINE_ID (Inventory)	NA
Oracle Fusion Cost Management / Miscellaneous Inventory	CST_TRANSACTIONS.TRANSACTION_ID	CST_COST_DISTRIBUTION_LINES.DISTRIBUTION_LINE_ID	NA
Oracle Fusion Cost Management / Sales Order Issue	CST_TRANSACTIONS.TRANSACTION_ID	CST_COST_DISTRIBUTION_LINES.DISTRIBUTION_LINE_ID	NA
Oracle Fusion Cost Management / Transfer Order Delivery	CMR_TRANSACTIONS.TRANSACTION_ID (Expense)	CMR_RCV_DISTRIBUTIONS.CMR_SUB_LEDGER_ID (Expense)	NA
Oracle Fusion Cost Management / Transfer Order Delivery	CST_TRANSACTIONS.TRANSACTION_ID (Inventory)	CST_COST_DISTRIBUTION_LINES.DISTRIBUTION_LINE_ID (Inventory)	NA
Oracle Fusion Cost Management / Work Order	CST_TRANSACTIONS.TRANSACTION_ID (Material Transaction)	CST_COST_DISTRIBUTION_LINES.DISTRIBUTION_LINE_ID	NA
Oracle Fusion Cost Management / Work Order	CST_RESOURCE_TRANSACTIONS.RESOURCE_TRANSACTION_ID (Resource Transaction)	CST_COST_DISTRIBUTION_LINES.DISTRIBUTION_LINE_ID	NA
Oracle Time and Labor	HWM_TM_REC_GRP.PARENT_TM_REC_GRP_ID	HWM_TM_REC_GRP_USAGES.TM_REC_VERSION	HWM_TM_REC.TM_REC_ID

Capturing Additional Transaction Attributes

You can capture project-specific attributes on actual cost and commitment transactions using the Cost Collection flexfield. Manage naming, validation, and ordering of these attributes within each of the documents that capture them, such as expense reports and purchase orders. You can capture, store, display, search, and report project-related attributes in the transaction source applications.