🔍 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:
- Open your preferred SQL tool: SQL Developer, TOAD, or PL/SQL Developer.
- Connect to the Oracle EBS database using your schema credentials.
- 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
Stay tuned for more Oracle EBS insights and backend tips.
