Skip to main content

News

Cloud PPM Expenditure Type Setup via Spreadsheet

When uploading expenditure types using the Rapid Install spreadsheet I came across a few things that weren’t clearly documented.
1. If an expenditure type requires multiple Expenditure Type Classes be aware that you can upload only ONE unique expenditure type at a time. For example, the Expenditure Type “Hourly Labor” requires Straight time and Overtime type classes. Upload Hourly Labor with either Straight time or Overtime type class. Once this is in the system successfully, upload it a second time with remaining of the 2 type classes.
a. Notable Details:
 Type Class selections are included in the spreadsheet
 Choices are Non-labor, Straight Time Labor and Overtime Labor
 Non-labor will “assume” all non-labor type classes and assign these to the uploaded expenditure type
 Straight Time Labor will, expectedly, “assume” Straight Time type class
 Overtime Labor will, expectedly, “assume” Overtime type class

  1. Unlike the Type Class column, you can load a UOM for any UOM defined in the system, but, syntax must be exactly as in system. The spreadsheet downloads with Units and Currency in the LOV.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Wallace Bartlett, Sr. Solutions Architect

Wallace has been working with Oracle applications for nearly 20 years implementing domestic and international projects in roles from consultant to Director/Solution Architect. He has participated in implementation/upgrade, project oversight, pre-sales, and large complex process improvement efforts. Experience includes project and managerial accounting operations, financial planning & budgeting, payables and billing. His Oracle experience includes Project Accounting suite, Financials and process improvement within numerous industries. The list includes Professional Services, Manufacturing, Mining, Financial Services and Business Services, Communications and Media, and Automotive.

More from this Author

Categories
Follow Us