Application Express :: EBS Authentication - Invalid Login Credentials
Feb 4, 2013
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));
[code].........
If i give ebs username and pwd means, it is not logging in as it is showing invalid login credentials.
View 6 Replies
ADVERTISEMENT
Jul 16, 2013
I am using SSO login for Authorizations. Would like make use of SSO for creating authentication schema. My main requirement is to assign privilege based on users using SSO loging.
View 0 Replies
View Related
Jan 11, 2013
I am unable to login my Application Express with my username and password, It shows the below error/
Invalid Login Credentials
Application Express Login
Oracle Application Express is a rapid Web application development tool that lets you share data and create custom applications. Using only a Web browser and limited programming experience, you can develop and deploy powerful applications that are both fast and secure. Learn how to get started.
Workspace:
Username
Password
Reset Password
Login to Application Express
FacebookLinkedInTwitterGoogle+
This service is for demonstration purposes only. Use of this system to store sensitive data is prohibited.
View 1 Replies
View Related
Feb 21, 2013
I have Oracle 11g Express on my laptop and my desktop. I have a workspace that I've been using for a week now on my desktop. Now, for some reason, I am unable to log in to my workspace from my laptop. I know for sure that the credentials are correct because I can log in using my desktop with no problem. I tried from IE and Firefox.
View 2 Replies
View Related
Jul 26, 2012
We are unable to connect our admin account for some unknown reason. We keep receiving the following message "Invalid Login Credentials". We tried to change the admin credentials with sqlplus. We tried the usual procedure "apxchpwd" successfully, but we still cannot log in.We then tried to create a new admin2 account with the following pl/sql block.
SQL> connect APEX_030200 as sysdba
Enter password:
Connected.
[code]....
We cannot connect with either admin & admin2.
View 3 Replies
View Related
Apr 11, 2011
in My remote system oracle 10g installed and i don't know the login Credential details. i.e username, password,database name.
View 12 Replies
View Related
Nov 28, 2012
I'm using the java API to select from Oracle using encrypted login credentials like:
${JAVA_HOME}/bin/java -classpath ${EXECUTEQUERY_CLASSPATH} -Djava.security.egd=file:/dev/urandom -Ddbname=${
DATABASE} -Duser=$DBowner -Dencrypted=true -Dpassword=$_PWD ExecuteSelect " ${sttmsql}"
In some cases I get an Error like:
Query(-1,-1):null
Sometimes I can restart the script and it runs perfectly (with the same Query!). Are there some limitations?
View 1 Replies
View Related
Aug 21, 2013
We just upgraded from Application Express 4.0.2.00.07 to Application Express 4.2.2.00.11. We are using one common application to authenticate and redirect to other applications.
We use the following code:
wwv_flow_custom_auth_std.login( P_UNAME => :P101_USERNAME, P_PASSWORD => :P101_PASSWORD, P_SESSION_ID => v('APP_SESSION'), P_FLOW_PAGE => '2000:1' );
We start to get the following authentication error after the upgrade. There is no authentication configured for this application.
ORA-1403: no data found This is the same code we used from htmldb 2.x through Apex 4.0.2.00.07.
View 0 Replies
View Related
Aug 16, 2012
Task is to create application for almost 10,000 PHD Scholors, i want to know which authtication scheme i used so that each Scholor can access his/her data only after authtication (Login Page).
View 4 Replies
View Related
Mar 5, 2013
We are close to successfully getting our CAS authentication integrated with Apex Listener 2.0 and Apex 4.2.1. We are using Weblogic app server for the Listener configurations and have been able to get the remote_user passed to Apex after login to CAS. We just set the header variable in the new 'HTTP Header Variable' authentication scheme. However there is a glitch at the callback from CAS -- we get the error 'wong number of types of arguments in call' and the URL shows: ..... /apex/apex_authentication.callback.
I see the documentation about this CALLBACK procedure, but am not sure how to set it to go back to the application. I know that CAS is working and passing the userid to the application because I can manually type in the app URL .... /apex/f?p=xxx and I immediately get into the application and the correct userid is identified --whereas initially when I hit the same application it sends me to our Central CAS server for login.
where the parameters of this procedure need to be set and how to set them. I assume the procedure needs to be called by Weblogic?for the callback to find the original calling application so it doesn't have to be 'hard-coded'. I see that one of the parameters is 'p_app_id'. I think our Weblogic engineer was assuming the call to that procedure would 'take care' of the return to the original calling application but obviously we have missed some configuration.
View 0 Replies
View Related
Dec 20, 2012
Apex 4.1.1 or 4.2 -
I do not see an option in web sheets to use HTTP Header values for authentication. Any workaround in order to use OAM for authentication to web sheets?
View 0 Replies
View Related
Apr 17, 2013
Our apex currently has LDAP authentication scheme. We have many applications within the workspace. We are looking for a way to have one authentication scheme defined for all the applications so that user doesn't have to enter username/password for each application. How can I share my LDAP authentication scheme for multiple applications.
View 4 Replies
View Related
Sep 16, 2011
How can i use OS authentication to login db?
SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges
sqlnet.ora text:
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
#SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.INBOUND_CONNECT_TIMEOUT=1
View 18 Replies
View Related
Jan 22, 2013
I have got single sign on working via the built in LDAP Directory authentication in APEX. But at the moment this is letting everyone who is within AD log inHow can I assign role permissions to each logged in user so some users have an admin role and see certain parts of the application / pages / navigation items while editors and readers have different permissions
And also to restrict access to certain pages within the application
View 3 Replies
View Related
Sep 28, 2012
I am trying to use embedded weblogic server for creating an LDAP authtication secheme but it is not working
I believe that embedded ldap server works on the same port as the admin server of the domain but configuring it has been a pain. I got the following code from forum to test the ldap connection
declare
l_retval pls_integer;
l_retval2 pls_integer;
l_session dbms_ldap.session;
l_ldap_host varchar2(256);
[code]........
Every time I run this, I get the following error
ldap session : 01000000(returned from init)
error: ORA-31202: DBMS_LDAP: LDAP client/server error: Invalid credentials
-31202
View 0 Replies
View Related
Apr 12, 2012
I have an installation Oracle 11.2 RAC on Oracle Linux 5.5 on VirtualBox 3.2.8, Enterprise Manager Startup Log In does not recognize the SYSMAN username / password.
Log's (I changed // for /):
[oracle@rac1 log]$ tail -10 emagent.trc
2012-04-12 14:31:08,327 Thread-1148807488 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https:/rac1.localdomain:1158/em/upload/: retStatus=-1
2012-04-12 14:32:09,333 Thread-1148807488 WARN ssl: <nmehlssl.c:nmehlssl_readcb>: nmehl_read_sock timed out, rsf = -5, setting read timeout flag
2012-04-12 14:32:09,335 Thread-1148807488 ERROR ssl: nzos_Handshake failed, ret=28862
2012-04-12 14:32:09,336 Thread-1148807488 ERROR http: 6: Unable to initialize ssl connection with server, aborting connection attempt
2012-04-12 14:32:09,338 Thread-1148807488 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https:/rac1.localdomain:1158/em/upload/: retStatus=-1
2012-04-12 14:32:39,777 Thread-1148807488 WARN ssl: <nmehlssl.c:nmehlssl_readcb>: nmehl_read_sock timed out, rsf = -5, setting read timeout flag
[code]...
View 2 Replies
View Related
Jul 5, 2013
APEX 4.0 Sometimes, I am getting the below error when I tried to logging into APEX workspace (after giving workspace name, User name and password), Expecting p_company or wwv_flow_company cookie to contain security group id of application owner.
ErrorERR-7621 Could not determine workspace for application (:) on application accept. I found some threads related to this but in different way not exactly when I am getting this error.
After 2 or 3 times, this error will not come and I can able to logging into workspace What is the cause for this issue??
View 1 Replies
View Related
Jun 12, 2012
I have an application that I'd like to prevent activity in after a certain time of day, say 3pm. Is there any way I can force logout of all current users and then prevent re-login until 9am the next day (short of deleting all of their login credentials and then recreating them the next morning)?
View 7 Replies
View Related
Jun 20, 2012
I've been creating numerous sample applications. In my latest one, I've been working on custom security schema and it's been working great for the most part. The one issue I'm having is passing login values into my application items. Though I don't receive any error messages or anything, upon checking the value of the application items via the session button, they never contain anything. The code I have in place on my login page is as follows:
begin
select username, user_id
into :F56_USER_NAME, :F56_USER_ID
from GS_USERS
where username = lower( rtrim( ltrim( :P101_USERNAME ) ) );
[code].........
View 8 Replies
View Related
Jul 10, 2012
After SSO Login to APEX Application it directs to Homepage by default,but i need it to direct to particular tab.
View 4 Replies
View Related
Oct 24, 2012
I installed APEX 4.2 over XE 11.2
The Installation process succeeded.I Used the Installation Guide -> and followed the steps from chapter 3...My problem after the Apex-Upgrade ->
The page URL.... is blank, or say it better, ... there is nothing visible on that page (no Login-Form)The original GetStarted page from XE Database -> URL.... shows an Error Error Error processing request.ORA-01403: no data found
I can post the sourcecode from the "blank" HTML-Page...
View 20 Replies
View Related
Nov 27, 2012
I have two pages
1. Login Page contains two items
P1_LOGINNAME - Textfield
P1_PASSWORD - Password
2. Data entry form created using page items. - This page is used to create new users
This page contains many items but issue with only two items.
P10_LOGINNAME - Textfield
P10_PASSWORD - Password
These items are used for creating loginname and password for new user. When i am logging with admin user ,Chrome browser prompts for save password or not save password
1. When i am logging with save password option then
LOGINNAME and PASSWORD of Login page is reflecting on the LOGINNAME and PASSWORD of Data entry page.
so how can i clear the LOGINNAME and PASSWORD item on Data entry page after login.I have tried to set blank to these fields after login
document.getElementById('P10_LOGINNAME').value = '';
document.getElementById('P10_PASSWORD').value = '';
// This is working in Firefox but not in chrome.APEX Version : 4.1
Database : 10g
View 6 Replies
View Related
Nov 1, 2012
I am working on an existing application updating it to use custom authentication. When I changed the active authentication scheme APEX created a new login page (121). Why? How do I set it back to the login page I was using previously which I ahve customized somewhat?
View 4 Replies
View Related
Sep 14, 2012
I have completed the installation of APEX and HTTP server on an instance. But while configuring , I got the following error in the login page.
Service Temporarily Unavailable. The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
Oracle-Application-Server-10g/10.1.3.1.0 Oracle-HTTP-Server Server at y0319t345 Port 7777 Access log has the following error:
10.12.26.109 - APEX_PUBLIC_USER [14/Sep/2012:14:41:22 -0700] "GET /pls/apex/apex_admin HTTP/1.1" 503 442
10.12.26.109 - APEX_PUBLIC_USER [14/Sep/2012:14:42:07 -0700] "GET /pls/apex/apex_admin HTTP/1.1" 503 442
10.12.26.109 - APEX_PUBLIC_USER [14/Sep/2012:14:42:10 -0700] "GET /pls/apex/apex_admin HTTP/1.1" 503 442
10.12.26.109 - APEX_PUBLIC_USER [14/Sep/2012:15:02:17 -0700] "GET /pls/apex/INTERNAL HTTP/1.1" 503 442
The database was on Solaris recently we upgraded to 11.2.0.2 and migrated it to Linux. I have tried [URL]... and the metalink note 1289136.1 with no success.
View 3 Replies
View Related
Jun 26, 2013
Is it possible to use Database authentication in APEX through database link, and how?Also is it posible to read roles from users through database link?
View 3 Replies
View Related
Mar 27, 2013
I need to enable authentication over LDAP SSL. I've configured a wallet (auto login) containing required certificates and set accordingly WALLET_PATH and WALLET_PWD settings using apex_instance_admin.set_parameter method. With this, everything is working fine and LDAP over SSL is working well. It confirms that the wallet is properly configured, valid and usable.
So, the wallet was created with auto login option and it seems to work well without specifying password when calling utl_http.
Proof of properly configured auto login wallet (without password).
TEST01@DB11G> exec show_html_from_url('https://www.verisign.com/'); -- test without wallet
BEGIN show_html_from_url('https://www.verisign.com/'); END;
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1527
ORA-29261: bad argument
ORA-06512: at "TEST01.SHOW_HTML_FROM_URL", line 25
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-29024: Certificate validation failure
ORA-06512: at line 1TEST01@DB11G> exec utl_http.set_wallet('file:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin'); -- set wallet info for use without password (autologin)
PL/SQL procedure successfully completed.
TEST01@DB11G> exec show_html_from_url('https://www.verisign.com/'); -- It works!
PL/SQL procedure successfully completed. So, when I configure WALLET_PATH without WALLET_PWD, it not seems to work as it should with my auto login wallet...
Is it APEX not handling auto login wallets correctly?
Apex Version: 4.2.0.00.27
OS: OEL 6.4
DB: 11.2.0.3 x64
View 0 Replies
View Related
Dec 2, 2012
I am running Apex 4.2 on Oracle Express Edition (Linux). Sometimes my login page has the alignments of the Workspace/username/password login area below the Apex image as below: [URL] ........
This is with using Firefox. The font page renders ok with other browsers like IE or Chrome.
View 2 Replies
View Related
Mar 29, 2013
I'm using Application Express 4.2.1.00.08
In the application, the authentication method used is the DB one, so the user (schema) must exist on the DB. This works fine.
For instance, I'm login as SCOTT
Creating the following query select upper(user) from dualshows that the real logged user is APEX_PUBLIC_USER and npot SCOTT.
How to create a connection with another "real" username ?
View 1 Replies
View Related
Oct 23, 2012
I am using custom authentication with APEX 4.1.1 and I want to display custom error messages on the login page if authentication fails. In my authentication function I'm using apex_util.set_authenication_result to set a result code (code below).
I've tried to use the apex_util.get_authentication_result on the login page to hide and show custom messages but it's not working. I don't believe the apex_util.get_authentication_result is actually obtaining the result?
FUNCTION verify_user(
p_username VARCHAR2,
p_password VARCHAR2
) RETURN BOOLEAN
IS
v_ctr NUMBER;
[code].........
View 13 Replies
View Related
Nov 20, 2012
Not able to open login page 101 in my internal application. I am getting below error
ORA-12170: TNS:Connect timeout occurred
Error Not able to get parameters values
OK
View 2 Replies
View Related