How can i Xog in Transaction Data in a Voucher under Transaction Entry

[Georgy]

Hi Experts,

We had to enter some Transaction Data in a Voucher under Transaction Entry through XOG.

How is this possible?

Thanks,
Georgy

[navzjoshi00]

Have you checked "imp_transactions_write.xml" ?

I've attached it for your reference ... (Also attached "imp_transactions_read.xml")

NJ

Attachment(s)

imp_transactions_write.xml   19 KB 1 version

imp_transactions_read.xml   580 B 1 version

[Georgy]

Hi NJ,

Thanks a lot for the files. Actually we need to create a new Voucher Entry and create a Transaction under it.

Here is our XOG code that we used (taken from the imp_transactions_write.xml file)

<?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="inboundTransaction" version="6.0.11"/>




<Transactions>



<Transaction actualCostRate="5845.29" 


actualCostRateCurrency="USD" 


billRate="5845.29" 


billRateCurrency="USD" 


chargeable="1" 


chargeCode="EXP" 


externalID="X-RESCODE_US1-PROJ_UK_STD2-37299-1" 


importStatus="N" 


projectID="projectid" 


resourceID="600002" 


transactionDate="2002-11-11" 


transactionType="M" 


units="1" 


taskID="taskid in projectid" 


inputTypeCode="Billable" 


groupId="121" 


voucherNumber="Correction" 


poNumber="23232" 


incurredBy="admin"/>

</Transactions>



 </NikuDataBus>

Here is the XOG OUT message:

<?xml version="1.0" encoding="UTF-8"?>
<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
    <Object type="inboundTransaction"/>
    <Status state="SUCCESS"/>
    <Statistics failureRecords="0" insertedRecords="1"
        totalNumberOfRecords="1" updatedRecords="0"/>
    <Records/>
    <DeprecationInformation>
        <Severity>WARNING</Severity>
        <Description>DEPRECATION MESSAGE</Description>
        <Exception type="java.lang.Exception">The objectType 'inboundTransaction' has been deprecated.  Please use the objectType 'transaction' instead.</Exception>
    </DeprecationInformation>
</XOGOutput>

We ran the same XOG replacing 'inboundTransaction' with 'transaction'...We get the same XOG success message with one inserted record...But we are seeing no new vouchers created. Where is this record being inserted?

Waiting for your inputs,
Georgy

[navzjoshi00]

"importStatus="N""

Have you seen the "Invalid Transactions" page ? It should be inserted as a new record ... :tongue

NJ

[Georgy]

Hi NJ,

Yes, we finally made it work. We have to run the Post Transactions to Financial job to make the new import voucher appear under "Transaction Entry" under Financial Management. Just xogging in wont do :(

Each time we xogin the new transaction using the above xog code, a new entry is made in the IMP_TRANSACTIONIMPORT table, which will be deleted when we run the Post Transactions to Financial job and they will then appear under the "Transaction Entry" page.

Thanks a lot friends,
Georgy