Questions tagged [oracle-apex21.2]

Oracle Application Express version 21.2 - released Nov 2021. Superseded in May 2022 by version 22.1.

Use this tag in addition to oracle-apex if your question is specifically related to Oracle APEX version 21.2.

31 questions
1
vote
1 answer

Oracle APEX: Is it possible to programmatically check/uncheck APEX$ROW_SELECTOR for a specific row

While looping through the rows of an IG I want to be able to programmatically check row selector for a row where another column's value 'Test'. If it equals something else, I want to uncheck it. Is that possible? I have something like that: var…
Coding Duchess
  • 6,445
  • 20
  • 113
  • 209
1
vote
2 answers

Oracle APEX: Issues with doSubmit

I have a conditional hyperlink column in my IG: SELECT CASE WHEN t1.active = 'No' THEN t1.active ELSE '
Coding Duchess
  • 6,445
  • 20
  • 113
  • 209
1
vote
2 answers

Logout all users in Oracle Apex

I have an application in which before every release we lock all users. Once locked, user cannot login. But if the user is already logged in and then I lock the user, the user will be able to continue until sessions ends. I'm trying to have a feature…
Arif Sher Khan
  • 461
  • 4
  • 12
1
vote
0 answers

Load test Oracle Apex applications

I have various Oracle apex apps which are session encrypted, protected and on friendly URLs. My objective is to load test the apps. My team is using NeoLoad but it is causing so many issues because of session encryption and protection as HTTP…
Arif Sher Khan
  • 461
  • 4
  • 12
0
votes
0 answers

Oracle Apex 21.2 - Page Item Source vs Computation

Are there any rules of thumb on when to use one over the other? I have a page item P2_STUDENT_ID, that can either get set from another page using a URL redirect or needs to get a default value from SQL if not coming from that page and is null in…
McRivers
  • 303
  • 2
  • 13
0
votes
0 answers

File upload in Oracle apex for virus scanning

I'm working on app where user will upload files. These files need to be scanned for malware and then stored in Azure storage (will be done by REST APIs). I don't want to upload files to actual database at any instance hence…
Arif Sher Khan
  • 461
  • 4
  • 12
0
votes
1 answer

Oracle APEX; changing location of apex_application.g_print_success_message

I am using apex_application.g_print_success_message to display messages to the user and it always pops up in the upper right corner. Is it possible to relocate the message?
Coding Duchess
  • 6,445
  • 20
  • 113
  • 209
0
votes
0 answers

Get SAML claims in Oracle Apex

I'm using SAML sign in an Oracle apex application. Authentication is working, and username is getting set to my email ID. I'm trying to retrieve other claims from the SAML response like given name, surname etc. I can see all the claims in Network…
Arif Sher Khan
  • 461
  • 4
  • 12
0
votes
1 answer

Oracle APEX Tab Container row too long and not breaking

My APEX Tabs Container has many tabs and it's not showing all of them in the page, forcing the user to scroll sideways to be able to see everything. There are no explicit options in the developer page that allows to change the amount of tabs shown…
AWildmann
  • 179
  • 3
  • 21
0
votes
0 answers

Oracle APEX: IG does not get refreshed after Submit Page

I have a DA that runs on Dialog Close and it performs some actions on the records selected in the IG. Last action in that DA is Submit Page action that displays success message. The issue is that the data in the IG does not get updated until page is…
Coding Duchess
  • 6,445
  • 20
  • 113
  • 209
0
votes
1 answer

Oracle APEX: Issue capturing Close Region

I have a region on the page - Inline Dialog and I need to capture when region is being closed using Close Region action. I created a DA on Dialog Close Event: Dialog Closed Selection Type: Region Region: MyRegionBeingClosed But that does not work.…
Coding Duchess
  • 6,445
  • 20
  • 113
  • 209
0
votes
2 answers

apex.submit does not cause Interactive Grid refresh

On my page I am calling apex.submit("PROCESS1") from javascript. It executes the code of PROCESS1 process but the IG I have on the page does not get refreshed. After PROCESS1 executes I see the unchanged data in the grid and it only changes after I…
Coding Duchess
  • 6,445
  • 20
  • 113
  • 209
0
votes
1 answer

Oracle APEX - retrieve default report_id for an IG

I want to retrieve a report_id for the default report for an IG. I tried using apex_application_page_ir_rpt APEX view but there is no data there for that specific application. How can I programmatically find a default report ID?
Coding Duchess
  • 6,445
  • 20
  • 113
  • 209
0
votes
1 answer

Oracle APEX - hidden regions flash on page refresh

On my page there are several region that are hidden or shown based on a condition. I set a variable calculation before regions and then on change of that variable I show/hide various regions. Everything works as expected but I've noticed that when I…
Coding Duchess
  • 6,445
  • 20
  • 113
  • 209
0
votes
0 answers

Oracle APEX - ORA-02290: check constraint (APEX_220100.WWV_FLOW_TEMP_OPT_NAME_CK) violated

I am getting a check constraint error when adding a template option. I made a copy of the Inline Dialog template and wanted to add a different option for size and gotten this error. I selected the options below: Group: Size Display name:…
Coding Duchess
  • 6,445
  • 20
  • 113
  • 209
1
2 3