Project Process Configurator (Fusion PPM) : a Boon (most times) & a Bane (at times)

Process Configurator Feature has been around for a while. You can check out Oracle’s documentation here. Though there are various uses for the Configurator – one of the lucrative uses is for defining custom ‘Revenue Method’s to achieve Percent Complete Revenue along  COGS Clearing. (There is a vanilla “Percent Complete Revenue” Oracle provides out of

Project Process Configurator (Fusion PPM) : a Boon (most times) & a Bane (at times) Read More »

Setup: Project Financial Management, Contracts, Payables, Receivables & Cost Accounting (23B)

Below is the list of (most common ‘Required’) Setups under Project Financial Management in 23B release. Apart from the below – a Projects Consultant will also need to be conversant with a) Home > Others > Resource Directory (Resources/Organizations) – needed for Contracts (in a large organization) needing Security between user groups. b) Procurement >

Setup: Project Financial Management, Contracts, Payables, Receivables & Cost Accounting (23B) Read More »

EBS SQL : Project Budgets

SQL to fetch Budget Numbers (very useful in saving time) SELECT ppa.segment1 “Proj Num” ,ppa.name “Proj Name” ,ppa.description “Proj Desc” ,ppa.project_type “Proj Type” ,pt.task_number “Task Num” ,( SELECT name FROM pa_proj_elements WHERE proj_element_id = task_id AND object_type = ‘PA_TASKS’ ) “Task Name” ,pt.description “Task Desc” ,pt.long_task_name ,( SELECT sum(bl.burdened_cost) FROM pa_budget_lines bl ,pa_resource_assignments ra ,pa_budget_versions

EBS SQL : Project Budgets Read More »

EBS SQL : Organization Hierarchy, etc

When working with large implementations, the below sql/s come in handy to view information quickly Query to get Org Hierarchy Information :- select (select name from HR_ALL_ORGANIZATION_UNITS where ORGANIZATION_ID = pahd.PARENT_ORGANIZATION_ID) Parent, (select name from HR_ALL_ORGANIZATION_UNITS where ORGANIZATION_ID = pahd.CHILD_ORGANIZATION_ID) Child, (select name from HR_ALL_ORGANIZATION_UNITS where ORGANIZATION_ID = pahd.ORG_ID) OU , pd.* from apps.pa_org_hierarchy_denorm pahd

EBS SQL : Organization Hierarchy, etc Read More »

Scroll to Top