How to Integrate EBS with Oracle APEX.

prachi18

need to intigrate EBS users with APEX using db links. Any hints or links ?

Sylvain Martel

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!

prachi18

Thanks Sylvain, it helped.

Sylvain Martel

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!

prachi18

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

Sylvain Martel

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!

prachi18

Thanks Sylvain, it helped.

Sylvain Martel

Make sure to flag this post as answered for other users using this forum.