Oracle Project Suite

Oracle Business Flow: Project Expenditure to Revenue Recognition

on Friday, 17 October 2014. Posted in Oracle Project Suite, Blog, Oracle Financial Applications

Oracle Business Flow: Project Expenditure to Revenue Recognition



In this article I share the Oracle business flow: Project expenditure to revenue recognition business process with the associated enterprise roles. The Oracle Business Flows— Enable you to relate your business requirements to the E-Business Suite functionality. I recommend these flow models to assist you with the project scope and increase end-user  awareness of the project. It also establishes a common understanding of the integrations required to deliver the project.

Be aware not all consultants have this information, E-Business Suite accelerators are available from Oracle Consulting and other approved partner channels.



Trends in Project Management

on Tuesday, 01 January 2013. Posted in Oracle Project Suite, Blog

The role is shifting into a dual function of the project management role, where project manager is both a manager and an analyst. This has always been the case in most:
*projects that require specialized skills, as in for example SAP, Oracle - modeling, simulation and analytics - regardless of the size of the organization;
*small organizations/ teams;
*Consulting organizations.

Some additional trends I am seeing:
*Globalization of project and programs
*Enteprise-wide project management technology tools (such as SharePoint and Project Server)
*Integration with other frameworks (Six Sigma, ITIL, etc.) to increase business efficiency and effectiveness
*Integration of project management with business objectives/goals (providing value and ROI to the business)
*Lots of soft skills and leadership training (strategic and creative thinking, conflict resolution, influencing others, etc.)

Also training that improves the thinking that takes place on a project to help improve the decision making. This improves the overall success rate of projects giving an excellent return on training investment. That helps ensure that the project managers and their key team members employ whole-brain thinking skills. Using all four thinking quadrants eliminates blind-spots and ensures higher levels of buy-in and support for decisions. It also lowers debates and regurgitation time in decision making processes.

Another emerging trend in PM is the use of Agile methods. Larger companies are starting to see some of the benefits of using the Agile method. 






The 5 project phases

on Tuesday, 01 January 2013. Posted in Oracle Project Suite, Blog



On any of my projects I like to follow the following 5 project phases. 1) Project Preparation 2) Business Blueprint 3) Realization 4) Final preparation 5) Go Live and Support, it has helped me mitigate and manage risks and dependencies.


1) The project is initiated and the project team consisting of the client  and consulting personnel is put in place. The project charter and scope are confirmed and documented. The project work plan is developed.


2) Business requirements are gathered and captured in a process “blueprint” for the organization. End-user training plan is developed and the detailed implementation approach is determined. An evaluation of the Client IT landscape and the projected interfaces are defined.


3) The business and process requirements are configured within the Oracle system. Technical specifications are developed and programmed. Roles are mapped, skill gaps assessed, and training materials developed.  Integration testing is executed to confirm configured functionality conforms to business requirements.


4) Testing, end user training, data conversion, production system installation and site preparation are completed. All critical open issues are resolved and the organization is prepared for the “live” environment.


5) The organization transitions from a project-oriented pre-production environment to a live production operation. A change transition assessment is conducted and post-implementation support is provided.


Oracle Project integration with MS-Projects

on Tuesday, 01 January 2013. Posted in Oracle Project Suite, Blog


Oracle Projects uses MS Projects to create and maintain WBS. You may send and receive a project, send an update, view real-time project information and receive real-time values for task attributes. Oracle Projects OOTB(Out-of-the-box) integration is as follows: 

Information From MSP To MSP
Schedule Yes
Budget Yes
Project Template Yes
Existing Projects Yes
Resources & Rates Yes
Progress & Actual effort Yes
Cost Progress Yes

Project Conversions - Key Points

on Tuesday, 01 January 2013. Posted in Enterprise Software , Oracle Project Suite

Projects Conversions: Key points to note in respect to other integrated modules: 

Complete Financial and HR configuration Prerequisites:

Step 1 (GL): Review your chart of account values.

Step 2 (AR): Create customers, customer sites and customer contacts. All the Progressive Billing project has to be associated with a customer, bill-to site, ship-to site and a billing contact.

Step 3 (HR): Define your project organizations. DRU 203 and DRU 204

Step 4 (HR): Create your employees and employee assignments for the Project Manager role for each of the converted Project.Complete Projects Configuration Prerequisites:

Step 5 (PA): Review and update project structures: project types, project templates, revenue categories, event types, lookup sets…This has to be Unique for the Conversion related Projects.-List here the details all that will be created new.

Step 6 (PA): Create your projects and tasks.

Step7 (PA): Assign projects to correct customers, sites and contacts. All three are needed to generate revenue and invoices.

Step 8 (PA): Create customer agreements and funding allocations.

Step 9(PA): Baseline Approved Revenue Budget

Step 10(PA): PA Periods and GL periods-Require details if this will be just 1 Period

Convert Legacy Revenue Balances:Step 11 (PA): Disable revenue transfer to General Ledger.Step 12 (PA): Create legacy revenue balances as Revenue Events (Revenue Amount is populated). Step 13 (PA): Generate revenue for legacy revenue events. Step 14 (PA): Run the Interface Revenue to General Ledger. Step 15 (PA): Turn back on the Transfer Revenue to General Ledger implementation option. Navigate to the Implementation Options screen and enable the Transfer Revenue to GL flag.

Convert Legacy Invoice Balances


Convert Legacy Invoice Balances

Distinguish between billed (that were already printed and sent to the clients) and Unbilled legacy invoices (those that were generated in the legacy system, but were not printed and sent out). –These will be billing events and invoices in Oracle Projects. In order to prevent the balances from becoming open AR balances in Receivables, we will need to delete them in Oracle Receivables.

Step 16 (PA): Create legacy invoice balances as Billing Events (Bill Amount is populated).

Step 17 (PA): Generate draft invoices for legacy invoice balances.

Step 18 (PA): Approve and release draft invoices.

Step 19 (PA): Interface legacy project invoices to Oracle Receivables. Run the PRC: Submit Streamline Interface process with the XI: Interface Interfaces to Receivables option.

Step 20 (AR): Delete the legacy project invoices in Oracle Receivables. As Receivables Manager, navigate to the Transactions form. Find, incomplete and delete the legacy project invoices.

Unpaid Legacy AR InvoicesWhat we converted above was a summary of billed customer invoices for each project. Some of them have might already been paid, some have not in Receivables. You will need to convert any unpaid AR invoices as open AR transactions in Oracle Receivables.Unbilled Billable ItemsVerify and reconcile Projects converted Balances with GL, AR, OM –Where required.

Oracle R12 Time import into projects

on Tuesday, 01 January 2013. Posted in Oracle Project Suite, Blog

One common misunderstanding of OTL (Oracle Time and Labor Module) is the time import.

If you are using the standard OTL self service timecard - deposit to timestore - approve - retrieve data into application, then you don't need to run the Transfer to project Accounting job. You only use that job for timecards generated by the Automatic Timecard Generation process or for timecards transferred to the professional forms Timecard window for OTLR.

All you need to do is make sure the PRC: Transaction Import job from the Projects Superuser. Use the parameter 'Oracle Time and Labor' as the source, and don't put anything in the batch parameter. As below:



ZOO Comment

Copyright 2018 All rights reserved.