Oracle Blogs

Process to Call a shell script or REST API from oracle R12 Ø     To call a rest api we need to run curl command in bash script Example of simple bash script calling API #!/bin/bash curl -L 'https://aet-trackine.com/services/' \ -H 'Content-Type: application/json' \ -H 'Authorization: Bearer F95U05owDB6e8%2b0e3bAV5GSRmBzJB0Q0WeplT5XDSOMoLBpk' \ -d '{     "method": "add",     "data":         {             "recipient_details":                 {                      "recp_mobile": "+91991273324",                     "recp_name": "John Doe",     ...

 Soft Link Creation for host Files Command in Putty STEP-1 - "cd" to the path of host file. cd $PO_TOP/bin STEP-2 - run this cammand ln -s $FND_TOP/bin/fndcpesr softlinkname     

This is expect script to send files between 2 different servers #!/bin/expect -f #taking aurgument 1 as file name set name [lindex $argv 0] #logging in into remote server spawn sftp applmgr@172.*.*.* expect "applmgr@172.*.*.*'s password:" send "password\r" expect "sftp>" #transferring file using put command from and to path send "put -p /u02/oracle/VIS/${name} /u02/oracle/VIS/fs1/EBSapps\r" expect "sftp>" #refresh send "lcd /u02/oracle/VIS" expect "sftp>" #refresh send "cd /u02/oracle/VIS/fs1/EBSapps\r" expect "sftp>" #exiting remote server send "exit\r"

Hi There, This is a bash script through which we can invoice a REST API from backend in ORACLE R12 and we are populating data in api payload from sql database. Using a HOST concurrent program execute this bash script to invoke api , replace your API urls and etc. #!/bin/bash # API URL api_url="https://yourapi url" # parameter for order No. and Delivery Nmber not mandatory to be used in sql query orderno=${5} del_number="${6}" # Authorization Code(Bearer Token) Autho="give_autho_code_here____" # SQL query for details sql_query="SELECT     a     || '|'     || b     || '|'     || c     || '|'     || d     || '|'     || e     || '|'     || f    || '|'     || g    || '|'     || h    || '|'     || i    || '|'     || j  ...