Skip to main content

Hello,

In Apps 8, we used a custom event and Oracle API to send an SMS to our engineers upon a work order being assigned to them.

The Oracle API Command_Sys.Send_Sms_Message works in Apps 8, but it seems it has been removed in Apps 10 and we need an alternative method of sending SMS.

Does anyone have this working in Apps 10, and are they able to share how they have achieved this please?

Regards

Shaun

Hello @SHAUN_KERSLAKE ,

 

@dsj have a solution about this in his blog. I think it could be very useful for you.

 

https://dsj23.me/2020/04/06/clickatell-sms-integration-with-ifs/

 

Ozgun Bal

@Ozgun BAL @dsj Thanks for providing this article.

I have followed the steps and tried to get it working, but within the IFS Application message I am getting following error:

Exception while sending data 
Caused by: ifs.fnd.connect.http.HTTPClient$UnauthorizedAccessException: POST error #401: Unauthorized access
 

The only element which could be causing an issue is where it says YOURAPIKEY in the below:

 

plsql_rest_sender_API.Call_Rest_EndPoint(rest_service_ => 'SMS',

                                         xml_ => bxml_,

                                         callback_func_ => 'P_L_S_Q_L_Rest_Test_API.REST_callback_Test',

                                         http_method_ => 'POST',

                                         http_req_headers_ =>'Content-Type: application/xml,Accept: application/xml,Authorization: YOURAPIKEY');

 

I have tried the API ID and the Auth Token within Clickatell REST API setup, but both don’t work.

 

Any help would be really appreciated

Thanks

Shaun

@Ozgun BAL @dsj Thanks for providing this article.

I have followed the steps and tried to get it working, but within the IFS Application message I am getting following error:

Exception while sending data 
Caused by: ifs.fnd.connect.http.HTTPClient$UnauthorizedAccessException: POST error #401: Unauthorized access
 

The only element which could be causing an issue is where it says YOURAPIKEY in the below:

 

plsql_rest_sender_API.Call_Rest_EndPoint(rest_service_ => 'SMS',

                                         xml_ => bxml_,

                                         callback_func_ => 'P_L_S_Q_L_Rest_Test_API.REST_callback_Test',

                                         http_method_ => 'POST',

                                         http_req_headers_ =>'Content-Type: application/xml,Accept: application/xml,Authorization: YOURAPIKEY');

 

I have tried the API ID and the Auth Token within Clickatell REST API setup, but both don’t work.

 

Any help would be really appreciated

Thanks

Shaun

 

Hi @SHAUN_KERSLAKE 

You need to use the API key from the SMS integration. It’s after a long time I’m logging into clickatell portal and here’s my API key looks like

 

@Ozgun BAL  thanks for referring my blog :) hope it is useful 😎

 

Cheers!

Damith

Terms & ConditionsCookie settingsAccessibility statement