Project Partners Blog


Archive for the ‘Oracle E-Business Suite’ Category

Project Partners Blog Author:
Sachin Gupta | Oracle Primavera Solution Architect – Application Integration Specialist

Oracle E-Business Suite and Oracle Unifier Integration Framework

Project Partners implemented this solution for a large metropolitan transportation, and on-premise Oracle EBS customer.

The project consisted of the customer implementing Oracle Unifier cloud a few months prior. They were looking for an effective solution to load actuals transactions from on-premise Oracle EBS to Oracle Unifier cloud. They had created a business process in Oracle Unifier for actuals transaction and enabled for integration.

The customer did have one simple requirement. They needed a scalable solution to load eligible actuals transaction from on-premise Oracle EBS to Oracle Unifier cloud daily using a REST API.

As the project moved forward, we conducted our due diligence and dug deeper so we could identify a few more items that needed to be appropriately addressed:

  • Ability to introduce new attributes in the integration equilibrium which may require updating all transactions in Unifier with the data from EBS.
  • Avoid duplicate transactions.
  • Capable to identifying and create/update transactions and in rare scenario delete transactions from Unifier to keep it always in sync with Oracle EBS.

After reviewing various options with customer, they agreed on the framework shown below:

  1. Utilize Oracle EBS concurrent request to populate data daily in a staging table.
  2. Pull data from Oracle Unifier cloud in staging table.
  3. Compare the data in two staging tables to identify new and modified data.
  4. Call Oracle Unifier Rest API to process the data.

Noted advantages of this framework:

  • Scalable – It can easily process a volume of 100,000 transactions daily.
  • Automated – It can identify new vs modified data and discard data that do not require change.
  • Extensible – New attributes introduced for integration, can be easily populated for all existing transactions in Oracle Unifier Cloud.

Project Partners, a long-standing Oracle Partner, and global leader in optimizing business processes and IT investments within project-driven organizations.

www.projectp.com

Author: Wendy Lamar | Managing Principal Consultant | Project Partners
Oracle E-Business Suite R12 Project Certified Implementation Specialist

Asset Capitalization Dashboard

The Asset Capitalization Dashboard has been included in release 12.2.8.  The dashboard provides the user with a complete view of a capital project’s costs, and capabilities to manage certain functions of capital project maintenance that were previously only accessible via Oracle forms.

The Asset Capitalization Dashboard is accessed from the Project Home, navigating to the Financial tab, Asset Capitalization subtab.

 

The dashboard provides a summary of the project costs, including capitalizable and non-capitalizable costs; as well as the Assets assigned to the project or a task of the project.  The summary also indicates those costs not yet summarized, not yet capitalized, and not yet processed through asset generation and/or interface to Oracle Assets.  There is an indicator of any rejected lines.  Certain summarized information also provides drill down capabilities to view the expenditures included.

 

The next screenshot is the resulting page from drilling into Capitalizable Costs expenditures; access by clicking the Cost Summary – Capitalizable Costs amount (red arrow above):

 

 

 

 

 

 

 

 

 

 

 

 

Returning to the main dashboard – In the lower region, you will view the Assets Inquiry to view the project assets.  Parameters are provided to search the assets and limit results.

 

Manageable functions include managing holds, reversing assets, and assigning an asset to the project or task level.  Details of costs and their progression through costing processes are reported by asset (with drill down capabilities).  At the end of the row the user can open the asset lines, as shown in the next screenshot.

View Asset Lines Results:

 

Note that some actions that can be performed from this page, including splits and interfacing the asset to Oracle Assets.  There are also search capabilities to limit the data returned.

Returning to the main dashboard – at the top and bottom right, buttons are included to navigate to the Task Summary.

 

The Task Summary allows the user to view the cost information summarized by task, including common cost tasks and any non-capitalizable costs.  If an asset has been generated including costs from the task chosen, the task number, name and description will display in the lower region.

 

In summary, the capital asset dashboard provides quick access to most capital project maintenance steps accessed directly from the project home, providing more visibility to the project team for total project costs and necessary actions, saving time spent on day to day activities and reconciliation efforts.

P: #1.650.712.6203 | www.projectp.com

 

 

Project Partners Blog Author:
Sachin Gupta | Oracle Primavera Solution Architect – Application Integration Specialist

Activity Excel Utility Using P6 EPPM Web Services

P6 EPPM Web Services is a great way of integrating external systems with P6 EPPM application. Activity excel utility allows reading and writing data to Oracle Primavera P6 EPPM using P6 EPPM Web Services.

Activity excel utility allow user to:

  • Maintain activity details
  • Maintain activity relationship
  • Assign global and project activity code to activity
  • Assign resource or role to activity
  • Maintain activity steps
  • Maintain activity UDF
  • Maintain resource assignment UDF
  • Maintain activity step UDF

 

 

 

 

 

 

 

 

Update Project List – download list of projects from the connected P6 EPPM application

Read All Data – allows downloading all activity data at the click of button

Clear All Data – removes data from all worksheets

Read – Read or download data from P6 EPPM using Web Services

Modify – Create, Update or Delete the data for the corresponding business object

Screenshots of some of the worksheet are shown here for reference

Activity Details allows creating new activity and maintaining existing activity data. CRUD flag is used to identify the operation to be performed

“C” – Create, “U” – Update, “D” – Delete, “R” – Read.

Activity data is downloaded with CRUD flag as “R”

 

Activity attributes like Duration Type, % Complete Type, etc. use same set of values as in the application.

Activity Relationship can be created and updated within excel utility. Relationship Type has a predefined set of values as used in application – Task Dependent, Resource Dependent, Level of Effort, Start Milestone, Finish Milestone, WBS Summary.

 

 

 

Activity Code Assignment allow user to assign activity code to activities. Both global and project specific activity codes can be assigned to activities.

 

 

 

Resource Assignment allow user to assign resource/role to activities. This can be used to maintain resource assignment for activities of the project.

 

 

 

User interface for all other worksheets are similar to the one shown above.

Download evaluation copy here.

—————————-

Project Partners, a long-standing Oracle Partner, and global leader in optimizing business processes and IT investments within project-driven organizations.

www.projectp.com

 

Project Partners Blog Author:
Sachin Gupta |Oracle Primavera Solution Architect  Application Integration Specialist

Primavera Data Service (PDS) is a new free offering for P6 and Unifier cloud customer to enable and use. It exposes a set of endpoints that enables extraction of data from application database. It uses data service endpoints to discover which database tables and columns are accessible and then run queries against them. It provides read only access to data. It is available to both new and existing cloud customers.

Primavera Data Service can be used to read data from cloud environment. Data can be extracted in CSV file format or it can be stored in local database. Once the data is extracted, either in CSV file or stored in local database, reports and dashboard can be built on such data. The complete process to read the data using PDS and writing it to local database or CSV file can be automated. It can be run at pre-determined time or ad-hoc basis based on the requirement.

Primavera Data Service uses JavaScript Object Notation. JSON, is an open-standard file format or data interchange format that uses human-readable text to transmit data objects consisting of attribute–value pairs and array data types (or any other serializable value) – Through JSON Applications, PDS makes use of RESTful end points to access the cloud database.

Primavera Data Service provide read only access to the following for P6 EPPM:

  • SELECT privileges on all P6 tables (including PX tables) except ADMIN_CONFIG, BRE_REGISTRY, PREFER, PUBUSER, SETTINGS, and tables that start with DLT, DR$ and MDRT_.
  • For granted tables, synonyms use the same name as the table.
  • Views for PXRPTUSER (ds_p6reportuser config is used to access these views).

Note that this data need to be extracted periodically to keep it current, although it will still not be real time but good for data analysis and generating month end reports using tools like Tableau, Microsoft Power BI, etc.

For real time data, P6 web services can be used. P6 web services can read and write data and can be used for integration where as PDS can only be used to read data.

Limitation:

  1. The data service cannot be used to read BLOB or CLOB fields.
  2. Complex SQL queries cannot be written to extract data.
  3. API does not support queries using LIKE and IN conditions.

*Important NOTE: PDS is currently available for customers running P6/Unifier 19.4 or later in GBUCS environments.  PDS is available for OCI running P6/Unifier 19.12.1/20.1 or later.

List of tables available for P6 EPPM with configuration ds_p6adminuser:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

List of views available for P6 EPPM with configuration ds_p6adminuser:

 

List of views available for P6 EPPM with configuration ds_p6reportuser:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

If you are looking for a solution to extract data from cloud database (P6, Unifier or Oracle Primavera Cloud) and build reporting solution, or looking for a demo to extract the data from your cloud environment one time to see how the data looks like, contact us at sgupta@projectp.com, or http://www.projectp.com/demos/contact_us.cgi

*Reference: How P6 and Unifier Cloud Customers Can Utilize Primavera Data Service (PDS) to Access their Cloud Database (Doc ID 2552583.1)

For more information on Project Partners go to www.projectp.com

 

 

 

FOR ANNOUNCEMENT | IMMEDIATE RELEASE


Project Partners, LLC. receives MBE certification from WRMSDC

A privately held minority consulting services and software solutions firm achieves National
Minority Business Enterprise (MBE) certification

_______________________________________

Half moon Bay, CA–July, 2020 – Project Partners, the world’s foremost Experts in Enterprise Project Portfolio Management™ for project-centric organizations is proud to announce that is has received the Minority Business Enterprise (MBE) of the Western Regional Minority Supplier Development Council (WRMSDC) National certification. After completing the extensive application, meeting, and passing the review and rigorous requirements of the MBE certification process, this certification award proves that Project Partners, LLC meets the requirements to do business with large corporations, local, state, and federal government departments as a minority business entity. This milestone is an exciting opportunity for Project Partners with its mission to expand and continue to deliver a consistent level of high-quality services that positively impact the organizations it serves.

“Receiving this coveted certification is definitely an honor.  I know that the WRMSDC fully supports the growth and welfare of minority communities by championing the use of minority-owned businesses, therefore has a stringent national certification process.  We are proud to have successfully gone through the process and been awarded our MBE certification,” says Randy Egger, CEO and President of Project Partners.  “We also look forward to participating and leveraging WRMSDC’s community of MBE’s and tools that will provide us access to new prospects in our pursuit for growth and development of our products and services exclusively to project-centric organizations leveraging Oracle Technology. It’s a tremendous opportunity.”

To learn more about Project Partners, LLC, including its new status, visit www.projectp.com

###

About Project Partners, LLC:  Project Partners, LLC is a privately held firm headquartered in Half Moon Bay, California, offering consulting services and software solutions.  Project Partners is a long-standing Oracle partner and a single point solution provider for all requirements across Oracle ERP | PPM Cloud, Oracle E-Business Suite, Oracle Primavera applications for project-driven organizations. As a 100% minority-owned business with MRMSDC certification as an MBE, Project Partners is committed to stellar service and developing innovative and sustainable solutions for their clients.

www.projectp.com


Questions About ERP | PPM Cloud?
  Time Slots Filling Up Fast, But Still Available!

Check it out and join us during the month of May & June as we offer our DEDICATED office chats. Project Partners ERP | PPM Cloud subject matter experts will be available for a deep dive informative discussion addressing your questions around your key top of mind issues/pain points. We’ll share our insights, guidance and solutions within your personalized FREE Q&A phone consultation.

Don’t miss this opportunity to ask your questions, no matter where you are in your Oracle ERP | PPM Cloud journey. We look forward to having great discussions and providing you with expert insight, analysis and the answers you’re searching for.

LEVERAGE OUR EXPERTISE TO THE FULLEST.

We’re here to help and solution with you.  Simply Register Below & Secure Your Spot for a One-on-One Office Hour Chat!

SECURE YOUR OFFICE CHAT TIME HERE


www.projectp.com


INTRODUCING PROJECT PARTNERS PROJECT APPLICATION – PROCESS ASSESSMENT SERVICES

Whether helping you uncover hidden project challenges stemming from your current functional and operational applications/processes to understanding the why and how to migrate to the cloud, our Project Application/Process Assessment services give you the rigorous framework you need to grow and quickly achieve organizational success.

Our Team Will Partner With You to Assess Your Project Applications and Background Processes Inside and Out. 

Projects is the link that can penetrate your entire organization and requires careful analysis to maximize efficient operations.  If you are experiencing what appears to be a pain in your organization’s business process and applications, then now is the time to take another look and assess with the experts.

We are extending a SPECIAL ASSESSMENT offering that has proven results for our customers.  Just take the SIMPLE next steps to obtain Project Partners holistic approach to a full assessment and associated discount offer.

CLICK | SCHEDULE AN ASSESSMENT HERE TO GET STARTED

www.projectp.com

A FRESH APPROACH TO ORACLE CAPITAL PROJECTS AND FIXED ASSETS

In this webinar, we’ll discuss how to move beyond to drive efficiencies and reporting accuracies with a fresh approach to Oracle Capital Projects, fixed assets, and showcase how Project Partners successfully delivered this solution for a customer that is using a third party fixed assets system to manage their capital projects.

We Invite You To Join Us And Learn More About This Powerful Solution:  

• The Capital Projects functionality delivered in Oracle Project Costing has enabled many of our customers to take advantage of the native integration to Oracle Fixed Assets

• However, there are industries that require a greater level of detail, control for estimating and allocating asset costs

• To address this, our team developed a solution that supports the need for greater level of detail, control of asset costs and allocations – which we will review and showcase for you

REGISTRATION OPEN NOW

Register today, and feel free to review our resource library and services overview at www.projectp.com.  HAVE QUESTIONS?  Need more information about this Webinar or other services  – We’re here to help!

Schedule a Consultation:
Phone: #1.650.712.6203   Email: cfryc@projectp.com

—————————-

Project Partners, Oracle Platinum Partner, and global leader in optimizing business processes and IT investments within project-driven organizations.

 

Are you part of a non-traditional Professional Services Organization and feeling the staffing data-burden?

Then you are probably experiencing the common demand around deploying groups of staffing managers to manage these applications, yet with limited budgets and the same needs to manage resource supply and demand in order for your organization to stay effective and profitable.

We Invite You To Join Us In This Insightful Session Where You Will Learn:

  • A simpler alternative for Resource Planning
  • How to utilize Project Financial Forecasting to address Resource Planning
  • Ultimately “Two For One – Getting It Done!” – Forecasting

REGISTER TODAY – RESERVE YOUR PLACE

QUESTIONS? Need more information about this Webinar or our Services – We’re here to help!

Schedule a Consultation:
Phone: #1.650.712.6203   Email: cfryc@projectp.com

We look forward to sharing our expertise and knowledge with you for a simpler alternative for Resource Planning.  Register today, or feel free to review our resource library and services overview at www.projectp.com.

—————————-

Project Partners, Oracle Platinum Partner, and global leader in optimizing business processes and IT investments within project-driven organizations.

 

 

Part 2 of 2
LEVERAGING ORACLE PROJECTS TO MANAGE PERFORMANCE BASED REVENUE

As stated previously, the core principle in the new Standard requires that an entity recognize revenue to depict the transfer of goods or services to a customer in an amount that reflects the consideration given in exchange for those goods or services.

Impact to Balance Sheet and Income Statement

When a contract is signed, an asset and a liability are created for the total amount of goods and services promised to the customer.

Upon fulfillment of an identifiable performance obligation (commonly referred to as a “deliverable”), the liability is reduced, and revenue is recognized when that performance obligation is satisfied and accepted by the customer.

When payment is received for the goods and services provided, the asset is reduced.

This new methodology differs from the previous generally accepted practice of recognizing revenue when the customer is billed, and a receivable is created.  No longer will a company track unbilled revenue streams.  Oracle Projects provides the ability to configure your projects to meet the requirements of Step 5 of the new ASC 606 guideline with standard functionality.

Step 5 of the Standard requires a two-step approach.   Using Oracle Projects, work is performed, and delivery is recorded.  Then, a process to Generate Draft Revenue for the projects is run to complete the recognition process.

The following is an example of how your company can leverage Oracle Projects to meet ASC 606 compliance.

Service Contracts based on selling hours (T&E)

  • Work Based Revenue Recognition
    • Standard Oracle functionality of Time & Expense Billing
    • Set up project and billing information

  • Identify the Performance Obligations and set up as Budget Lines for the contracted number of hours

  • Delivery Team Charges Time & Expenses to the Project

  1. Revenue based on hours charged
  2. Acceptance of work performed implicit when customer signs timecard
  3. Invoicing takes place when the timecard is approved. This process can precede the actual recognition of revenue as the performance obligation is not yet complete.
  4. As each phase of the project is finished, revenue is recognized.

Run the Generate Draft Revenue Process for your projects to recognize revenue

Perform Work and Record Delivery

  • T&M Service Contracts based on specific Deliverables
  • Fixed Price Service Contracts based on Milestones
    • Mark Deliverable as Complete. Mark Billing Action as Complete

Run the Generate Draft Revenue Process for your projects to recognize revenue:

T&M/Fixed Price Service Contracts

  • A Fixed Price Service Contract requires the use of Billing Events generated from deliverables to generate revenue.
  • Invoicing can be generated per the terms of the contract; however, revenue cannot be recognized until the performance obligation has been met.

Unit Price Based Contracts

Oracle Planning and Control offers the ability to utilize a structure called Schedule of Values (“SOV”).  The SOV allocates value for various parts of the work from a contractual agreement.  The SOV schedule is also used as the basis for monitoring progress, tracking deliverables, and submitting and reviewing payment certificates for billing the client.  The user can either enter a contract in Oracle Project Contracts, or directly enter one.  Once a project is created, it can be updated from Oracle Project Contracts or directly entered in Oracle Planning and Control.

  • Enter Progress and record quantity completed for each SOV Task
  • In this case, a task has been set up for each performance obligation under the contract. As the task is completed and accepted, revenue can be taken

  • Billing Events are generated from Schedule Of Values progress and are used to generate revenue

Recent Enhancements to Support ASC 606

Oracle has been supporting organizations implementing these changes in their business to accommodate the new Standard.  To aid in the implementation and management of project revenue according to the new accounting standards, new consolidated patch sets to Oracle Projects have been released.

For companies using Oracle EBS Projects Suite Release 12.1.3 and above and Release 12.2.7 and above, Oracle has issued a patch set specific to each release to support management of project revenue according to ASC 606.

Below you will find screen shots of some of the new standard functionality available with these changes, recently published by Oracle.  As you can see, Oracle Projects addresses set up, tracking and revenue recognition via the use of a new Structure for Performance Obligations.

The new processes allow for the user to enable the use of Performance Obligation, create said obligations, publish and track progress against the performance obligation and generate revenue in accordance with the new standards.

As you can see Oracle Projects provides the ability to configure your projects to meet the requirements of the new ASC 606 guideline with standard functionality.

Oracle Licensing Requirements

  • Project Costing and Billing are required for all features discussed in this paper
  • Project Planning and Control (formerly known as Project Management) must be implemented to leverage Deliverable functionality
  • Schedule of Values functions are available in Oracle Project Planning and Control release 12.2.5
  • Application of Patch sets as described in this paper to take advantage of the ability to record and track Performance Obligations

CONTRACT MODIFICATIONS

Contract modifications, commonly referred to as change orders or amendments, occur when the price or scope of a contract is changed.  Depending on the circumstances, these changes are accounted for either as a modification to an existing contract, or as a separate contract.  Proper accounting treatment for modifications differs based upon this determination.

There are three steps to determine the proper treatment for a contract modification.

Determine Whether the Change Qualifies as a Contract Modification – A contract modification is any change to an enforceable rights and obligations of the parties to the original contract.  The Standards defines this as a change in scope and/or price of the original contract.  It does not need to be written, it can also be oral or implied through customary business practices.  Once an entity determines that a change is indeed a contract modification, it determines whether to account for it as a change to the original contract or as a separate contract.

Determine Whether the Modification is a Separate Contract – To determine that a modification is a separate contract, these two criteria must be met.

  1. The scope of the contract has increased with the addition of distinct goods or services, and
  2. The price of the contract increased by an amount comparable to the entities standalone selling price of the additional goods or services. (Selling price less ordinary selling costs)

Determine the Proper Accounting Treatment for Contract Modifications – If a contract modification is considered a separate contract, no changes to the existing revenue on the original contract are required.  The new contract is recognized as the performance obligations in the new, separate contract are met.  However, if the contract modification is not considered separate, then the modification is combined with the original contract.  There are two methods defined in the Standard for proper revenue recognition of a combined contract modification.

  • Prospective Treatment

If the remaining goods/services are distinct from those of the original contract and do not meet the criteria for a separate contract, the entity treats the original contract as terminated and accounts for both the original contract and modifications together as a newly created contract (ASC 606-10-25-13).

Revenue already recognized on the original contract is not adjusted.  All remaining transactions are accounted for on a prospective basis.

  • Cumulative Catch-up Adjustment

If the remaining goods/services are not distinct, the entity combines the increase or decrease of goods or services with the original contract’s promised goods/services to create a single performance obligation that is partially completed at the date of the modification.  The entity must adjust previously recognized revenue to reflect the changes of the modification to the transaction price.

USING ORACLE PROJECTS TO MEET THE OBJECTIVES OF CONTRACT MODIFICATIONS AS DEFINED
IN ASC 606

Begin by increasing the amount of the Agreement on the project, then adding an additional funding line for the increased contract amount to the project tasks.

If the contract modification is Prospective, the Date Allocated should reflect the date from which revenue recognition will occur.

Create a Revenue Event using the new Date Allocated and run revenue generation processes.  The new revenue amount will begin as of the new date as indicated.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

If the contract modification is cumulative, the Additional funding should be entered with the original Allocated Date.  When a new Revenue Event is created, use an event date that is retroactive to the original date.

 

The new revenue will “catch-up” in the currently open accounting period upon generation.