Update timesheet entries by XOG. Possible?

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Can XOG be used to update submitted timesheets or adjust any posted timesheets?

Environment

Release : All

Component : CA PPM XML OPEN GATEWAY (XOG)

Resolution

XOG can only be used to update timesheet data on timesheets that have a status of Open or Returned. 

If a timesheet is already submitted, it can be returned using a similar XML as the one below: 

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/timesheetApproval.xsd">
<Header action="write" externalSource="NIKU" objectType="timesheetApproval" version="15.7.1.270"/>
<timesheetApprovals>
<timesheetApproval approved="false" timesheetDbId="5024036" resourceDbId="5004043" timeperiodDbId="5001038"/>
</timesheetApprovals>
</NikuDataBus>

To update the hours on the returned or open timesheet, an XML similar to the one below can be used: 

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_timeperiod.xsd">
 <Header action="write" externalSource="NIKU" objectType="timeperiod" version="15.7.1.270"/>
 <TimePeriods>
  <TimePeriod finish="2020-12-12T00:00:00" openForTimeEntry="true" start="2020-12-05T00:00:00">
   <TimeSheets>
    <TimeSheet ID="5024037" lastModified="2020-12-09T11:49:31" resourceID="someUser" status="0" version="4" action="replace">
     <TimeSheetEntries>
      <TimeSheetEntry assignmentEstimate="40" assignmentEstimateForTimePeriod="0" assignmentFinish="2020-01-22T17:00:00" assignmentID="5002044"
          assignmentPendingEstimate="0" assignmentStart="2020-01-20T08:00:00" chargeCodeID="Planning" chargeCodeName="Planning"
          internalTaskID="5001991" projectID="PR1014" projectName="XPL Translations" roleID="csk.networkEngineer" taskID="LM.001.040"
          taskName="Identify Infrastructure Requirements" totalActuals="17" typeCodeID="Billable" typeCodeName="Billable">
       <DailyActuals>
        <Actual actualDate="2020-12-05" amount="0"/>
        <Actual actualDate="2020-12-06" amount="0"/>
        <Actual actualDate="2020-12-07" amount="5"/>
        <Actual actualDate="2020-12-08" amount="5"/>
        <Actual actualDate="2020-12-09" amount="5"/>
        <Actual actualDate="2020-12-10" amount="2"/>
        <Actual actualDate="2020-12-11" amount="0"/>
       </DailyActuals>
      </TimeSheetEntry>
     </TimeSheetEntries>
     <Notes/>
    </TimeSheet>
   </TimeSheets>
  </TimePeriod>
 </TimePeriods>
</NikuDataBus>