as i understood, we should add a new parameter (mdu_status) to the API updateOBCTaskStatus, but its functionality is not mentioned. so kindly mention what shall we do with this parameter ?

Please note the below changes required.

• Add additional field under the OBB remarks section and also the last update in OBC report to display the update in MDU_Status parameter.

Additionally for the same API we need to capture the attachments passed by OBB which is currently being passed but not stored in FN.

Dear @Amir Mohammad Ali Talebi ,
As discussed , Kindly raise separate GTM for this requirement.

Below is example payload from OBB , the attachment file content (base64) format and file name are highlighted in below params.

<soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/ xmlns:obc=http://omantel/services/obcservice> <soapenv:Header /> <soapenv:Body> <obc:updateOBCTaskStatusRequest> <OT_EAI_HEADER> <MsgFormat>OBC</MsgFormat> <MsgVersion>1</MsgVersion> <RequestorId>ITSOBC</RequestorId> <RequestorChannelId>W</RequestorChannelId> <RequestorUserId>ITSOBC</RequestorUserId> <RequestorLanguage>E</RequestorLanguage> <RequestorSecurityInfo></RequestorSecurityInfo> <EaiReference>0</EaiReference> <ReturnCode>0000</ReturnCode> </OT_EAI_HEADER> <Request> <ReferenceNo>OT-BEUC-R-ConnONT-01680269</ReferenceNo> <Unable to render embedded object: File (--> <ErrorCode></ErrorCode> <) not found.-Optional:> <EstimatedCompleteDate>2024-04-22T10:56:21</EstimatedCompleteDate> <Unable to render embedded object: File (--> <InstalledPlanDate>2024-04-22T10:56:21</InstalledPlanDate> <) not found.Optional:> <OBCTag>40RDN5061825331//OT534653</OBCTag> <Unable to render embedded object: File (--> <Remarks></Remarks> <FINSOrderNo>182971406</FINSOrderNo> <UpdatedBy>BSS OBC UpdateStatus</UpdatedBy> <) not found.Optional:> <SurveyAppointmentDate>2024-04-22T10:56:21</SurveyAppointmentDate> <Unable to render embedded object: File (--> <SurveyCompletionDate>2024-04-22T10:56:21</SurveyCompletionDate> <TaskStatus>Installation Tested and Complete</TaskStatus> <) not found.Optional:> <ONTSerialNo>485754439910D4AD</ONTSerialNo> <Unable to render embedded object: File (--> <ONTMake>OBC</ONTMake> <) not found.Optional:> <handsetSerialNo>NOT APPLICABLE</handsetSerialNo> <Unable to render embedded object: File (--> <handsetMake>NOT APPLICABLE</handsetMake> <) not found.Optional:> <fileContent></fileContent> <!Optional:-> <fileName>installation_evidence_20240409055905479.pdf</fileName> </Request> </obc:updateOBCTaskStatusRequest> </soapenv:Body> </soapenv:Envelope>

Subject: LS-58 : Omantel New Parameter Addition to API for MDU Status- GTM # 1146 // LS-169: GTM# 1146(Request to Save Attachments from updateOBCTaskStatus in NEP)

Dears,

These two tickets are implemented.
Patch Required (3.7.0.1273)

@integration,
Kindly to apply the below two scripts on schema
First Script:
alter table FN_OT_OBC_TASK add MDU_STATUS VARCHAR2(255);
Second Script:
ALTER TABLE FN_OT_OBC_TASK
ADD (FILE_CONTENT BLOB,
FILE_NAME VARCHAR2(255));

Regards,
Sara

One remark from sara , MDU status was added only on obc task report for now , not obc report , this can be completed on Monday

start dev = 3 Mar
End dev = 13 Mar

real WL = 2md

Applied on PROD