Archive for the ‘PeopleSoft’ Category

Ideas for MOSC – My Oracle Support Community

Posted by

I have an idea! But what should I do with it? Ideas. We all have them. Some of them end up as customizations to our software. Others end up as simply dreams. But some lucky thoughts may end up on the MOSC – My Oracle Support Community. Ultimately, they may even end up as part of the delivered functionality. To find the space, to see what ideas are out there, or to add your own, CLICK HERE!

If you haven’t had an opportunity to check out the hundreds of active ideas, you really owe it to yourself to give it some attention. You can vote up or down on a specific idea that someone else has offered. You can even add your own!

Here are a few new ideas (along with their links) for the Maintenance Management module (my favorite). You might find them helpful for your account, or they may get your creative juices flowing so you can add your own.

Click on any of the links to find out more about these and other great ideas.

PM Schedule Mass Update – Add the new Employee ID and Crew fields

Allow Mobile Tech’s Quick Work Order to be configured to flow directly to Schedules, rather than Requirements

Allow users to enter Procurement / Inventory using the My Tasks tile within Mobile Tech

Limit the # of search results on Mobile Tech. System prone to freezing

Valid Dispensing UOM on Inventory on WO

Rolling date setup for Open By task Date tile

ANSI standard acknowledgement codes are missing in PeopleSoft for 855s

“View Only” Maintenance Security Role

Service Request Notes to be transferred to Work Order

Add “Unassigned” check box option on other Workbench views

On Hand Parts & Costing for Work Orders

PM Schedule – Auto Update Last Reviewed Activity

Resource Lines on Time Entry

Include Description on Parent WO Lookup

If you have questions, or would like information about the PeopleSoft Maintenance Management module, or any other PeopleSoft product, please contact Robin Cole at or Larry Zagata at To read more about MIPRO Consulting, click here.

Increase Your Daily Productivity with MS Excel ‘Insert Data from Picture’

Posted by

Looking to increase your productivity? If you have an Android phone, you can now test out Microsoft’s new feature titled, ‘Insert Data from Picture’ in their Excel app for Android.

The new feature was first announced back in September 2018 at the Microsoft Ignite annual conference. The ‘Insert Data from Picture’ lets you take a photo in the Excel app of table data with your phone. The information is automatically turned into an editable Excel spreadsheet. The ‘Insert Data from Picture’ utilizes image recognition to eliminate the daunting task of manually entering the data. It has started to show up this weekend on some Android Excel apps. Last week on its website, Microsoft said support for the Excel iOS app is coming soon.

In the Excel for Android app, simply tap the insert data from picture button (lower right). The camera app will open and highlight what it considers to be table data in a live red border. Click the shutter button when you’ve got it steady and filling most of the frame. Next you crop out the irrelevant data using the resize handles before Excel processes and inserts the data into a ready-made table. At this stage you can tap Edit to correct any data OCR errors you have spotted. Finally, press insert and you can format and use the table and its data. Microsoft highlights that this mobile app feature output can be saved to OneDrive for access from all your devices.

Do you have a favorite app to help you increase your productivity? If so, share it with us. We would love to hear from you!

Customizations May Not Be Taboo Anymore

Posted by

Recently, I met with a customer who was considering implementing a new PeopleSoft module. The attendees included a functional executive, several of her managers, and two IT managers. At the beginning of the meeting, the executive announced that no matter what was decided, she did not want any customizations to the software.

Generally, history and experience have taught us that avoiding customizations are a good policy. Upgrading or updating customized software can be challenging. However, the new features of PeopleTools 8.56 and 8.57 mean that customizations aren’t always an automatic NO. Two new features that give you the flexibility to change the appearance and function of a page are Page and Field Configurator and Drop Zones. They allow you to create custom fields within a page and still easily move to future PUM updates. Below is a brief description of each in layman’s terms.

Page and Field Configurator

The Page and Field Configurator allows you to change the look and function of a page without the need for customizations. It gives you the ability to hide fields or even an entire page that are not necessary to your specific needs. It also allows you to change the look and behavior of any field by changing the field label, making it required, or adding a default value in the field. These changes happen through configuration settings. Therefore, they stay configured during PUM updates making the update process easier.

Drop Zones

Drop Zones give you the ability to add your own fields to delivered Fluid pages without having to customize the component. In simplified terms, a placeholder is inserted into the Fluid page at the time of design. The placeholder is a protected area which allows you to create your own fields which are not impacted with PUM updates. PeopleSoft has already created Drop Zones on many Fluid pages to help with the initial design and implementation.

In conclusion, these are empowering tools which can expand the capabilities of your existing software. Some customers have used these features to reduce the amount of customized software. Additionally, some have used it to add needed functions without customization. This is a very high-level overview of these capabilities. Good, new options now exist for organizations that want to try to eliminate customized software or for those that were opposed to customizations. I encourage you to look at the details of these features.

Please follow this link for an instructional blog on how to use Page and Field Configurator:

Please follow this link for an instructional video on how to use page and field configurator:

To read more about MIPRO Consulting, click here.

My Favorite PeopleSoft Lease Administration Transactions, Part I

Posted by

Welcome! I would like to introduce my next blog series, “My Favorite PeopleSoft Lease Administration Transactions.” With the new accounting rules taking effect this year, I’ve had plenty of opportunity to work with PeopleSoft Lease Administration using PUM 27 to 30 (especially PUM’s 28 to 30 over the past six months). As a consultant and an accountant, I’ve been very impressed with the ability of PeopleSoft’s Lease Administration to effectively handle both complex and routine lease transactions.

Each installment in this blog series will feature a different one of my favorite transactions. My results will be verified through an example transaction accompanied by a detailed accounting walk-though.

Without any further introductions, let’s jump right in!

My first favorite transaction is amending a multi-asset lease to remove an asset. In this example, the number of leased assets is reduced from three assets to two assets. I performed this amendment in two different ways. In scenario #1, I removed the asset as of the current date. In scenario #2, I back-dated the amendment by one month to the prior month. Often in the real world, lease amendments do not get recorded in the system until after the fact. Scenario #2 was designed to simulate this real-world circumstance.

As expected, both scenarios of the amendment produced verifiable results.

For this example, the lease data included:

  • Lease Term – 07/01/2018 – 06/30/2021
  • Payment – $2,800.00 per month before the amendment
    • 3 Assets @933.33per month
    • 100,800 total (36 x 2,800) = 100,800
  • Borrowing rate – 5%
  • ROU Capitalized Cost per asset $31,141.32

As stated earlier, the amendment consists of removing one of the assets from the lease. The amendment(s) were performed on 12/01/2018 in the system using the following two scenarios:

  • Scenario 1 – In December, the lease was amended effective 12/01/2018.
  • Scenario 2 – In December, the lease was amended effective 11/01/2018 (back-dated).

New payment amount after removing an asset $1,866.67 ($2,800 x 2/3).

If we look at the lease when it was created, we can see that the ROU asset balances per asset are $31,141.32.

Below is an image taken directly from PeopleSoft’s Lease Administration. The Lease Administration payment schedule from the base rent page shows the monthly rent and the amortization. Take note that this schedule is for the entire lease and not just for one asset. 

The Excel table I created (shown in the screenshot below) breaks down the amortization by asset in the two right hand columns. I used this offline Excel calculation to verify the results of the lease amendment calculations in both scenarios.

Looking at the Cumulative Obligation reduction column, we see that the balance (as of 11/30/2018) is $4,051.51. This represents the amount of Obligation/ROU reduction on the asset before it would be removed from the lease (using first scenario 12/01/2018 amendment date). We also see a balance of $3,234.45 on 10/31/2018. This corresponds to the amount of Obligation/ROU reduction on the asset (if the amendment was back dated to 11/01/2018 as in scenario #2).

Shown below are screenshots from my PeopleSoft Lease.

  • In scenario #1, using the 12/01/2018 as the effective date, you can see PeopleSoft Lease Administration correctly calculated the amended ROU/Capitalized down to the penny at $4,051.51. This exactly matches the verification amount from my Excel spreadsheet above.
  • Also, in scenario #2, the PeopleSoft amended calculation of $3,234.45 exactly matches my verification amount.

Updated PeopleSoft ROU/Capitalized cost amounts from scenario #1 (12/01/2018):

Updated PeopleSoft ROU/Capitalized cost amounts from scenario #2 (backdated to 11/01/2018):

Seeing how the ROU numbers tied out for both scenarios is why this is one of my favorite transactions in PeopleSoft Lease Administration. Although the transaction was slightly complex, Lease Administration handled it as expected.

Now, let’s look at the payments!

In scenario #1 (with effective date 12/01/2018), you can see the system begins the new lower payment with December.

In scenario #2 (with the back dated amendment of 11/01/2018), the system identifies the November payment was previously made at the higher amount. It corrects November to the lower amount through a credit memo.

In scenario #1 (with 12/01/2018), the new lower payment amount starts with December.

On the other hand, in scenario #2 (with 11/01/2018), the new lower payment amount is back-dated in November with the original higher November payment being reversed out with a credit.

In conclusion, PeopleSoft has done a great job with the details, especially from an end-to-end accounting perspective.  Using my off-line calculations I was able to verify my lease amendment results against the journal entries and the payment information.  It was great to have the audit trail and see all the details!

As always, thank you for reading and be sure to read my next installment in this series & our other Lease Administration Blogs.

Steven Brenner, CPA
Senior Principal Consultant
MIPRO Consulting

Supplier Scorecard

Posted by

The enhanced Supplier Scorecard feature was delivered in FSCM PUM Image 29. It is now possible to define and incorporate Key Performance Indicator (KPI) questions and Weighted Scores into templates and evaluations for a supplier. This enhancement allows you to view and analyze objective and subjective questions with a completed Supplier Evaluation Scorecard.

You can get to the Supplier Scorecard from the Procurement Operations Home Page.

Here you can create evaluation templates, questions, and create/manage supplier evaluations.

Now, suppliers can rate on both subjective and objective content. There is a significant amount of information to setup and maintain supplier evaluations; however, a detailed explanation can be found in this link to PeopleBooks.

Additionally, if you would like more information, please contact me at To read more about MIPRO Consulting, click here.

2019 Sources of PeopleSoft Info and Networking

Posted by

It might surprise you that organizations are still selecting PeopleSoft as a brand-new solution for their financials, supply chain, and human resources system. These “net new customers” choose PeopleSoft over other options to replace their current ERP systems. Personally, I am aware of two in the last thirty days.

The PeopleSoft community continues to be vibrant and interactive. While the Quest Oracle Community leads the charge, there are several conferences in 2019 which provide insight, support, networking opportunities, and a view into the future of PeopleSoft.  Below is my personal take on some of the best 2019 conference opportunities (in calendar order).

Alliance: Orlando, FL – March 3-6, 2019

This is the premier user-driven conference for higher education & public sector customers who use Oracle applications. This conference is run by the Higher Education User Group (HEUG) and the Public Sector Users Group (PSUG) and has over 3,500 attendees, 100 vendors, and 350 educational tracks. During this conference, you can hear about PeopleSoft from the higher ed and/or public sector perspective.

COLLABORATE 19: San Antonio, TX – April 7-11, 2019

This is the largest user-led Oracle technology and applications forum boasting over 3,200 attendees and more than 1,000 sessions. In addition to PeopleSoft sessions, you can attend those covering Oracle Cloud, eBusiness, JD Edwards, and Oracle technology. You can think of this as an “Oracle Open World Lite” as it contains a little of everything without highlighting a single technology.

PeopleSoft Executive Forum @ COLLABORATE 19: San Antonio, TX – April 8-9, 2019

During a Monday evening reception, organizational executives (using PeopleSoft) connect with each other and with Oracle PeopleSoft product management team leadership. This is followed the next day with a forum of insightful topics presented by customers and Oracle PeopleSoft leadership. The forum is beneficial for executives attending COLLABORATE. For those who just want a quick PeopleSoft update and view into the future, this conference is also worthwhile.

OHUG 2019 Global Conference: Fort Worth, TX – June 10-12, 2019

The Oracle HCM Users Group (OHUG) is an organization devoted to providing users with HCM-related insights into Oracle E-Business Suite, PeopleSoft, and Oracle HCM Cloud (including Taleo Business, Taleo Enterprise, and Taleo Learn) applications. This conference includes hundreds of attendees and more than 150 HCM-related sessions across Oracle’s suite of HCM solutions. It is more of an HCM than PeopleSoft-centric conference.

Interact 2019 (HIUG): Orlando, FL – June 16-19, 2019

The Healthcare Industry Users Group, with Oracle’s support, hosts a conference with 600+ attendees. It has more than 175 sessions focused on Oracle’s applications, specifically for healthcare organizations. Historically, this has been a PeopleSoft heavy conference with many healthcare customers using PeopleSoft. Recently, however, Oracle’s influence has added significant Oracle Cloud content. The size and healthcare focus make this a great networking opportunity for PeopleSoft healthcare customers.

PeopleSoft Reconnect: Chicago, IL – July 16-18, 2019

Reconnect is a PeopleSoft specific conference with 400+ attendees and more than 200 deep-dive sessions. Quest Oracle Community created this conference as a reincarnation of PeopleSoft’s annual Connect Users Conference. Dedicated to PeopleSoft and providing exceptional opportunities to network, Reconnect has 400 participants versus the thousands that appear at other conferences. This is one of our favorite conferences for PeopleSoft customers.

Oracle OpenWorld*: San Francisco, CA – September 15-19, 2019

*The current 2019 website is not yet available at the time of this blog.

This massive Oracle event occurs in the Fall and highlights all of Oracle’s hundreds of solutions.  During this conference, approximately 60,000 people invade San Francisco for a week. Since Oracle has focused more on highlighting its Cloud solutions, their on-premise solutions like PeopleSoft, JD Edwards, and eBusiness have taken a back seat. This event also includes PeopleSoft sessions, but not as many as in other conferences. However, if you are an Oracle shop with several of their products, this is a good conference. With a bit of effort or some help from us, you can coordinate your schedule to focus on PeopleSoft related content.

In general, our customers say that Collaborate, Reconnect, and either Interact or Alliance (depending on the industry) have provided them the most benefit and value for their time and dollars spent on attending conferences.

We are looking forward to another great year for the PeopleSoft user community!

Simple Journal

Posted by

A new Journal Entry feature in Fluid was delivered in FSCM PUM Image 29 called Simple Journal. Through configuration, this feature allows customers to restrict and control the fields displayed on the Fluid Journal page. These setting are based on the need or function of the user. It simplifies the data entry from an end-user standpoint. There is no change to the existing delivered journal processing.

The new Fluid Tile called Simple Journal:

You can view or add a new journal:

All the required information for a journal is on the left. Data entry is on the right. This includes items such as header data, currency data, dates, and adjustments, etc.

Finally, you can process the journal with the options seen in the photo below.

Additionally, if you would like more information on simplified analytics, please email me at To read more about MIPRO Consulting, click here.

Planning to implement your ASC842/IFRS 16 lease accounting solution in 2019? PeopleSoft can help!

Posted by

Since 2019 is now upon us, some organizations have already implemented PeopleSoft Lease Administration. Some are in the final stages for go-live preparation. Some organizations have not yet started to implement a solution and are targeting 2019 to do so. The good news is that PeopleSoft has you covered regardless of your project go-live target date. The delivered cutover process lets you target your go-live date. It also provides you with the accounting entries and audit trail you need for a smooth transition.

As I have mentioned in my earlier blogs, the biggest effort for implementing the new accounting rules is identifying your lease data. For many organizations, managing leases is decentralized and is mainly focused on managing the monthly payments. Going forward that all needs to change. Leases all need to be fully documented at a central point. The underlying ROU Assets and Liabilities put on the balance sheet. This is where the challenge lies. Having the time to build your catalog of leases.

When do you plan to go live?

If your target is sometime in 2019, as I stated above, PeopleSoft can help. The integration to Asset Management and the General Ledger is all there. For obvious reasons, going live in January 2019 is easiest and the cutover and transition for the accounting entries requires the least amount of effort. Moving to the new rules requires putting assets and liabilities on the balance sheet. Regardless of when you plan to go-live to go-live, some journal entries will be required to properly reconcile the beginning balances with the new system. But please note that managing the cutover process does become a bit more complex if you target later go-live dates as each passing month just adds an additional layer that needs to be reconciled.


Lastly, the one thing that I consider the easiest part of a PeopleSoft Lease Administration project is implementing the module. If your organization will be moving onto Lease Administration, my experience says build your new environment now. Have Lease Administration ready and waiting. Get the easiest part of the project out of the way the soonest. When your lease data is ready, your new environment will ready to go and you can avoid any further delays. I have also seen that including your accountants and users as part of the lease administration build out actually makes gathering your lease data easier. The users will have a clearer picture of the data requirements which in turn will lead to better lease data.

In closing, if you are planning to go live with PeopleSoft Lease Administration in 2019, PeopleSoft makes the process very manageable. It may not make the effort of gathering your lease data go away, but PeopleSoft will provide the accounting entries and audit trail so that you reconcile the process every step of the way.

Thank you for reading and be sure to read our other Lease Administration Blogs.

Steven Brenner, CPA
Senior Principal Consultant
MIPRO Consulting

It’s still not too late to implement PeopleSoft Lease Administration for January 1, 2019 and be ready for the new ASC 842 & IFRS 16 accounting rules!

Posted by

I would like to remind everyone that the deadline for compliance with the new ASC 842 & IFRS 16 rules is fast approaching. My headline is a bold statement, but it can hold true if you can answer yes to the following questions:

  1. Have you already identified all your leases, including the payment schedules?
  2. Do you already have your new lease accounting policies in place?
    • How will your leases be valued: Gross, Net, Triple Net and Practical Expedient?
    • Have you quantified the straight-line accounting impacts?
  3. Do you know which accounts on your balance sheet and P&L you will be using?
    • For some organizations, moving to the new standards may require setting up new accounts.

If you have answered yes to the above questions or if you are substantially on your way to completing those tasks, then you are a good candidate to begin implementing PeopleSoft Lease Administration and be live on 1/1/2019. From a business user’s perspective, those 3 questions can be 75% – 80% of the upfront effort required. Once you have that lease information in place, your project implementation team will have what they need to setup Lease Administration and have the system ready for testing with plenty of time for a 1-1-2019 go-live.


Certainly, the timing for a 1-1-2019 go-live will be tight. Keep implementation simple and strictly focused on meeting the new accounting standards. Lease Administration has many other features for enhanced notifications, etc. By keeping your focus on the accounting entries, you will be just fine. As delivered Lease Administration provides effective internal controls. Any other features, bells, & whistles you wish to bring up should be slotted for a phase II (post go-live). This will greatly minimize any potential critical path issues.

Although my three questions above are clearly high level, they do serve as an excellent guideline. If you have already tackled these questions, then a big piece of your preparation effort has already been completed. However, if your organization has not substantially answered these questions, then beginning a new implementation for a 1-1-2019 go-live would clearly have its challenges.

In conclusion, it is still possible to begin a PeopleSoft Lease Administration project and be live on 1-1-2019. For organizations that are not ready at all, I will cover this in my next Blog “You can still go-live with PeopleSoft Lease Administration after 1-1-2019 and meet the new accounting standards”.

Thank you for reading and be sure to read our other Lease Administration Blogs.

Steven Brenner, CPA
Senior Principal Consultant
MIPRO Consulting

How to Get Rid of Stress While on a Business Trip

Posted by

Feel stressed out while traveling? You aren’t alone. Learning to get rid of stress is essential when traveling. According to a study by CWT Travel Solutions Group (CWT), the top three triggers for stress when traveling can be grouped into three main areas:

1. Lost Time. It’s difficult, or downright impossible, to get work done while traveling, especially when you have a long flight. Many day-to-day business needs pile up while you are on the road, so when you return, you will need to “catch up” on work that you missed.

2. Unforeseen Events. Just thinking about the possibility of lost or delayed luggage, a delayed flight, or a missed connection can cause extreme anxiety for most business travelers.

3. A New Routine. It’s challenging to find time to exercise or stick to a healthy diet when you are on the road, which means many business travelers sacrifice their health while traveling.

Lost baggage, poor or no internet connection, flying coach on long-haul flights and delays are the four biggest drivers of stress within those three groups. CWT surveyed 6,000 business travelers and found that people traveling for work can lose up to 6.9 hours on a trip due to stress, meaning that they used that time for neither work nor rest.

Luckily, learning to get rid of stress is easy!. Click here for Emenike Emmanuel’s top five ways to eliminate stress on a business trip.

Do you have any other unique strategies to reduce stress while traveling on business? Share with us in the comments below.