EBS SQL : Projects & Sales Orders
If you ever are in a situation where you need to let the business know of scenarios where more than one Sales Orders are attached to the same Project, (or vice versa) – please use the below SQL/s. Version 1 : All Projects that have more than one Sales Orders SELECT (SELECT segment1 FROM pa_projects_all […]
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 […]
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 > […]
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 : 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 […]
R12 Projects : Part 4 : Oracle Project Billing
Part 4 of a four part series on Oracle R12 Projects.