Forum Stats

  • 3,817,441 Users
  • 2,259,333 Discussions
  • 7,893,774 Comments

Discussions

How to Integrate EBS with Oracle APEX.

prachi18
prachi18 Member Posts: 11 Green Ribbon
edited May 12, 2021 12:17PM in APEX Discussions

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

Tagged:

Best Answers

  • Sylvain Martel
    Sylvain Martel Member Posts: 780 Silver Trophy

    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
    prachi18 Member Posts: 11 Green Ribbon
    Answer ✓

    Thanks Sylvain, it helped.

Answers

  • Sylvain Martel
    Sylvain Martel Member Posts: 780 Silver Trophy
    edited May 12, 2021 12:59PM

    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
    prachi18 Member Posts: 11 Green Ribbon

    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
    Sylvain Martel Member Posts: 780 Silver Trophy

    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
    prachi18 Member Posts: 11 Green Ribbon
    Answer ✓

    Thanks Sylvain, it helped.

  • Sylvain Martel
    Sylvain Martel Member Posts: 780 Silver Trophy

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