Book Image

Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation

By : Ranjeet Yadav
Book Image

Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation

By: Ranjeet Yadav

Overview of this book

PeopleSoft financial management applications have been recognized as a leading ERP product across a wide range of industries that helps organizations automate their accounting operations, cut costs, and streamline business processes. They offer industry leading solutions for organizations' global needs, however complex they may be. PeopleSoft Enterprise Financial Management 9.1 Implementation is probably the only learning resource for a novice practitioner, who may otherwise have to rely on thousands of pages of documentation for such a complex ERP system. This book covers all the crucial elements of PeopleSoft Financials—a business processes, configuration, and implementation guide. This is the ideal one-stop resource before entering the world of PeopleSoft implementation. Beginning with the fundamentals of a generic financial ERP system, this book moves on to basic PeopleSoft concepts and then dives into discussing the individual modules in detail. You will see how to leverage financial modules such as Billing, Accounts Receivable, Accounts Payable, Asset Management, Expenses, and General Ledger. Dedicated chapters discuss key PeopleSoft features such as application security and commitment control for budgeting. You will learn fundamental ERP concepts such as the chart of accounts, used by organizations for recording and reporting financial transactions, and how to implement them in PeopleSoft through chartfields, business units, and SetIDs.
Table of Contents (16 chapters)
Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Understanding Setup Manager


Configuring PeopleSoft Financial applications from scratch is certainly no easy task. A typical implementation involving multiple modules typically involves hundreds of configuration activities that need to be performed in a specific sequence. In this chapter so far, we have covered some of the critical configuration activities, but discussing each of them is quite impractical. So the million dollar question is—How do we ensure that we complete all the necessary setup activities in the right order?

Let's not worry…PeopleSoft has just the right tool to help us with exactly this. It is known as the Setup Manager.

Setup Manager lists all the tasks required for implementing a product (module) in the right sequence. In addition, it shows the navigation path to the page where required configuration needs to be done. A direct link is provided so that the user can reach the appropriate page. We'll quickly see how to use it.

Implementation challenge

Configure the PeopleSoft Billing module using Setup Manager.

Note

Follow the navigation PeopleTools | Setup Manager | Manage Implementation Projects.

Follow this navigation to access Setup Manager:

PeopleTools | Setup Manager | Manage Implementation Projects

The following screenshot shows the Manage Implementation Projects page:

As you can see, we can create the implementation project either by a product (such as Billing, Accounts Receivable, and so on) or a Business Process (such as Process customer payments, Receive goods, and so on).

For our business requirement, as we need to configure the Billing module, we'll create the implementation project by Product.

Click the Products button. As shown in the following screenshot, the system opens a page listing all the PeopleSoft modules for which the organization holds a license:

Check the Select checkbox next to the required module and click the View Summary button at the bottom of the page.

The system opens a new page with two tabs. The following screenshot shows the Product Summary tab:

The page shows all the features offered by PeopleSoft in selected product. As part of the implementation, one of the critical tasks is to determine which of these features are really needed for the implementing organization.

Let's assume that for our hypothetical Billing module implementation, we do not need the Balance Accumulation and Billing Summarization features. Remove these features from the list by clicking the '-' button next to them.

Tip

Features marked with a star are mandatory and cannot be removed.

Click Save at the bottom of the page. The system opens a new page, which is shown in the following screenshot:

Enter the Project Name and Description and click OK. As shown in the next screenshot, the system opens a page showing the implementation project with given name:

Click the Generate Setup Tasks button in this page to automatically create the list of configuration tasks. The following screenshot shows the process status page:

This triggers a batch process in the background with its Run Status as Queued. When the process is completed, the run status automatically changes to Success.

Click the View Setup Tasks button to see the configuration activities. The following screenshot shows the Manage Setup Tasks page that opens:

This page lists out all the necessary configuration activities in the appropriate sequence.

The Status field shows the current status for the setup task. Place the cursor over the icon to see the status: Not started, In progress, or Complete.

Setup Task: Clicking the hyperlink transfers the control to the appropriate page in order to perform the required setup activity.

Click the Tracking tab to record progress of setup activities. The following screenshot shows the details of Tracking tab:

  • Assigned To: This is a free from text field, where details of person (or persons) responsible for this task can be entered. Note that this doesn't affect who actually performs a particular task.

  • Percent Complete: Again this field needs to be updated manually and is entirely informational. When you enter 100% in this field, the task status changes to Complete.

Click the Task Details tab. The following screenshot shows the details of Task Details tab:

  • Cross Database: This field indicates if a configuration option affects multiple modules.

  • Load Method: Indicates how configuration values can be entered into PeopleSoft system. Available options are: Component Interface, ETL, Other, and Online.

Let's look at a different set of tasks. The following screenshot shows a few setup tasks for the Billing module:

As you can see, configuring Adjustment Type and Book Code can be done by Online method alone. On the other hand, configuration for other tasks can be done either by Component Interface or Online method.

Let's understand these different configuration methods:

  • Online: Required configuration values can be entered manually on the online pages. For example, to configure Adjustment Type, the user can navigate to the appropriate page and enter as many adjustment type values as required.

  • Component Interface: When the volume of configuration values is quite high, this is the preferred method. PeopleSoft offers a utility called Excel to Component Interface. It essentially automates the data entry into PeopleSoft setup pages by reading data from pre-defined Microsoft Excel templates. For example, if there are 2000 Account values to be configured, it is much easier to put the data such as Account number, Description and so on, into the Excel template. The template contains all the field values that need to be entered on the PeopleSoft page. The Excel to Component Interface utility then reads these values from the template, validates them, and loads them one row after the other into the PeopleSoft component.

  • Other: You can write a customized program to load configuration values from an external source.

So, this is what we'll need to do as we go along the configuration of a PeopleSoft module:

  • Create an implementation project for a specific module. It'll show all the required configuration activities.

  • In the Tracking tab, assign each task to the concerned person (it may be yourself!) along with the planned start and end dates (although it is not mandatory).

  • Click the hyperlink for each task so that the system opens the required page and performs necessary system setups.

  • Once a task is completed, enter 100% as percentage completed, so that task status changes to Complete.