Query to get Sale Order and Move Order Info in Oracle apps R12 EBS

Below is the query to get Sale Order and Move Order Info

 SELECT
            mtrh.request_number                         AS move_order_number,
            mtrh.organization_id,
            mtrh.header_id,
            mtrl.line_id,
            mtrh.move_order_type,
            mtrl.quantity,
            mtrl.quantity_delivered,
            ( mtrl.quantity - mtrl.quantity_delivered ) unallocated_qty
        FROM
            xx_ont_sale_ord_ibi_t       ibi,
            oe_order_headers_all        ooha,
            oe_order_lines_all          oola,
            wsh_delivery_details        wdd,
            mtl_txn_request_headers     mtrh,
            mtl_txn_request_lines       mtrl
        WHERE 1=1
            AND ibi.order_number = ooha.order_number
            AND ibi.line_id = oola.line_id
            AND ooha.header_id = oola.header_id
            AND wdd.source_line_id = oola.line_id
            AND wdd.source_header_id = oola.header_id
            AND wdd.move_order_line_id = mtrl.line_id
            AND mtrl.header_id = mtrh.header_id
            AND ibi.order_number = p_order_no;

Install Oracle JDK in Ubuntu 24.04

Step : 1 Download Oracle JDK 8

Under the “Linux” section, download the Linux x64 Compressed Archive (.tar.gz) file

Step 2: Extract and Move the JDK

Create a directory to install Java in, for example, /usr/lib/jvm/ (if it doesn’t exist):

sudo mkdir -p /usr/lib/jvm

Navigate to your Downloads folder and move the downloaded .tar.gz file to the new directory. (Replace jdk-8uXXX-linux-x64.tar.gz with your actual filename):

sudo mv ~/Downloads/jdk-8uXXX-linux-x64.tar.gz /usr/lib/jvm/

Navigate to the install directory and extract the archive:

cd /usr/lib/jvm/
sudo tar -zxvf jdk-8uXXX-linux-x64.tar.gz

Step 3: Configure Java Alternatives

Use the update-alternatives command to register the newly installed Java executables with the system

sudo update-alternatives --install "/usr/bin/java" "java" "/usr/lib/jvm/jdk1.8.0_XXX/bin/java" 1
sudo update-alternatives --install "/usr/bin/javac" "javac" "/usr/lib/jvm/jdk1.8.0_XXX/bin/javac" 1

Step 4: Set the Default Java Version

If you have multiple Java versions installed, use this command to select Oracle JDK 8 as the default system-wide Java

sudo update-alternatives --config java

Step 5: Set the JAVA_HOME Environment Variable

Open the /etc/environment file using a text editor (like nano or vim) with sudo privileges:

sudo emacs /etc/environment

Add the following line at the end of the file, replacing the path as needed (ensure it points to your JDK directory, not the bin folder to JAVA_HOME), For bin folder amend in PATH variable as shown below.

JAVA_HOME="/usr/lib/jvm/jdk1.8.0_XXX"

PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/usr/lib/jvm/jdk1.8.0_471/bin"

Reload the environment variables:

source /etc/environment

Step 6: Verify the Installation

java -version
echo $JAVA_HOME

Installing Forticlient VPN in Ubuntu

To install Forticlient VPN first download the Forticlient VPN only .deb Installer

Go to the last section of Forticlient Website and select Forticlient VPN-only

Once downloaded the .deb file then execute the below command to install. Here the gr is my user

sudo apt install /home/gr/Downloads/forticlient_vpn_7.4.3.1736_amd64.deb

Once dependencies are resolved and package installed then you can open forticlient.

Let me know if you are facing any Issues with Forticlient

To Uninstall

sudo apt autoremove --purge forticlient

Using TRAMP to connect to remote server from Emacs on OCI Instance

For this post I will use the Ubuntu 24.04 release with Emacs 29 on wsl-2.6 and will provide the below steps.

I have already created an OCI Instance and we usually connect with key file directly by below command

ssh -i 'C:\Users\Gowtham\Downloads\<prviate-key-file>' opc@<public-ip-address>

Step 1 : Install Tramp

Installed Tramp by using ELPA. M-x list-packages searched tramp and pressed I for Install and then x to apply. Then recompiled the below using the command

M-x package-recompile RET tramp

Step 2 : Configure ssh

create a file in .ssh folder ~/.ssh/config

Inside the folder I have given below as my configuration

Host UbuntuTest001
     Hostname <IP/Hostname of the System>
     User ubuntu
     Port 22
     IdentityFile ~/.ssh/Ubuntu-20251214-Test001.key
     # Add keep-alive to prevent session hangs
     ServerAliveInterval 5
     ServerAliveCountMax 2

Step 3 : Test ssh

$ ssh UbuntuTest001

Once you put the command to connect the host you should be able to do it. Else the ssh config should be checked

Step 4 : Connect to remote file

To Connect to remote file go to dired mode C-x C-f and then type the below

/ssh:<host_alias_specified_ssh_config>:<remote directory/file to be opened>
;;I connect by the below for testing 
/ssh:UbuntuTest001:/home/ubuntu

Creating a simple Oracle Integration

Open Oracle Integration Cloud Application and follow the below steps

1. Go to Design –> Click Integrations –> Click Create Button –> Click Schedule

Provide Name and Package for the Integration. I have given as XX_EBS_TEST_DEMO for Integration and DEV for Package and click Create

Now add a DB Connection. DB Connection should be created in prior. Enter the Endpoint and select the operation. Here in my case Im just running a sql statement

It will ask for Query and provide the query. I have provided select * from XX_DEBUG_MESSAGE. Once provided validate it. Click Continue and finish.

At the right edge to the below you will be able to see Error Icon. Click on it. It will ask for Primary Business Identifier. Update the Primary Business Identifier.

Drag and drop the startTime to Primary Business Identifiers Variable Undefined. The Errors will get removed and will be getting as below.

Now save the Integration and Activate it. As we have not defined any schedule it will be just activated. This is a very simple Integration. We will see more detailed on the next blog.

A great time at Periya Pathai to Sabarimala

We started our journey from Tirupur to Kottayam at 10:30 PM on 25th November. After reaching Kottayam, we freshened up and took a bus to Erumeli. Once we arrived, we explored the town for a while before beginning the Periya Pathai trek.

Our first stop on the trail was the Koyikkakavu Forest Check Post. Up to this point, the pathway is mostly urban with temples along the route and well-laid roads. This is where the true forest trek begins. The distance from Pamba to this point is 6.5 km, and from here to Pamba it stretches to 25 km.

The forest trekking experience is truly exceptional—surrounded by lush greenery, streams, waterfalls, the sounds of birds and insects, and fellow pilgrims along the way. Since mobile network coverage is almost nonexistent, it creates a great opportunity for genuine conversations and bonding within the group.

Our next halt was the Kalaketty Sree Sivaparvathy Temple, a beautiful and simple structure reflecting Kerala’s traditional architecture. It was an ideal place to rest.

We then headed towards the Azhutha River. After enjoying the scenic view and refreshing ourselves, we began the steep ascent. Until this point, the gradient is mild, but the climb from Azhutha to Kallidamkunnu is notably steep.

From Kallidamkunnu to Pudussery, the trail becomes gentler with minor inclines. Since the Pudussery check post closes at 3 PM, we stayed overnight there. The center offers only basic accommodation, so I had carried a jerkin and blanket to ensure a comfortable rest. The check post reopens at 7 AM the next morning.

The following morning, we resumed our trek from Pudussery towards Karimala, crossing four hills in about an hour. This stretch is known for leeches, so we applied a mixture of salt and raw camphor blended with coconut oil on our legs and feet. It worked well in preventing leech bites. Though a couple of people did get bitten, they removed the leeches quickly. Carrying additional salt helps, as it neutralizes leeches instantly. Some trekkers also use neem oil as an alternative.

The ascent towards Karimala is quite steep. After reaching the top, we paused to refresh ourselves with snacks and juice before moving ahead.

From Karimala, we descended towards Valayanvattam and Cheriyanavattam. While ascending is easier with enough energy, descending takes more time due to the need for caution and grip. After Cheriyanavattam, we finally reached the Pamba river.

From Pamba, we began the final climb towards Sannidanam. The route covers two steep hills—Neelimala and Apachimala—over a 3 km ascent. We saw 2 snakes while travelling. Beyond these sections, the path evens out. I experienced leg pain after trekking about 4 km from Pamba, but eventually managed to reach Sannidanam and took some rest. After a fulfilling Ayyappan Darisanam and receiving the Aravana Payasam, we started our return journey.

Overall, it was an excellent trekking experience.