AnsweredAssumed Answered

Trying to XOG in a Transaction with PO Number and Invoice Number

Question asked by e_martin on Jul 26, 2013
Latest reply on Nov 5, 2015 by saksr01
We have the files, but we keep running into an issue with actually performing the XOG. This is what we are putting in:
<?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="4444"    



actualCostRateCurrency="USD"        



billRate="4444"        



billRateCurrency="USD"      



chargeable="0"       



chargeCode="LABOR"     



externalID="null"



importStatus="N"      



projectID="E0000769"       



resourceID="04406"      



transactionDate="2013-06-24"    



transactionType="L"        



units="1"      



taskID="5018005"



inputTypeCode="DEFAULT"   



voucherNumber="INVOICE1"/>  


</Transactions> 

</NikuDataBus>
and this is what we get in response to it:
<?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 elapsedTime="0.0010 seconds" state="FAILURE"/>
  <Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="0" updatedRecords="0"/>
  <ErrorInformation>
    <Severity>FATAL</Severity>
    <Description>[Error] :0:0: attribute "objectType" has a bad value: the value is not a member of the enumeration.
</Description>
    <Exception type="java.lang.Exception"><![CDATA[
java.lang.Exception: Invalid xml data

at com.niku.xog.service.ObjectHandler.processRequest(ObjectHandler.java:129)

at com.niku.xog.handler.XOGProcessHandler.postProcess(XOGProcessHandler.java:44)

at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1354)

at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:210)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:94)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)

at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:257)

at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:283)

at com.niku.xql2.binding.ServiceControlBindingXql.processFile(ServiceControlBindingXql.java:388)

at com.niku.xql2.binding.ServiceControlBindingXql.getDocument(ServiceControlBindingXql.java:271)

at com.niku.xql2.binding.ServiceControlBindingXql.processRequest(ServiceControlBindingXql.java:155)

at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:749)

at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:211)

at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:194)

at com.niku.union.web.PortletController.processServiceRequest(PortletController.java:1393)

at com.niku.union.web.PortletController.processAuthorizedPortlet(PortletController.java:876)

at com.niku.union.web.PortletController.processPageActionRequest(PortletController.java:394)

at com.niku.union.web.PortletController.processRequest(PortletController.java:163)

at com.niku.union.web.WebActionController.processAction(WebActionController.java:1124)

at com.niku.union.web.WebActionController.processRequest(WebActionController.java:163)

at com.ca.clarity.uif.service.vxml.VXMLService.processRequest(VXMLService.java:403)

at com.ca.clarity.uif.UIServlet.service(UIServlet.java:66)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.wily.brt.filter.BRTFilterBase.doFilter(BRTFilterBase.java:422)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.niku.union.web.filter.GZIPResponseFilter.doFilter(GZIPResponseFilter.java:130)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:56)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)

at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)

at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776)

at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)

at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)

at java.lang.Thread.run(Thread.java:619)
]]></Exception>
  </ErrorInformation>
  <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>

Outcomes