Role Based Costing in Oracle Projects

One of the scenario that i came across is client wanted to have the cost rates assigned at the role level. With the standard functionality this is not possible. So we decided to create a form to assign the rates to the project roles. But i would prefer enabling the flexfield in the Project Roles […]

Read More

Reconciling PA and other modules – Part I

The most challenging part is reconciling the cost and revenue in PA with other modules.Below is a flow chart showing the data flow between the modules PA, AP, PO and GL. Here in this Part1 iam giving you the basic queries that will be helpful to reconcile the cost between these modules. In Part2 I […]

Read More

How to find Maintenance and RUP level in Oracle projects?

1) For the Apps Version run the following sql: SQL > select release_name from fnd_product_groups; 2) For the Maintenance Family Pack Level run the following sql: SQL > select patch_level from fnd_product_installations where application_id = 275; 3) For the RUPs(11i) run the following sql: select distinct patch_name PatchNum, decode(patch_name, ‘5644834’, ‘(11i.PJ_PF.M) Project Foundation Rollup 4’, […]

Read More

How to Capture Extra Information in Projects?

  In this article i will explain the powerful facility that Oracle projects has provided to capture extra information for any projects without having to write a single line of code. UDA : User Defined Attributes UDA is a powerful mechanism wherein similar to the Descriptive flex fields in forms. Here we have to create […]

Read More

Enhancements in Oracle Projects

Some of the enhancements to Projects can be : 1. Adding/Updating a single Task Across multiple project. 2. Adding multiple tasks to multiple projects at a time. 3. Adding /Updating a key member across a project. 4. Publishing Multiple Projects at a time. These enhancements will save more time to any organization. All these can […]

Read More

Custom Project Numbering in Oracle Projects

Some of the companies they want to customize the way automatic project numbering is working in projects. One such requirement is to have different project number sequences for different OUs. Since the projects numbering is based on a sequence if the automatic project numbering is on and is common for all the OUs, there is […]

Read More