Query to find front end link URL for Oracle EBS application from backend

🔍 How to Find Oracle EBS Front-End URL from Backend (SQL)

If you're an Oracle E-Business Suite (EBS) administrator or developer, there may be times when you need to identify the front-end login URL of your application. This can easily be retrieved directly from the database using a simple SQL query.

---

🧭 Step-by-Step Guide

Follow the instructions below to query the EBS base URL from the backend:

1. Open your preferred SQL tool: SQL Developer, TOAD, or PL/SQL Developer.
2. Connect to the Oracle EBS database using your schema credentials.
3. Run the below query to fetch the front-end base URL:

SELECT home_url FROM icx_parameters;

This query retrieves the HOME_URL field from the ICX_PARAMETERS table, which holds the base URL configured for your Oracle EBS instance.

Example result of the ICX_PARAMETERS query.

---

💡 Pro Tips

• Make sure you have SELECT privileges on ICX_PARAMETERS.
• If you have multiple environments (DEV, TEST, PROD), this query helps ensure you're using the correct login URL.
• The URL returned can be used to automate login links or embed in external apps.

---

📌 Related Posts

• How to Configure Oracle EBS Login URL
• Understanding ICX Modules in Oracle EBS

Stay tuned for more Oracle EBS insights and backend tips.