 |
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
|
|
Hi eveybody , I hope you are doing great, we went into debate today as we are doing revamping for one of our client theme, so they raised a point that if we continue using VITA theme, it might be deprecated soon as Oracle showcasing Redwood, do you think that VITA will be deprecated soon? do you recommend to start over and re-do the work on redwood again, knowing that redwood has limited customizations in theme roller.
19-Sep-2024 11:09:AM by: Mohannad Amarneh
|
 |
Issue: Oracle OCI ATP APEX 24.1 is giving gateway timeout errors for a process running 15-20 minutes. Changed timeout in OCI Load balancer but still getting meessage.
18-Sep-2024 07:41:PM by: Joe Kerr
|
|
Would you also prefer that the Master Detail didn't require you to fill the secondary display column? Then vote up for this idea
https://apexapps.oracle.com/pls/apex/r/apex_pm/ideas/details?idea=FR-3998
17-Sep-2024 12:57:PM by: Paulo Künzel
|
 |
```Does Oracle Apex support OAuth2 + PKCE Authentication?```
17-Sep-2024 02:44:AM by: Vivek
|
|
Hello everyone,
I’m working on retrieving files from the GitHub API and creating an interactive report in Oracle APEX for user downloads. The API provides a base64-encoded contents field and a download_url. I’m struggling to decode the content and use it in the report to enable downloads.
Any help would be appreciated.
Best regards,
Sridhar
16-Sep-2024 03:47:PM by: Sridhar Utukuri
|
 |
We're running a survey to collect your feedback, I'm asking you to spare 5 minutes to let us know HOW we're doing and what YOU'RE doing with oracle database
https://surveys.oracle.com/ci/documents/detail/5/834/12/6750ef905b6399847b3fce84d6e47ed40a708573
16-Sep-2024 02:33:PM by: thatjeffsmith
|
|
Good morning, everyone!
Well, the day has arrived!
I have an application developed and in production (I know it's not ideal) using Oracle 21XE and APEX. Well, the SYSAUX tablespace of the main container is occupying 4.5GB, and the database is about to hit the dreaded "exceeded 12GB storage" error. Considering that I won't be able to reclaim the unused space in the SYSAUX of the main container, I'm almost certain I'll need to reinstall the database, and here's where I need your help: is there any way to migrate the PDB1 container to a new database and thus avoid reinstalling Apex, privileges, schemas, etc., or would it be advisable to perform a complete new installation and migrate piece by piece?
Thank you in advance and best regards.
Juan Carlos
16-Sep-2024 10:47:AM by: Juan Carlos Pérez
|
 |
Hi All, from the below end point, Upto http://oraclecloud.com|oraclecloud.com is the common rest api and after we need to set our own path i want to understand after .com/ Do we need to create our document understanding project in our oci console and the same need to give here? How to do ?This is the part of invoice automation in apex, reading file from object storage using document understanding in oci console. Thanks in advance.
*https://document.aiservice.us-ashburn-1.oci.oraclecloud.com/20221109/actions/analyzeDocument*
12-Sep-2024 10:47:PM by: Jai
|
 |
Hi All, we're using language translations in our app. I changed my code when I was using the english language on the app and it was working but when I tried to change the language it throws an error and the trace indicates it's using the old version of the code, do you know any fix for this or it is a bug in version 22.1?
12-Sep-2024 09:15:AM by: Richard Pavia
|
|
Hi all, how to create a incoming connection below to the activity in Workflow Definition. Because when a click on create connection by default it is creating out going connection. Incoming connection needs to be defined for few activities. Kindly suggest.
12-Sep-2024 02:10:AM by: Jai
|
 |
Hi,
is there a way to remove these gaps in the chart?
11-Sep-2024 01:06:PM by: Nitec
|
 |
Hi @Everyone
*How to jasper pdf reports Direct print repot in oracle Apex*
11-Sep-2024 10:00:AM by: MD.SHAJALAL SAGAR
|
|
Pretty basic question really. Given a radio button, (LINK_TYPE) if the value is 'document' displayh 'doc_contents' item, otherwise do not display it at all.
LINK_TYPE has a Dynamic Action, with event scope of static and type immediate.
Under "When" I selected item p2_link_type. Under Client-side condition I selected "Item = Value" and then selected p2_link_type for item and 'document' for value.
Under True I created something I named 'Show' that basically repeats all of this. I have disabled "Fire on initialization"
I did something similar with False except that the action is Hide.
I'm not sure what I'm doing wrong. This seems like pretty basic functionality but I can't seem to get it to work at all.
10-Sep-2024 05:37:PM by: Fernando Luna
|
 |
Hi, I have a table of 3 columns - tab_no, code, code_desc. I develop a page that has 20 different list of values like popLOV or select list. I need to work with Rest Api. I think about some function that get the tab_no and returns the list of values but I don't know how to make it. I would love to have an explanation... thanks.
10-Sep-2024 05:13:AM by: Yarden Avraham
|
 |
Aloha, just check any one has tried oracle apex tutorial lab: Automate Invoice Handling with OCI Document Understanding. After the app is created following the instructions, I am able to load the invoice pdf file to the oci bucket storage but keep running into this error "Request failed with HTTP-401: Unauthorized". If the credential is not correct, then file should not be uploaded to the cloud. Any suggestions. Mahalo.
08-Sep-2024 12:27:AM by: Winston Sun
|
 |
Hi all, I am trying to make a Popup LOV fill the height of the screen when it is showing the list of values.
Does anyone if it is possible to dynamically set the height of a Popup LOV? I have tried the following in page load but it is not getting persisted:
apex.jQuery(window).on('theme42ready', function() {
apex.jQuery(".a-PopupLOV-dialog.ui-dialog-content.ui-widget-content").css("height", document.documentElement.clientHeight);
});
Thanks.
06-Sep-2024 10:39:AM by: Neil Harsley
|
|
Just a heads up, when I just tried access apex.oracle.com I received the following wonderful error:
400 Bad Request
Request Header Or Cookie Too Large..
Any ideas on how to proceed?
05-Sep-2024 04:30:PM by: Tony Miller
|
|
I have a grid, in which I have 10-15 rows of questions. sample query similar to my grid sql:
select QUESTION_NO,
QUESTION_TEXT,
YES_RESPONSE,
NO_REPONSE,
REMARKS,
ID,
ANSWER,
' ' as Answer_VALUE,
is_required
from GRID_QUESTIONS
I need to on the grid loading, programmatically set the remarks column (textarea) required if on the same row the is_required is set to Y.
Code I have right now to handle this:
var ig$ = apex.region("questiongrid").widget();
var gridView = ig$.interactiveGrid("getViews", "grid");
var model = gridView.model;
model.forEach(function(record, index) {
var statusValue = model.getValue(record, "IS_REQUIRED");
if (statusValue === 'Y') {
var cellElement = gridView.view$.find("td[data-col='REMARKS']").eq(index);
cellElement.prop("required",true);
}
else {
var cellElement = gridView.view$.find("td[data-col='REMARKS']").eq(index);
cellElement.prop("required",false);
}
});
Code is running BUT not setting the required property… Does anyone see the issue I am missing?
Thank you!
Tony MIller
White Rock, NM
05-Sep-2024 01:56:PM by: Tony Miller
|
|
Good morning,
I currently have APEX 24.2 installed on my own server, running on Oracle Database 21SE, with ORDS 24.1 and Tomcat9.
The system is functioning correctly, but I am sure it can be optimized, and I am looking to hire an expert consultant to help me fine-tune the system. I don't speak English, and the consulting must be conducted in Spanish.
Please, if you know anyone who might be interested, ask them to send me a private message.
Thank you very much!
Juan Carlos P.
05-Sep-2024 09:25:AM by: Juan Carlos Pérez
|
|
I have an interactive grid with a radio group (values Y,N, NA) and need to use this value to show/hide an associated column in grid upon selection or when grid initially displays. I am running a dynamic action on the change event of the radio group that does the following:
// Get the interactive grid widget
var ig$ = apex.region("questiongrid").widget();
// Get the grid view and model
var gridView = ig$.interactiveGrid("getViews", "grid");
var model = gridView.model;
// Get the selected records (returns an array)
var selectedRecords = gridView.getSelectedRecords();
if (selectedRecords.length > 0) {
// Get the first selected record
var currentRecord = selectedRecords[0];
// Retrieve the value from the radio group column
var radioValue = model.getValue(currentRecord, "ANSWER");
// Display the value in an alert
alert("Selected Radio Group Value: " + radioValue);
} else {
alert("No record is selected");
}
My problem is this code is returning an OBJECT and not the actual value of the radio group.. Can anyone suggest a modification to help? I know the code does NOT show/hide columns, it will as soon as I determine the error in how to get the radiogroup value..
Thank you!
Tony Miller
White Rock, NM
04-Sep-2024 02:17:PM by: Tony Miller
|
 |
anybody else getting 403 messages with apex service or autonomous from oci?
04-Sep-2024 01:22:PM by: Travis Caruth
|
 |
Hello ,
I have implemented IDCS for SSO in my application. My requirement is that if I change the role (Admin, Manager, Employee) from the "Create User" form, the particular user for whom the role is changed should automatically be logged out from the application.
NOTE - we have successfully implemented it without sso using below code.
CODE :-
DECLARE
SESSION_ID NUMBER;
l_workspace_id number;
BEGIN
select workspace_id
into l_workspace_id
from apex_workspaces
where workspace = (
select workspace
from apex_applications
where application_id = :APP_ID
);
for session_rec in (
select apex_session_id
from apex_workspace_sessions
where workspace_id = l_workspace_id
and user_name = :app_user
and apex_session_id != :APP_SESSION
)
loop
apex_session.delete_session(
p_session_id => session_rec.apex_session_id
);
end loop;
END;
03-Sep-2024 11:06:AM by: mayurmehar003
|
 |
hello
is someone management source control of apex application and other components with git and azure devops/github
???
thanks!!!
02-Sep-2024 05:50:PM by: Chana-Shlang
|
 |
Hi Experts,
Hope you all are doing great.
How can i upload pdf files through oracle Apex to Windows directory, and how can i save that directory reference in the table?
and how i can preview files from the reference link, which is saved in the table against pdf in the Windows directory.
01-Sep-2024 08:00:AM by: Mukarram Jamal
|
|
Is the sample "Doctor Appointment" application available for download anywhere?
Thanks
31-Aug-2024 03:13:PM by: Ravi Kiran
|
|
Given a Restful Services module and a URL where I supply a value to determine what PDF content to display, I've set this up in my Apex application to reference this and also that it open up in a new browser window. Is there a way to control the title of the browser window that is opened up? It seems to use the ID from the database as the title and I'd rather it didn't.
31-Aug-2024 02:33:AM by: Fernando Luna
|
|
In an interactive grid, does anyone have a trick to show a radiogroup without a user clicking on column to actually display the radiogroup..
30-Aug-2024 09:08:PM by: Tony Miller
|