AnsweredAssumed Answered

Post Transaction to Financial Job failed for expense transaction in V13

Question asked by TIDI on Sep 10, 2012
Latest reply on Nov 8, 2015 by clarity5.5
Hello All,

We are xoggin transaction of type expense against expense resources through xog client. It is creating a new transaction in clarity as expected. But when we execute the job Post transaction to financial, job id is generated but still in invalid transaction with reject reason as "New Transaction" and status as rejected.

Since we dont have a valid error messge, we cant identify the exact issue. We have check the financial properties of the project and the expense resource. all are set and active. Please find below the transaction xog which we are using:

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_transaction.xsd">
<Header action="write" externalSource="NIKU" objectType="transaction" version="13.0.0.7032"/>
<Transactions>
<Transaction chargeCode="Expense" inputTypeCode="Billable" projectID="PR000026" resourceID="NLR_ADTOR" taskID="5023302"


transactionClass="OTHR_EXP" transactionDate="2012-07-30"
transactionType="X" voucherNumber="1001" externalID="TSK1001_5023302" groupId="12861111"


actualCostRate="1234" actualCostRateCurrency="CAD" billRate="1234" billRateCurrency="CAD"


units="1"/>
</Transactions>
</NikuDataBus>

Upon executing the below sql, we found the value in fatalerror column as "-1422 - 8=>ORA-01422: exact fetch returns more than requested number of rows"

SELECT fatalerror
FROM IMP_TRANSACTIONIMPORT

We are using Clarity V13.0.

Any help would be much appreciated!!

Outcomes