AnsweredAssumed Answered

Cost Plus Code is not valid.

Question asked by Lowell on Jul 28, 2015
Latest reply on Aug 27, 2015 by Lowell

I have a XOG error when attempting to write to the rate matrix

<Exception><![CDATA[

java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20940: Cost Plus Code is not valid

ORA-06512: at "NIKU.PAC_MNT_MATRIX_ROW_VALIDATE_SP", line 2084

ORA-06512: at "NIKU.PAC_MNT_MATRIX_ROW_INSERT_SP", line 99

ORA-06512: at line 1

 

 

 

My input file looks like this:

 

 

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_matrix.xsd">
<Header action="write" externalSource="NIKU" objectType="matrix" version="8.1.3.4545"/>
<matrices>
<matrix defaultCurrencyCode="USD" location="TRG" name="Cambia" type="Cost/Rate">
<columns>
<column name="transactionClass"/>
<column name="resourceClass"/>
<column name="resourceRole"/>
<column name="resource"/>
</columns>
<matrixRows>

<matrixRow currencyCode="USD" fromDate="2014-03-11" toDate="2014-08-04" transactionClass="EXTERNAL"  resourceClass="*" resourceRole="*" resource="usr-1" rate="2.00" standardCost="2.00" actualCost="2.00" typeCode="*"/>

</matrixRows>
</matrix>
</matrices>
</NikuDataBus>

Outcomes