API to Update Task Information in Oracle Projects

API to Update Task Information in Oracle Projects

Here is one API to update Task Information in Oracle Projects. Here I have used the API to update the Task Manager Information.

API to add Classification to an Oracle Project

API to add Classification to an Oracle Project

The below API can be used to add a Classification to an Oracle Project.

Query to find Project Manager Info of an Oracle Project

Query to find Project Manager Info of an Oracle Project

The below query can be useful when you are working in Oracle Projects and you need to find out the Project Manager Name and Email Address for a particular project.

Oracle also has provided a seeded package called PA_PROJECT_PARTIES_UTILS that have couple of good functions that can be used to get Project Parties information.

Few Queries for Oracle Projects

Few Queries for Oracle Projects

Project Basic Info:

Project Parties (Project Key Members):

Approved Cost Budget Version Detail:

Budget Planning Element Information:

Change Order Basic Information:

Financial Plan CI Impact:

Project Change Order Approval Action History:

Oracle Project Foundation APIs

Oracle Project Foundation APIs

This article gives a brief description of the APIs that you can use to integrate project data from an external system with Oracle Projects. The procedures discussed below are located in the public API package PA_PROJECT_PUB. Project Procedures: 1] CREATE_PROJECT CREATE_PROJECT is a PL/SQL procedure that creates a project in Oracle Projects using a template […]

Oracle Projects Migration/ Data Conversion

Oracle Projects Migration/ Data Conversion

During my work on a projects conversion, I came accross this very nice document. This document is very informative and so sharing with you all. Happy reading! Main Article: In this article I will be explaining the general steps involved in any Conversion/Data Migration of Oracle Projects module. At the end of this article, you would […]

Key Tables in Oracle Projects

Key Tables in Oracle Projects

Here is a brief description of the key tables in Oracle Projects. Table Description PA_PROJECTS_ALL It stores the highest units of work defined in Oracle Projects. PA_PROJECT_ASSETS_ALL It contains assets information defined for capital projects. PA_PROJECT_ASSIGNMENTS It stores details of all Assignments for a project. PA_PROJECT_CLASSES It contains the class codes of class categories that […]

Oracle Project Suite: An Introduction

Oracle Project Suite: An Introduction

The oracle project suite is a complete enterprise level project management solution. They provide a robust flexible approach to define and manage enterprise level projects and the people, schedules, deliverables, and finances associated with them. Generally, enterprise project management involves the collection and coordination of corporate resources (such as people, money, and hard assets) to […]