Clarity

Hi,

I am trying to XOG financial transaction. Here is my XOG input. XOG import resulted with success message and after that I have run the job  "Post Transactions to Financial". After the job is run, I can see a new voucher created in UI, but the transaction details are in missing. 

Please let me know if I have missed anything. 

INPUT:

====

<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_inboundTransaction.xsd">
<Header action="write" externalSource="NIKU" objectType="transaction" version="6.0.11"/>
<Transactions>
<Transaction
externalID="1"
chargeCode="Work"
chargeable="1"
inputTypeCode="Regular"
projectID="PR000200"
resourceID="jgray"
taskID="5014023"
transactionClass = "PM"
transactionDate="2018-08-15"
transactionType="L"
actualCostRate="8"
actualCostRateCurrency="USD"
billRate="8"
units="1"
userLov1="bb_lookup_ulv1_109"
voucherNumber="TEST"
importStatus="N"
incurredBy="jgray"
>
</Transaction>

</Transactions>
</NikuDataBus>

OUTPUT:

======

<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
<Object type="transaction"/>
<Status elapsedTime="0.03 seconds" state="SUCCESS"/>
<Statistics failureRecords="0" insertedRecords="1" totalNumberOfRecords="1" updatedRecords="0"/>
<Records/>
</XOGOutput>

Could you check the following references, they kind of refer to the similar issues:

https://communities.ca.com/thread/99739680

https://communities.ca.com/thread/101473726

XOG of financial transaction 

The following type generally corrects -> 

externalSource="ORACLE-FINANCIAL" objectType="transaction"

Example:

<?xml version="1.0" encoding="UTF-8"?>

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_inboundTransaction.xsd">

          <Header action="write" externalSource="ORACLE-FINANCIAL" objectType="transaction" version="6.0.11"/>

          <Transactions>

            <Transaction actualCostRate="10099" actualCostRateCurrency="USD" billRate="10" billRateCurrency="USD"

              chargeCode="Scoping" externalID="12348" groupId="12345" importStatus="N" inputTypeCode="Billable"

              poNumber="2222" projectID="PD1002" resourceID="aaronBennett" taskID="5023004"

              transactionDate="2018-07-15" transactionType="L" units="1" voucherNumber="2345"/>

          </Transactions>

        </NikuDataBus>

I have tried these, but no luck. I cant  see transaction in UI. 

Hi nsateesh,

Can you check the relevant db table to cofirm if the xogged in data was inserted?

Suhail

Is there any other way to check without looking into db. I dont have access to Database. 

Hi nsateesh,

Where on the CA PPM UI are you checking the inserted Transaction(s)? Under Invalid Transactions?

Suhail.