I facing issue JSON payload. JSON array is not parsing the object. How can make this JSON array as single value string instead of accessing as array? What I need to change for Payload? Please suggest. This is sample payload which I need to get the values. --- "Region":[ "Subsaharan Africa" ], "Country":[ "Zambia" ], "Sector":[ "Science", "Infra" ]
18-Jun-2019 10:06:AM by: Rishu
Hi All, In 18.2 APEX, the settings where we can set Null values for column whose type is Plain text (based on Lov) is missing. Can you suggest whether it is a bug or there is some different setting? I have checked in my 12c app and I used to get the following settings as shown in screenshot. I want to hide entire column when it is ‘-‘ but for Lov types, I am getting NULL and not ‘-‘. I have set report attributes Show null values as - which is not working in case of Plain text (based on Lov).
18-Jun-2019 09:49:AM by: Kinjan Bhavsar
Do you mean the JS library or the plugin? Plugin acting strangely like it removes the value on mouse hover. Do you have example that you can share with me for the setter and getter parts? Many thanks.
18-Jun-2019 06:40:AM by: Yunus
I’ve been using autonumeric for these kind of things and it’s been working really great when getting/setting the values though, you will need to use the library’s getter and setter function
18-Jun-2019 12:41:AM by: maxime_tremblay
Hi All, Is there a way to remove bold when we click on radio button.
18-Jun-2019 12:03:AM by: pritham9
Hello everyone, I want to implement numeric format for weight and currency fields in my application with digit and thousand seperator. I also need to implement Set Value action for those fields; so that when user enters the value, I will make some automatic calculations based on the values. So far I tried, default apex formatter, autonumericJS and its plugin, but all of them became problem with Set Value action. Either invalid numeric error, or NaN in JS. I would like to use regex but don't know how to integrate. So any ideas? How can I implement currency and amount numeric fields that has digit and thousand seperator and works with set value actions? Any thanks appreciated. I've been trying this for so long.
17-Jun-2019 12:39:PM by: Yunus
Hi All, When i set long label in Floating items it goes to out side items, I want to break it after items end. i try with CSS "break-word" but not works, This issue in all items of apex which has set template Floating items,
17-Jun-2019 12:00:PM by: mayurvaghasiya22
You are welcome. And yes, it checks it on the server.
17-Jun-2019 10:49:AM by: dietmar.aust
Thanks for your help and quick response
17-Jun-2019 10:48:AM by: Prashanth
Thanks. It works. It requires the page to submit to fire the validation. I was under the impression that it works similar way like Textarea char limits
17-Jun-2019 10:48:AM by: Prashanth
You can also create a simple example on and give us temporary access to your workspace ... so that we can fix it. But it worked for me right out of the box.
17-Jun-2019 10:42:AM by: dietmar.aust
try to create a new application with a single page and one RTE. Try it there. Does it work?
17-Jun-2019 10:41:AM by: dietmar.aust
@dietmar.aust I changed the application compatibility mode to 19.1. Still, the RTE accepts text more than Max Length value. Is there any other settings which I missed?
17-Jun-2019 10:39:AM by: Prashanth
What you could do is have the link submit the page and call your process on page submit
15-Jun-2019 07:50:PM by: maxime_tremblay
I mean to say is this possible to call oracle plsql procedure in apex url ?
15-Jun-2019 06:11:PM by: Sahil
what do you mean call your proc on the url?
15-Jun-2019 05:10:PM by: maxime_tremblay
Respected all, There is a apex url in my classic report i want to call my proc on that apex url is this possible? If yes please share any link or guide
15-Jun-2019 04:10:PM by: Sahil
14-Jun-2019 05:27:PM by: Renato Nobre
Anyone know the best way in APEX to playback and .wav file stored in the database as a BLOB
14-Jun-2019 04:05:PM by: mrgaddy
Thanks. I will try this.
14-Jun-2019 06:12:AM by: Prashanth
Hi All, I built an APEX 5.0 application integrated with Oracle EBS. User navigates to APEX application from Oracle EBS responsibility. It does have any Authentication scheme. Authorization Scheme attached to the application checks if user has a valid Oracle EBS session to view the application. User creates a transaction in APEX app and it sends an approval email using APEX_MAIL. Email contains basic transaction information in HTML tables. Now my questions are: 1. I want to include a hyperlink in the email body to allow approver to view transaction. When I click on the hyperlink added using APEX_UTIL.PREPARE_URL and primary key to view transaction, I get authorization scheme violation error since I don't have valid EBS session. Alternative I thought is to create a duplicate standalone APEX app with no authorization but authentication scheme based on EBS API fnd_web_sec.validate_login to validate EBS credentials. Disadvantage of this approach is duplication of code. 2. Other requirement is to approve the transaction directly from email. I'm not sure how I can achieve this without going to transaction page. Please advise. Thanks.
13-Jun-2019 03:18:PM by: Kishore Ryali
There is no counter, though.
13-Jun-2019 03:09:PM by: dietmar.aust
Starting with APEX 19.1 it now respects the maximum length. But you need to switch the compatibility mode to 19.1 in order to make it happen.
13-Jun-2019 03:08:PM by: dietmar.aust
Thank you Maxime, The tabular form works. It just take me long time to check every time it's not functioning. I will play this log process. Appreciate your help!
13-Jun-2019 03:05:PM by: reps
Hi All, How can I display a Character Counter in Rich Text Editor item like how we have the setting in TextArea? I want to restrict the length of the RTE to 3500 chars. Adding it in "Maximum Length" attribute is not working for RTE and it accepts more than 4000 chars. I am in APEX 19.1
13-Jun-2019 02:33:PM by: Prashanth
Great - thanks @doug.a.gault!
13-Jun-2019 01:43:PM by: gilcrest
There are a number of APEX Specific hosting companies that are probably better for a small application than the Oracle Cloud is at the moment. You can find a list of them here: Can’t really point you to one in particular, but maybe others here have recent experience they’ll share.
13-Jun-2019 01:40:PM by: doug.a.gault
hey everyone - it's been a while since I've dabbled in Apex, but it looks like it's thriving! I'm considering building an apex app for a client of mine. I'm trying to understand what are the best options for a really small shop, with minimal transaction load in the cloud, but am baffled by Oracles cloud pricing options... What are people using these days to host a small oracle db/apex app in the cloud?
13-Jun-2019 01:31:PM by: gilcrest
can anyone help that how to highlight row in IG using dynamic action or javascript api??? can anyone give example for how to use $( ".selector" ).grid( { highlights: { "hlid0001": { seq: 1, row: true, color: "#FF7755" }} } );
13-Jun-2019 10:06:AM by: Zahid Waheed
```begin if :apex$row_status = 'C' then ...log insert method... elsif :apex$row_status = 'U' then ...log update method... elsif :apex$row_status = 'D' then ...log delete method... end if; end; ``` make sure that you set the corresponding tabular form region for the corresponding attribute
13-Jun-2019 01:10:AM by: maxime_tremblay
has this tabular form ever work? what you could do is add a custom plsql process that could be used to log everything
13-Jun-2019 01:02:AM by: maxime_tremblay
eg. I have two PK in this view of page. But I configured 1 as "Hiden Column", then if I click "Apply Changes" button, this field will not send to backend. So many other rows will also get updated. But is there a way I can debug this, to see the update query it's sending backend, so I can see I'm missing the one PK in the query
12-Jun-2019 08:43:PM by: reps
Thanks for the quick reply. I just click the apply changes button but no changes made. I know it could be the trigger is not working. But I also want to know how to debug it, to see what exactly it's doing with the backend
12-Jun-2019 08:34:PM by: reps
can you describe the problem are you having?
12-Jun-2019 08:32:PM by: maxime_tremblay
Does anyone still use APEX 5, and know how to debug the Tabular Form? Like how the MRU process is doing, is there a way to see the actual update query it's running? Thanks
12-Jun-2019 08:31:PM by: reps
You need to create manual data save process.
12-Jun-2019 04:35:PM by: mayurvaghasiya22
Please help!!
12-Jun-2019 04:08:PM by: lavanya.seshadri

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
18-Jun-2019 08:51
Dynamic Pagination for an IR
0 replies
18-Jun-2019 08:22
How can i process IG Data in PL SQL
2 replies - last reply: - by:
18-Jun-2019 05:41
save updates of multiple rows in editable IG [APEX19.1]
0 replies
17-Jun-2019 22:41
Interactive grid - conditional rows display
0 replies
17-Jun-2019 18:26
Data upload
1 replies - last reply: 17-Jun-2019 18:26- by: DSJ-Oracle
Ambika Dayal
17-Jun-2019 18:13
Interactive Grid validation check fails for saved private and public reports
0 replies
17-Jun-2019 17:53
IG: How to change dynamically Fixed Report Height
4 replies - last reply: 18-Jun-2019 08:01- by: Oleh Tyshchenko
Phil Cannata-
17-Jun-2019 15:49
What is region name "emp" in the IG Cookbook Update Selection page?
2 replies - last reply: 17-Jun-2019 16:09- by: Phil Cannata-Oracle
17-Jun-2019 15:20
Use of &DEBUG. in classic reports
0 replies
17-Jun-2019 15:01
No wallet required by
4 replies - last reply: 18-Jun-2019 07:57- by: Prog1024
17-Jun-2019 14:24
Sending 'Apply' to IR's Dialog
2 replies - last reply: 18-Jun-2019 07:12- by: Lucio_07
Jose Aróstegu
17-Jun-2019 11:48
How to trigger total recalculation of an IG sum from a non IG text item?
0 replies
Lee Burgess
17-Jun-2019 10:28
identifying and tagging hyperlinks in a text field
5 replies - last reply: 17-Jun-2019 13:27- by: fac586
17-Jun-2019 10:04
is tree in apex 18.2 cannot be refresh by dynamic action ?
2 replies - last reply: 17-Jun-2019 15:06- by: ReemaPuri
17-Jun-2019 09:56
Reflect column name on dynamic query
9 replies - last reply: 17-Jun-2019 15:33- by: 3479158
17-Jun-2019 06:46
How to make page items' border look different by making a single change at application level
18 replies - last reply: 18-Jun-2019 07:58- by: Srini.S
17-Jun-2019 04:28
Interactive Grid- if I add columns in to the grid, the download doesn't show these columns
1 replies - last reply: 17-Jun-2019 11:46- by: Laure Tchagam
17-Jun-2019 01:31
Tabular form "data is too old" in APEX 19 after validation error
3 replies - last reply: 17-Jun-2019 17:35- by: Carsten Czarski-Oracle
Phil Cannata-
15-Jun-2019 12:26
Sample Interactive Grids, Form with Grid (page 34) Saving to Database
3 replies - last reply: 17-Jun-2019 12:48- by: Phil Cannata-Oracle
15-Jun-2019 09:26
Apex transformation rule data load
2 replies - last reply: 17-Jun-2019 17:57- by: Tonito99
14-Jun-2019 15:05
Facing challenge.Yesterday It was success and Today failing badly.Is this Bug in Web Source Modules
6 replies - last reply: 14-Jun-2019 15:05- by: harish_sharma
Sameh M. Sewi
13-Jun-2019 12:59
Arabic Characters in PDF displayed as # and in download to CSV displayed as ¿
0 replies
Thomas Zink
12-Jun-2019 20:27
Interactive Report - Page reloads when press the built in download button and don't get a download
6 replies - last reply: - by:
05-Jun-2019 13:42
APEX 18.2 Radiogroup/List of Values
35 replies - last reply: 17-Jun-2019 19:20- by: cgrav
21-May-2019 10:49
Upgrade 18.2 to 19.1 - ORA-06512: at "APEX_190100.WWV_INSTALL_API", line 440
6 replies - last reply: 17-Jun-2019 14:31- by: 2891811


Morten Braten  
Custom Theme Style performance
Performance, Universal Theme
16-Jun-2019 20:17:18 by: Juergen Schuster
Jason Straub  Other
Video Office Hours: APEX and Multitenant
Installation, Videos
16-Jun-2019 11:36:03 by: Maxime Tremblay
Morten Braten  Other
Use SINCE_SHORT for compact time format mask
Interactive Grid, Interactive Report, Reports
16-Jun-2019 10:51:03 by: Juergen Schuster
Morten Braten  Other
Get a separator into a submenu
15-Jun-2019 18:29:24 by: Juergen Schuster
Hayden Hudson  
Bypass login for unit testing with
14-Jun-2019 20:25:09 by: Juergen Schuster
Jeffrey Kemp  
Before Header Branch
14-Jun-2019 07:02:36 by: Juergen Schuster
Jeffrey Kemp  
Showing image thumbnails in Icon View
Images, Interactive Report
13-Jun-2019 12:12:54 by: Maxime Tremblay
Dimitri Gielis  
Why you don't see the apex_debug messages in SQL-Developer
11-Jun-2019 14:24:59 by: Juergen Schuster
Jaydip Bosamiya  
Stop loading indicator on validations in a Modal Dialog
Modal / Inline Dialog
10-Jun-2019 17:48:57 by: Juergen Schuster
Ahmed Alsaied    Other
New Training in Arabic
09-Jun-2019 16:16:00 by: Juergen Schuster
Roberto Capancioni  
Creating an Authorization App Part 1
08-Jun-2019 16:20:47 by: Juergen Schuster
Jason Straub  Other
Office Hour: APEX on Multitenant, June 13, 10:00 EDT
Installation, Videos
08-Jun-2019 01:17:40 by: Juergen Schuster
Maxime Tremblay    Other
Newsletter #36 is out!
07-Jun-2019 20:59:05 by: Maxime Tremblay
Marko Gorički  Other
Fix the case for the username
07-Jun-2019 10:42:58 by: Juergen Schuster
Niall Mc Phillips  Other
Sending status 301 for moved pages
06-Jun-2019 15:57:37 by: Juergen Schuster
Daniel Hochleitner  
Find out if your APEX session has been cloned
04-Jun-2019 10:43:36 by: Juergen Schuster
Michelle Skamene    Other
Member of the Month, May: For her 3 excellent blogposts
Member of the Month
03-Jun-2019 14:27:54 by: Maxime Tremblay
Lucas Rayner  
APEX Exception Handling
API, Error
01-Jun-2019 19:43:42 by: Juergen Schuster
Hayden Hudson  
Get through APEX Login with Jmeter
Testing, Videos
31-May-2019 18:11:48 by: Juergen Schuster
Jackie Mcilroy  Other
New Job Offer: Malaysia, Selangor, Contract
29-May-2019 01:49:23 by: Jackie Mcilroy
Jeffrey Kemp  
Autoformat Numbers in Interactive Grid
Interactive Grid
28-May-2019 08:28:52 by: Juergen Schuster
Michelle Skamene  
Share Navigation Bar across applications
28-May-2019 08:26:52 by: Juergen Schuster
Aljaz Mali    
Sample Data Sets
Applications, Installation
27-May-2019 18:38:19 by: Juergen Schuster
Przemyslaw Kantyka  Other
Video Interview: SVN integration in Application Builder
Versioning, Videos
27-May-2019 11:55:19 by: Juergen Schuster
Aljaz Mali  
Page Utilities
Application Builder
24-May-2019 14:57:29 by: Juergen Schuster
Jeffrey Kemp  
Hide HTML when exporting from Interactive Report
Excel, Export, Interactive Report
23-May-2019 11:33:20 by: Juergen Schuster
ali saleh    Other
New 19.1 Training in Arabic
20-May-2019 07:45:46 by: Juergen Schuster
Dietmar Aust  
Why I left the Oracle ACE program
18-May-2019 18:32:58 by: Juergen Schuster
Carsten Czarski    
APEX at ODTUG Kscope19
17-May-2019 14:57:10 by: Jackie Mcilroy
Michelle Skamene  
Mega Menu
17-May-2019 14:53:56 by: Jackie Mcilroy
Tim St. Hilaire  
REST Basic Authentication
Authentication, REST
16-May-2019 11:09:36 by: Juergen Schuster
Joel Kallman    Other
APEX URL Shortcuts
15-May-2019 12:19:40 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20