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
| Field | Original Value | New Value |
|---|---|---|
| Gantt Options | Milestone (set to milestone: having a due date but zero effort) | |
| Planned Start | 2026-04-15 24:00 (milestone: set planned start date to due date) | |
| Planned End | 2026-04-15 24:00 (milestone: set planned end date to due date) |
| Assignee | Khaled Khalil [ kkhalil ] | Ayed Bada [ abada ] |
| Attachment | 15042026_ALTER_TABLE_FN_OT_OBC_TASK.sql [ 132609 ] |
| Status | Opened [ 1 ] | Pending Requirements [ 10300 ] |
| Status | Pending Requirements [ 10300 ] | Pending Design Session [ 10112 ] |
| Assignee | Ayed Bada [ abada ] | Khaled Khalil [ kkhalil ] |
| Status | Pending Design Session [ 10112 ] | Dev Scheduled [ 10014 ] |
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| Assignee | Khaled Khalil [ kkhalil ] | Ayed Bada [ abada ] |
| Status | To Be Released [ 10400 ] | Ready for QA [ 10023 ] |
| Assignee | Ayed Bada [ abada ] | Abdulrahman Dabboussi [ adabboussi ] |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 6 hours [ 21600 ] | |
| Worklog Id | 296948 [ 296948 ] |
| Baseline Start | 2026-04-15 24:00 (set baseline based of initial work logging) | |
| Baseline End | 2026-04-15 24:00 (set baseline based of initial work logging) |
| Time Spent | 6 hours [ 21600 ] | 1 day, 2 hours [ 36000 ] |
| Worklog Id | 296949 [ 296949 ] |
| Transition | Time In Source Status | Execution Times | Last Executer | Last Execution Date | |||||
|---|---|---|---|---|---|---|---|---|---|
|
7d 1h 11m | 1 | Khaled Khalil | Wednesday 3:07 PM | |||||
|
10s | 1 | Khaled Khalil | Wednesday 3:07 PM | |||||
|
6s | 1 | Khaled Khalil | Wednesday 3:07 PM | |||||
|
7s | 1 | Khaled Khalil | Wednesday 3:07 PM | |||||
|
42s | 1 | Ayed Bada | Wednesday 3:08 PM | |||||
|
46s | 1 | Khaled Khalil | Wednesday 3:08 PM |
|
Links Hierarchy |
Documentation
|
Documentation
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.