Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.9K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.5K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.2K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 402 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
How to Integrate EBS with Oracle APEX.

need to intigrate EBS users with APEX using db links. Any hints or links ?
Best Answers
-
Hello Prachi,
If I understand your question properly, you want to offer to the user an APEX login screen using EBS credentials. The answer is yes, and it doesn't matter if you are using db links or you are right on the EBS database.
You need to create a custom authentication scheme where you will pass the username and password captured in the login screen, to an EBS API.
In the PL/SQL code of the authentication scheme, enter this code:
FUNCTION ebs_validate_login ( p_username IN VARCHAR2 , p_password IN VARCHAR2) RETURN BOOLEAN AS BEGIN return fnd_user_pkg.validatelogin(pv_username, pv_password); END ebs_validate_login;
You need to grant fnd_user_pkg to your APEX instance parsing schema.
Hope this helps!
-
Thanks Sylvain, it helped.
Answers
-
Hello Prachi,
You need to define your requirement a bit more so we can help you. I can only provide some general comments based on your question at this time.
It is highly recommended to install APEX directly on the EBS database. This architecture is support by Oracle Support, the EBS and APEX teams. Please have a look at the white paper I co-wrote with David Peake (Extending Oracle E-Business Suite Release 12 using Oracle APEX).
As for for database links, I'm not a big fan because they are slow and will not provide a great user experience to your EBS users. There is not really any reason to have APEX outside the EBS database. I have successfully implemented a large number of EBS organizations with APEX following EBS development standards. Having APEX parsing on a custom schema is key.
Let me know more specifically what you need and I will be able to guide you appropriately.
Hope this helps!
-
Hi Sylvain,
for APEX logins, is there a way to set it so it uses the same login as EBS? Is that possible using db links ?
Thanks in advance
-
Hello Prachi,
If I understand your question properly, you want to offer to the user an APEX login screen using EBS credentials. The answer is yes, and it doesn't matter if you are using db links or you are right on the EBS database.
You need to create a custom authentication scheme where you will pass the username and password captured in the login screen, to an EBS API.
In the PL/SQL code of the authentication scheme, enter this code:
FUNCTION ebs_validate_login ( p_username IN VARCHAR2 , p_password IN VARCHAR2) RETURN BOOLEAN AS BEGIN return fnd_user_pkg.validatelogin(pv_username, pv_password); END ebs_validate_login;
You need to grant fnd_user_pkg to your APEX instance parsing schema.
Hope this helps!
-
Thanks Sylvain, it helped.
-
Make sure to flag this post as answered for other users using this forum.