Hi guys, I have form in popup page which has around 30-40 fields , When I click on button to open this popup screen it will take lot of time to open.Any pointers on how to debug the performance and what may be the cause? I have already checked debug stats but evrything seems okay there!!. Thanks
23-May-2018 08:00:AM by: ashwinrao
@maxime_tremblay I need to implement in all pages
22-May-2018 09:24:PM by: pritham9
22-May-2018 08:20:PM by: trevorh
22-May-2018 08:19:PM by: trevorh
:P272_VALUESLIST doesn't work either I presume? You might need to try something like `where values in (select * from(apex_string.split(:P272_VALUESLIST, ','))`
22-May-2018 08:19:PM by: trevorh
by just now I mean technically 23 minutes ago according to the git logs :wink:
22-May-2018 07:34:PM by: krisrice
oh rly! I've been try to get team members to use git + gitlab, I'd be very interested in that.
22-May-2018 07:33:PM by: trevorh
As @trevorh mentions those 2 scripts apxexp/apximp could be use together to sling an import to/from envs. I just now set on up to export using sqlcl inside a gitlab pipeline
22-May-2018 07:32:PM by: krisrice
SQLcl is da bomb
22-May-2018 07:31:PM by: krisrice
oh :slightly_smiling_face: there he is!
22-May-2018 07:31:PM by: trevorh
I've seen @krisrice about here on slack as well, so you might potentially be able to ask him questions about using SQLcl
22-May-2018 07:31:PM by: trevorh
see apxexp.js and apximp.js
22-May-2018 07:29:PM by: trevorh
And there are scripts for SQLcl to export and import Apex applications here:
22-May-2018 07:29:PM by: trevorh
@akashbr I believe this white paper has a section on automated exporting:
22-May-2018 07:27:PM by: trevorh
How to export the application from DEV to INT and INT to PROD automatically, for time being I am doing this process manually by exporting and importing the application which is not the best solution to do. Can you please explain me the process of achieving it with an example. Thank you in advance
22-May-2018 08:47:AM by: akashbr
@maxime_tremblay in my case the minified file was the issue, now it works , excellent, thank you so much.
22-May-2018 03:07:AM by: uyogi2008
if the file you changed also as a corresponding minified file, you will need to rebuild it as APEX is going to be using the minified file by looking at the plugin’s github repository, all JS file have a minified version. so that’s another possible reason why it’s not working I also like to rename the new file (I usually append something like `-custom`) and add it to the plugin, it can be useful when upgrading the plugin
22-May-2018 01:28:AM by: maxime_tremblay
The overall process is correct. It might be a browser cache problem.
22-May-2018 01:09:AM by: maxime_tremblay
I am using a plugin "Mailgun Email Validator" to validate the email address. I wanted to modify one of the javascript of that plugin to suppress an error message. Steps for plugin javascript modification is : On the Workspace home page-> Application Builder-> Application home page-> Shared Components-> Plug-ins. Click the .js file which has to be modified, Delete it & uploaded the new file-> Click Apply changes After clicking on apply changes, I get a message on the top as "0 rows updated 0 rows deleted" After execution, the changes I wanted is not reflecting on the page. Am I doing the plugin java script upload wrongly? do I miss any other step in this?
21-May-2018 09:44:PM by: uyogi2008
@kathrynbrooksgamble Awesome!
21-May-2018 12:52:PM by: sspendol
@sspendol APEX_050100 had lost the privs on sys objects (compared to non- upgraded system). I've reapplied those and we are back in business. Thanks very much for your help.:+1:
21-May-2018 12:52:PM by: kathrynbrooksgamble
@kathrynbrooksgamble That’s an important package, and not sure why it’s not recompiling based on those other objects. You may want to open an SR with Oracle to further diagnose what’s going on.
21-May-2018 12:36:PM by: sspendol
@sspendol There is one invalid package WWV_FLOW_F4000_PLUGINS which won't recompile These are the errors : • Error(2136,8): PL/SQL: Statement ignored • Error(2136,13): PLS-00201: identifier 'SYS.DIANA' must be declared • Error(2139,8): PL/SQL: Statement ignored • Error(2139,31): PLS-00201: identifier 'SYS.DIANA' must be declared • Error(2234,17): PL/SQL: Statement ignored • Error(2236,40): PLS-00201: identifier 'L_ITEM.NAME' must be declared • Error(2391,25): PL/SQL: Statement ignored • Error(2393,48): PLS-00201: identifier 'L_KEYWORD.KEYWORD' must be declared • Error(2483,5): PL/SQL: Statement ignored • Error(2484,19): PLS-00201: identifier 'L_LAST_TYPE' must be declared
21-May-2018 12:34:PM by: kathrynbrooksgamble
@kathrynbrooksgamble Check to see if there are any invalid objects - particularly in the APEX_050100 schema. If so, recompile and see if that does the trick.
21-May-2018 12:17:PM by: sspendol
@kathrynbrooksgamble Has whatever is hosting ORDS been restarted? Had similar issues before where ORDS wasnt fully shutdown and started back up again
21-May-2018 12:17:PM by: shaun.mauer
@shaun.mauer - sorry 3.0.9 is the ORDS version
21-May-2018 12:16:PM by: kathrynbrooksgamble
@shaun.mauer Yes ORDS 4 . All the applications are fine. But in designer I cannot edit any page when I edit any page (even page 0) and I cannot create a new app.
21-May-2018 12:16:PM by: kathrynbrooksgamble
@kathrynbrooksgamble How are you accessing Apex? With ORDS?
21-May-2018 12:10:PM by: shaun.mauer
@sspendol Its all the applications - its the apex designer itself that's throwing the error so there's nothing in the Debug under Utilities. Is it a known issue when upgrading from 12.1 to 12.2?
21-May-2018 11:58:AM by: kathrynbrooksgamble
21-May-2018 11:56:AM by: kathrynbrooksgamble
@kathrynbrooksgamble Edit the application that is throwing the error and then select Utilities > Debug Messages
21-May-2018 11:52:AM by: sspendol
My DBA has upgraded the database from 12.1 to 12.2 Now Apex apps still work fine but when I go into the Apex designer and try to edit a page I always get "Error in PLSQL code raised during plug-in processing." Contact your administrator. Details about this incident are available via debug id "xxxxx". How do I access this debug information?
21-May-2018 11:28:AM by: kathrynbrooksgamble
because, the way to do it is to add an icon in the post element text that will, when clicked, changes the item type from a password type to a text type and back to a password when clicking again. if you need to have it everywhere, you can do the above using an on page load JS function that will add the icon after the item for every page in your app
18-May-2018 09:36:PM by: maxime_tremblay
do you want/need to do it for all password items in an application or only the one on the login page?
18-May-2018 09:33:PM by: maxime_tremblay
Hi. Is there a way to show eye icon next to password field so when user clicks on it password is visible to validate?
18-May-2018 08:00:PM by: pritham9
Hi guys, The rich text area is saving data with html entities for ex : £ for £ symbol. Is there any way to escape these html entities while saving into db? I am currently using AR P processing to save data.
18-May-2018 11:42:AM by: ashwinrao
Dear @doug.a.gault @patrickwolf_oracle if this issue is difficult for fixing then I kindly ask you to say what workarounds could be applied for solving it (I need to use more than 2 Interactive grids on the page ). Thank You!
18-May-2018 08:11:AM by: ilia_g
Each time I make a modification on IG public report (I set an authorization scheme), I have to refresh the page to have the save ,edit and delete button enable. I wonder how the authorization scheme is evaluated to enable the buttons.
17-May-2018 04:55:PM by: phanny
Yup.. Definitely reproducible. @patrickwolf_oracle you want to have a look at this??
17-May-2018 03:04:PM by: doug.a.gault
Unfortunattly the issue is there (( I used Chrome 66.0.3359.170 user = guest passwor = demo2018 User action (After page load) - steps - for rows in 1st region: 1. Step1: 1.1 "Department" - click "ACCOUNTING" 1.2 "Employess" - double-click: - MILLER - KING - CLARK 2. Step2: 2.1 "Department" - click "SALES" 2.2 "Employess" - double-click: - "SMITH" - "ADAMS" ... Error in console : Uncaught TypeError: Cannot read property 'serverOffset' of null Uncaught TypeError: Cannot read property '7521' of null at Object.getRecordMetadata If no error now - do next step for "Department" = SALES etc. Error will occur (( The same error in Chrome 66.0.3359.181 and IE 11.0.9600.19003 also
17-May-2018 02:26:PM by: ilia_g
I’m not seeing the error you’re describing. I’ve followed the steps you outlined and I’m not getting any console errors at all. I used both Chrome 66.0.3359.139 and FireFox 59.0.2
17-May-2018 01:35:PM by: doug.a.gault

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
Udit Nagpal
23-May-2018 09:31
legacy component view button in oracle apex 18.1
7 replies - last reply: - by:
23-May-2018 09:30
how i get host ip
6 replies - last reply: - by:
23-May-2018 08:50
Apex 5.1.3 intercative grid - prevent, dynamically, editing some cells
1 replies - last reply: - by:
David Cleverl
23-May-2018 08:42
Problem displaying a Spinner on Page Load using apex.widget.waitPopup();
1 replies - last reply: - by:
23-May-2018 07:38
Always Redirecting to Apex Home page from EBS
2 replies - last reply: 23-May-2018 08:17- by: fac586
23-May-2018 07:36
User message notification for warning and information
1 replies - last reply: 23-May-2018 07:36- by: user5108636
23-May-2018 07:21
Open a *.pdf on a network drive and upload limit
0 replies
23-May-2018 05:39
Using Global Temp Table in apex
5 replies - last reply: 23-May-2018 07:57- by: fac586
23-May-2018 03:30
Link APEX_ERROR with alert region
2 replies - last reply: 23-May-2018 08:15- by: Prashanth Raju-Oracle
22-May-2018 23:29
Unable to access token link for RESTFul services
1 replies - last reply: 23-May-2018 04:20- by: Alli Pierre Yotti
22-May-2018 19:17
User profiles
1 replies - last reply: 22-May-2018 19:54- by: fac586
22-May-2018 17:48
IR Subscription - No Data
1 replies - last reply: 22-May-2018 19:26- by: fac586
Daljit R
22-May-2018 17:15
APEX 5 Custom Branching from an Error Page (within a Dialog)...
0 replies
22-May-2018 16:17
Select list with query.
5 replies - last reply: 22-May-2018 19:05- by: oratechs
22-May-2018 14:50
Create a help icon on the report heading of a tabular report
2 replies - last reply: 22-May-2018 17:39- by: fac586
Rumburak 9000
22-May-2018 13:03
BUG? Curly braces in URL-Parameter success_msg
0 replies
22-May-2018 11:16
Handling REST Requests (POST, PUT)
3 replies - last reply: 23-May-2018 04:24- by: Alli Pierre Yotti
22-May-2018 09:58
Save disabled items in Interactive Grid
4 replies - last reply: 22-May-2018 20:56- by: John Snyders-Oracle
22-May-2018 05:20
APEX_ERROR api warning and process execution
15 replies - last reply: 23-May-2018 07:58- by: user5108636
21-May-2018 22:50
Popup LOV or Select List returning multiple columns
4 replies - last reply: 22-May-2018 23:34- by: jacknomiz
21-May-2018 15:10
Increase Row Height of Heading Rows of IG Oracle APEX
13 replies - last reply: 22-May-2018 15:30- by: DSteele41
21-May-2018 14:55
Event after page is loaded
17 replies - last reply: 23-May-2018 08:07- by: fac586
17-May-2018 09:44
how to open apex page in new window when calling from ebs
1 replies - last reply: 23-May-2018 07:50- by: 3684251
Soukaina IDRI
16-May-2018 13:02
How to use customized Font Awesome in Navigation Menu
7 replies - last reply: 22-May-2018 13:54- by: Soukaina IDRISSI
11-May-2018 10:12
BUG: 18.1 on Failed to execute Change Multiple Components > Region
2 replies - last reply: 22-May-2018 17:46- by: fac586


Ferenc Toth    
New Plug-in: Full Year Calendar
Calendar, Plug-ins
23-May-2018 13:06:01 by: Juergen Schuster
Nihad Haskovic  
APEX and Google Maps
21-May-2018 21:37:22 by: Juergen Schuster
Franco Soldera  
Machine Learning
19-May-2018 20:06:17 by: Juergen Schuster
Tim St. Hilaire  
APEX Auth-N Authentication with Oracle Identity Cloud Service (IDCS)
18-May-2018 17:26:24 by: Juergen Schuster
Maxime Tremblay  
Lazy Loading Reports to improve felt performance
18-May-2018 12:41:23 by: Juergen Schuster
Mazin Abdulah  
Start with blank Interactive Grid
Interactive Grid
18-May-2018 11:53:24 by: Juergen Schuster
Dick Dral  
Generate Excel from HTML in APEX
17-May-2018 13:24:32 by: Juergen Schuster
Martin D'Souza  
16-May-2018 14:27:23 by: Juergen Schuster
JMJ Cloud Austin  
How Version 18.1 will help APEX win the Cloud
APEX 18, Cloud, REST
15-May-2018 22:36:52 by: Juergen Schuster
Lino Schildenfeld  
Google Maps in Interactive Report
Interactive Report, Map
15-May-2018 11:38:20 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: United Arab Emirates, Dubai, permanent
15-May-2018 09:02:05 by: Juergen Schuster
Scott Wesley  
Filtering outliers from Oracle APEX activity logs
Benchmarks, Logging, Performance
15-May-2018 08:53:12 by: Juergen Schuster
Matt Mulvaney  
Disabling Interactive Grid Columns
Interactive Grid
15-May-2018 08:38:55 by: Juergen Schuster
Mathias Magnusson  
Customized Help Text
09-May-2018 21:35:43 by: Juergen Schuster
Joel Kallman    
Is APEX suitable for Enterprise Applications
Architecture, Press
09-May-2018 10:18:36 by: Juergen Schuster
Menno Hoogendijk    
New Plug-in: Interactive Grid set values via Buttons
Interactive Grid, Plug-ins
08-May-2018 09:54:09 by: Juergen Schuster
Menno Hoogendijk    
New Plug-in: Open Close Inline Dialog
Modal / Inline Dialog, Plug-ins
08-May-2018 09:52:44 by: Juergen Schuster
Joel Kallman    
3 Reasons to go to malagAPEX
07-May-2018 09:58:43 by: Juergen Schuster
Carsten Czarski  
Twitter API in APEX
04-May-2018 12:39:07 by: Juergen Schuster
John Snyders  
Media Mega Menu
04-May-2018 09:36:49 by: Juergen Schuster
Denis Savenko    
APEX Alpe Adria - Was it worth it?
03-May-2018 11:48:10 by: Juergen Schuster
Scott Spendolini  Other
Webinar Secure Webservices. May 3rd.
02-May-2018 22:24:57 by: Juergen Schuster
Juergen Schuster    Other
Newsletter #23 is out!
02-May-2018 16:20:53 by: Juergen Schuster
Chris Saxon    Other
10 Part FREE SQL Online Tutorial
02-May-2018 16:09:01 by: Juergen Schuster
John Snyders    Other
Member of the Month: April, For another 2 excellent Blog Posts we all rely on
Member of the Month
01-May-2018 19:28:26 by: Juergen Schuster
Shane Bentz    Other
New Meetup: Madison, WI
01-May-2018 16:50:06 by: Juergen Schuster
Monty Latiolais  
18.1 Feature Ranking
01-May-2018 16:24:10 by: Juergen Schuster
Craig Sykes  
Integrating Chat Bots
Machine Learning
26-Apr-2018 12:36:33 by: Juergen Schuster
John Snyders  
18.1 New Region Features Sample App
APEX 18, Regions
24-Apr-2018 22:33:27 by: Juergen Schuster
Luka Gredelj    Other
New APEX Theme Style
Universal Theme, User Interface
23-Apr-2018 10:37:23 by: Juergen Schuster
Marc Sewtz    Other is upgraded to 18.1
21-Apr-2018 17:01:33 by: Juergen Schuster
John Snyders  
18.1 New Inline Popup
Modal / Inline Dialog
21-Apr-2018 13:53:43 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20