6 Replies Latest reply: Feb 4, 2013 6:47 AM by scott.wesley RSS

    ebs authentication in apex

    930803
      Hi Everyone,

      Am trying to use the same username and password of ebs to my standalone(not integrated with EBS) application. Am using apex 4.2 and Oracle Database 11g Enterprise Edition
      CREATE OR REPLACE FUNCTION ebs_authenticate (
         p_username   IN VARCHAR2,
         p_password   IN VARCHAR2
      )
         RETURN BOOLEAN
      AS
      BEGIN
         RETURN (APPS.FND_WEB_SEC.validate_login (p_username, p_password) = 'Y');
      END ebs_authenticate;
      In Before Header Process
      
      Get Username Cookie :           
      :P101_USERNAME := apex_authentication.get_login_username_cookie;
      Set Username Cookie Process :
      
      begin
      owa_util.mime_header('text/html', FALSE);
      owa_cookie.send(
          name=>'LOGIN_USERNAME_COOKIE',
          value=>lower(:P101_USERNAME));
      exception when others then null;
      end;
      Login Process :
      wwv_flow_custom_auth_std.login(
          P_UNAME       => :P101_USERNAME,
          P_PASSWORD    => :P101_PASSWORD,
          P_SESSION_ID  => v('APP_SESSION'),
          P_FLOW_PAGE   => :APP_ID||':1'
          );
      If i give ebs username and pwd means, it is not logging in as it is showing invalid login credentials.

      Can anyone can help me in this.

      Brgds,
      Max