Application Express :: Getting Application Items To Work With Login
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
ADVERTISEMENT
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
Jul 5, 2012
How to set up Apex SSO in your work area? I have been trying to set it up, but to no avail. I even tried asking support but still under oblivion.
Have you able to run this script before?
apex_sso.sql, apex_verify.sql, apex_sso_server.sql
My output for this scripts are good.
View 0 Replies
View Related
Oct 4, 2012
When I create a new page item via copying from existing page item it fails with the below error code, if there is > or < character in the source of the existing item.Error Source contains <, > or " which are invalid characters. It works fine if I create new item using wizard and then have the same source. I use div tags in the source of my display only items.
View 3 Replies
View Related
Dec 18, 2012
I have 2 regions in my application one is html form region and another is tabular form .I created 6 items in html region and created DA for the items to hide according to the value of items and then created tabular form
find below the sample link
[URL]...
user name: aneesmohamed.m@gmail.com
psswd: symphony
once i select the first item(declaration letter) it will show the second item (applicacable) perfectly,but when i select applicable as yes and discrepancy then all the items become misplaced,
View 7 Replies
View Related
Jan 8, 2013
I have a master-detail form which was getting close to the 100 items per page limit in Apex 4.0 which I then scaled back and got to work properly. I had thought that I could start adding more columns to the detail part of the form since 4.2 was supposed to have increased that limit. I am finding that this does not seem to be true at least in the case of this particular form. I tried increasing and started getting 404 errors when trying to save data--same symptom I had had with 4.0. I am back nearly to the same # of columns I started with--and nowhere near the 200 limit. Columns are month by month projection data that I had hoped to extend with the increased page item limit.
I missing something required to take advantage of larger page items limit? Do I need to use one of the new templates?
View 4 Replies
View Related
Oct 28, 2013
db11gxe , apex 4.0 , firefox 24 , I have a page with a report and two items , and i want to print the whole page (the report with the items) , can apex do so ?
View 1 Replies
View Related
Jul 30, 2012
I'm creating Tool Tip definitions for the Operators in the Filter on the Interactive Reports. I was looking for a definition for the 'Contains' operator and from what I've found this operator is used to do a text search and it returns a relevance score for every row selected.
I've also read that in order for that score to be determined that the column(s) need to be indexed with a CONTEXT index. Non of the columns in the tables are indexed with a CONTEXT index, however, when I put a value in the Expression box for a column I get a record returned.
If I run the same query in PL/SQL Developer like:
SELECT <column>
FROM <table>
WHERE contains(<column>,<search text>,1) > 0;
I get an error that the column is not indexed, so how does it work in APEX?
View 2 Replies
View Related
Feb 21, 2013
APEX 4.2.1 On a page with dozens of editable page items, when branching back to the same page on-submit, is there a way to clear cache for all items except a few (key) items? The branch attributes (via the f?p= syntax) support clearing cache for the entire page and setting specific item/value pairs but no support for exclusions.
View 2 Replies
View Related
Dec 20, 2012
how to create tabs with drop down submenu items like the ones we have under products tab in the link below.
[URL]
View 7 Replies
View Related
Dec 14, 2012
Im tring to dynamically hide/show page item. I searched and found something but it not working for me. Im using apex 4.1 and below described are work I did.
In my page (form) I have 5 fileds iitems.
- Customer No
- Edit
- First Name
- Last Name
- Address
I want to hide First Name, Last Name, Address based on the value in Edit. Let say if user selects "Edit First Name" then First Name must get visible while Last Name & Address hidden.
So I placed this line onChange="$f_Hide_On_Value_Item(this,'LASTNAME,'LN')" in page item EDIT> Label > HTML Table Cell Attributes
But it not working for me? Where am I go wrong?
View 2 Replies
View Related
Sep 13, 2012
I have a simple shuttle:
1 Adam
2 Baker
3 Charlie
4 Delta
5 Echo
6 Foxtrot
Select Name D, UserID R from UserTable
The values are stored in a VARCHAR2 field MULTI_USER (for example 1:2:4:6) When I want to get the names back from the selected item, how do I reference the colon-separated items?
For example:
Select Name from UserTable
where UserID in (select MULTI_USER from MULTI_USER where MULTI_USER_ID = 1)
should return:
Adam
Baker
Delta
Foxtrot
View 2 Replies
View Related
Sep 7, 2012
I have created tabular form. I have set LOV for one column. Here my requirement is when i select the value from lov then it will fetch that value into page item.
I am using apex 4.1
View 12 Replies
View Related
Jun 10, 2013
The values in the page item dont get submitted hence generate errors in my application , in apex 4.2 using collectionEg.
apex_collection.add_member(p_collection_name => 'ORDER', p_c001 => :P56_product_id, p_c002 => :P56_product_name, p_c003 => :P56_list_price, p_c004 => 1);
Can there be a reason why ?
View 4 Replies
View Related
Oct 16, 2013
I have 20 item fields in same form. i need to align them in sequential manner. For example x y z abcl m o p q r s xyzabclmopqrs are the items to achieve this what i have to do...
View 2 Replies
View Related
Nov 15, 2012
I am facing this problem, not sure how to solve this. Basically, the default value of the "items" on the page don't get set when the session is cleared and I visit the page for the first time.
So when I check the session for the first time, all page items are null. But when I revisit the page, the page items gets set sometimes.
View 6 Replies
View Related
Aug 17, 2012
I have created a JQuery mobile template for APEX which at the moment is just returning data from my database in a reports region. Is it possible to include a search bar before the user sees any data so they can search for records in the database and return them to the results page I have already created?
If so what is the best approach with the mobile template?
View 0 Replies
View Related
Feb 21, 2013
On a tabular form I have 50 columns each an input box , (basically 50 weeks of the year)
in these boxes I want to make them numbers only and max length 2
currently I have in the ELEMENT ATTRIBUTES for each column
OnFocus="javascript:this.maxLength=2"; onKeyPress="return numbersonly(this,event)";
( I have a function called numbers only in page 0 )
what I would like to do , to make it more maintainable is to remove all the calls in the element attributes of each column
and put it in 2 dynamic actions how would I go about this ?
I have tried using jquery selector of input:text to call javascript code on both events , Get focus and Key Press for every text box but its not working .
View 5 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
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
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
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
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
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