In the login page, I want to add a text "Register" that when clicked will send the user to another page to register.
With a button, its simple because its inbuilt there,but I do not want a button,just this: Register
I want also to have the text in color not black.
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...
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 RelatedI 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.
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.
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].........
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
i have a html button. With the following attributes: onclick="return false" class="upd_description" A dynamic Action is listening on this button.
Event: Click
Selection-Type: jQuery Selector
JQuery Selector: .upd_description
static_URL: f?p=&APP_ID.:306:&SESSION.::&DEBUG.:306:P306_SER_SK:&P305_SER_SK.
as defined in my button attributes.
Button and dynamic action are on page 305. I can now open Page 306 as modal window but the page will close immediately.
We are using Application Express 4.1.0.00.32 on Wondows XP and Oracle version is 10g. I've created a report in APEX and the user is insisting on putting a header on each page in PRINT of the report which should contain the "from date" and "to date", which are present on the select criteria on top.
Can I somehow add from_date and to_date items in Title so that when they print the report, they'll see the from and to dates in the title?Or is there someother way to do this. The report is an interactive report with a control break and user prints the report with file->print.
I am new to APEX and I am developing an application to manage Oracle database user accounts. I have a page (8) that has text items for the username and the database name. I have a submit button (this works fine) that will issue the ALTER USER... statement to reset the user's password and unlock the account. I have another button that should:
get the value of the username - P8_USERNAMEassign it to an application item - FIND_USER_IN_DBredirect to page in application - to page 11
The issue is that FIND_USER_IN_DB does not get populated and page 11
which is a simple report with the following query:
SELECT *FROM valid_dbWHERE username = :FIND_USER_IN_DB;
How do I accomplish this?
I have different public page (page1) and different page for authorized user(page5).Upon successful login after process validation ,computation it should navigate to authorized user page 5 but the branching does work it keeps on going to page 1 .
View 8 Replies View RelatedI have a number of pages containing charts and gantts. I want the user to be able to filter the data shown in these various charts. More than that, I want the user's filters to persist between pages. So, if they select "Key project = 'Y'" on the gantt page, the gantt will filter - and if they then navigate to a report (bar chart) page, that will also be filtered for Key projects only.
To make this happen, I plan to have an identical sidebar on all these pages. This will contain maybe 8 dropdowns and tickboxes allowing the user to create or remove these filters. Eventually some users might save preferences for certain choices within these dropdowns.
Since the sidebar will almost always be identical from page to page, the smartest approach would seem to be to create one sidebar (as html region) and access that sidebar from all pages rather than copying the code from page to page. Then I thought I'd create application-level items in order to create global variables for each of the dropdowns.
My question is: is this approach possible? And can I create a "global" region in Page 0 and then access it from other pages? (This is how I thought it would work but I have tried and can't see how to do it.)
My collection is not working as expected, what could be the issue here. This is what i did,
1. I created a collection in a process to fire on page load
if apex_collection.collection_exists(p_collection_name=>'MMMM') then
apex_collection.delete_collection(p_collection_name=>'MMMM');
end if;
APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name => 'MMMM');
2. On my page i have a text field P1_text1 when i enter value into text field like ="sample data" i want this data loaded into my collection, so i created a button and added a process(on submit - before computations...) so it should insert into the collection when i click the button but no data is loaded, process:
APEX_COLLECTION.ADD_MEMBER(
p_collection_name => 'MMMM',
p_c001 => :P1_TEXT1,
p_c002 => 'TESTDATA' );
3. when i run the below query it shows "no data found" ,
SELECT c001,c002
FROM APEX_COLLECTIONS
WHERE collection_name = 'MMMM';
Need to create a report based on date ranges and for this created a interactive report and two page item datepicker fields P15_fromdate and p15_todate. Report works fine with this criteria.But user wants one more field quarter(P15_quarter), When they select the quarter the range values has to get reset and as to get applied to report.
Issue here is unable to find a way to set the page range item values based on the quarter field selection
how to reset the page item fields.
I want to create a news ticker to scroll the images horizontal at the bottom of the page.
I tried with the text content its working fine but and coming to the images its not working.
how to use the workspace images into the news ticker.
I have "After header" process (with PL/SQL code) in "Page Rendering" section and want to navigate to some page after this process has been completed. I created a branch (On Submit: After Processing) with Target Type: URL. But this branch is executed only after "Page Processing", not after "Page Rendering". Maybe , there is any APEX API functions for pages navigating..
View 2 Replies View RelatedI'm using Apex Version: 4.2.1.00.08
I created a page with 2 tree regions. Both trees use different items and different queries. The first tree is displayed correctly. But the second one just contains the first item, if I don't display the first on via customizing the page or if I change the order of the trees the previoulsy invalid tree is shown correctly, but I didn't find a way to display both correct at the same time.
Trying to create a "page zero". Usually in previous releases this is done executing the following:
1. On the Workspace home page, click Application Builder.
2. Select an application.
3. The Application home page appears.
4. Click the Create Page button.
5. For Select a page type, select Page Zero.
Note that the Page Zero option only appears if the application does not have a page zero.
6. Click Finish.
Since the upgrade to 4.2 this option is not available or has move. (I do not have a page zero already created.)
I wanted to apply some CSS throughout my application by adding it in Global Page in APex 4.2
And I used
<style>
#t18InlineError {
color: rgb(243, 12, 12);
}
</style>
It doesn't work.
i want to display a list of all users on a page those currently accessing or using the application. How do i accomplish this requirement?
View 1 Replies View RelatedI'm trying to set up a PL/SQL dynamic action that is triggered by clicking on a button. The dynamic action sets two values in a table and then I would like to redirect to another page. Setting the values works fine. The code is below:
declarel_information varchar2(255) := :P94_FILENAME;BEGINcommit;UPDATE VDI_METADATASET CREATEUSERLISTNAME = l_information, CREATEUSERLISTON = sysdate();commit;htp.init;owa_util.redirect_url('f?p=&APP_ID.:81:&APP_SESSION.::NO:::');END; The redirect fails with the following eror: "Error: parseerror: JSON.parse: unexpected non-whitespace character after JSON data"
how to redirect to a page from within PL/SQL . None of them result in success.
How do I center a button within a region? I tried 'align="center"' but this seemed to be ignored. The button is at the left of the screen. Also, what are the 'display points' (Page Template Region Position 1-8) used for, and why is there a specification for column position of 1-9? Could these be attributes that will allow my button to be centered on the window instead of on the left?
View 3 Replies View RelatedI have a requirement to create an applications with company standard layout,logo and colors.
What is the best way to start. Should I change Page Template or Region template.
There are some standard .css files.
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 Relatedit is possible to have two Validations one Page Item. Also I need to execute them one by one. If one is passed then go to the other and validate that one.
Example:P20_FORM_ACTIONP20_REOPENP20_REASON Validation 1: P20_REASON != 0 with condition P20_FORM_ACTION = CLOSEIf Validation 1 is passed then go to Validation 2Validation 2: P20_REASON != 0 with condition P20_REOPEN = YES
If Validation 2 is passed, then submit the form otherwise get error. is possible in Application Express 4.2.2.00.11. I tried to put the validations as described above into my application, but it did not work. Only one Validation was executed.
I am using Oracle Application Express 11g
I don't have a option for "Page item to submit" in Chart Region
I have javascript code i want to move from standard report page to page zero, well page 0 doesn't have html header/page attribute section so how to i achieve this?
View 7 Replies View RelatedI have no authentication required for my application, but want to secure a few pages.
On the page I wish to secure I have specified that user should not be a public user.
When I click a link to the page I do get a login box, but I seem to be able to enter any old rubbish and still proceed to the page.
How do I secure an individual page without a general authentication scheme at application level, so an Apex user account is needed.
i m using apex 4.1, and want to submit page when page load. i tried dynamic action but it continuously refreshing page. is there any other javascript or anything else from which i submit page on load
dynamic action used, event on load and action submit page but it continuously submitting page.
We have our own portal page. We are trying to pass username and password so they do not have to log in twice. This worked in version 4.1 but when we put in patch p13331096 to get to version 4.11.00.23 the form stopped working. Users have to log into our portal page an then into APEX. That does not make them happy.
<form action="http://dashboard.reliv.com/pls/dwprod/wwv_flow.accept"
method="post" name="wwv_flow" >
<input type="hidden" name="p_flow_id" value="106" />
[Code]....
