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 |
Create self-assessed tax transactions from Payables as payable commitments in Projects. |
Oracle Purchasing |
|
Oracle Cost Management |
|
Oracle Projects |
|
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.
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:
|
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 |
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 |
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 |
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.