Skip navigation
All Places > Clarity PPM > Blog > 2014 > September

If you try to delete a transaction class (or Resource Class, etc) and get an error saying you cannot, chances are that it's being used on resource profile, WIP transactions, or financial plans.


With the enhancement done in financial planning in v13 the schema for financial plans has changed, adding a new table 'odf_multi_valued_lookups'. Today let's use a query to find out which financial plans are currently grouped by transaction classes and a specific transaction class is used in the plan detail


select  inv.code PROJ_CODE, pln.code PLAN_CODE

from    odf_multi_valued_lookups odf, fin_cost_plan_details dtl, fin_plans pln, inv_investments inv, transclass tc

where   odf.object = 'costplan'

and     odf.pk_id = 

and = dtl.plan_id

and     pln.object_id =

and     odf.value = 'transaction_class_id'

and     dtl.transaction_class_id =

and     tc.transclass = 'LaborTra' -- replace with your transaction class name

group by inv.code, pln.code


As the Technical Refernece guide illustrates here, you can modify this query to find another attribute by changing out the transclass table, the odf_multi_valued_lookups.value value and the column name from fin_cost_plan_details.


Please, feel free to share your queries here for department, role, etc; or share your queries that finds which resources/WIP transactions use a specific transaction class!



Dear CA Clarity Community Member,


With so much going on in the Clarity Community I have consolidated recent activities in case you missed anything.


Ready to begin building your agendas for CA World '14? Visit our Agenda Builder log-in page to get started. You must be registered to begin building your agenda. CA World '14 Agenda Builder Now Available


Join Office Hours for CA Clarity PPM, September 11 @ 1 PM ET

Have a question about CA Clarity PPM? Connect with CA Technologies technical experts to get answers via Office Hours for Clarity. Our team is here to help you get more out of your technology. Join us for one hour Thursday, September 11th @ 1 PM ET. NOTE - No audio is provided and all Q&A happens via online chat, making it a truly ‘fun’ event.

Latest Flipboard Cookbook content is now available on the CA Clarity PPM Community Overview page!

Be sure to join the CA Clarity Global User Community Webcast - September 25th @ 12PM ET


Welcome – karen_beaudouin – Community President

CA World ’14 PPM Preview – DavidWerner – CA Product Marketing

Product Management Ideas Initiative in the Clarity PPM Community - Clarity Product Management is rolling out a new approach for harvesting Ideas from the Clarity PPM Community into the product backlog and would like your feedback - Brian Nathansonnatbr01 – CA Product Management

Clarity Scheduler – This session will provide an introduction into the Clarity scheduler. You can now create and maintain a WBS in Clarity using this drag and drop interface – Mike Thibault  mike2.2  – Community Vice-President


To Join -

Some great videos you may have missed from CA Education! We have a few published 'YouTube' videos available showing you 'how-to' do something in Clarity. These videos are published on our CA Educate YouTube account. Check them out and subscribe to the channel for future updates.

You can check out the videos here: CA Clarity PPM  How-To Videos

Help us improve the experience: Looking for usability testing participants

Thank you to all the volunteers! At this point we have what we need for this round of testing but hope there will be many more round in the future. You can continue to sign up and you'll be added to the list of potential participants for future studies.


Did you miss the To Process/System supporters, Transformational Webinar - Enabling the most for your users and business?

The recording is now available! and while you're at it you might want to check out:

Enabling Your Users and Business To Get the Most Value from PPM


Missed a Tuesday Tip? or any other Tip?

Let Project Management Be Your GPS on the Road to Success

TIP : Documenting your Configuration (via SQL)

CA Clarity Tuesday Tip - Prevent Users From Adding Unassigned Tasks

CA Clarity Tuesday Tip - Duplicate Portlet Display

CA Clarity Tuesday Tip: Timesheet Populate Actions

How to See Account Notification Settings For Yourself and Others

Baselines in CA Clarity PPM and Microsoft Project

What are the licence types and what do they mean?

Think You Know Everything About Dependencies in a Project Plan? Well Think Again!

That's it for now folks but I'm sure there will be a lot more soon! Take a moment to get on the discussion in CA Clarity and make your voice heard!




Community Manager, IT Business Management