I have 12.1.0.5840 0.1 003
If I XOG in
<?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XML Spy v4.3 U (http://www.xmlspy.com) by Murali (Niku Corporation) -->
<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
externalID="1"
chargeCode="Capital"
chargeable="1"
inputTypeCode="normal"
projectID="zCompleted"
resourceID="kinnunenad"
taskID="5000730"
transactionDate="2009-05-22"
transactionType="L"
actualCostRate="120"
billRate="150"
importStatus="N"
voucherNumber="NF004"
units="2">
</Transaction>
</Transactions>
</NikuDataBus>
which is the sample file slightly modified to match my project, resource and other data.
It goes in without errors.
If I query
SELECT [PAC_IMP_HEADER_ID]
,[SOURCEMODULE]
,[TRANSIMPORTKEY]
,[EXTERNALTRANSNO]
,[EXTERNALBATCHID]
,[TRANSTYPE]
,[TRANSDATE]
,[QUANTITY]
,[RATE]
,[COST]
,[CHARGEABLE]
,[NOTES]
,[SITE]
,[IMPORTSTATUS]
,[IMPORTDATE]
,[ERRORCODE]
,[WORKINT]
,[WORKBUF]
,[PROJECT_CODE]
,[COMPANY_CODE]
,[IMPORTEDBY_RESOURCE_CODE]
,[RESOURCE_CODE]
,[ROLE_CODE]
,[JOB_ID]
,[EXTERNAL_ID]
,[TASKID]
,[RATE_CURRENCY]
,[COST_CURRENCY]
,[EXTERNAL_SOURCE_ID]
,[APPLY_TO_EXTERNAL_ID]
,[CHARGE_CODE]
,[INPUT_TYPE]
,[FATALERROR]
,[TRANSCLASS]
,[USER_LOV1]
,[USER_LOV2]
,[EXPENSE_TYPE]
FROM [c8a].[niku].[IMP_TRANSACTIONIMPORT]
Where transdate < '2010-01-01'
I get
0
50
5000044
NULL
NULL
L
2009-05-22 00:00:00.000
2.000000
150.000000
120.000000
1
NULL
NULL
N
2013-09-30 21:49:14.297
0
NULL
NULL
zCompleted
NULL
NULL
kinnunenad
NULL
NULL
1
I can also see in in the Invalids.
So it is ready for the first step in Atul's list
Whether or not it will go further from there in Transaction port to Financials depends if the normal criteria is met.
I did not yet test if the rates in the file will honoured and the other data licke the voucher number will be passed on to WIP in later processing.
Martti K.
.