1. getIpOpticsDesignParameters : for this API, I tried several samples, but the cost I’m getting is empty. It seems that we don’t have data. Is it possible to insert a cost more than 50 OMR.

REQUEST / RESPONSE :
<soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/ xmlns:ser=http://server.internal.api.srd.nep.mobinets.com/>
<soapenv:Header/>
<soapenv:Body>
<ser:getIpOpticsDesignParameters>
<!-Optional:->
<requestId>341</requestId>
<!-Optional:->
<serviceName>1608320_FBB</serviceName>
</ser:getIpOpticsDesignParameters>
</soapenv:Body>
</soapenv:Envelope>

<soap:Envelope xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/>
<soap:Body>
<ns2:getIpOpticsDesignParametersResponse xmlns:ns2=http://server.internal.api.srd.nep.mobinets.com/>
<return>
<ipOpticsTotalCost>0.0</ipOpticsTotalCost>
</return>
</ns2:getIpOpticsDesignParametersResponse>
</soap:Body>
</soap:Envelope>

the service reads the IP_OPTICS milestone for the given requestId, sums the cost field across all MilestoneProfile entries linked to it, and returns a single value: ipOpticsTotalCost. The serviceName parameter is accepted but not used.

How to demo with customer (UI verification):
Open SRD Request Manbagement page -> IP & Optics tab (visible when active task = IP_OPTICS)
The tab shows a profiles grid with: Site ID, Transport Type, Node Name, Node ID, Transport Interface, Cost
Add a profile: choose Transport Profile -> Cost auto-fills -W save
Call the API -> ipOpticsTotalCost = sum of all profile costs in the grid

Please provide a sample in Omantel platforms 179 and 84 and to be demoed in SRD UI.

The SQL Code provided is returning empty

This request returns a default (empty) response.
To obtain a valid response, please run the following query to retrieve a valid request_id:
SELECT sm.request_id
FROM SRD_MILESTONE sm
INNER JOIN SRD_MILESTONE_PROFILE smp
ON sm.id = smp.MILESTONE_ID
WHERE sm.DTYPE = 'IP_OPTICS';