Oracle E-Biz - E-Invoice Integration via PL/SQL & Shell Script

Customer Based out of KSA belongs to Construction Industry and they use Oracle EBS R12.2.x – SCM, Order Management, Financials.

Successfully integrated using Custom Solution

Challenges

Customer doesn’t have a Middleware.

Due to the old database version, Oracle Wallet is not working.

Solution Delivered

Installed the certifications in the customer OS.

Generated the JSON file and placed it in the respective Unix folder.

Created a shell script to call the E-invoice API.

The JSON response is updated 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 & Shell Script Integration

Real Time Data Transmission

Minimal Error Reporting