|
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
|