Slack

My workspace Credentials; workspace:arjunkumar username:arjunkumar password:arjunkumar application no:117718 page:16
29-Apr-2017 01:25:PM by: arjun
Hi all, I have created two IG's (dept is master IG of emp).If i select one record and press the save button i am getting below error. ---Ajax call returned server error ORA-20987: APEX - ORA-02292: integrity constraint (ARJUNKUMAR.SYS_C0057314683) violated - child record found for .--- But my requirement is I have to show an alert message in place of predefined error message.Below process i have written to get the alert message if any child records available for that record but i am unable to getting alert using this code. can you please anyone tell me what wrong with my code.Thanks ```declare v_count number; v_value varchar2(400); begin if :APEX$ROW_STATUS IN ('D') then select count(*) into v_count from emp where deptno in(select deptno from dept where deptno = :DEPTNO); if v_count <> 0 then v_value := :DEPARTMENT_ID; HTP.p ('<script type="text/javascript">'); HTP.p ( 'alert(''Delete Child Records of ' || v_value'');' ); HTP.p ('</script>'); end if; end if; end```
29-Apr-2017 01:24:PM by: arjun
well it seems its back online again
29-Apr-2017 04:46:AM by: farzadso
is apex.oracle.com under maintenance for everyone?
29-Apr-2017 04:24:AM by: farzadso
@pritham9 that's exactly what I suggested, but he's not able to get to the template option modal @maik.michel if you are on 5.0, the modal page has no template options (the modal stretch option was introduced in 5.1), if you are on 5.1 make sure that you are using latest UT if you are not sure what version of the UT you are using, go to the shared components -> theme -> UT under the file section, you'll be able to see the version of the UT you are using, should be `/i/themes/theme_42/1.1/` if you see 1.0, then you'll need to refresh the theme by clicking on the "Refresh Theme" under the subscription section then you'll be able to select the template option :wink:
28-Apr-2017 08:35:PM by: maxime_tremblay
@maxime_tremblay I can't set the template options for the modal page. So I am not able to reach the property for activating the maximize-option...
28-Apr-2017 08:08:PM by: maik.michel
@eureka7 @pritham9 Thanks for comments. I will check these.
28-Apr-2017 05:11:PM by: ahamedna
@eureka7@ahamedna From the Administration list, click Monitor Activity. The Monitor Activity page features activity reports divided into the following sections: Page Views - Contains reports of page views organized by view, user, application, or application and page. Page View Analysis - Contains reports analyzing page views, such as top page views by application. Environment - Contains reports of environments organized by user agent, browser, external clicks, or operating system. Application Changes - Contains reports that track application changes by developer, day, or application. Sessions - Lists active sessions with the current workspace. Login Attempts - Contains reports listing login attempts. This report includes logins to: Application Express environment through the login pages for Oracle Application Express Administration Services or Oracle Application Express applications developed using Application Express that use the built-in session management facilities of Application Express Select a report to review.
28-Apr-2017 04:53:PM by: pritham9
@eureka7 @ahamedna i am not sure about time line. But easiest way is below
28-Apr-2017 04:52:PM by: pritham9
@ahamedna, @pritham9 I don't know whether they are available at any time don't they get deleted after sometime???
28-Apr-2017 04:49:PM by: eureka7
@ahamedna you can get it from apex_workspace_activity or from team development in application itself.
28-Apr-2017 04:48:PM by: pritham9
But I don't know if those data get flushed or not
28-Apr-2017 04:48:PM by: eureka7
@ahamedna I know the view APEX_WORKSPACE_ACTIVITY_LOG has all information about all page activities, and maybe you can query and fetch what you need. You can also have a look at some packaged application there is in admin section some reports about users activities, and try to check the code behind too
28-Apr-2017 04:47:PM by: eureka7
@maxime_tremblay Thanks for confirming. Noticed the above in db requirements.
28-Apr-2017 04:25:PM by: shabbin
@shabbin 5.1.1 is working fine on XE
28-Apr-2017 04:22:PM by: maxime_tremblay
Hi all, is it possible to know which page accessed most by users and which page took more time to respond?
28-Apr-2017 04:22:PM by: ahamedna
Hello, It happen sometimes in some sotuation that I can not figure out that the normal Apex action "Refresh does not work" I have this code onclick of a link in a report to update another report passing the ID of the current row ```onclick="ShowDetail(pId)" function ShowDetail(pId){ apex.item('P10_ID').setValue(pId); apex.event.trigger(document,'ShowDetail'); }``` In the custom DA 'ShowDetail' First I set the value in session (using plsql null;) And tried this but none worked: 1. normal action "Refresh" and selected the region from LOV 2. apex.event.trigger('#region_show_detail_id','ApexRefresh'); 3. $a_report($v('region_show_detail_id').substring(1),'1','999','999'); any help? thanks
28-Apr-2017 04:17:PM by: eureka7
Hi All, Is Apex 5.1.1 not supported on XE 11gR2 I see in prerequisites that apex5.1.1 supported only on 11.2.0.4 if thats the case then cant we install on current XE version or do we have any workaround for this?
28-Apr-2017 04:15:PM by: shabbin
@maik.michel so are you saying that it's the modal's template option you can't set or the parent page's template option? because there's a template option for the modal that you can select to make it fullscreen
28-Apr-2017 12:58:PM by: maxime_tremblay
@swesley_perth from what I remember it was fine, I'll have a look at it and let you know if everything is working/displayed as expected
28-Apr-2017 12:57:PM by: maxime_tremblay
@pierre Hello, Pierre, do you know the solution?
28-Apr-2017 07:20:AM by: amaya
Hi @maxime_tremblay , remember the css fun with FontAPEX in 5.0? you have trouble using the FontAPEX on regular buttons in 5.0? I have an icon button using Icon CSS Classes, and it doesn't like the new icon set. I couldn't determine what would need modifying. Do you know?
28-Apr-2017 03:40:AM by: swesley_perth
@pierre yes, I want to set the height and width to maximum... And there is a checkbox for that...
27-Apr-2017 08:44:PM by: maik.michel
I have a problem with interactive grid in 5.1.0 and 5.1.1. When a report (privat / public) is saved and then I add a new column to the source, the saved reports doesn’t show this column and it doesn’t show up at actions / select columns when an existing report is active. I didn’t find a way to add the column without deleting the report and creating a new one. The primary report and there the select columns window shows the added column. Any ideas? Didn’t find the problem in the known issues.
27-Apr-2017 08:34:PM by: chriz_l
@amaya i can show the Picture. Please make it bigger
27-Apr-2017 05:52:PM by: pierre
@maik.michel DO you want to adjust the width and height for the Modal Dialog?
27-Apr-2017 05:43:PM by: pierre
@maxime_tremblay thanx for your Response, but that doesn't work either... All I wanted to do was to maximize the modal dialog on open... Any further ideas?
27-Apr-2017 05:38:PM by: maik.michel
What is it wrong?? please, help me!
27-Apr-2017 04:25:PM by: amaya
The application update 45 an not 4,5 as
27-Apr-2017 04:24:PM by: amaya
but , if I update to 4,5 as
27-Apr-2017 04:24:PM by: amaya
The button Action is in English, and the format numbers looks ok
27-Apr-2017 04:23:PM by: amaya
apparently it is works
27-Apr-2017 04:22:PM by: amaya
-> Database Session as:
27-Apr-2017 04:21:PM by: amaya
And changed in share componet -> security->security atributte
27-Apr-2017 04:21:PM by: amaya
Hello everyone, I have problem with NLS_NUMERIC_CHARCSET. I need my application in english for the button Action and menu belong to the Report Interactive. Bur I need ',.' as NLS_NUMERIC_CHARACTERS, as in Spain. So I change the properties of application in Globalization.
27-Apr-2017 04:19:PM by: amaya
Hi All, Has anyone ever tried to integrate APEX with `Process Maker` which is an open source business process development software. It is a workflow automation tool?
27-Apr-2017 01:50:PM by: eureka7
Hi All, I am facing problem with column heading in IR.Column headings are showing correct in google chrome but i am not able to see column headings properly in internet explorer 11 version.Could you please tell me the solution to achieve this in internet explorer and other browsers also.Thanks
27-Apr-2017 05:18:AM by: kiran_deekonda

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
SATHEESH S KU
29-Apr-2017 08:16
How to Hide Interactive Grid Toolbar Actions button
Link
1 replies - last reply: 29-Apr-2017 09:59- by: Alli Pierre Yotti
Robin Hochtei
28-Apr-2017 22:49
How to execute remote stored procedure from apex process
Link
2 replies - last reply: 29-Apr-2017 06:24- by: fac586
oklimberg
28-Apr-2017 20:31
Checkbox item lose value in tabular after validation error on newly created rows
Link
1 replies - last reply: 29-Apr-2017 07:53- by: Mahmoud_Rabie
sky123
28-Apr-2017 19:50
server side validations
Link
0 replies
kvsinfo
28-Apr-2017 19:07
Interactive Grid override column with CSS like in IR
Link
1 replies - last reply: 29-Apr-2017 02:14- by: Alli Pierre Yotti
Taz1
28-Apr-2017 17:19
update profile page
Link
1 replies - last reply: 29-Apr-2017 08:20- by: Mahmoud_Rabie
Apex_2017
28-Apr-2017 16:39
Oracle Apex 5.1 API
Link
0 replies
user8806650
28-Apr-2017 15:11
Confirm dialog before delete row in IG in Apex 5.1
Link
1 replies - last reply: 28-Apr-2017 15:34- by: Alli Pierre Yotti
danDB
28-Apr-2017 14:43
Maximum amount of dynamic actions reached ?
Link
2 replies - last reply: 29-Apr-2017 11:19- by: Mahmoud_Rabie
akin.f
28-Apr-2017 14:07
User locked out of interactive grid. Buffer too small error
Link
0 replies
Mahmoud_Rabie
28-Apr-2017 14:00
Pre-Built VM for Apex 5.1, Oracle DB, ORDS, OL7
Link
3 replies - last reply: 28-Apr-2017 14:24- by: Hilary Farrell-Oracle
Steven Harrop
28-Apr-2017 10:58
AnyChart to Jet charts
Link
3 replies - last reply: 28-Apr-2017 15:18- by: Hilary Farrell-Oracle
3440464
28-Apr-2017 09:50
Jquery issue after upgrading apex from 3.2 to 5.1.1
Link
4 replies - last reply: 28-Apr-2017 16:49- by: InoL
joehoub
28-Apr-2017 08:46
Download to csv results in error ORA-20987: Error at line 1, col 1844: Unterminated quoted string
Link
5 replies - last reply: 28-Apr-2017 08:46- by: joehoub
Marko Goricki
28-Apr-2017 08:04
APEX IG Bug - Error on Save - no data found for .
Link
4 replies - last reply: 28-Apr-2017 13:21- by: Pavel_p
user10317008
28-Apr-2017 03:58
Oralec APEX Reload image from dynamic Action
Link
2 replies - last reply: 29-Apr-2017 07:09- by: user10317008
user9930026
27-Apr-2017 22:06
How can I capture user's IP Address (or other client details) for an unauthenticated page?
Link
3 replies - last reply: 28-Apr-2017 15:23- by: user9930026
Chintan Gandh
27-Apr-2017 20:06
Dashboard Page
Link
7 replies - last reply: 29-Apr-2017 08:05- by: Mahmoud_Rabie
Shem
27-Apr-2017 18:03
How to stop APEX from timing out during long running query
Link
6 replies - last reply: 28-Apr-2017 20:58- by: TexasApexDeveloper
zagirov
27-Apr-2017 15:24
Issues on top navigation menu
Link
2 replies - last reply: 28-Apr-2017 19:03- by: zagirov
anand_gp
25-Apr-2017 10:53
how to save page when add row button is clicked
Link
8 replies - last reply: 28-Apr-2017 14:20- by: anand_gp
anand_gp
25-Apr-2017 10:19
Printing to dot-matrix printer
Link
9 replies - last reply: 28-Apr-2017 14:31- by: anand_gp
mshaqalaih
25-Apr-2017 08:13
interactive grid re-order column
Link
2 replies - last reply: 29-Apr-2017 04:37- by: mshaqalaih
Habib
21-Apr-2017 08:03
APEX_MAIL_LOG in 5.1.1 Security Flaw
Link
10 replies - last reply: 28-Apr-2017 14:21- by: Habib
Agowda-Oracle
30-Mar-2017 11:08
Dynamic action on Interactive Grid
Link
3 replies - last reply: 29-Apr-2017 05:08- by: user8806650

News

X
    
 
ImageNewsFavorite
Dick Dral  
Custom Cards with Named Report Template
Cards, Reports
Link
28-Apr-2017 16:39:49 by: Juergen Schuster
Christoph Ruepprich  
Easy way to validate JSON in the Database
JSON
Link
25-Apr-2017 07:01:01 by: Juergen Schuster
Jorge Rimblas  
Warn before closing Modal Dialog
Modal Page
Link
24-Apr-2017 17:18:47 by: Juergen Schuster
M.Yasir Ali Shah    
New Plug-in: Nice Calculator
Plug-ins
Link
23-Apr-2017 21:38:51 by: Juergen Schuster
yotti Alli Pierre  
Caching BLOB images
CLOB / BLOB
Link
22-Apr-2017 21:48:21 by: Juergen Schuster
Joel Kallman  Other
APEX Curriculum now publicly available for download
Trainings
Link
20-Apr-2017 22:19:57 by: Juergen Schuster
yotti Alli Pierre  
Custom Card Template
Cards
Link
19-Apr-2017 14:31:55 by: Juergen Schuster
Vincent Morneau    Other
Nice APEX Website build with Material Design
Nice Web Design, User Interface
Link
19-Apr-2017 07:14:36 by: Juergen Schuster
Dick Dral  
New Plug-in: Restrict Shuttle choices
Plug-ins, Shuttle
Link
18-Apr-2017 15:48:27 by: Juergen Schuster
yotti Alli Pierre  
Example Custom Report Template
Reports
Link
18-Apr-2017 15:45:11 by: Juergen Schuster
yotti Alli Pierre  
Message List Customizable
Link
18-Apr-2017 15:41:13 by: Juergen Schuster
Farzad Soltani    
New Plug-in: D3 Liquid Gauge
Charts, Plug-ins
Link
15-Apr-2017 08:42:06 by: Juergen Schuster
yotti Alli Pierre    
Install the Application Builder in other Languages
Application Builder
Link
15-Apr-2017 08:35:56 by: Juergen Schuster
Sylvain Martel  Other
Webinar SSO with APEX and EBS
EBS, SSO, Webinar
Link
15-Apr-2017 08:32:46 by: Juergen Schuster
yotti Alli Pierre  
Responsive Navigation Bar Part 2
Navigation
Link
15-Apr-2017 08:30:23 by: Juergen Schuster
Kris Rice  
ORDS Standalone and URI Rewrites
ORDS
Link
15-Apr-2017 08:24:32 by: Juergen Schuster
Kris Rice  
Connection Pooling and Auditing with ORDS
ORDS
Link
15-Apr-2017 08:22:10 by: Juergen Schuster
yotti Alli Pierre  Other
Automate your development process
Versioning
Link
13-Apr-2017 19:35:42 by: Juergen Schuster
Monty Latiolais  Other
Webinar of the Insum Hackathon Winners
Webinar
Link
12-Apr-2017 20:46:53 by: Juergen Schuster
Ivan Sabolić  
Chat Demo in APEX
Applications, Websockets
Link
12-Apr-2017 20:27:49 by: Juergen Schuster
John Snyders  
Add Checkbox Selection to Tree
Tree
Link
12-Apr-2017 20:23:39 by: Juergen Schuster
Carsten Czarski  
Rest Sample Apps in 5.1 Part 1
JSON, REST
Link
12-Apr-2017 20:19:16 by: Juergen Schuster
Daniel Hochleitner  Other
Docker Image for 5.1.1
APEX 5.1, Installation
Link
12-Apr-2017 20:10:27 by: Juergen Schuster
yotti Alli Pierre  
Show Modal Dialog when exiting the site
Modal Page
Link
12-Apr-2017 20:08:09 by: Juergen Schuster
yotti Alli Pierre  
Responsive Navigation Bar Part 1
Navigation
Link
11-Apr-2017 20:12:13 by: Juergen Schuster
Mark Lancaster  
Auto Dismiss Success Message in 5.1
APEX 5.1
Link
11-Apr-2017 19:57:41 by: Juergen Schuster
M.Yasir Ali Shah  
Animate Font Awesome
Font
Link
11-Apr-2017 06:47:07 by: Juergen Schuster
yotti Alli Pierre  
Personalised Wait Indicator
Form
Link
10-Apr-2017 18:45:03 by: Juergen Schuster
Rodrigo Mesquita  
5.1 Dynamic Theme Styles
APEX 5.1, Universal Theme, User Interface
Link
10-Apr-2017 18:42:36 by: Juergen Schuster
yotti Alli Pierre  
Row Deletion with Confirm dialog
Interactive Report, Reports
Link
10-Apr-2017 08:24:27 by: Juergen Schuster
Dick Dral  
Finding slow JavaScript in APEX
Debugging, JavaScript
Link
10-Apr-2017 08:21:37 by: Juergen Schuster
yotti Alli Pierre  
Open a modal by clicking in a text field
Modal Page
Link
07-Apr-2017 18:58:55 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20