Clarity PPM

Expand all | Collapse all

Issue with XOG a financial transaction

  • 1.  Issue with XOG a financial transaction

    Posted 08-16-2018 11:24 AM

    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>



  • 2.  Re: Issue with XOG a financial transaction

    Posted 08-16-2018 02:14 PM

    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>



  • 3.  Re: Issue with XOG a financial transaction

    Posted 08-16-2018 03:25 PM

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



  • 4.  Re: Issue with XOG a financial transaction

    Posted 08-17-2018 05:44 AM

    Hi nsateesh,

     

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

     

    Suhail



  • 5.  Re: Issue with XOG a financial transaction

    Posted 08-17-2018 02:38 PM

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



  • 6.  Re: Issue with XOG a financial transaction

    Posted 08-20-2018 02:08 AM

    Hi nsateesh,

     

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

     

    Suhail.