Cost Plan creation through XOG IN - Transaction Classes with Comma produce an error
search cancel

Cost Plan creation through XOG IN - Transaction Classes with Comma produce an error


Article ID: 204790


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


Product: Clarity PPM
Keywords: Cost Plan; XOG; Transaction Class; Comma

Steps to Reproduce:

1. Navigate to Administration -> Finance -> Setup
2. Click on "Transaction Classes" under "Classifications"
3. Click on New and create a transaction class with the following details

Transaction Class = 0959,50
Description = 0959,50
Short Description = 0959,50
Transaction Type = Labor

4. Use the following XML to create a Cost Plan (Through XOG IN). Note that transaction class is being set to a value with comma in it. This uses the demo data on a project with ID PR1005. Change the project ID if using a different data set

<NikuDataBus xmlns:xsi="" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_costPlan.xsd">
 <Header action="write" externalSource="NIKU" objectType="costPlan" version=""/>
  <CostPlan benefitPlanCode="" code="plan3" finishPeriod="2020-12" investmentCode="PR1005" investmentType="project" isPlanOfRecord="false" name="Plan 3" periodType="MONTHLY" revision="1" startPeriod="2020-01">
      <segment finish="2020-01-31T00:00:00" start="2020-01-01T00:00:00" value="99999.0"/>
      <segment finish="2020-02-29T00:00:00" start="2020-02-01T00:00:00" value="12345.0"/>
      <segment finish="2020-03-31T00:00:00" start="2020-03-01T00:00:00" value="12345.0"/>
      <segment finish="2020-04-30T00:00:00" start="2020-04-01T00:00:00" value="12345.0"/>
      <segment finish="2020-05-31T00:00:00" start="2020-05-01T00:00:00" value="12345.0"/>
      <segment finish="2020-06-30T00:00:00" start="2020-06-01T00:00:00" value="12345.0"/>
      <segment finish="2020-07-31T00:00:00" start="2020-07-01T00:00:00" value="12345.0"/>
      <segment finish="2020-08-31T00:00:00" start="2020-08-01T00:00:00" value="12345.0"/>
      <segment finish="2020-09-30T00:00:00" start="2020-09-01T00:00:00" value="12345.0"/>
      <segment finish="2020-10-31T00:00:00" start="2020-10-01T00:00:00" value="12345.0"/>
      <segment finish="2020-11-30T00:00:00" start="2020-11-01T00:00:00" value="12345.0"/>
      <segment finish="2020-12-31T00:00:00" start="2020-12-01T00:00:00" value="12345.0"/>
      <GroupingAttribute code="transaction_class_id" value="0959,50"/>
      <ColumnValue name="partition_code">partition10</ColumnValue>

Expected Results: Cost Plan gets created in the mentioned project

Actual Results: XOG IN fails with the following error message. However, the same Transaction Class can be selected from the UI to create a Cost Plan.

  <Description>Missing or invalid value for Grouping Attribute.</Description>


Version: 15.9.0


Due to a defect with ID DE58993.


The defect is fixed in version 15.9.2.