PeopleSoft Enterprise Financials, ESA, ALM, and SCM Portal Packs 9.1 PeopleBook November 2009 PeopleSoft Enterprise Financials, ESA, ALM, and SCM Portal Packs 9.1 PeopleBook SKU fscm91pbr0 Copyright © 1992, 2009, Oracle and/or its affiliates. All rights reserved. Trademark Notice Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. License Restrictions Warranty/Consequential Damages Disclaimer This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by 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. Warranty Disclaimer The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing. Restricted Rights Notice If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable: U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation 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 Notice This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications. Third Party Content, Products, and Services Disclaimer This software and documentation may provide access to or information on content, products and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content, products and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third party content, products or services. Contents Preface PeopleSoftEnterpriseFinancials,ESA,ALM,andSCMPortalPacksPreface ................................. xvii Oracle'sPeopleSoftEnterpriseProducts ..................................................................................................... xvii RelatedDocumentation .............................................................................................................................. xviii CommonElementsUsedinThisPeopleBook ........................................................................................... xviii PeopleBooksandtheOnlinePeopleSoftLibrary ......................................................................................... xix Part 1 Configuring PeopleSoft Financials, ESA, ALM, and SCM Portal Packs Chapter 1 GettingStartedwithPeopleSoftFinancials,ESA,ALM,andSCMPortalPacks ................................... 3 PeopleSoftFinancials,ESA,ALM,andSCMPortalPacksOverview .......................................................... 3 PeopleSoftFinancials,ESA,ALM,andSCMPortalPacksImplementation ................................................. 4 Chapter 2 SettingUpPeopleSoftFinancialsPortalPack ............................................................................................. 5 PrerequisitesforthePeopleSoftFinancialsPortalPack ................................................................................. 5 UsingRolesandPermissionListsforthePeopleSoftFinancialsPortalPack ................................................ 7 Chapter 3 SettingUpPeopleSoftEnterpriseServiceAutomation(ESA)PortalPack .............................................. 9 PrerequisitesforthePeopleSoftESAPortalPack .......................................................................................... 9 UsingRolesandPermissionListsforthePeopleSoftESAPortalPack ....................................................... 11 Copyright © 1992, 2009, Oracle and/or its affiliates. All Rights Reserved. iii Contents Chapter 4 SettingUpPeopleSoftAssetLifecycleManagement(ALM)PortalPack .............................................. 13 PrerequisitesforthePeopleSoftALMPortalPack ....................................................................................... 13 UsingRolesandPermissionListsforthePeopleSoftAssetLifecycleManagement(ALM)PortalPack . 14 Chapter 5 SettingUpPeopleSoftSupplyChainManagement(SCM)PortalPack ................................................. 17 UnderstandingPeopleSoftSCMPortalPack ................................................................................................. 17 PrerequisitesforPeopleSoftSCMPortalPack .............................................................................................. 17 UsingRolesandPermissionListsforthePeopleSoftSCMPortalPack ....................................................... 18 PageletSecurity ....................................................................................................................................... 18 Part 2 Using PeopleSoft Financials Portal Pack Chapter 6 UsingPageletsEnabledbyPeopleSoftGeneralLedger ........................................................................... 23 ViewingExpenseVariances ......................................................................................................................... 23 PagesUsedtoViewExpenseVariances ................................................................................................. 23 ViewingExpenseVariances .................................................................................................................... 24 PersonalizingExpenseVariance ............................................................................................................. 25 ComparingStandardLedgers ................................................................................................................. 26 ViewingCommitmentControlBudgetOverviews ................................................................................ 27 ViewingGrossMargins ................................................................................................................................. 27 PagesUsedtoViewGrossMargins ........................................................................................................ 28 ViewingGrossMargins .......................................................................................................................... 28 PersonalizingGrossMargins .................................................................................................................. 28 ViewingLedgerDetails .......................................................................................................................... 30 ViewingLapsingofAppropriation ............................................................................................................... 30 PagesUsedtoViewtheLapsingofAppropriation ................................................................................. 31 ViewingtheLapsingofAppropriation ................................................................................................... 31 PersonalizingLapsingofAppropriation ................................................................................................. 31 ViewingBudgetAlerts ................................................................................................................................. 32 iv Copyright © 1992, 2009, Oracle and/or its affiliates. All Rights Reserved. Contents PagesUsedtoViewBudgetAlerts ......................................................................................................... 32 ViewingMyBudgetAlerts ..................................................................................................................... 33 PersonalizingMyBudgetAlerts ............................................................................................................. 33 ViewingBudgetDetails .......................................................................................................................... 34 ViewingOperatingBudgetVariances .......................................................................................................... 35 PagesUsedtoViewOperatingBudgetVariances .................................................................................. 36 ViewingOperatingBudgetVariances ..................................................................................................... 36 PersonalizingOperatingBudgetVariance .............................................................................................. 37 ComparingStandardLedgers ................................................................................................................. 38 ViewingCommitmentControlBudgetOverviews ................................................................................ 38 ViewingProjectRevenueVariances ............................................................................................................. 39 PagesUsedtoViewProjectRevenueVariances .................................................................................... 40 ViewingProjectRevenueVariances ....................................................................................................... 40 PersonalizingProjectRevenueVariance ................................................................................................ 41 ComparingStandardLedgers ................................................................................................................. 42 ViewingCommitmentControlBudgetOverviews ................................................................................ 43 ViewingUnbilledBalancestoProjectsExpiring ......................................................................................... 43 PagesUsedtoViewUnbilledBalances .................................................................................................. 44 ViewingExpiringProjects ...................................................................................................................... 44 PersonalizingUnbilledBalancestoProjectsExpiring ........................................................................... 44 ViewingActualVersusBudgeted(StandardBudget)Information .............................................................. 45 PagesUsedtoAccessandViewActualVersusBudgetedInformation ................................................. 45 ApplyingChartFieldSecurityforActualVersusBudgetedInformation .............................................. 46 ViewingActualvsBudgetedInformation .............................................................................................. 47 PersonalizingtheActualVersusBudgetedView ................................................................................... 48 ComparingLedgerDetails ..................................................................................................................... 48 Chapter 7 UsingPageletsEnabledbyPeopleSoftPayables ...................................................................................... 51 SettingUpPeopleSoftPayablesforthePeopleSoftFinancialsPortalPack ................................................. 51 UnderstandingSetup ............................................................................................................................... 51 PageUsedtoSetUpPeopleSoftPayablesforthePeopleSoftFinancialsPortalPack ........................... 52 ViewingAverageDaysinPayables .............................................................................................................. 52 PagesUsedtoViewAverageDaysinPayables ...................................................................................... 52 ViewingAverageDaysinPayables ........................................................................................................ 53 PersonalizingAverageDays ................................................................................................................... 53 ViewingAverageDaysInformationbyBusinessUnit ........................................................................... 53 ViewingPayablesDiscounts ......................................................................................................................... 54 PagesUsedtoViewPayablesDiscounts ................................................................................................ 54 ViewingPayablesDiscounts ................................................................................................................... 55 PersonalizingPayablesDiscounts .......................................................................................................... 55 ViewingDiscountsbyBusinessUnit ...................................................................................................... 56 Copyright © 1992, 2009, Oracle and/or its affiliates. All Rights Reserved. v Contents ViewingTopPayablesVendorsbyExpenditure .......................................................................................... 56 PagesUsedtoViewTopPayablesVendorsbyExpenditure .................................................................. 57 ViewingTopPayablesVendorsbyExpenditure .................................................................................... 57 PersonalizingTopVendors ..................................................................................................................... 57 ViewingTopVendorDetails .................................................................................................................. 58 Chapter 8 UsingPageletsEnabledbyPeopleSoftReceivables ................................................................................. 59 SettingUpPeopleSoftReceivablesforthePeopleSoftFinancialsPortalPack ............................................ 59 UnderstandingSetup ............................................................................................................................... 59 PageUsedtoSetUpPeopleSoftReceivablesforthePeopleSoftFinancialsPortalPack ...................... 60 ViewingAgingSummaryInformation ......................................................................................................... 60 PagesUsedtoViewAgingSummaryInformation ................................................................................. 60 ViewingAgingSummary ........................................................................................................................ 60 PersonalizingAgingSummary ................................................................................................................ 61 ViewingAverageTimetoResolveDeductions ............................................................................................ 61 PagesUsedtoViewAverageTimetoResolveDeductions ................................................................... 62 ViewingAverageTimetoResolveDeductions ...................................................................................... 62 PersonalizingAverageTimetoResolve ................................................................................................. 62 ViewingDaysSalesOutstanding .................................................................................................................. 63 PagesUsedtoViewDaysSalesOutstanding ......................................................................................... 63 ViewingDaysSalesOutstanding ............................................................................................................ 63 PersonalizingDaysSalesOutstanding ................................................................................................... 64 ViewingDeductionsbyAmount .................................................................................................................. 65 PagesUsedtoViewDeductionbyAmount ............................................................................................ 65 ViewingtheDeductionsbyAmount ...................................................................................................... 65 PersonalizingDeductionbyAmount ...................................................................................................... 65 ViewingDeductionsbyReason .................................................................................................................... 66 PagesUsedtoViewDeductionsbyReason ............................................................................................ 67 ViewingtheDeductionsbyReason ........................................................................................................ 67 PersonalizingDeductionbyReason ........................................................................................................ 67 ViewingOutstandingandPastDueBalances ............................................................................................... 68 PagesUsedtoViewOutstandingandPastDueBalanceInformation .................................................... 69 ViewingOutstandingBalances ............................................................................................................... 69 ViewingPastDueBalances .................................................................................................................... 69 ViewingSalesforNewandExistingCustomers .......................................................................................... 70 PagesUsedforViewSalestoNewandExistingCustomers .................................................................. 70 ViewingSalesforNewandExistingCustomers .................................................................................... 70 PersonalizingSalesforNewandExistingCustomers ............................................................................ 71 ViewingTopCustomerSalesBalances ........................................................................................................ 72 PagesUsedtoViewTopCustomerSalesBalances ................................................................................ 72 ViewingTopCustomerSalesBalances .................................................................................................. 72 vi Copyright © 1992, 2009, Oracle and/or its affiliates. All Rights Reserved. Contents PersonalizingTopCustomerSalesBalances .......................................................................................... 73 ViewingTopCustomerWrite-offs ............................................................................................................... 73 PagesUsedtoViewTopCustomerWrite-offs ....................................................................................... 74 ViewingtheTopCustomerWrite-offs ................................................................................................... 74 PersonalizingTopCustomerWrite-offs ................................................................................................ 74 ViewingWrite-offTrends ............................................................................................................................. 75 PagesUsedtoViewWrite-offTrends .................................................................................................... 76 ViewingWrite-offTrends ....................................................................................................................... 76 PersonalizingWrite-offTrends ............................................................................................................... 76 Chapter 9 UsingPageletsEnabledbyPeopleSoftTreasuryManagement ............................................................... 79 ViewingBankContacts ................................................................................................................................ 79 PagesUsedtoViewBankContacts ........................................................................................................ 79 ViewingBankContacts ........................................................................................................................... 80 PersonalizingBankContacts ................................................................................................................... 80 ReviewingFinancialContactInformation .............................................................................................. 80 ViewingBankStatementReconciliationAgingInformation ....................................................................... 80 PagesUsedtoViewBankStatementReconciliationAgingInformation ............................................... 81 ViewingBankStatementReconciliationAging ..................................................................................... 81 PersonalizingBankStatementReconciliationAging ............................................................................ 82 ReviewingBankStatementInformation ................................................................................................. 82 Part 3 Using PeopleSoft Enterprise Service Automation Portal Pack Chapter 10 UnderstandingEnterpriseServiceAutomationPagelets ......................................................................... 85 UnderstandingEnterpriseServiceAutomationPageletTypes ..................................................................... 85 CommonElementsUsedinThisChapter ............................................................................................... 85 OperationalSummaryPagelets .............................................................................................................. 86 OperationalThresholdAlerts ................................................................................................................. 87 TransactionsinProgress ......................................................................................................................... 88 AdministeringSystemDefaultsforPeopleSoftEnterpriseServiceAutomationPortalPackPagelets ........ 88 PageUsedtoAdministerSystemDefaultsforPeopleSoftEnterpriseServiceAutomationPortalPack Pagelets ................................................................................................................................................ 89 DefiningDefaultValuesforEnterpriseServiceAutomationPagelets ................................................... 89 ViewingOTAs .............................................................................................................................................. 90 Copyright © 1992, 2009, Oracle and/or its affiliates. All Rights Reserved. vii Contents PagesUsedtoViewOTAs ...................................................................................................................... 91 SettingUpOTAs .................................................................................................................................... 91 UsingtheOperationalThresholdAlertPagelet ...................................................................................... 92 UsingtheOperationalThresholdChartPagelet ..................................................................................... 93 PersonalizingOTAs ............................................................................................................................... 93 ViewingtheMediaSourcesPagelet .............................................................................................................. 94 PagesUsedtoViewtheMediaSourcesPagelet ..................................................................................... 94 SettingUpMediaSources ....................................................................................................................... 95 PersonalizingMediaSources .................................................................................................................. 96 ViewingtheMediaSourcesPagelet ........................................................................................................ 96 ViewingEnterpriseServiceAutomationNavigationCollectionPagelets ..................................................... 97 UnderstandingNavigationCollectionPagelets ....................................................................................... 97 PagesUsedtoViewEnterpriseServiceAutomationNavigationCollectionPagelets ........................... 97 ViewingNavigationCollections ............................................................................................................ 98 MaintainingNavigationCollections ....................................................................................................... 98 Chapter 11 UsingPageletsEnabledbyPeopleSoftContracts .................................................................................... 99 ViewingtheTopFiveContracts ................................................................................................................... 99 PagesUsedtoViewtheTopFiveContracts ........................................................................................... 99 ViewingTopFiveContracts ................................................................................................................. 100 PersonalizingTopFiveContracts ........................................................................................................ 100 ViewingMostRecentContracts ................................................................................................................. 101 PagesUsedtoViewMostRecentContracts ......................................................................................... 102 ViewingMostRecentContracts ........................................................................................................... 102 PersonalizingMostRecentContracts .................................................................................................. 103 ViewingContractStatusMetrics ................................................................................................................ 104 PagesUsedtoViewContractStatusMetrics ........................................................................................ 105 ViewingContractStatusMetrics .......................................................................................................... 105 PersonalizingContractStatusMetrics ................................................................................................. 105 ViewingContractMilestoneMetrics .......................................................................................................... 107 PagesUsedtoViewContractMilestoneMetrics .................................................................................. 107 ViewingContractMilestoneMetrics .................................................................................................... 107 PersonalizingContractMilestoneMetrics ........................................................................................... 108 ViewingContractProductGroupMetrics .................................................................................................. 109 PagesUsedtoViewContractProductGroupMetrics .......................................................................... 109 ViewingContractProductGroupMetrics ............................................................................................ 109 PersonalizingContractProductGroupMetrics ................................................................................... 110 UsingOTAsforPeopleSoftContracts ........................................................................................................ 111 UnderstandingOTACalculationsinPeopleSoftContracts ................................................................. 111 PagesUsedtoPersonalizeOTAsforPeopleSoftContracts ................................................................. 112 PersonalizingContractRevenueForecast ............................................................................................ 113 viii Copyright © 1992, 2009, Oracle and/or its affiliates. All Rights Reserved. Contents PersonalizingContractSales ................................................................................................................ 115 Chapter 12 UsingPageletsEnabledbyPeopleSoftExpenses ................................................................................... 119 UnderstandingthePageletsDesignedforPeopleSoftExpenses ................................................................. 119 CommonElementsUsedinThisChapter ............................................................................................. 120 ViewingTotalPredictedExpenses ............................................................................................................. 121 UnderstandingTotalPredictedExpenses ............................................................................................. 122 PagesUsedtoViewTotalPredictedExpenses ..................................................................................... 122 SettingUpDefaultsfortheTotalPredictedExpensesPagelet ............................................................ 123 ViewingTotalPredictedExpenses ....................................................................................................... 124 ViewingtheTotalPredictedExpensesSummaryPage ........................................................................ 125 PersonalizingYourTotalPredictedExpensesPagelet ........................................................................ 127 UsingOperationalThresholdAlerts(OTA)forPeopleSoftExpenses ....................................................... 128 UnderstandingtheTotalExpenseCostsOTA ..................................................................................... 128 PagesUsedtoPersonalizeOTAsforPeopleSoftExpenses .................................................................. 129 PersonalizingTotalExpenseCost ........................................................................................................ 129 ViewingTransactionsinProgress(TIP) ..................................................................................................... 131 UnderstandingTransactionsinProgress ..................................................................................................... 132 TIPStages ............................................................................................................................................ 133 ViewingandPersonalizingTransactionsinProgress .......................................................................... 134 PagesUsedtoViewandPersonalizeTransactionsinProgress ............................................................ 134 UnderstandingHowtoSearchforTransactionsinProgress ................................................................ 135 ViewingTransactionsinProgress(Details) ......................................................................................... 137 ViewingTransactionsinProgressCharts ............................................................................................ 139 PersonalizingTransactionsinProgress ................................................................................................ 140 AdministeringExpenseReportandTimeReportPagelets .................................................................. 141 Chapter 13 UsingPageletsEnabledbyPeopleSoftProgramManagement ............................................................ 145 ViewingChangeControlAnalysis ............................................................................................................. 145 PagesUsedtoViewChangeControlAnalysis ..................................................................................... 145 ViewingChangeControlAnalysisInformation .................................................................................... 146 PersonalizingtheChangeControlAnalysisPagelet ............................................................................ 146 ViewingCriticalIssuesbyProject .............................................................................................................. 148 PagesUsedtoViewCriticalIssuesbyProject ..................................................................................... 148 ViewingCriticalIssuesbyProject ........................................................................................................ 148 PersonalizingtheCriticalIssuesbyProjectPagelet ............................................................................ 148 ViewingIssuesbyPriority .......................................................................................................................... 149 PageUsedtoViewIssuesbyPriority ................................................................................................... 149 Copyright © 1992, 2009, Oracle and/or its affiliates. All Rights Reserved. ix Contents ViewingIssuesbyPriority .................................................................................................................... 149 ViewingIssuePrioritybyProject ............................................................................................................... 150 PagesUsedtoViewIssuesbyPrioritybyProject ................................................................................ 150 ViewingIssuesbyPrioritybyProject ................................................................................................... 150 PersonalizingtheIssuePrioritiesbyProjectPagelet ........................................................................... 151 ViewingTopFiveIssues ............................................................................................................................ 151 PagesUsedtoViewTopFiveIssues .................................................................................................... 151 ViewingtheTopFiveIssues ................................................................................................................. 152 PersonalizingtheTop5IssuesPagelet ................................................................................................ 152 ViewingTopFiveRisks ............................................................................................................................. 153 PagesUsedtoViewTopFiveRisks ..................................................................................................... 153 ViewingtheTopFiveRisks .................................................................................................................. 153 PersonalizingtheTop5RisksPagelet ................................................................................................. 154 ViewingForecasttoCompleteInformation ................................................................................................ 154 PagesUsedtoViewForecasttoCompleteInformation ....................................................................... 154 ViewingForecasttoCompleteInformation .......................................................................................... 155 PersonalizingtheForecasttoCompletePagelet .................................................................................. 155 ViewingPrograms ...................................................................................................................................... 156 PagesUsedtoViewPrograms .............................................................................................................. 156 ViewingMyProgram ............................................................................................................................ 156 PersonalizingtheMyProgramPagelet ................................................................................................ 157 UsingOTAsforPeopleSoftProgramManagement ................................................................................... 157 UnderstandingOTACalculationsinPeopleSoftProgramManagement .............................................. 158 PagesUsedtoPersonalizeOTAsforPeopleSoftProgramManagement ............................................. 160 PersonalizingtheBudgettoForecastTimeVarianceOTA ................................................................. 162 PersonalizingtheProjectsPredictedtobeLateOTA .......................................................................... 163 PersonalizingtheActualtoForecastUtilizationOTA ......................................................................... 163 PersonalizingtheForecastUtilizationOTA ........................................................................................ 164 Chapter 14 UsingPageletsEnabledbyPeopleSoftProjectCosting ......................................................................... 167 ViewingTopProjects ................................................................................................................................. 167 PagesUsedtoViewTopProjects ......................................................................................................... 167 ViewingTopProjectsbyBudgetAmount ............................................................................................ 168 PersonalizingTopProjects ................................................................................................................... 169 UsingOTAsforPeopleSoftProjectCosting .............................................................................................. 170 UnderstandingOTACalculationsforPeopleSoftProjectCosting ....................................................... 170 PagesUsedtoPersonalizeOTAsforPeopleSoftProjectCosting ........................................................ 172 PersonalizingBudgettoActualCostVariance .................................................................................... 174 PersonalizingBudgettoActualTimeVariance ................................................................................... 175 PersonalizingGrossMargin ................................................................................................................. 176 PersonalizingProjectsOverBudget ..................................................................................................... 177 x Copyright © 1992, 2009, Oracle and/or its affiliates. All Rights Reserved.