[LS-1061] Modify getOBCData API- GTM 2387 Created: 08/Apr/26  Updated: 15/Apr/26  Due: 15/Apr/26

Status: Ready for QA
Project: L3 Support
Component/s: FN
Affects Version/s: None
Fix Version/s: None

Type: CR Priority: Normal
Reporter: Abdulrahman Dabboussi Assignee: Abdulrahman Dabboussi
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: 0 minutes
Time Spent: 1 day, 2 hours
Original Estimate: Not Specified

Attachments: File 15042026_ALTER_TABLE_FN_OT_OBC_TASK.sql     PNG File Screenshot 3.png    
Customer:
OMAN-Tel
Planned Start:
Planned End:
Product: NEP
Actual Start:
Date of Baselining:

 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>

 Comments   
Comment by Ayed Bada [ 15/Apr/26 ]

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.

Generated at Fri Apr 17 12:10:25 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.