Oracle E-Biz - E-Invoice Integration via Bash Script

Customer Based out of KSA belongs to Construction & Motor Industry and they use Oracle EBS R12.1.x – SCM, Order Management & Financials.
Successfully integrated using Custom Solution
Challenges

The customer doesn’t have a Middleware.

The customer’s database version is very old, causing Oracle Wallet to malfunction.

Certifications are not installed due to OS version compatibility issues.

Solution Delivered

The customer created a shared directory for access from both Windows and Linux servers.

The JSON file is generated and placed in the respective folders.

A Bash script was created to call the E-invoice API from the Windows server.

After processing, the shell script updates the response back to Oracle.

Proper messages are captured in the table, and the customer can view errors by running reports in Oracle.

Key Highlights

PL/SQL & BASH Scripting

Real Time Data Transmission Using Windows Server

Minimal Error Reporting