Skip to main content
7,168 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
3 votes
1 answer
70 views

I’m working on Oracle APEX (v 23.1) with Friendly URL mode enabled. I want to generate a page URL where the value of a page item appears in the path, not in the query string. For example, this is the ...
Faezeh_Ebrahimi's user avatar
  • 91
-2 votes
0 answers
61 views

I'm having an issue with a page item losing its value when navigating via page wizard. I have a page with 4 sequential inputs: p1_org, p1_vacancy, p1_candidate, p1_assignment. Each item after p1_org ...
cam_pdx's user avatar
  • 307
1 vote
1 answer
41 views

I have an application where I need to display and stylize the heading of the region. So instead of display heading simply as "Car", I need to display "car icon Car". This icon and ...
Arif Sher Khan's user avatar
  • 609
2 votes
1 answer
49 views

I have defined the following Help Text for a drop down list on a page in oracle APEX : <html> <style> table, th, td { border:1px solid black; } </style> <body> <table ...
user31903851's user avatar
  • 33
-1 votes
0 answers
59 views

I have a workspace named DEV that contains two schemas: ADMIN and DEV_1. Inside this workspace, I also have two developer accounts: DEV_1 (developer) DEV_2 (developer) And I have two applications: ...
Kien Nguyen's user avatar
  • 13
1 vote
1 answer
92 views

I have creating my first simple plugin. The idea is to have button in a page, on clicking of which an interactive report region will be reset, instead of going through "Actions menu" of IR. ...
Arif Sher Khan's user avatar
  • 609
0 votes
1 answer
31 views

Environment: - ORDS 25.2 deployed on Tomcat 9.0 - Java 17 - Database and APEX on separate servers (PaaS) - Reverse proxy: Nginx Problem: After upgrading to ORDS 25.2.1, the APEX layout breaks. Some ...
Flavia Cabral's user avatar
  • 1
0 votes
0 answers
23 views

I have an IG where there are 2 date fields, and I wanted the second datefield to have a minimum value of the first one+1 day, but only if the first datefield is in the next day, otherwise to have the ...
Roger26's user avatar
  • 57
0 votes
1 answer
39 views

I'm creating a bar chart in Oracle Apex 23ai and I need to change the color of bars from selected rows when they have the max value. My label is X_LABEL, value is Y_VALUE and X_VAL is used to sort the ...
Kamil Dudar's user avatar
  • 3
0 votes
1 answer
71 views

I have a problem with executing the code after submitting. The case should be very simple, but I don't understand why it doesn't work. I have a form on the page 24: Default buttons: And default ...
MateuszDurak's user avatar
  • 41
0 votes
1 answer
62 views

I am trying to reset the password for my APEX user account. I tried executing and committing the following update: UPDATE wwv_flow_fnd_user SET account_locked = 'N' , web_password = 'newpass', ...
Acroyear's user avatar
  • 1,461
-4 votes
1 answer
119 views

I have a table in oracle apex: CREATE TABLE Fundusze ( Id NUMBER(10) NOT NULL, Nazwa VARCHAR2(50) NOT NULL, Waluta VARCHAR2(50) NOT NULL, Typ VARCHAR2(50) NOT NULL, CONSTRAINT ...
aretai's user avatar
  • 1,655
0 votes
2 answers
89 views

I’m currently having trouble setting an item upon page load. It seems that the value is being stored only on the client side, not on the server side. While the current behavior works properly when ...
stummyhurts's user avatar
  • 33
1 vote
1 answer
83 views

I am making form with user input form as you can see the image. Because of XSS, I am using Apex's own security option: Restricted characters : Blocklist &<>"/;,*|=% and -- Is there ...
wosyn's user avatar
  • 27
0 votes
2 answers
128 views

I have an Oracle Apex application that has an input field and some buttons. The workflow is: User enters text, presses enter. The screen changes to a different "page" that does not have the ...
Greg Reynolds's user avatar
  • 10.4k
0 votes
1 answer
85 views

I built a package to handle all the integration with the Signit API for electronic signature. The issue I have is that when I send an Arabic character in JSON. The API response is that it is a bad ...
Karam Alem's user avatar
  • 32
0 votes
1 answer
330 views

ISSUE: I have a dialog page in my Oracle APEX application (version 24.1.5) that can be called from nearly every other page in the application. When settings on the dialog are changed, and the changes ...
Jason Bourne's user avatar
  • 53
0 votes
1 answer
116 views

I have a dialog page in my Oracle APEX application that can be called from nearly every other page in the application. When settings on the dialog are changed, and the changes are submitted via a ...
Jason Bourne's user avatar
  • 53
0 votes
0 answers
62 views

I have a grid that will be loading data from a table. I would like the validation of the grid to fire after data load, rather than on submit. This is so a user gets a notification that something is ...
Greg Reynolds's user avatar
  • 10.4k
1 vote
1 answer
133 views

I'm building an academic project in Oracle APEX, and I'm trying to implement a custom login system using a PL/SQL package. Here's the issue: the authentication function works correctly (it returns ...
SantiagoGM's user avatar
  • 11
1 vote
2 answers
148 views

i am using Oracle apex24.2 i have created a RestApi and linked it to a Rest Data source. i was able to define this rest data source on my screen using a page process. i want to call this process when ...
Samir's user avatar
  • 13
0 votes
0 answers
67 views

I'm trying to send push notifications using Firebase Cloud Messaging (FCM) HTTP v1 API from my backend server, and I understand that I need to generate a server-to-server access token using a Firebase ...
Anil Kumar's user avatar
  • 1
1 vote
1 answer
73 views

In the Oracle APEX sample application for workflows, there is a "Laptop Request" workflow. The first task in this workflow (Request Pending task) executes a procedure via Invoke API, this ...
smackenzie's user avatar
  • 3,092
0 votes
2 answers
103 views

i am using oracle apex24.2 i have created a master details form. the master form contains some data regarding the people and the detail form contains data about their leaves. i want a column of this ...
Sly Warden's user avatar
  • 13
0 votes
1 answer
199 views

i am trying to create a time picker in oracle apex24. i couldn't find any time picker on oracle apex24. i did create a date picker and i can choose time from it and its working but i need to remove ...
Sly Warden's user avatar
  • 13
1 vote
1 answer
124 views

No "Comment out" option is shown Hello, how do you activate "Comment out" while using Oracle APEX 24.2? I want to comment out this Dynamic action. However i can find the comment ...
wosyn's user avatar
  • 27
0 votes
2 answers
76 views

i have an application in APEX 24.1. Currently, i use different Authentication Schemes, which i can change on demand: Active Directory Oracle Apex Accounts Custom Auth (created by me) No matter the ...
user1508072's user avatar
  • 161
0 votes
2 answers
141 views

I am using Oracle Apex 24. I am trying to call a REST API in JavaScript when a button is clicked. The REST API was called, and the resulting JSON items populated successfully. However, this is not the ...
Sly Warden's user avatar
  • 13
0 votes
1 answer
99 views

I have a button which uses DA and executes the server side code... when there is a low network user clicks the button multiple times which cause duplicate entry... I want to disable when user clicks ...
shajin's user avatar
  • 66
0 votes
0 answers
118 views

I'm encountering an error: ORA-40597: JSON path expression syntax error ('$.') JZN-00217: Key step contains unexpected characters at position 2 error when using an "Invoke API" page process ...
Sly Warden's user avatar
  • 13
-1 votes
1 answer
147 views

I have a requirement to hide the No Data Found message on an Interactive Report when page is initially loaded then show back the message if there is no data. I have search items (Say PX_Search_Item_1, ...
Bhavin Adhvaryu's user avatar
  • 11
0 votes
1 answer
61 views

Interactive Grid Image Hello, as a beginner in Oracle Apex, i have problem with Interactive Grid. While adding more values in Person ID column, i have an error ORA-06502: PL/SQL: value or conversion ...
wosyn's user avatar
  • 27
1 vote
1 answer
201 views

I'm using Oracle APEX Release 24.2.0 and Oracle ORDS Release 25.1 on Oracle Database Express Edition 21.1. I tried to generate a RESTFul API for a couple of tables : tcustomer, tcity and tsalesperson, ...
JRG's user avatar
  • 615
0 votes
2 answers
263 views

I am trying to schedule a PDF report to be sent to an email using Oracle Apex 24.2 or if I can store it on a custom directory on apex application ( not locally). I know how to create a scheduled job ...
Sly Warden's user avatar
  • 13
1 vote
2 answers
113 views

The goal of this program is to match a form's element IDs corresponding to different questions with the actual questions, so the resulting table's column names are the questions themselves instead of ...
nathan's user avatar
  • 11
0 votes
1 answer
151 views

I am a little stuck on working with javascript in Interactive Grid in Oracle Apex. I just want to change the label of one interactive Grid save button, but I am not able to do it. I don't want to ...
Leo's user avatar
  • 135
0 votes
2 answers
77 views

I'm trying to implement a reset button in Oracle APEX that: Shows a confirmation dialog (P1002_CONF_MESSAGE item) only if any form fields were modified Resets immediately if no changes exist. Is that ...
stummyhurts's user avatar
  • 33
0 votes
0 answers
97 views

I am learning Oracle Apex 24, and creating a workflow ( created a human task / task definition ). I am able to create parameters initialized once when the workflow started but they are read only for ...
Sly Warden's user avatar
  • 13
0 votes
1 answer
378 views

I'm working with Oracle Cloud Infrastructure and trying to invoke a Generative AI Agent from an Oracle Function using the Python SDK. Everything seems correctly set up, but I'm getting a 404 Unknown ...
Nagailîc Pavel's user avatar
  • 1
1 vote
1 answer
238 views

I installed Oracle APEX Release 24.2.0 and Oracle ORDS Release 25.1 on Oracle Database Express Edition 21.1. APEX is up and running, then I enabled Restful Services for an specific table. After that I ...
JRG's user avatar
  • 615
1 vote
1 answer
91 views

I have a report that's running in ~3 seconds in sql developer. When I paste the report into oracle apex, and hardcode the variables in my where clause, the report will load roughly around the same ...
LogicallyFunky's user avatar
  • 87
0 votes
2 answers
273 views

I'm currently using Oracle APEX v24.1 with Google Chrome. I have an updateable interactive grid with Custom Toolbar buttons Save and Clear at actions4 position. One of the column on an Interactive ...
Bhavin Adhvaryu's user avatar
  • 11
0 votes
1 answer
84 views

I have tables in Oracle that contain spatial data using the SDO_GEOMETRY data type. I would like to create a button inside APEX that allows users to download a zipped shapefile export of this data. ...
Danilo Silva's user avatar
  • 1
1 vote
2 answers
103 views

I have an oracle apex form version 24 . i have a user ID and i need to fetch his name and put it in an item on the screen . what is the proper way to do so ? I am new to this technology. i did try ...
Sly Warden's user avatar
  • 13
0 votes
1 answer
58 views

I want to make my application multi-language and achieves following conditions: Navigation Bar has the list of languages that make the language changing easily from any in the application. The ...
shady's user avatar
  • 134
0 votes
2 answers
166 views

Scenario: I have an interactive grid with 4 columns: prod_ref (select list), prod_name, promo_ref (hidden), and weight. When prod_ref changes, a dynamic action updates prod_name and promo_ref values. ...
Abdullah's user avatar
  • 1
-3 votes
3 answers
119 views

tldr: Need to GROUP BY SUM(COST) OVER A,B and also ORDER BY SUM(COST) OVER A I have a database with columns TYPE, NAME, and COST. My end goal is to create a grouped bar chart in an APEX Application ...
Jax's user avatar
  • 93
0 votes
0 answers
72 views

I can send Twilio SMS messages or no content-variable WhatsApp Messages on Oracle APEX using APEX_WEB_SERVICE.MAKE_REST_REQUEST But when I try to add some parameters and send whatsapp messages with ...
Zolomon's user avatar
  • 7
0 votes
1 answer
62 views

I am curious is it possible to make and design a page for a web app soley using code and achieving the same functionality
Kaylon Haven's user avatar
  • 1
-6 votes
2 answers
135 views

How can I calculate date of birth from an age field in Oracle Apex? I created a dynamic action to execute server side code on date of birth filed to calculate age from date of birth: select trunc(...
Abdullah's user avatar
  • 1,123

1
2 3 4 5
…
144