• Company
  • Overview
  • Executives
  • Alliances
  • News & Events
  •  
• Products
  • Overview
  • Invoicing
  • OP3
  • Reporting
  • User Interface
  • Product Support
  •  
• Services
  • Overview
  • Oracle
  • Primavera
  • PMO
  •  
• Industries
  • Overview
  • Engineer / Construct
  • Gov't Contracting
  • Professional Svcs
  • Others
  •  
• Customers
• Resources
  • Overview
  • Webinars
  • White Papers
  • Presentations
  • Q&A Forum
  • Our Blog
  • Links
  •  
• Product Demos
  • Invoicing
  • OP3
  • Presos & Whitepapers
  • Reporting
  • User Interface
  •  
• Promotions
• Contact Us
  • Overview
  • Careers
  • Product Support
  •  

Excel Interface to Oracle Applications

Project Partners User Interface (UI-Apps)™

Project Partners User Interface provides Project Managers with an easy Microsoft^® Excel interface to the Oracle Projects suite of applications. Project Partners User Interface can replace up to 20 Oracle forms with one role-based Microsoft Excel workbook. 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.

Pre-Packaged Workbooks

Project Partners’ pre-defined Oracle-integrated workbooks are oriented to users who need to create tasks and budgets, and those who perform forecasting. The workbooks are designed to address the needs of users in the Professional Services and Engineering & Construction industries. The project management functions within the workbooks can be easily adapted for project managers in any industry using simple configuration options in conjunction with a flexible customization framework, allowing your IT group to adapt the sheets to your specific business process.

Built-In Project Management Process

Project Partners User Interface Applications utilizes a project management process that is very intuitive to use.

Click here for full sized image

 

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 workplan and financial plan maintenance and resource reporting
• 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

For more detailed information on Project Partners User Interface: Email: User Interface Info