Transcription
Oracle FusionCloud ProjectManagementUsing Project Costing22C
Oracle Fusion Cloud Project ManagementUsing Project Costing22CF57572-01Copyright "2011, 2022", Oracle and/or its affiliates.Author: Rakesh ChaudharyThis software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protectedby intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate,broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering,disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please reportthem to us in writing.If this is software, software documentation, data (as defined in the Federal Acquisition Regulation), or related documentation that is delivered to theU.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed, oractivated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to oraccessed by U.S. Government end users are "commercial computer software," "commercial computer software documentation," or "limited rightsdata" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction,duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including anyoperating system, integrated software, any programs embedded, installed, or activated on delivered hardware, and modifications of such programs),ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in theapplicable contract. The terms governing the U.S. Government's use of Oracle cloud services are defined by the applicable contract for such services.No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended foruse in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardwarein dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safeuse. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.Oracle , Java, and MySQL are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarksor registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo are trademarks or registered trademarks of Advanced MicroDevices. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products, and services from third parties. OracleCorporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, andservices unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsiblefor any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicableagreement between you and Oracle.
Oracle Fusion Cloud Project ManagementUsing Project CostingContentsGet Help . i1Project Costs1Overview of Capturing Project Costs . 1Project Costs Capture . 1Sponsored Project Costs Capture . 4Enter Project Costs with ADFdi Spreadsheets . 5How Project Costs are Imported . 6Internal and External Commitments . 7How External Commitment Transactions are Imported . 9How External Commitment Transactions are Validated . 10How External Commitment Transactions are Processed . 11Can I view only approved project commitments? . 12Time Card Adjustments for Projects . 13How Time and Labor Works with Project Costing . 13Considerations for Capturing Inventory Costs . 16Considerations when Importing Overheads from Inventory Management . 17Import Costs Process . 17Project Expenditure Batch Approval Workflow . 19FAQs for Project Costs . 222Project Cost Transactions27Overview of How Project Cost Transactions are Processed . 27How Project Costs are Processed . 27View and Resolve Errors in Unprocessed Project Cost Transactions . 31How Accounting and Project Accounting Dates are Determined . 31How Project Costs are Validated . 32Considerations When Selecting Billable or Capitalizable Status for Transactions . 34How Expenditure Item Chargeable Status is Determined . 35Transaction Controls . 37Budgetary Control Funds Status . 38Considerations when Editing Burden Schedule Multipliers . 42
Oracle Fusion Cloud Project ManagementUsing Project CostingWhat are project cost reversals? . 43How can I reverse processed project costs? . 43FAQs for Project Cost Transactions . 463Overhead Costs to Projects49Overview of How Overhead Costs are Distributed to Projects . 49How Burden Costs Are Calculated . 49Recalculate Burden Costs . 53Examples for Additive and Precedence Burden Structures . 54Considerations for Burden Cost Options for Project Types . 55Burden Cost Calculations Test . 57FAQs for Overhead Costs to Projects . 584Project-Driven Supply Chain61Overview of Project-Driven Supply Chain . 61Capture Purchase Order Costs in Projects . 63Capture Transfer Order Costs in Projects . 64Capture Sales Order Issues in Projects . 65Capture Manufacturing and Maintenance Work Order Costs in Projects . 66Forecasting and Reporting on Supply Chain Transactions with Multiple Cost Distributions . 67FAQs for Project-Driven Supply Chain . 695Project Cost Adjustments71Overview of Reviewing and Adjusting Project Costs . 71Project Costs Adjustment Approval Workflow . 71How Project Cost Adjustments are Processed . 73Expenditure Item Adjustment Statuses . 74Review Budgetary Control Validation Errors . 75Configure Approval Notifications for Project Cost Adjustments . 75FAQs for Project Cost Adjustment . 766Project Rate Schedules81Overview of Project Rate Schedules . 81Rate Schedule Types . 81Import Project Rate Schedules Process . 83FAQs for Project Rate Schedules . 84
Oracle Fusion Cloud Project ManagementUsing Project Costing7Accounting for Project Transactions87Overview of Accounting for Project Transactions . 87How Accounting Burden Costs are Processed . 87Options to Maintain Accounting Periods and Project Accounting Periods . 90Project Costs and Revenue Accounting Entries . 93Considerations when Creating Accounting for Transactions . 94Accounting Class Usages in Projects . 95How Accounting Periods and Project Accounting Period Closing are Validated . 95Sweeping Transaction Accounting Events . 97Account Rules . 98Verify Accounting Sources for Projects . 100Post Subledger Transactions to the General Ledger . 101Accounting Project Costs Externally . 101Project Costing Accounts for Budgetary Control . 102FAQs for Accounting for Project Transactions . 1048Project Cost Allocations107Overview of Allocating Project Costs . 107How Project Cost Allocations are Processed . 107Considerations for Allocation Methods . 109Considerations for Allocations Basis Methods . 111Considerations for Allocation Offset Methods . 112Allocation Statuses . 113AllocationSource Pool Amount: How It's Calculated . 115Examples for Calculating Prorate Amounts using Allocation Basis Method . 116Considerations for Expenditure Type Class of Allocation Transactions . 119Define Allocation Rules to Allocate Labor Costs from a Shared Services Project . 119Define Allocation Rules to Allocate Rent Costs from General Ledger . 123FAQs for Project Cost Allocations . 1269Capital Asset Costs129Overview of Capital Asset Costs . 129Capital Projects Processing . 129Asset Cost Allocation Methods . 130Capitalization Options for Project Types . 130How Project Costing Source Lines Are Imported . 133Automatically Derive Depreciation Expense Account for Assets . 134
Oracle Fusion Cloud Project ManagementUsing Project CostingImport Assets . 135Import Unassigned Asset Lines . 136Verify Accounting Sources for Projects . 137FAQs for Capital Asset Costs . 13810Labor Distribution141Overview of Labor Distribution . 141Labor Schedules . 141Pay Element Labor Schedules . 143Person Assignment Labor Schedules . 144Person Assignment Pay Element Labor Schedules . 146Considerations for Managing Labor Schedules . 147Can I restrict access to pay element labor schedule management capabilities? . 152Manage Labor Costs . 152Import Payroll Costs . 15311Oracle Digital Assistant for Time Entry155Introduction to Oracle Digital Assistant . 155Time Entry Using Oracle Digital Assistant . 156
Oracle Fusion Cloud Project ManagementUsing Project CostingGet HelpGet HelpThere are a number of ways to learn more about your product and interact with Oracle and other users.Get Help in the ApplicationsUse help icons Help icon to access help in the application. If you don't see any help icons on your page, click your userimage or name in the global header and select Show Help Icons.Get SupportYou can get support at My Oracle Support. For accessible support, visit Oracle Accessibility Learning and Support.Get TrainingIncrease your knowledge of Oracle Cloud by taking courses at Oracle University.Join Our CommunityUse Cloud Customer Connect to get information from industry experts at Oracle and in the partner community. Youcan join forums to connect with other customers, post questions, suggest ideas for product enhancements, and watchevents.Learn About AccessibilityFor information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program. Videos included inthis guide are provided as a media alternative for text-based topics also available in this guide.Share Your FeedbackWe welcome your feedback about Oracle Applications user assistance. If you need clarification, find an error, or justwant to tell us what you found helpful, we'd like to hear from you.You can email your feedback to oracle fusion applications help ww grp@oracle.com.Thanks for helping us improve our user assistance!i
Oracle Fusion Cloud Project ManagementUsing Project CostingGet Helpii
Oracle Fusion Cloud Project ManagementChapter 1Using Project Costing1Project CostsProject CostsOverview of Capturing Project CostsCapture project costs and commitments, including sponsored projects and time cards, in Oracle Fusion Project Costingor import them from third-party applications.You can do this by using the application directly or through desktop Excel integration spreadsheets.Project Costs CaptureYou can capture project-related costs from both Oracle Cloud and third-party applications, and then transfer them toOracle Projects. You can also capture costs manually by creating uncosted, costed, and accounted transactions for thirdparty application sources in Projects.Transaction SourcesHere's a table that lists the cost types and the corresponding source applications.Source NameOracle PayablesTransaction Type Supplier invoice Self-Assessed TaxCreate self-assessed tax transactions from Payables as payable commitments in Projects.Oracle Purchasing Self-Assessed TaxCreate self-assessed tax transactions from Purchasing as PO commitments in Projects. Purchase Orders Purchase RequisitionsPurchase orders and purchase requisitions are available as committed costs for reporting inProjects.Oracle Cost Management Expense-Based Receipts Inventory Miscellaneous Transactions Inventory Movement RequestsOracle Projects Costs in Unreleased Expenditure Batches Adjustment Transactions Unprocessed Transactions1
Oracle Fusion Cloud Project ManagementChapter 1Using Project CostingProject CostsSource NameTransaction TypeThird-Party ApplicationsExternal costs imported using Desktop-Excel Integration, web services, or the Oracle Cloud interface.How Costs are CapturedHere's a figure that illustrates how you can capture different types of costs from internal and external applications, andthen transfer them to Projects.Here's a table that shows how you can export transactions from various sources to Oracle Projects.Source of Cost TransactionsDescriptionOther Oracle Cloud applicationsEnter and process project-related transactions, and then submit the Import Costs process. Forexample, you enter invoices with project-related distributions in Oracle Payables. You can then validate,account, and import them to Oracle Projects.2
Oracle Fusion Cloud Project ManagementChapter 1Using Project CostingProject CostsSource of Cost TransactionsDescriptionThird-party applicationsImport costs using one of the following: Desktop-Excel integration Web services Load data to the interface table in Oracle CloudYou can load data to interface tables using predefined templates and the Load Interface File forImport scheduled process, which are both part of the External Data Integration Services for OracleCloud feature. For more information, see the File Based Data Import guide for your cloud services.Individual third-party transactions createdin Oracle ProjectsYou can create individual transactions with a third-party application source directly from the ManageUnprocessed Costs page in the Costs work area.Let's say you're approaching period close and have to create a few third-party transactions. Ratherthan wait to receive the transactions from the third-party application, you can create them directlyusing this method.Foreign Keys to Important PJC EXPENDITURE ITEMS ALL Table FieldsHere is a table that lists the foreign keys of the ORIGINAL HEADER ID, ORIGINAL DIST ID, andORIGINAL LINE NUMBER fields in the PJC EXPENDITURE ITEMS ALL table in some of the most commonly-usedtransaction sources and documents.Source / DocumentORIGINAL HEADER IDORIGINAL DIST IDORIGINAL LINE NUMBERColumn Attribute / Key DescriptionNANANAOracle Payables / Supplier invoice / AP INVOICES ALL.INVOICE IDExpense report / Intercompanyinvoice / Interproject InvoiceAP INVOICE DISTRIBUTIONSALL.INVOICE DISTRIBUTION IDAP INVOICE LINES ALL.LINENUMBEROracle Payables / PaymentsAP INVOICE PAYMENTSALL.INVOICE PAYMENT IDAP PAYMENT HISTDISTS.PAYMENT HIST DIST IDNAOracle Cost Management /Purchase ReceiptCMR RCVTRANSACTIONS.EXTERNALSYSTEM REF ID (Expense)CMR RCV DISTRIBUTIONS.CMRSUB LEDGER ID (Expense)NACSTCST COST DISTRIBUTIONTRANSACTIONS.TRANSACTION ID LINES.DISTRIBUTION LINE ID(Inventory)(Inventory)NAOracle Fusion Cost Management /Miscellaneous InventoryCSTCST COST DISTRIBUTIONTRANSACTIONS.TRANSACTION ID LINES.DISTRIBUTION LINE IDNAOracle Fusion Cost Management /Sales Order IssueCSTCST COST DISTRIBUTIONTRANSACTIONS.TRANSACTION ID LINES.DISTRIBUTION LINE IDNA3
Oracle Fusion Cloud Project ManagementChapter 1Using Project CostingProject CostsSource / DocumentORIGINAL HEADER IDOracle Fusion Cost Management /Transfer Order DeliveryCMRCMR RCV DISTRIBUTIONS.CMRTRANSACTIONS.TRANSACTION ID SUB LEDGER ID (Expense)(Expense)NACSTCST COST DISTRIBUTIONTRANSACTIONS.TRANSACTION ID LINES.DISTRIBUTION LINE ID(Inventory)(Inventory)NACSTCST COST DISTRIBUTIONTRANSACTIONS.TRANSACTION ID LINES.DISTRIBUTION LINE ID(Material Transaction)NACST RESOURCETRANSACTIONS.RESOURCETRANSACTION ID (ResourceTransaction)CST COST DISTRIBUTIONLINES.DISTRIBUTION LINE IDNAHWM TM REC GRP.PARENT TMREC GRP IDHWM TM REC GRP USAGES.TMREC VERSIONHWM TM REC.TM REC IDOracle Fusion Cost Management /Work OrderOracle Time and LaborORIGINAL DIST IDORIGINAL LINE NUMBERCapturing Additional Transaction AttributesYou can capture project-specific attributes on actual cost and commitment transactions using the Cost Collectionflexfield. Manage naming, validation, and ordering of these attributes within each of the documents that capturethem, such as expense reports and purchase orders. You can capture, store, display, search, and report project-relatedattributes in the transaction source applications.Sponsored Project Costs CaptureGrants accountants can capture and adjust sponsored project costs in the Costs work area or by using the Costs filebased data import Excel templates.Prerequisite ConditionsTo capture and adjust sponsored project costs: The Grants Management offering must be implemented. The projects must be sponsored. Sponsored projects must be associated with at least one valid award or contract, and one external fundingsource.4
Oracle Fusion Cloud Project ManagementUsing Project CostingChapter 1Project CostsPrerequisite StepsThe grants administrator creates and submits the awards in the Awards work area. The sponsored project from theaward is automatically associated to the contract line.Capturing Sponsored Project Costs on the Manage Unprocessed CostsPageOn the Manage Unprocessed Costs page, depending on the number of awards or funding sources associated to thesponsored project, the grants accountant enters a sponsored
Oracle Fusion Cloud Project Management Using Project Costing Chapter 1 Project Costs 1 Project Costs Overview of Capturing Project Costs Capture project costs and commitments, including sponsored projects and time cards, in Oracle Fusion Project Costing or import them from third-party applications.
