Description:
Why is My Cost Plan showing a detail row with a value 'NOT_SPECIFIED' in the Group By Role Column?
Transactions have been brought in to Clarity via XOG, all financial processing are completed and records are now in the PPA_WIP table. I have a cost plan that has a group by of Roles and sub group by of Charge Code, actual fields such as Units for Actuals, Cost for Actuals are configured in the Time Scale Value field area. All the actuals I XOG wrote in are now appearing in a line item with 'NOT_SPECIFIED' in the Group By column, the Sub Group by column does show the correct charge code matching my XOG xml file.
<Please see attached file for image>
<Please see attached file for image>
Solution:
Why does the Group By column not show the Primary Role of the resource I used in my XOG file?
The Cost Plan retrieves the information (Units for Actuals, Cost for Actuals, etc) from the financial tables: ppa_wip and ppa_wip_values.
The transactions that are created through a XOG write action did not specifically identify the Resource Role Id and therefore when the transaction was posted into the financial module, the data stored in the table, ppa_wip.role_code is null for those transactions. When Cost Plan displays data from this table no role is found to be displayed for these transactions, therefore a default 'NOT_SPECIFIED' value is displayed instead.
Why doesn't Clarity automatically retrieve resource role based on the resource used?
You need to specify resource role when XOG is used to bring in transactions. The application does not automatically pull resource role from the resource properties, project role or task assignment role. This is a flexibility the application has in place to allow a resource to take on different roles (wear many hats as we say). For example a resource with a primary role of "IT Director" can be assigned to a project to be a "IT Project Manager", and on a specific task you can assign this resource as an "Analyst". In addition, this resource can incur a transaction with yet a different role, or no role at all.
If you don't group your cost plans by Roles you may not need to be concerned about this, but since you do group by Roles it will be necessary to always bring in resource role in the XOG xml file.
What is the correct attribute for resource role? I cannot find it from the sample imp_transaction_write.xml file
The XOG attribute is roleID.
You must specify the value as displayed on :
Clarity Application page->Resources->select the role to open the Properties page->Role ID
The XOG Schema Data (xsd) file for the sample imp_transaction_write.xml is "nikuxog_transaction.xsd", which includes "nikuxog_commonTransaction.xsd". The roleID attribute is documented in this file.
How do I fix the missing roles on the existing transactions so my cost plan will display them properly?
Here are the steps you can take to identify the transactions and fix them one by one.
<Please see attached file for image>
<Please see attached file for image>
KEYWORDS: CLARITYKB, NOT_SPECIFIED, ROLE, DETAIL, FLAT VIEW, costplan, budgetplan.