Details
-
Type:
CR
-
Status:
Ready for QA
(View Workflow)
-
Priority:
Normal
-
Resolution: Unresolved
-
Component/s: FN
-
Labels:None Labels
-
Customer:OMAN-Tel
-
Product:NEP
Description
As discussed please check below we need the field INSTALLED_PLAN_DATE to show date time together.
The value is available in INSERTDATE column in this format : API should return 2026-04-07 13:30:32 (Format)
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Header xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<wsse:Security
xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"
xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd"
soap:mustUnderstand="1">
<wsse:UsernameToken wsu:Id="UsernameToken-ccc6a478-03f3-475b-a929-11a2cef3d665">
<wsse:Username>nep-api-key</wsse:Username>
<wsse:Password
Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">
mobinets@2017</wsse:Password>
</wsse:UsernameToken>
</wsse:Security>
</SOAP-ENV:Header>
<soap:Body>
<ns2:getObcRemarksResponse xmlns:ns2="http://server.api.nep.mobinets.com/">
<return>
<returnCode>0</returnCode>
<returnMessage>SUCCESS</returnMessage>
<TASK>
<WO_ID>-3312255</WO_ID>
<STATUS>Order Accepted</STATUS>
<INSTALLED_PLAN_DATE>08-Apr-2026 HH:MM:SS</INSTALLED_PLAN_DATE>
<!-- add date time>
</TASK>
<TASK>
<WO_ID>-3312255</WO_ID>
<STATUS>SubContractor Assigned</STATUS>
<INSTALLED_PLAN_DATE>08-Apr-2026</INSTALLED_PLAN_DATE>
</TASK>
<TASK>
<WO_ID>-3312255</WO_ID>
<STATUS>Order Rejected</STATUS>
<INSTALLED_PLAN_DATE>08-Apr-2026</INSTALLED_PLAN_DATE>
</TASK>
</return>
</ns2:getObcRemarksResponse>
</soap:Body>
</soap:Envelope>
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Links Hierarchy
- Transitions
- Trace

The new patch, along with the provided SQL query, will cover the requirement to return INSTALLED_PLAN_DATE with time details.
In the OBC task (FN), we have maintained compatibility with the previous date format.
Please run the mentioned SQL query.
Patch 3.7.0.1445.