• Company
  • Overview
  • Executives
  • Alliances
  • News & Events
  •  
• Products
  • Overview
  • Our Products
  • Oracle Primavera
  • NetSuite SRP
  •  
• Services
  • Overview
  • Oracle E-Business
  • Oracle EBS R12
  • Oracle Fusion Apps
  • Oracle Primavera
  • NetSuite SRP
  • PMO
  •  
• Industries
  • Overview
  • Arch, E&C
  • Gov't Contracting
  • Professional Svcs
  • Publishing
  • Others
  •  
• Customers
• Resources
  • Overview
  • NetSuite SRP
  • Oracle E-Business
  • Primavera
  • Resource Library
  • Webinars
  • Links
  •  
• Our Blog
• Contact Us
  • Overview
  • Careers
  • Product Support
  •  

Microsoft® Excel Interface to Oracle Applications

Project Partners User Interface Applications™

Project Partners User Interface Applications enable Oracle E-Business Suite Applications users to utilize Microsoft® Excel as a concise and user-friendly interface to Oracle Projects. Project Partners User Interface Applications (UI-Apps) can improve user productivity by 65% so Project Managers can focus on improving project operations. Additionally, users can connect to Oracle using Excel, download data, and then work offline on the Excel workbook, reconnecting later to Oracle to synchronize the updates made offline with the Oracle database – easily and securely.

Use one worksheet instead of multiple forms

 

Pre-Packaged Workbooks

UI-Apps' pre-defined Oracle-integrated workbooks allow Project Managers to perform the following functions:

• Create New Projects
• Build and Manage Project WBS, Schedules and Budgets
• Manage Clients and Agreements
• Manage Contract, Capital and Indirect Projects
• Manage Transaction Controls
• Capture Project Schedule Progress
• Update Project Financial Forecasts
• Report on Projects

Built-In Project Management Process

UI-Apps workbooks utilize built in business process flows that mirror the best practices of most project-centric organizations and are very easy to use. These workbooks can easily be tailored to fit.

Click to enlarge Process Flow Images

 

Integration Leverages Oracle Applications Technology and Security

Project Partners User Interface is certified with the Oracle E-Business Suite Applications R11.5 and R12 technology stacks. It leverages the business logic in Oracle public APIs to perform validations, update the Oracle schema, invoke workflows, and more. Project Partners User Interface uses the standard Oracle Applications security model for authentication and security, and provides a login approach that is consistent with Oracle Applications in the enterprise.

Work With Oracle Data in Disconnected Mode

Users can connect to Oracle using Excel, download data, and then work offline on the Excel workbook. Later they can re-connect to Oracle and synchronize the updates made in Excel with the Oracle database.

Project Partners UI-Apps deliver four primary benefits:

• Project manager productivity is improved by minimizing screen navigation; up to 20 Oracle screens are replaced with one role-based Excel worksheet
• Project managers can work in traditional online mode or can work off-line and synch with Oracle when next connected via the internet
• Quick implementation in four weeks or less means less business disruption
• Minimal training is required, resulting in immediate user adoption

Unlike other Excel based products offered to Oracle Applications customers,
UI-Apps provide:

• A role-based solution oriented to project managers, not a tool oriented to IT users
• The ability to perform multiple Oracle Project Management functions in one workbook
• Preformatted worksheets and reports used by Project Managers for many project management functions, not just loading data into Oracle Applications.
• Automatic validation of key data from Oracle stored in hidden sheets and available for use whether working online or offline
• Worksheets with built-in business logic, e.g. data calculation and manipulation
• Extensive configurability for tailoring worksheets to different end-user communities

UI Apps On-Demand Videos

Project Manager Reporting via Microsoft® Excel

Learn how Project Partners Reporting gives Project Managers (PMs) comprehensive project reporting from Oracle E-Business Suite Projects applications in a handy Microsoft® Excel workbook. PMs can easily and quickly download data to review key project metrics, financial amounts, and drill-down from project to task to the lowest level of cost/revenue data and charts of key data. The project schedule with baseline and current dates and progress can be viewed in Gantt Chart format. Even better, PMs can review all project performance data either while connected to their enterprise network, or they can save the workbook and work disconnected. View the Webinar

Be a Hero: Maximize the ROI of Oracle EBS Projects and Ensure Rapid Adoption Across Your Enterprise

Your firm knows that using Oracle E-Business Suite Projects will help increase profitability and ensure that project objectives are met. But your project managers and administrators already have day jobs, they don’t have extra time to learn new software or hours every day to use project management programs. How can you help your firm meet its business goals and maximize the return on its investment? You can have your project managers and administrators trained on Oracle EBS Projects in 82% less time and spending 40% less time on a daily basis, using a familiar Microsoft® Excel front-end, ensuring rapid end-user adoption, and putting your company on the fast track to the many benefits provided by Oracle. See how our User Interface Applications free up your firm’s employees to make more strategic contributions and achieve business objectives. View the Webinar

For more detailed information on Project Partners User Interface: Contact Us