R12 Projects : Part 3 : Oracle Project Costing
Part 3 of a four part series on Oracle R12 Projects.
R12 Projects : Part 3 : Oracle Project Costing Read More »
R12 Projects : Part 2 : PA Essentials – Implementation Options & Project Fundamentals
Part 2 of a four part series on Oracle R12 Projects.
R12 Projects : Part 2 : PA Essentials – Implementation Options & Project Fundamentals Read More »
R12 Projects : Part 1 : An Eagles Eye View
Part 1 of a four part series on Oracle R12 Projects.
R12 Projects : Part 1 : An Eagles Eye View Read More »
Accounting for Costs/COGS: Project Manufacturing Environment
The below is applicable for Customer Billable Contracts/Projects Using Projects in a Manufacturing Environment has its own benefits and disadvantages. But that is the subject of a different discussion topic. LoL. There is a lot of choice on how to setup accounting (based on the needs). Below is the 80% scenario that will fit most
Accounting for Costs/COGS: Project Manufacturing Environment Read More »
PPM SQL : Querying for Projects & Classifications
Use the below query to fetch list of Projects & key data needed by Business Analysts SELECT (SELECT name FROM HR_ORGANIZATION_UNITS_F_TL WHERE organization_id = ppp.ORG_ID AND LANGUAGE = ‘US’) Business_Unit_Name ,(SELECT name FROM pjf_projects_all_vl p1WHERE p1.project_id = ppp.created_from_project_id) Project_Template ,(SELECT project_type FROM pjf_project_types_vlWHERE project_type_id = ppp.project_type_id) Project_Type ,SEGMENT1 Project_Number ,NAME Project_Name ,DESCRIPTION Project_Description ,(SELECT
PPM SQL : Querying for Projects & Classifications Read More »