Slack

Hi All, I am facing an issue with the large datasets in the BI Publisher Desktop report. It works fine for normal datasets. Do you have any ideas on how to resolve this? *ORA-06502: PL/SQL: numeric or value error: character string buffer too small*
18-Mar-2024 06:40:AM by: Awais Majeed
Anyone with experience defining Oracle APEX REST APIs accessing OAuth2 based isolved APIs with bearer tokens and credentials? (Also posted a more detailed question in Oracle APEX developer forum)
16-Mar-2024 11:04:PM by: Joe Kerr
Hi all, We have a SIMPLE APEX application with 1 million rows in ONE Table. -Total 20 columns in table -No blob/clob or heavy data -Max column text size is VARCHAR2(1000) characters Application has only ONE FORM/report(IR) to view&edit this data. This app is downloaded to MOBILE on first browser access and edit data. At peak, we expect 700-1000 concurrent users logged in and searching data(all indexed columns)&updating data row by row. Btw, we are using simple custom Table stored USER/PWD authentication. How many EPCU we need to support and how much roughly it may cost in OCI? Is this(1000+ concurrent users) something OCI APEX can handle without any crash? Should we go for Oracle apex cloud or APEX in OCI? Appreciate any guidance Thanks
15-Mar-2024 04:00:PM by: Ravi Kiran
Why when using x01 in URL gives error? ```ERR-1002 Unable to find item ID for item "X01" in application "161496".``` Error is under: Utilities->Debug Messages->Debug Message Data
15-Mar-2024 02:58:PM by: Indrek T
Anyone have a way on a standard date picker within APEX 22.1 to allow selection of time along with the date?
14-Mar-2024 07:34:PM by: Tony Miller
Hello all, I've got a Sample Database Application installed on my instance, where I cannot access via browser. How can I remove this app including all the database supporting objects, like tables, triggers, packages, etc.? I've already prepared something like this, but I can't see any switch regarding the supporting objects actions ```begin apex_application_install.set_workspace('YOUR_WS'); apex_application_install.set_keep_sessions(false); apex_application_install.remove_application(100); commit; end;```
14-Mar-2024 12:03:PM by: Wojciech Sowa
It is the ONE thing it lacks!
14-Mar-2024 12:33:AM by: Blake
When will Apex have WYSIWYG editor like VBS?
14-Mar-2024 12:33:AM by: Blake
Hi all, need your help, want to use voice as a command in Oracle APEX page so that user will not be clicking any button rather user will be speaking on tab or mobile device, can you please guide on it, how it can be done, what are pre requisites, any plugin or something else
13-Mar-2024 02:28:PM by: Zahid Waheed
Hi all. I wanted to ask that i would like to create a seperate HELP page containing some text and images related to the Help regarding the application. How can i achieve that? Thanks. :slightly_smiling_face:
13-Mar-2024 09:07:AM by: Muhammed Sharjeel Arshad
Hey all, Quick question, I'm currently using Oracle Xe 21c and Apex 23.2, I know I have to pay support to get the latest patchsets for apex, but I cannot find where to register o sign up for this, can anyone help me?
12-Mar-2024 04:04:PM by: Isaac Lañado
Hi, I had a question regarding the bar-chart if someone can answer. Here *i want to display the names of the Series alongwith these 2 small boxes on the right side of the graph*. This is done from *Tooltip properties or i am missing some property* for this? Thanks
12-Mar-2024 08:18:AM by: Muhammed Sharjeel Arshad
Priority is fine. I don't need dates. Planned for next release, or 10 releases from now, might be handy
11-Mar-2024 06:06:PM by: Doug S
Has anybody accessed an ADB-S (private endpoint) APEX app on OCI via Site-to-Site VPN, private LB etc? Any tips greatly appreciated!
11-Mar-2024 05:11:PM by: Si
They will never say “when” (as a date). The best thing we can hope for is a priority list :wink:
11-Mar-2024 05:08:PM by: roelhartman
Anybody know if there is a publicly available roadmap for the VS Code SQL Developer extension? I see in the support forums there are often mention of "todo" items. Mostly trying to avoid creating discussion on things that are already planned, but knowing roughly when that feature might be released would be nice as well. Thanks!
11-Mar-2024 04:44:PM by: Doug S
• Hello, I am creating a Oracle E Business Suite connection in Oracle integration cloud, but while creating the connection I am getting error - "CASDK-0005: Verify if Metadata Provider service is deployed with alias 'provider' in Oracle E-Business Suite. Ensure that all its methods are deployed with GET verb. For possible resolution, refer Error Messages chapter in Using the Oracle E-Business Suite Adapter guide". So, to resolve this error I am trying to deploy 'Metadata provider" API in Oracle EBS application but now I am getting error - "java.lang.securityexception: user: asadmin~~<username>, failed to be authenticated." Can anyone help me to resolve this issue.
11-Mar-2024 11:00:AM by: Amruta Mohite
So if Oracle Sql Developer the desktop version is on the way out (from what I have heard, within next 2 years) and they want us using the web version or the VS version, what does that say as to the future of sql developer data modeler? Is it to be replaced too?
08-Mar-2024 04:36:PM by: Tony Miller
hello everyone , I have one template. In that template, I have questions, and the requirement is that the user wants to shuffle the questions using drag-and-drop functionality. For the template, I'm using an interactive grid.
08-Mar-2024 08:45:AM by: ABHIJIT
Hi all, Can someone give me information is it possible to configure the data loading processes to use newline characters as delimiters when uploading files? I don't see newline in the list of option provided for delimiters.
08-Mar-2024 07:25:AM by: Bojana Popov
Does anyone have a routine, given a starting date and an ending date, to provide a set of dates.. If I give 01-mar-2020 as starting point and 31-Mar-2024 as end date need to get a row for each month.. 01-Mar-2020, 31-Mar-2020 01-Apr-2020, 30-Apr-2020 ... 01-Mar-2024, 31-Mar-2024.. Has anyone done something like this before?
07-Mar-2024 10:02:PM by: Tony Miller
When doing a file download on a page, the standard practice is to: sys.HTP.init; sys.OWA_UTIL.mime_header(c_mime_type, FALSE); sys.HTP.p('Content-Length: ' || DBMS_LOB.getlength(l_blob_content)); sys.HTP.p('Content-Disposition: filename="' || l_filename || '"'); sys.OWA_UTIL.http_header_close; sys.WPG_DOCLOAD.download_file(l_blob_content); apex_application.stop_apex_engine; Now if I have this on a page submittal process, the success message is NOT displayed, since do the Stop_Apex_Engine call.. Is there a way to still get that success message displayed?
07-Mar-2024 07:43:PM by: Tony Miller
Hello there, I have dynamic navigation menu for the app. Each menu item calls a page. However, that page (for which there is a entry in navigation menu) navigates to many pages (kind of sub pages) and but on menu I show only one menu item. Now, while I am navigating to different pages, I want to show parent menu item as selected. How do I achieve this in dynamic menu query? I am using APEX 22.2. Please help. Thanks.
07-Mar-2024 11:30:AM by: maheshdm
Hello, We have developed a web application in oracle apex and the requirment is that HTTP Security headers like CSP, X-frame, HSTS shall be properly configured in the web application. could you please clarify below query. -Does oracle apex provide above functionality by default ? -If not then do we need to configure it manually at insatnce level or application level ?
07-Mar-2024 06:58:AM by: ABHIJIT
Hello,
07-Mar-2024 06:44:AM by: ABHIJIT
Hey ...I get below message in browser when I implement social sign in , in authentication schemes ,I put IDCS url in Discovery URL
07-Mar-2024 06:31:AM by: mayurmehar003
Dear apex gurus I am wondering how to conditionally show a navigation menu entry to contributors not to regular readers? Thanks in advance
06-Mar-2024 04:49:PM by: Yawei Li
Hello everyone, I have updated from Apex 20.1 to 23.2, and I've been encountering the error: 'Syntax error: Unexpected end of JSON input' in the Page Designer on some pages like error pages and on other pages as an error in a dynamic action. I have attached some photos. Does anyone know what might be happening?
05-Mar-2024 10:50:PM by: Alberto Barrio
@Jayson Hanes - Oracle APEX PM for resetting a password on for a cloud account, any (what should be valid) password is not acceptable and cannot even be submitted on this page. The list of requirements wont go away and it's throwing this uncaught error. If you know who to ping on this by chance?
05-Mar-2024 02:37:PM by: Matt McGee
Asked before an received answer of as_xlsx but wondering if ANYONE has attempted build multi-tab xlsx files via Oracle APEX & Pl/SQL? I know of Apex Office Print but looking at any OTHER alternatives..
04-Mar-2024 10:29:PM by: Tony Miller
If I have a dbms_scheduler job built to call a stored procedure and inside that stored procedure I am using an email template stored within an application, shouldn't I be able to access the template with apex_mail.send? Here isd the code I am using in stored procedure: apex_mail.send ( p_to => l_to_address, p_from => l_from_address, p_template_static_id => 'EUCG_ROLLOVER_REPORT', p_application_id => 104, p_placeholders => '{' || ' "FIRST_NAME":' || apex_json.stringify(l_first_name) || ' ,"LAST_NAME":' || apex_json.stringify(l_last_name) || ' ,"MY_APPLICATION_LINK":' || apex_json.stringify(l_url) || '}' ); Getting an error when procedure gets to sending mail saying it can't find the template in application 104..
04-Mar-2024 07:05:PM by: Tony Miller
I have configured apex instance to use smtp email, and I can send email with IR when using download option from action menu. But the IR subscription is not sending emails. I have checked there is no record on APEX_MAIL_LOG and APEX_MAIL_QUEUE. Any idea how to troubleshoot problem?
01-Mar-2024 09:48:PM by: Mclovin
https://twitter.com/JaysonHanes/status/1763617385397846053
01-Mar-2024 05:54:PM by: Jayson Hanes - Oracle APEX PM
It is trying to execute APPLICATION_PROCESS=getCurrentStatus"
01-Mar-2024 02:15:PM by: lschilde
only see tons of POST requests in network tab
01-Mar-2024 02:11:PM by: lschilde
We are running APEX 23.2 patch 3
01-Mar-2024 02:07:PM by: lschilde
anyone has seen this before when playing with working copies, Merge or compare come to this and stall where nothing ever happens. Basically anything on that drop down menu cases the same issue except with working copy details.
01-Mar-2024 02:07:PM by: lschilde
Hey everyone ! how can we implement Single sign on(sso) implementation in apex ?
01-Mar-2024 05:00:AM by: mayurmehar003
Hello! I have a newly created app in APEX 23.2.2 and I am trying to delete the Authorization Scheme "Reader Rights". I'm getting an error that it's utilized somewhere, but when I click on Utilization under Tasks, I can't seem to figure out where to "de-reference" it. Anyone have any ideas?
29-Feb-2024 08:34:PM by: EJ Egyed
Hi all, How can we delete the application computation using API during import to other environment. Anyone has info about the API please
29-Feb-2024 09:13:AM by: Malathi Sundaram
How can we make our application responsive on mobile phones , on desktop it is working fine .
28-Feb-2024 08:54:AM by: mayurmehar003
Anybody using multiple schemas inside a single workspace? Any gotchas to be aware of?
27-Feb-2024 10:18:PM by: Travis Caruth
greetings - i have what might be an artifact of older methods from older version of APEX, but want to verify with everyone. we just upgraded to version 23.1. this behavior happened before the upgrade and is still happening. i have an apex page based on the "Right Side Column" page template. this page has four interactive grids on it. the user can click a button that opens a region that is defined in the "right side column" page position. when the "right side column" region opens, the interactive grids resize to be smaller/thinner since the region is opening on the right. the user enters data into standard items in the region and click the "save" button within the region. the "save" button uses javascript and ajax to save the data to the database, close the region defined in the "right side column" position, and refresh the interactive grids as the data being saved may change the rows in those interactive grids. my problem is that sometimes (not always), the interactive grids do not resize to become their original full size when the region in the "right side column" is closed. the regions of the interactive grids resize to their original size, but the IGs within them stay retracted/thinner. i can't figure out the proper JS to call to get them to redraw back to their original widths. suggestions?
27-Feb-2024 04:35:PM by: Shane Bentz
Hello everyone, I want to integrate object storage into my Oracle APEX application on Oracle Cloud. Currently, the architecture consists of an instance with Apache Tomcat and a DB system where APEX is installed. I followed all the steps in a video that explained the process, but I'm facing an issue. In the screen to generate the REST Data Source of type Oracle Cloud Infrastructure (OCI), in the next step, it asks me to configure an Oracle Wallet. My question is, which certificate should I configure in that wallet for communication, or do I not need to configure any certificate?
27-Feb-2024 03:24:PM by: Alberto Barrio
Hi guy's I have one error, In oracle apex I'm using cards feature , In one card I'm showing no. of assigned task , so In that the card is loaded only one time while login that's why it is showing same count after deleting , but when I login again it is showing correct count , is there any solution regarding this , I have used events too still same issue I'm facing , Please help me out .
27-Feb-2024 12:24:PM by: Prashant
Hi,how can we freeze IG width i.e user will not able to change the width of column
27-Feb-2024 08:17:AM by: mayurmehar003
Has anyone encountered the situation when the user navigates to a new page and non of the form elements are rendered? Header and side menu are rendered correctly, just the page elements are non-existent, renders a blank page, so to speak. When user clicks refresh, the page is rendered fully and correctly.
26-Feb-2024 11:26:PM by: davoro
Do any of you fine APEX humans know how to set the height of a select list drop down? My list contains 19 rows and I'd like to see all of the rows. Is there an easy way to do that?
26-Feb-2024 08:32:PM by: J. Peter MacKay
So, I'm heading out to my retirement party - last day is Thursday. I think I first started working seriously in APEX in 2008 and it's (mostly) been a great ride. I'll probably continue to work a couple side-projects on apex.oracle.com, but not that much. I want to say to all here that it's been a pleasure working with you all - especially the APEX team, but also everyone else here who shares their knowledge and experience of this great product. Best wishes to you all.
26-Feb-2024 08:31:PM by: Stew Stryker
Hey everyone! I am trying to improve the performance of a query that I have that uses APEX_DATA_PARSER.PARSE but am struggling a little bit. I have a 26 MB XLSX file and I am just trying to figure out how to get the function to not store data into an APEX Collection. While monitoring during query execution, I see that a large amount of time is spent inserting into the table `wwv_flow_collection_members$` when I don't want it to. Does anyone have any ideas how to prevent that from happening? Currently returning 4 rows takes about 40-45 seconds to return. Below is the query I am using to test. In my real query I am passing the real file profile generating from parsing the file once. I am currently on APEX 23.2.2 and Oracle Database 19c ```SELECT * FROM apex_application_temp_files f CROSS JOIN apex_data_parser.parse (p_content => f.blob_content, p_file_type => 1, p_file_profile => '{...}', p_detect_data_types => 'N', p_skip_rows => 1, p_max_rows => 5, p_force_trim_whitespace => 'Y', p_nullif => 'NULL', p_store_profile_to_collection => 'N');```
26-Feb-2024 07:53:PM by: EJ Egyed

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
L_a_u_r_a
18-Feb-2022 16:16
Is it possible to submit EBS request set from APEX and get the request id for each request?
Link
User_TFX19
18-Feb-2022 15:54
APEX_WEB_SERVICE and client certificates?
Link
User_6X3A4
18-Feb-2022 15:38
Multiple drop downs in a page
Link
Munaf Rafique
18-Feb-2022 14:42
Error in Callback URL at apex and the below is the debug from sqlplus . can you please Help ?
Link
SmithJohn45
18-Feb-2022 13:55
IG: Dynamic Action sometimes not Set Value but sometimes does?
Link
PJ
18-Feb-2022 12:45
APEX - apex.server.process pass clob to client
Link
fac586
18-Feb-2022 09:56
BUG: UT 21.2: Search Engine pagination misalignment
Link
User_O8O4V
18-Feb-2022 09:39
YYYYMMDD Validation
Link
gernot1
18-Feb-2022 08:44
workspace login using http header variable authentication
Link
User_8849S
18-Feb-2022 07:25
Apex web service REST call returning null
Link
SmithJohn45
18-Feb-2022 04:56
IG: selected value thru PopUp LOV should not appear in next row
Link
User_NF3HC
18-Feb-2022 03:10
Authentication failed for REST Enabled SQL service.
Link
partlycloudy
18-Feb-2022 02:43
Auto dismiss notification messages - All pages
Link
Joe R
17-Feb-2022 18:48
Deploying an Application with Subscribed Authorization Scheme's - 21.2.3
Link
srgarg-Oracle
17-Feb-2022 17:41
Set Value DA -> Submit DA -> Processing
Link
partlycloudy
17-Feb-2022 16:56
Region button - Update click target
Link
Geert01
17-Feb-2022 08:25
Badge List: Change the blue color when hovering over the card
Link
Brad Chriss
16-Feb-2022 18:50
Close Dialog event
Link
Suat GURSES
16-Feb-2022 12:24
Oracle APEX Interactive Grid -Master/Child Table Issue
Link
Sushmitha Sun
16-Feb-2022 09:18
How to remove the default notification that comes when a process is successful
Link
Ace1
14-Feb-2022 13:57
Interactive grid dynamic sum in a total row
Link
Suat GURSES
23-Dec-2021 08:07
APEX BUG
Link
CaribbeanUser
26-Nov-2021 20:23
Setting a Popup LOV column in an interactive grid doesn't show the display value
Link
Amico
26-Jul-2021 13:33
After update to Apex 21.1.2 refreshing interactive grid duplicates rows
Link
Javier P
27-Jun-2021 07:57
Duplicate records showed in a result set of an Interactive Grid
Link

News

X
    
 
ImageNewsFavoriteForward
Monica Godoy    
New Office Hour: APEX Tutorials
Webinar
Link
15-Mar-2024 15:36:40 by: Juergen Schuster
Dimitri Gielis    Other
APEX Office Print 24.2 is out!
AOP
Link
14-Mar-2024 08:23:58 by: Juergen Schuster
Juergen Schuster  Other
New Job, Permanent, W2 only, USA, Alabama, Auburn
Jobs
Link
13-Mar-2024 15:16:02 by: Juergen Schuster
Matt Mulvaney  
Using AI to generate Theme Roller Styles
AI, Universal Theme
Link
13-Mar-2024 14:59:28 by: Juergen Schuster
Marc Sewtz    Other
23.2 Patch Set Bundle 4 is out! (35895964)
APEX 23, Bugs
Link
12-Mar-2024 03:28:57 by: Maxime Tremblay
Matt Mulvaney  
Enable REST calls to use your Virtual Private DB and tenant
REST, Security
Link
11-Mar-2024 17:59:19 by: Juergen Schuster
Kehinde Adeyemi  
Display image in Navigation Bar
Navigation
Link
08-Mar-2024 15:55:58 by: Juergen Schuster
Juergen Schuster  Other
New Job: Contract, Germany, Munich
Jobs
Link
08-Mar-2024 15:30:07 by: Juergen Schuster
Jon Dixon  
Saving Richt Text Editor via AJAX
Rich Text Editor
Link
08-Mar-2024 12:26:36 by: Juergen Schuster
David Anderson  Other
New Job: Experienced Oracle APEX Instructor, Part-Time Remote
Jobs
Link
06-Mar-2024 21:04:33 by: Juergen Schuster
Dimitri Gielis    
New Commercial Plug-in: FlowForms (24.1)
Plug-ins
Link
06-Mar-2024 18:47:38 by: Juergen Schuster
Richard Baldogi    
New Plug-in: APEX Scroll Progress Bar
Plug-ins
Link
06-Mar-2024 18:43:04 by: Juergen Schuster
Monica Godoy  
Workflow Options in APEX
Workflow
Link
06-Mar-2024 17:37:12 by: Juergen Schuster
Steve Muench  
JSON Duality View for APEX apps
JSON, REST
Link
06-Mar-2024 12:38:09 by: Juergen Schuster
Monica Godoy  
Oracle APEX Sample Document Generator App!
Cloud, Printing
Link
06-Mar-2024 01:43:44 by: Maxime Tremblay
Timo Herwix    Other
Member of the Month February: For 4 great blog posts!
Member of the Month
Link
05-Mar-2024 12:10:32 by: Maxime Tremblay
Timo Herwix  
PDF generation in OCI within APEX
Cloud, PDF
Link
04-Mar-2024 16:46:24 by: Juergen Schuster
Wojciech Sowa    
Free APEX Version in a Docker Container
Docker
Link
04-Mar-2024 16:43:00 by: Juergen Schuster
Vincent Morneau    
Apple revoked it's PWA decision!
Progressive Web Applications
Link
01-Mar-2024 20:23:31 by: Juergen Schuster
Vincent Morneau    
PWA not working in the EU with Apple
Progressive Web Applications
Link
29-Feb-2024 13:29:48 by: Juergen Schuster
Timo Herwix  
Social Sign On with MS Azure Office 365
Authentication, SSO
Link
29-Feb-2024 13:24:25 by: Juergen Schuster
Kris Rice  
PDF generation with OCI
Cloud, PDF
Link
27-Feb-2024 13:25:14 by: Juergen Schuster
Matt Mulvaney    
Convert page LOVs to Shared Components
LOVs
Link
27-Feb-2024 12:57:47 by: Juergen Schuster
Juergen Schuster  Other
New Job: Vienna, Austria, Contract
Jobs
Link
27-Feb-2024 12:51:54 by: Juergen Schuster
Timo Herwix  
Mastering Identity Lifecycle Management for OCI IAM and Azure AD
Security
Link
24-Feb-2024 16:55:43 by: Maxime Tremblay
Learco Brizzi    
APEX World conference program is out
Conferences
Link
23-Feb-2024 07:57:22 by: Juergen Schuster
Maxime Tremblay  Other
New Job: Permanent, USA, California, Redwood City
Jobs
Link
23-Feb-2024 00:44:28 by: Maxime Tremblay
Matt Mulvaney  
Hidden Colours in Redwood Light
Universal Theme, User Interface
Link
21-Feb-2024 13:31:34 by: Juergen Schuster
Juergen Schuster  Other
New Job: Contract, USA, Minneapolis
Jobs
Link
20-Feb-2024 18:18:25 by: Juergen Schuster
Chaitanya Koratamaddi    
APEX Cloud Pricing
Cloud
Link
19-Feb-2024 19:05:42 by: Juergen Schuster
Jon Dixon  
Load Data 5 times faster from OCI Object storage to your APEX app
Cloud, Data Loading
Link
16-Feb-2024 07:30:22 by: Juergen Schuster
Marc Sewtz  
23.2 Patch Set Bundle 4 is out! (35895964)
APEX 23, Bugs
Link
14-Feb-2024 21:07:20 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20