Oracle Blogs

QR code Generate From Oracle PLSQL Here is a GITHUB link For necessary Files. https://github.com/Rehman0270/PLSQLQRcode 1) Download The required files from above link. 2) upload all jar archives in lib folder to your database  (Eample path in WINSCP to put the jar files : /u02/oracle/VIS/fs1/EBSapps/10.1.2/lib ) 3) After uploading open putty and change directory to lib folder in WINSCP and run below commands one by one cd  /u02/oracle/VIS/fs1/EBSapps/10.1.2/lib loadjava -force -genmissing -r -user username/password@database -verbose core-1.7.jar loadjava -force -genmissing -r -user username/password@database -verbose javase-1.7.jar loadjava -force -genmissing -r -user username/password@database -verbose qrgen-1.2.jar 4) Open sql developer and run this functions CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "QRCodeBean" as import oracle.sql.BLOB; import oracle.sql.*; import oracle.jdbc.driver.*; import java.sql.*; import javax.imageio.ImageIO; import java.awt.image.Buffered...

Command to create fmx in Oracle Forms frmcmp_batch userid=apps/apps module=/u02/oracle/VIS/fs1/EBSapps/appl/au/12.0.0/forms/US/RRR.fmb output_file=/u02/oracle/VIS/fs1/EBSapps/appl/au/12.0.0/forms/US/RRR.fmx module_type=form

 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  ...