PeopleSoft Enterprise Project Costing 9.1 Reports - Oracle

Transcription

PeopleSoft Enterprise ProjectCosting 9.1 ReportsNovember 2009

PeopleSoft Enterprise Project Costing 9.1 ReportsSKU fscm91fprc-r1109Copyright 2009, Oracle and/or its affiliates. All rights reserved.Trademark NoticeOracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of theirrespective owners.License Restrictions Warranty/Consequential Damages DisclaimerThis software and related documentation are provided under a license agreement containing restrictions on use anddisclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreementor 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, ordecompilation of this software, unless required by law for interoperability, is prohibited.Warranty DisclaimerThe information contained herein is subject to change without notice and is not warranted to be error-free. If you findany errors, please report them to us in writing.Restricted Rights NoticeIf this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of theU.S. Government, the following notice is applicable:U.S. GOVERNMENT RIGHTSPrograms, software, databases, and related documentation and technical data delivered to U.S. Government customersare “commercial computer software” or “commercial technical data” pursuant to the applicable Federal AcquisitionRegulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, andadaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and,to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19,Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City,CA 94065.Hazardous Applications NoticeThis software is developed for general use in a variety of information management applications. It is not developedor intended for use in any inherently dangerous applications, including applications which may create a riskof personal injury. If you use this software in dangerous applications, then you shall be responsible to take allappropriate fail-safe, backup, redundancy and other measures to ensure the safe use of this software. OracleCorporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerousapplications.Third Party Content, Products, and Services DisclaimerThis software and documentation may provide access to or information on content, products and services from thirdparties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kindwith respect to third party content, products and services. 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.

ContentsChapter 1PeopleSoft Project Costing Reports. . . . . . . . . 1PeopleSoft Project Costing Reports: A to Z. . . . . . . . . 1Report Samples . 3Copyright 2009, Oracle and/or its affiliates. All rights reserved.iii

ContentsivCopyright 2009, Oracle and/or its affiliates. All rights reserved.

CHAPTER 1PeopleSoft Project Costing ReportsThis appendix provides an overview of PeopleSoft Project Costing reports and enables you to view a summarytable of all reports.Note. For samples of these reports, see the PDF files that are published on CD-ROM with your documentation.See AlsoEnterprise PeopleTools PeopleBook: PeopleSoft Process SchedulerPeopleSoft Project Costing Reports: A to ZThis table lists the PeopleSoft Project Costing reports, sorted alphanumerically by report ID.Note. Reports in PeopleSoft Project Costing that show project transaction data are generated from data in theProject Transactions Reporting table (PC RPO), which you must populate beforehand.Report ID and ReportNamePCPL1000Project Financial ReportDescriptionView a transaction summaryof all activities by analysistype, source type, category,and subcategory. (SQR)NavigationRun Control PageProject Costing, Reports,Summary, Financial,FinancialRUN PCPL1000Project Costing, Reports,Summary, Transaction,Transaction SummaryRUN PCPL2000Note. Run the ReportSummarization process(PC RPO) by transactiondate before you run theProject Financial Report.PCPL2000Project Transaction ReportView a transaction summaryof all projects by analysistype, source type, category,and subcategory. (SQR)Note. Run the ReportSummarization process bytransaction date before yourun the Project TransactionReport.Copyright 2009, Oracle and/or its affiliates. All rights reserved.1

PeopleSoft Project Costing ReportsReport ID and ReportNamePCX9000Project Funds DistributionReportPCY1000-.RPTBusiness Unit ListPCY1030-.RPTActive Analysis GroupDefinitionsChapter 1DescriptionNavigationView various amounts for aproject or appropriation suchas the amount funded, spent,remaining, and collected.(XML Publisher)Project Costing, FundsDistribution, Project FundsDistribution ReportRUN PCX9000View a list of all businessunits and their correspondingdefault options. (Crystal)Setup Financials/SupplyChain, Business UnitRelated, Reports, ProjectCosting Units, ParametersRUN PCBU1000View the definition of eachanalysis group in the system.(Crystal)Project Costing, Reports,Definition, Active AnalysisGroups, Active AnalysisGroupsRUN PCY1030Project Costing, Reports,Project Budget Review,Project Budget ReviewRUN PCY1050Project Costing, Reports,Summary, TransactionLevel Report, TransactionLevel ReportRUN PCY5050View a list of all activeanalysis types for a specificsetID as of a specific date.(Crystal)Project Costing, Reports,Definition, Analysis Typesby SetID, Analysis Typesby SetIDRUN PCY8020View a list of all activeactivity types for a specificsetID as of a specific date.(Crystal)Project Costing, Reports,Definition, Activity Typesby SetID, Activity Typesby SetIDRUN PCY8030View a list of all user-definedlinks between sourcetypes, categories, andsubcategories. (Crystal)RUN PCY8080Project Costing, Reports,Definition, LinkedTransaction Elements,Linked Transaction ElementsView a list of budget-to-costBudgets to Costs Review by variances by budget itemfor each period of a saction Level ReportRun Control PageView a list of the activitytype, activity ID, source type,category, and subcategory fortransactions for all projectsor specified projects for abusiness unit, and optionallyfor a specific date range orbudget, cost, and revenueanalysis group. (Crystal)Note. Run the ReportSummarization process bytransaction date before yourun the Transaction LevelReport.PCY8020-.RPTActive Analysis Types byTableset IDPCY8030-.RPTActive Activity Types byTableset IDPCY8080-.RPTLinked TransactionElements2Copyright 2009, Oracle and/or its affiliates. All rights reserved.

Report ID:PCPL1000Bus. Unit:US004 -- US004 ILLINOIS OPERATIONSProject:-Dept:-From Date 01/01/2001Thru Date 12/31/2003PeopleSoft PCPROJECT FINANCIAL REPORTPage No. 1Run Date 11/06/2003Run Time 17:10:19ProjectActivityAnalysis SourceIdIdTypeTypeCategoryAmount r Unit Of MeasureFor CategoryFor Source TypeFor Analysis TypeFor Activity IDFor Project IDIMPLEMENTTotalTotalTotalTotalTotalINSTALLACTFor Unit Of MeasureFor CategoryFor Source TypeFor Analysis TypeFor Activity ACTFor Unit Of MeasureFor CategoryFor Source TypeFor Analysis TypeFor Activity IDFor Project IDPASSET1TotalTotalTotalTotalTotalACT1ACTFor Unit Of MeasureFor CategoryFor Source TypeFor Analysis TypeFor Activity IDTotalTotalTotalTotalTotalTotalACT2ACTFor Unit Of MeasureFor CategoryFor Source TypeFor Analysis TypeFor Activity IDFor Project 0.0030,000.00

Report ID:PCPL2000Bus. Unit:US004 -- US004 ILLINOIS OPERATIONSProject:-Dept:-From Date 01/01/2001Thru Date 12/31/2003PeopleSoft PCPROJECT TRANSACTION REPORTPage No. 1Run Date 11/06/2003Run Time 17:09:34ProjectActivityAnalysis SourceCurrency Unit ofIdIdTypeTypeCategory SubCategory CodeMeasureAmount rForFor Source TypeFor Analysis TypeFor Currency CDFor Project INSTALLACTMATERIALSACTForForFor Source TypeFor Analysis TypeFor Currency CDFor Project ACTACT2ACTForForFor Source TypeFor Analysis TypeFor Currency CDFor Project ACTForForFor Source TypeFor Analysis TypeFor Currency CDFor Project LEMENTACTUSDPASSET1ACTUSDPASSET2

# % & ' ( ( ) * , ( ) * . ( ) * % # ' * ' ,- )# !" " ' ,- )# !" % ( ' ,- )# ) !" ! " # % ! ! !" " &' # ('' - # % % # ' * ! ('' - % # ' * ! ! !" " # % (('' - # % ! ! !" # " &'

Report ID:PCY1030-.RPTRun Control ID:PeopleSoft Project CostingACTIVE ANALYSIS GROUP DEFINITIONSAnalysis Group1/1/2001As Of Date:Analysis GroupNAME and DescriptionTableSET ID:Analysis Type NAME and DescriptionACTActual CostTime and Labor ActualTime and Labor EstimateQuantity MultiplierSigned .001.00ADJST Resource AdjustmentACTNPYPAYALLActual CostNo Pay Time and Labor ActualTime and Labor ActualAll Analysis DFCCFNDFRVFTCGLEGLRActual CostBilling AdjustmentTotal Cost Budget - Scenario 1Total Cost Budget - Scenario 2Total Cost Budget - Scenario 3Total Cost Budget - Scenario 4Total Cost Budget - Scenario 5Total Cost Budget - Scenario 6Total Cost Budget - Scenario 7Total Cost Budget - Scenario 8Billable AmountBilled AmountBilling RetainageTotal Cost BudgetCost Share Commitment AdjustCost Budget AdjustmentsCommitment AdjustmentsCost Share Commitment ReversalAsset Cost SummaryCommitment incl. PO & SubcontCost of Removal of AssetCostShare Requisition ReversalCost Sharing RequisitionCost of Removal Cost SummaryCommitment ReversalsCosting ( without Contracts)Billing DeferralBilling DiscountEmployee TimeBill EstimateCost EstimateFixed Cost Billed AmountCompletion CostFunds DistributionFixed Cost Revenue AmountForecast To CompleteGL ExpenseGL Revenue1Run Date11/6/2003Run Time5:14:19 PMSHAREActual CostACTPAYTLAPage No.Analysis Type Map

% & ' () % * , ) % % * % % % % ! " # # #

# % & ( ' %%%%% .# / # ! ) # ) ! " ! "# ' , / * # " ! ! " !* % & 0 & # 1 1 " ! ! ! ! # #2 1 '%()%%(%%%*%% %(%%%*%% %*%% '%()%%(%%%*%% %(%%%*%% %*%% #2 # 1 '%()%%(%%%*%% %(%%%*%% %*%% '%()%%(%%%*%% %(%%%*%% %*%% '%()%%(%%%*%% %(%%%*%% %*%% '%()%%(%%%*%% %(%%%*%% %*%% '%()%%(%%%*%% %(%%%*%% %*%% , , &%%%%% , -

- ' & # % & ' ( )* , - , 12 1, 6, ,6 ,, ,8 2 ,8 , ?1 1 1, ? , , ,, #& - %& ' & ( ('& & ! ! ('& & / . & ! " " # " " % " & " ' " ( " ) ! ! , . !! ! ! . !! ! ! . !! ! , / !! 0 !! ! 3 1 4 5 , ! / 5 . , 7 , / . , 7 5 , ! / !! 0 !! ! , / 9 : . ; 5 ! 0 ! ! ! ! ! , / ! ! , / , ! ! 0 ! 155 , / 1/ ! 1 ! 5 ! 5 !! 0 5 ! 5 5 ! !! 0 . ! , , ! , / , / # &00& %& & # ) &00& %& 1 !"! # * ## ,

) , ) 3/ ) 3 / - )-./ / ) * ! !# !"!# % & &' ( )-./ / 0 1) /) 3 / %& '%( #( # % % & . / 0 / * ! "# ! "% ! '! ) #! )! # ! " *% ! ,"! " - % " ! " * ! ! ! " ! ". ! "/ 1/22/ 3/ ) / / 5 /22/ 3/ ) 4

- . !,2 /, ," "" 4 # # % * * & !2/ ! 3 ! !"" !"" !"" "" 4 '( "# !"" !"" % % 5 # % %' / ! 0 !1 3 ! " # % % 5!"" "" 4 % % 5 %&%' ( ) ) & *

PeopleSoft Enterprise Service AutomationProject CostingPage:Project Funds Distribution ReportReport Definition: PCX9000Run Date:1 of 18/28/2009Report ParametersBusiness Unit:Currency Code:As of Date:C BRIDGEProjectActivityC st Level Sort:Second Level Sort:Third Level Sort:Fourth Level Sort:SubCategory%FundCodeF450ContractTotal %Total %C BRIDGE%APP1%%%Total %Total APP1C BRIDGE%APP2%%%Total %Total APP2C BRIDGE%APP3%%F120Total %Total APP3Total %Total C BRIDGEEnd of ReportLinePROJECT IDACTIVITY IDRESOURCE TYPERESOURCE .00

PeopleSoft Project Costing Reports: A to Z This table lists the PeopleSoft Project Costing reports, sorted alphanumerically by report ID. Note. Reports in PeopleSoft Project Costing that show project transaction data are generated from data in the Project Transactions Reporting table (PC_RPO), which you must populate beforehand. Report ID and .