Application Express :: Build A Menu Framework
Jun 27, 2012
I have built a Menu Framework using the following instructions.
[URL]........
I am facing 2 problems.
1. If the user is in a child application and clicks logout. He is taken to the login screen of the master application (Correct), but once he enters login details, he is returned to the child application (False). I think he should be returned to the Home page of the Master application.
2. If I set Session Timeouts in the Edit Security Attributes of the applications. Then if the user is timed out, he is sent to the login screen of the Master application (Correct). If he then logs in, he is sent the the Home page of the Master application (Correct).
Now if he clicks a link to a child application he is then sent back to the Master application login screen. He then has to login again. He is sent to the Master Home page and everything is then ok.
View 1 Replies
ADVERTISEMENT
Jun 29, 2013
I have a requirement wherein onclick of button I want to open/close list/popup (which is displayed below button, just like in select list) and can select any item from list to do some action.
View 7 Replies
View Related
Jul 2, 2013
why the link provided under the How to Build an Access Control Page Download Spreadsheet Data Download the following *.csv file to your local system: In your Web browser go to:
[URL]............
returns nothing for me!
View 1 Replies
View Related
Nov 2, 2012
I am trying to implement a Jtree with Context Menu. When Context Menu is implemented the nodes wont expand or collapse.This happens with Sample Trees Packaged application for Project Documentation tree.
View 0 Replies
View Related
Jul 3, 2013
I'm looking for a solution to navigate through the drop down menu (APEX-Region-Plugin two level menu) by using the tab key and short-cut keys. How it could work?
View 0 Replies
View Related
Aug 28, 2012
i want to create tab menu like in sumneva site URL.....
View 13 Replies
View Related
Jan 30, 2013
I am trying to find a way to set the selected columns, like what the action menu -> select columns does. I am planning to build a AJAX Tree with check boxes, but I don't know where to pass that data to to update the selected columns. I'm sure their is a magic apex function that is passing the values of the current shuffle box, but as that is dynamically created, I have not be able to find that process / function.
Reason for this: Too many columns on the IR report. Want them divided by categories in a tree view. And no, I cant break the report up into multiple reports. Currently this report has 548 columns.
View 1 Replies
View Related
Nov 11, 2012
I am use this slideshow within my application [URL]... and this the slide source [URL]...
and use this CSS menu [URL]... and this the css menu source code [URL]...after working the Slideshow is covering over drop-down menu .
if you want to see in action [URL]...
View 1 Replies
View Related
Nov 28, 2012
Tree with context menu not expanding on page load
I try the solution and it works fine but I lost tree functionality that saves tree state (Selected Nod Page Item), value of this item is correct but async operation reset tree state.
View 0 Replies
View Related
May 18, 2013
APEX Version : 4.2.2
Application : TRQ_APP
[URL].......
I have a menu list defined in page 0 - when the menu list is displayed in home page (Page 1) it looks fine but in others pages it displays differently
To have the menu list displayed in all pages of application as it is in page 1.
View 5 Replies
View Related
Jun 21, 2013
We have recently did upgrade from 4.1 to 4.2 with listener 2.0. The edit bar (to edit the page) and Save Report option from Actions Menu ( Interactive Report) are missing, is it a bug?
View 3 Replies
View Related
Nov 17, 2012
Given:
- Apex 4.2
- Application Theme: Bluejay-22
- Page Template Class: Two Level Tabs
Required:
- Convert 2nd Level Tabs of (Bluejay-22 Theme) to be Drop-Down Menus as in (Application Builder Theme)
- Where can I find documentation for app_AppMenuMultiOpenBottom3
Current Situation
- Only the first level tabs are converted to match the (Application Builder Theme).
- The Drop-Down menus of the second level tabs are not working
Steps tried
1) link the following CSS's into the Header section of the Page Template of (Bluejay-22)
<link rel="stylesheet" href="/i/css/apex_builder.min.css?v=4.2.0.00.27" type="text/css" />
<link rel="stylesheet" href="/i/css/apex_ui.min.css?v=4.2.0.00.27" type="text/css" />
<link rel="stylesheet" href="/i/css/apex_ui_builder_home.css" type="text/css" />2) link the following Scripts into the Header section of the Page Template
<script type="text/javascript">
[code].....
View 16 Replies
View Related
Oct 1, 2012
I called an application from Oracle forms using: Client_Host('cmd /c START "" "\localPathmyApplication.exe"'); This works fine on local as well as server.
But when I use the same command to call the application directly from the MENU ITEM, it gives error alert: "WebUtil Error: oracle.forms.webutil.host.Host bean not found. WEBUTIL_HOST.Execute will not work."
I even tried using DDE.App_Begin(). This gives error: ORA-106561. How can I call any application (.exe) directly from the menu item on the server?
View 3 Replies
View Related
Dec 4, 2012
I have Windows Server 2008 R2 32bit and Oracle 11g Release 2 Express Edition installed on my server machine.
I have Windows 7 Pro 64bit, Visual Studio 2010 SP1 32bit, .NET 4.0 and Oracle .NET Data Provider (ODTwithODAC1120320_32bit) installed on my development machine.
The data provider download mentioned Entity Framework support. Existing tutorials on how to use Oracle with the Entity Framework makes me believe that EF is indeed supported! But when I try to create a new ADO.NET Entity Model, the Oracle data provider nor data source isn't listed!
Image: [URL]
On the other hand, if I want to create a new database connection, via the Server Explorer view, there are no problems connection to Oracle's DB.
Image: [URL]
The reason I need Entity Framework support is because we're migrating from MSSQL to Oracle and are looking for the most painless route to do so.
View 1 Replies
View Related
Dec 10, 2012
am starting a new project for a customer who is currently using Oracle 8x. My experience as a software developer has been using MS SQL Server and so most of our code uses Entity Framework 4 and 5 with ASP.Net 4.0 and 4.5. This is my first experience with Oracle.
After doing some research I found that it looks like their version of Oracle is EOL and no longer supported. Does using Oracle Data connection tool kits for Entity Framework and Oracle 8? The tutorial that Oracle has on there site requires Oracle 10.25 or later? I am wondering if I will need to drop my code back to inline sql or if I can still use Linq with EF.
View 2 Replies
View Related
Nov 28, 2012
When running into what should be an OptimisticConcurrencyException in entity framework, i'm getting an update exception as follows:
"A null store-generated value was returned for a non-nullable member 'DateChanged' of type 'FDDT.Model.FeedArray'."
I'm using the DateChanged field as the concurrency tracking field. In entity framework DateChanged has the following properties:
StoreGeneratedPattern: Computed
Concurrency Mode: Fixed
I have a trigger set on this field as follows:
TRIGGER FEED_ARRAY_TRIG_DTCHG before update on FEED_ARRAY for each row
begin
:new.DATE_CHANGED := sysdate;
end;
I've tried setting this concurrency tracking field to "Identity" instead, however that causes another error when I run into a concurrency exception and refresh using the client wins option.
View 2 Replies
View Related
Apr 19, 2013
i have one form name is LOV.fmb and i have one menu name is summit_menu.mmb how to display menu instead of default menu.
View 2 Replies
View Related
Jul 18, 2013
I'm trying to build a query capture the below information. Table looks something like below .
RoomSubjectStudentsA1Science10A1Maths20B1Science15B2English25C1Deutsch20A1French15C1English10
How can i write a query so that i takes the average of students in each room and display the output? I need to write a query so that it also picks up any new rooms and students added. Average is sum of total students in room by number of times each room is specified.
eg: A1 is listed 3 times a the result would be 10+20+15 divided by 3.
A1 B1 B2 C115 15 20 15
View 7 Replies
View Related
Jul 28, 2010
I installed oracle11g on my computer ,when im going to build demo its not working.its giving a error like this.
sys>conn u1/u1
error accesing PRODUCT_USER_PROFILE
warning product user profile information not loaded
you may need to run PUPBLD.SQL AS SYSTEM
connected
u1>@?/sqlplus/demo/demobld unable to open file "/oraeng/app/oracle/product/11.1.0/sqlplus/demo/demobld.sql"
View 1 Replies
View Related
Apr 25, 2011
We have developed a code which builds a trigger on a atble dynamically at run time usinf Dynamic SQL command Execute immediate.
create or replace
PROCEDURE GENERATE_TRIGGER
(
P_TNAME IN VARCHAR2
[Code].....
I am not usre if the error is due to insufficient privileges as we are able to build tabl;e in the system dynamically using the above mentioned command.
View 1 Replies
View Related
Aug 3, 2011
I am an absolute neophyte at this. I'm fairly good at SQL, but have not administrated a database before.
I am trying to take a backup from our production database and restore it to a fresh install of Oracle 10.2 on a Windows 2003 server using RMAN - but I am not getting very far. Software versions are all the same. I have access to the manuals, but it seems like every link I follow adds more questions than it answers.
I have gone through the wizard and set up oracle on the new box - that all seemed to go smoothly. In order for this to work, do I need to set up the database with the same DBID as the one in the backup files? Or is there a way to import the data from the backup and have it build the database from those files?
I'm not sure I'm even asking the right questions. Do any of y'all know of a tutorial that would walk me through this process step by step?
View 4 Replies
View Related
May 3, 2013
We have an requirement to create xml data for entire database (selected tables) which are in hierarchy.Procedure should read node_mapping table having parent and child tables relationship info and build XML Select statement.
Currently it is building SQL statement whenthere are one parent having multiple childrens i.e Dept having emp, emp_act, emp_rsch..but when child node are having childrens then it is not working - it has to repeatedly call this procedure (recursive) and build below given SQL statement.
1. To change procedure to build xml sql statement when there are multiple childrens to child nodes (hierarchy)
2. To format the output in xml data
We are using ORACLE 11G and WINDOWS 7
CREATE TABLE node_mapping
(
NODE_ID NUMBER(5) PRIMARY KEY,
PARENT_NODE VARCHAR2(100),
CHILD_NODE VARCHAR2(100),
PARENT_NODEID VARCHAR2(50),
CHILD_NODEID VARCHAR2(50)
[code]....
View 1 Replies
View Related
May 8, 2013
We have an requirement to build (XML) Select statement dynamically based on the mapping table (which is in hierarchy format)
I have removed xml keyword, so query will not work. but need procedure which will recursively check mapping table (parent and child table) and build below given select statement.
Example 1:
SELECT dname,
(select ename,
[Code]....
View 8 Replies
View Related
Jun 19, 2012
we get daily a full dump from our customer. We have to build the differences of tables (deltas) and load them in separate tables.
There some questions, requiremenst and restrictions:
1) Is it possible the merge the dumps ?
2) How to build the differences as the easiest ?
3) The whole process (import, merge, extract) should be run in batch.
4) We have only a solid knowledge and liitle time for doing.
View 1 Replies
View Related
Jun 21, 2011
select a default table in oracle as we do in teradata, below is the syntax of teradata.
select 'XXX' as Curr,
'BUS OBJ ' as acq_nm
from (select 1 as one) Union
select 'ALL' as Curr, from (select 1 as one).
so I need the same select in oracle.
View 3 Replies
View Related
Feb 26, 2010
I want to build a hierarchy and output it into a sub-report. Since the data in few hierarchy fields exceeds 4000 characters and therefore m getting the ORA-01489 error and the entire report was failing.
So i have used user aggregate function to print the out put. I have also used row_number() to print sequence in query output.
the query that i am using is
SELECT pr_id,
REPLACE (REPLACE (twadmin.STRAGG2(distinct RPAD (to_number(curr), 2, ' ') || ')' || NVL (DECODE (medical, NULL, clinical, medical), 'UNKNOWN') || '###' ||
RPAD (' Causality as per rport ', 50, ' ') || ': ' || reporter || '###' ||
RPAD (' Causality as per report2 ', 50, ' ') || ': ' || hospital || '###' ||
RPAD (' Dechallenge', 50, ' ') || ': '|| dechallenge || '###' ||
RPAD (' Rechallenge', 50, ' ') || ': '|| rechallenge), ',', CHR(10)), '###', CHR (10)) causality
[code]......
the output of the query is
ID Causality
-- ------
3755101 )Blisters (Blister)
Causality as per report1: Probable
Causality as per report2: Possible
Dechallenge : Not Applicable
Rechallenge : Not Applicable
2 )Mental status changes (Mental status changes)
[code].......
but the expected out put is
ID Causality
-- ------
3755101 )Blisters (Blister)
Causality as per report1: Probable
Causality as per report2: Possible
Dechallenge : Not Applicable
Rechallenge : Not Applicable
[code]........
but it should be as
1)
2)
3)
..
..
..
10)
11)
12) for the values in the causality field
View 25 Replies
View Related
Dec 18, 2012
I have created a VIEW with a column containing user-defined aggregated values(stores the output in varchar2 data type). Some of the records exceed the maximum limit, for example varchar2(4000). I was suggested a PL/SQL function to check the length and build a string if necessary..
CREATE OR REPLACE
FUNCTION SUBURL(col1 IN VARCHAR2, col2 IN varchar2)
RETURN varchar2
[Code].....
Here, I got the following error,
Error(4,25): PLS-00103: Encountered the symbol "," when expecting one of the following:
:= . ( @ % ; not null range default character
View 14 Replies
View Related
Jul 8, 2010
Is it possible to build index partition in parallel?I tried following command
alter index <index_name> rebuild partition <partition name> online parallel 5;
It executed without complaining, but want to know if index partitions can be build in parallel?
View 3 Replies
View Related
Oct 9, 2009
I am trying to modify an existing form in oracle apps. I copied all the necessary objects and modified the form. I can compile the object in windows. When I am trying to compile the object in Linux server using SSH I am getting the following error.
FRM-91500: Unable to start/complete the build.I am using the following command for compile
f60genm userid=apps/apps batch=yes module= FORMNAME.fmb module_type=form.
View 3 Replies
View Related
Mar 17, 2010
i have a doubt in building a query.
I have a table with fields
job_no activity Date
101 anchorage 20/01/2010
102 berthing 25/01/2010
103 sailing 29/01/2010
If i want to know the status of the ship on the date '22/01/2010' It has to show as 'anchorage', becoz on '25/01/2010' only it came to berthing from anchorage. How to write a query to achieve this.
View 12 Replies
View Related
