Slack

Hello everyone, I am new in Oracle apex. Need your help i am facing this below error msg during run my application. I am going to create master detail form. I
15-Oct-2024 01:34:PM by: Yousaf
@Indrek T Speaking of AI, I just tried to convince ChatGPT to generate a query that calculates today + N days, excluding weekends... the results weren’t great. So, I had to rely on my own intelligence for the task... Bloody free AI! Here’s the query in case anyone needs something similar—it works both ways. Any improvements are welcome; I aim for perfection. ```SELECT d FROM ( SELECT d, ROWNUM rn FROM ( SELECT sysdate + ( ( level ) * abs(:p_offset) / :p_offset ) d, TO_NUMBER(to_char(sysdate +(level), 'D')) AS target_date FROM dual CONNECT BY level <= abs(:p_offset) * 2 ) WHERE target_date NOT IN ( 1, 7 ) ) WHERE rn = abs(:p_offset);```
15-Oct-2024 10:08:AM by: lucashir
Hi all, is it possible to create a grouped stacked barchart like this? Somehow I cant group the stacked bars.
15-Oct-2024 08:42:AM by: Nitec
Trying to create D-link between Oracle generic setup with APEX and AWS Postgres DB - able to establish connection, but it times out very quickly. 1. IS anyone using PG as a connected DB 2. Has anyone experienced this issue and found a workaround/fix for it. I can provide additional details, just wanted to get the question out there as we are evaluating moving to APEX.
14-Oct-2024 01:18:PM by: Steve DeYoe
Subject: Google Authentication not working in Oracle APEX application after upgrade. I have an Oracle APEX application with Google Authentication. https://dev.acolyteapplications.com/. The environment configuration is... Platform: Oracle Linux8 in OCI Database: Oracle 23c APEX: 23.2 ORDS: 21.4 installed on second Oracle Linux8 in OCI. I created a new upgraded environment and imported same application. https://acolyteapplications.com/. The new environment configuration is... Platform: Oracle Linux9 in OCI Database: Oracle 23ai APEX: 24.1 ORDS: 24.3 installed on second Oracle Linux9 in OCI. I am getting error: Null username passed to login procedure. When I set Debug Level to APEX Trace, there is NO error and authentication works fine. I tried by setting Debug Level to Application Trace, error is there as below. I find it very strange the by changing Debug Level, application behaves differently. Kindly help. Any suggestion is very appreciated. ```Exception in "POST https://oauth2.googleapis.com/token": Error Stack: ORA-01841: (full) year must be between -4713 and +9999, and not be 0```
12-Oct-2024 09:25:AM by: Abhishek Arora
I have a Smart Filter page and a Faceted page both equipped with the same query and filters/facets. The page works, search is great. The filters/facets correctly filters the results down as desired. With one small exception. We have a Date Picker range filter/facet as described here: https://blogs.oracle.com/apex/post/date-picker-support-241 that we implemented shortly after upgrading to 24.1. We noticed that when you use the Date Picker range filter/facet, all the other filter chips disappear and the other facet areas become empty. The date range filter is working. And if we have other filters/facets selected before using the Date Picker range those selections are still active and working. After looking at the animated screenshot at the end of the blog post, I noticed that their other smart filter chips also disappear. Is this intended functionality?
11-Oct-2024 09:20:PM by: Derek Anderson
I read in an Oracle forum that there is no effective upper bound for number of pages that can be created in an application - but, in terms of best practice... is this a good idea? I am looking at replacing a screen written in forms that has a tree menu. There are 61 menu entries, 485 reports and 137 forms. At the moment I'm basically just calling the Oracle Reports as is so that part is done (for now). With respect to the 137+ pages that will be created to replace the 137 forms, is that unwieldy for maintenance or not a big deal? Is it preferable to have each form re-written individually? What does that do for the behavior of the apps. Does switching from one to another require you to re-authenticate? I'm trying to avoid unnecessary re-authentication as well. Any thoughts appreciated. [EDIT] - it seems I can use Session Sharing to avoid re-authenticating... In some cases, the user may have to re-authenticate because it's a completely different app. In those cases I'd probably create the app in a different work space to further bring home how separate the app is. Does this work?
10-Oct-2024 07:49:PM by: Fernando Luna
i want to create a search filed on top of classic report, where that search filed should give me matched results, from which i can select one.. i mean search filed should have like operator functionality..
10-Oct-2024 12:56:PM by: Harsha Vardhan Reddy
Hi Team,
10-Oct-2024 12:53:PM by: Harsha Vardhan Reddy
Hi Guys, is there anybody out there who might have a clue how to connect apex rest data source to Docuware DMS? i tried various approaches, none of them lead to a positive result. I cannot successfully request a auth token. Testing the REST API with Postman works like charm. After deeply inspecting logs of APEX and Docuware maybe i found the root cause Docuware expects "username" and "password" attributes in the connect/token request APEX API apex_web_service.oauth_authenticate only provides "ClientID" and "ClientSecret" when sending the Request. I did not find any clue how to send the expected data. Any idea how i can overcome that problem? Maybe i can request the token using APEX_WEB_SERVICE.MAKE_REST_REQUEST calls. But how should i integrate this call into the REST Datasource definition so i can leverage the Shared Component for using them as valid Datasources for example in an IG
09-Oct-2024 02:26:PM by: p.ettinger
In APEX 24.1 Popup LOV acts differently then previously? I have Popup LOV that will return Additional Outputs. Previously when I did not open search and typed value into text field then search was made and Additional Outputs was returned, now it does not return Additional Outputs values. Only when I open search and pick a value
09-Oct-2024 02:15:PM by: Indrek T
Hello together - i have an other question today. Is there a possibility to download APEX Patches without an Support Identifier? I updated my ORDS today and now my SQLDeveloper Web struggles.... i'm on APEX 24.1 The Server has no connection to the internet and is only for internal use!
09-Oct-2024 11:30:AM by: Andi Oberhauser
In APEX 24.1.3 and 24.1.5 how to get date picker value in JS. `apex.items.P4_MY_DATE.value` will return `undefined` (for text and select itmes at least it will return value). Can be tested in apex.oracle.com Seems that `apex.items.P4_MY_DATE.getValue();` and `apex.item( "P4_MY_DATE" ).getValue()` works. is `apex.items.P4_MY_DATE.value` deprecated or BUG?
09-Oct-2024 07:33:AM by: Indrek T
Hello everyone, i have a litte question about Supporting Objects. I have an app and i want make an "License Check" before Installation or after the installation. I tried it with an Pre-Installation SQL Statement to check if the entry exists but it always fails. Any Ideas?
08-Oct-2024 10:56:AM by: Andi Oberhauser
In Apex 23.1 PopupLOV seem to have an inbuilt search functionality, where what a user types is used to restrict rows returned in the LOV where the entered user text is *anywhere* in the row of the LOV. ie under the hood, APEX does a like "%<entered text>%" Our users have stated they want it to only restrict rows where the entered text is "at the start of a field". ie like "<entered text>%" Has anyone had a similar request, and how did they go about it. I appreciate almost certainly a solution wont be able to be done with PopupLOV REgards,
08-Oct-2024 02:09:AM by: Alister Miller
With a tree implementation, how would I use prepare_url to create a link that is opened in a new tab (is there a way to inject target="_blank"_ into the prepare_url call maybe?) That is: Can I get the link that is used in the SQL query for a tree menu to open in a new tab? (Here is the Sample Trees app for context)
05-Oct-2024 12:20:AM by: Fernando Luna
anybody got an example of a sql query in a data load definition that references another column in that definition? the documentation isn't there, and they don't show any examples. i tried searching and found nothing.
04-Oct-2024 10:07:PM by: Travis Caruth
Hello all, I need a custom domain in my oracle application url, how can I get it. Can someone please help to get ut Example: my application is used for ticket booking. So, I want url like ticketbook.mycompany.com Thanks, Sridhar
04-Oct-2024 01:54:PM by: Sridhar Utukuri
If I have an interactive grid showing a number of columns and the last column is truncated with NO SCROLL bar, how can I add a scroll bar to region to allow users to see last of the column value?
04-Oct-2024 01:51:PM by: Tony Miller
Evening all... Is there a way to modify the error page that shows up when session state protection is violated?
04-Oct-2024 12:43:AM by: Fernando Luna
Good morning, folks: Have a question related to uploading a file and saving to a BLOB column. This all works just fine but I struggle with the mime type. I have a column in my table to store the MIME type but because it doesn't get populated at all, when it comes time to read the file itself it fails unless I update the database with the correct MIME type. Is there a way to detect what the MIME type is at the time the file is uploaded to the database? Is this something that should be done at the database level (via a trigger perhaps) or can APEX detect this in some way? [EDIT]. Googling suggests there is no perfect way to derive the MIME type from merely inspecting the contents of a BLOB file. Can APEX detect the file name in some way as it's being uploaded and perhaps I can just make the assumption that a PDF file is in fact a PDF mime type?
03-Oct-2024 06:54:PM by: Fernando Luna
Hey guys, how is it going? I'm having some trouble finding an example on how to use Oracle APEX web service to send data in a x-www-form-urlencoded format, more specifically how to add data to the body of a POST request for that format. Does anyone have a link or sample code to share?
03-Oct-2024 01:29:PM by: Paulo Künzel
hi everyone :slightly_smiling_face: have a scenario in which i have modal page and when i close the modal page i need to refresh the item in parent page or reload parent page. is this possible? i already tried refresh region on same scenario but cant success with this
03-Oct-2024 09:49:AM by: Muhammad Ahmed Khan
Happy Wednesday folks: Is it possible to suppress this if the user hasn't authenticated to the app yet?
02-Oct-2024 06:00:PM by: Fernando Luna
Hi everyone, I'm encountering an error in Oracle APEX when trying to send emails from APEX: ORA-27492: unable to run job "APEX_230200"."ORACLE_APEX_MAIL_QUEUE": scheduler unavailable. Does anyone know how I can re-enable the Scheduler or if there's any step I'm missing to resolve this issue?
02-Oct-2024 05:03:PM by: Alberto Barrio
Does anyone have advice for sorting in APEX charts? Specifically, sorting for a Box Plot. The default sort is alphabetical by name of series/label. I do not want that, I want an alternate order. I am NOT dealing w months so the Time Series does not apply. For other chart types - bar, line - if I turn Fill Gaps OFF (and adjust the query to fill gaps iff necessary) the chart honors the ORDER BY in the query. But not for a Box Plot. I have yet to the the ORDER BY item to work for any chart type. Any suggestions are welcome. Thank you!
02-Oct-2024 01:36:PM by: thtechnology
Want to trigger APEX Processes using a custom event, such as from a Dynamic Action, please vote for APEX Idea: https://apex.oracle.com/ideas/FR-4039 This could be especially useful if you want to trigger a process from a Actions or Row Menu item, especially since you can now have processes run in the background. Otherwise you need DBMS_Scheduler, or calling an Automation.
02-Oct-2024 01:31:PM by: Joe Kerr
Dears, I have already existing APEX application that uses LDAP for authenticating users, the client asked to add sso portal as a third party, when the user authenticated using sso portal he can access all the internal apps using sso jwt token, if the sso is not working go back to LDAP, how to implement this in oracle APEX? anything out of the box or need to be handled in PL/SQL?
30-Sep-2024 03:30:PM by: Mohannad Amarneh
Good morning everyone! In a public access application I am developing, I need to be able to select the APEX theme based on certain logic, which I won't explain here. The question is simple: How can I programmatically change the APEX theme? Essentially, I want to choose one of the pre-established themes for the application. Well, it should be quite simple, but I haven't found a clear answer. I appreciate your help in advance. Best regards to all!
30-Sep-2024 12:03:PM by: Juan Carlos Pérez
Dears, I hope this finds you well, I am building some template component to customize the client theme, but I couldn't find where to customize the shape of the pagination section, any ideas?
30-Sep-2024 07:22:AM by: Mohannad Amarneh
Hello everyone, I oracle apex, form I have a blob field to upload/add a file/attachment. I wasn't able to upload more than 1 mb file. May I know what is the maximum size of file allowed to upload in apex form.? Can we extend the limit more than 1 mb? If we could be able to extend it, till what point can we do that? Is there any oracle document that provides information about BLOB size acceptance? Please, help me if you know something. Thanks, Sridhar
29-Sep-2024 08:02:PM by: Sridhar Utukuri
Dynamic Action behavior change from IG Pagination "Page" vs "Scroll" In simple IG there is behavior difference on *SELECTIONCHANGE* dynamic event Create an IG on simple DEPT table Add a Dynamic Action "SELECTIONCHANGE[IG]" and put an ALERT 1. Type=Page Open Page Actions=>Refresh We don't see the DA firing 2. Type=Scroll DA is firing and ALERT is shown This difference of DA based on pagination is observed after recent upgrade and caused lot of issues. This stopped our UPGRADE go-live We want Type="Page" and SELECTIONCHANGE DA to be firing on refresh Any help or alternative solution to execute SELECTIONCHANGE on REFRESH of IG solves our problem Thanks
29-Sep-2024 05:36:PM by: Ravi Kiran
Hello everyone, I oracle apex, form I have a blob field to upload/add a file/attachment. I wasn't able to upload more than 1 mb file. May I know what is the maximum size of file allowed to upload in apex form.? Can we extend the limit more than 1 mb? If we could be able to extend it, till what point can we do that? Is there any oracle document that provides information about BLOB size acceptance? Please, help me if you know something. Thanks, Sridhar
29-Sep-2024 02:15:PM by: Sridhar Utukuri
Dears, I hope this finds you well, I am building some template component to customize the client theme, but I couldn't find where to customize the shape of the pagination section, any ideas?
29-Sep-2024 09:32:AM by: Mohannad Amarneh
Good Afternoon everyone :slightly_smiling_face: ... i have a case here. i developed a screen manually and have 2 List of Values Columns 2nd List of Value is casecaded with first List of Value and 2nd list of value also fetch data from dynamic action but when i reload page and fetch values in field 1st LOV refresh and then 2nd LOV also refresh because of cascade and null value appear. can anyone guide me what am i missing here please
28-Sep-2024 08:12:AM by: Muhammad Ahmed Khan
Good afternoon all: What is the best way to approach upgrading APEX 22.1 to 24.1? I logged in as INTERNAL and while it says 24.1 is available there is no upgrade button showing (presumably because there is more involved in bringing it to two major releases?) Should I download 23.1 and upgrade it on the command line and then upgrade 23.1 to 24.1? Is it enough just to run apexins.sql as if it were a fresh install and trust it will "do the right thing"?
27-Sep-2024 08:09:PM by: Fernando Luna
Hi! I see that a page (Interactive Report) has a “Saved Reports” section, but there is only “Primary Report” inside it. Is there a way to create custom reports there? In particular, I wanted to make reports with computations inside. When I add computations from the Run mode, it looks like they are bound to the current session and can be no longer accessed after log-out and log-in.
27-Sep-2024 05:22:PM by: Dmitry Shachnev
I've been working on this app on and off for a couple of weeks. I decided to make the home page public. That is I only want to make ONE page public. The landing page... And have it show data that doesn't require authentication. I went to "Security" under "Page" in page designer on the right panel and selected Authentication: "Page Is Public" An error page appears when I try to start it up. ```Access Denied Access denied by Application security check Technical Info (only available for developers) is_internal_error: true apex_error_code: ACCESS_DENIED_SIMPLE component.type: APEX_APPLICATION_PAGES component.id: 100000000001 error_backtrace: ----- PL/SQL Call Stack ----- object line object handle number name 0x9afb33a8 1028 package body APEX_240100.WWV_FLOW_ERROR.INTERNAL_GET_ERROR 0x9afb33a8 1097 package body APEX_240100.WWV_FLOW_ERROR.INTERNAL_ADD_ERROR 0x9afb33a8 1581 package body APEX_240100.WWV_FLOW_ERROR.RAISE_INTERNAL_ERROR 0x9b33b690 978 package body APEX_240100.WWV_FLOW_AUTHORIZATION.IS_AUTHORIZED 0xa8af9b10 3005 package body APEX_240100.WWV_FLOW.SHOW 0xa8af9b10 5501 package body APEX_240100.WWV_FLOW.RESOLVE_FRIENDLY_URL 0xa45b72c8 2 anonymous block``` What have I missed?
27-Sep-2024 12:37:AM by: Fernando Luna
Does anyone know if a computation created on a page in Apex can be accessed via API?
26-Sep-2024 07:48:PM by: Steve DeYoe
ORA-01536: space quota exceeded for tablespace 'APEX_BIGFILE_INSTANCE_TBS2 getting this exception in workspace, any suggestion how to solve this?
26-Sep-2024 05:14:PM by: saurabh shirke
how to change form or interactive report data base of popup lov page item?can we use dynamic action on popup lov page item?
26-Sep-2024 05:10:PM by: saurabh shirke
Is there a simple way on a display only item to change the font color to red or green based upon its value? I have the code producing a span with the color but since its producing html, its NOT escaped..
26-Sep-2024 03:15:PM by: Tony Miller
hello everyone ... i have a scenario in which i have interactive report with text field and calculation on changes in text field and display changes on next column on same row after refresh but when i refresh cursor is not on same position as before refresh. Can i restrict cursor for same position ?
25-Sep-2024 12:07:PM by: Muhammad Ahmed Khan
Idea: Option tp restrict Saved Report Views per Group - Interactive Report and Interactive Grid https://apexapps.oracle.com/pls/apex/r/apex_pm/ideas/details?idea=FR-4015&session=113670374321915
24-Sep-2024 05:57:PM by: Paulo Künzel
Hello, Page is taking very long to load. I am trying to find out why. I checked the Debug Mode but nothing, In the Developer Tool console, I didn't find anything interesting either. Of course on the page there was no new process added lately.... Any idea how to handle this? Apex 19.2
24-Sep-2024 03:40:PM by: eureka7
Anyone successfully implemented single signon of APEX from EBS using ICX Session when APEX and EBS are hosted on different hosts in same domain.
24-Sep-2024 12:37:PM by: muzzamil
Hi - Apex version is 23.1.0 Does anyone know how to have a Calander event change background color when the mouse is hovering over the event. Regards,
24-Sep-2024 07:15:AM by: Alister Miller
Hello Oracle Community, I'm working with Oracle APEX and I've been wondering about the #ACTIONS# alias used in templates from Classic Report. Is it a space for plain HTML written that should be marked with "escape special characters"? is there a better way to do this?
23-Sep-2024 05:11:PM by: Paulo Künzel
Hello! Apex version is 20.2.0.00.20. I have an application with an Interactive Grid, and every time I update the application, Apex overrides all the filters and highlights created by our end users. Is this is the default behavior of Apex ?
20-Sep-2024 02:02:PM by: Rafael
Do you know what is happening here? Have you ever had this problem?
19-Sep-2024 12:53:PM by: Eric Sacramento

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes

CSS for Home-Pages 1,10,20