Slack

Ok, a fellow developer presented an interactive grid challenge to me.. We have a grid based upon a table of participants.. When need to add a new participant, we want to have a column with a popup lov to select from a list of available people to add. When the item is selected in the popup lov, Need to populate value for the id in the new row and other columns (first, last, middle) was wondering anyone had done something like this? I normally would have free form text fields in grid for them to enter values..
27-Mar-2024 08:15:PM by: Tony Miller
Hello everyone! I'm trying to create REST Data Source, but a problem that resulting JSON does not have an array. Sample JSON: ```{ "Квадрат_100_1,0037": { "prodAmount": 111, "prodId": "Квадрат_100_1,0037", "prodMaterial": "1,0037 | St37-2 | S235JR | Ст3" }, "Квадрат_100_1,0570": { "prodAmount": 440, "prodId": "Квадрат_100_1,0570", "prodMaterial": "1,0570 | St52-3 (St55) | S355JR | 17Г1С | 09Г2С" } }``` I use Oracle APEX 23.2. Can anyone guide me how to fix it?
27-Mar-2024 06:14:PM by: alexey_br
Thanks for the reply!
27-Mar-2024 01:12:PM by: Alberto Barrio
You cannot use temporary tables in an APEX context because these are tied to a database session. And you don’t get the same database session on each APEX request. You should definitely switch to collections.
27-Mar-2024 01:09:PM by: roelhartman
Hello everyone, currently I'm working on an application that was migrated from Oracle Forms. On one page, there was a temporary table being queried. Sometimes I retrieve information from the temporary table, and sometimes I don't. Should I switch to using Oracle APEX collections?
27-Mar-2024 01:06:PM by: Alberto Barrio
Is apex.oracle.com down for anyone? I'm currently getting this error
26-Mar-2024 06:01:PM by: EJ Egyed
I have a APEX OCI application(developed&Working) with oracle provided LONG url. How can I map it to a Domain name? I want to mask LONG oracle apex URL while using application. Sorry, I am new to this domain mapping and doesn't have much experience. I purchased a DOMAIN name in GODADDY. Where do I start now to map Oracle apex long url to that DOMAIN I purchased? Once this CUSTOM DOMAIN part is complete I want to upgrade to APEX to paid. Thanks for your help
26-Mar-2024 03:53:AM by: Ravi Kiran
Is there a way in a cards region to have it display in 1 Column? Out of the box the lowest # of columns seems to be 2 and I have a need to display a list of "cards" in one column..
25-Mar-2024 06:15:PM by: Tony Miller
Using Social Sign-In auth, Where and how I can add validation, example is account locked or not, so user will see nice error message?
25-Mar-2024 01:49:PM by: Indrek T
In OCI APEX, clicking on object browser is giving CREATE option instead of NAVIGATING to object browser...This suddenly happened and there is no way to go to objects! Please help or is there any alternative way to see objects!? Thanks
25-Mar-2024 01:26:PM by: Ravi Kiran
hello, am trying to upload my plug-in into apex world, but it gives me this if you could help me please !
25-Mar-2024 01:11:PM by: ouadia
Hello all, I would like to know how to use a short and meaningful URL to redirect to the long apex URL, hiding all the parameters. Just to have something like this: https://customer-portal.ourcompany.net where is this configured? Any good Doc? We are using Apex 19.2 on Oracle Database 12c Standard Edition Release 12.1.0.2.0
22-Mar-2024 08:15:PM by: eureka7
Modernizing the eye clinic module in Oracle APEX! :rocket: Introducing a single-page solution for doctors to examine and highlight eye issues using interactive eye anatomy. Enhancing patient care and efficiency in ophthalmology clinics.
22-Mar-2024 05:39:AM by: Awais Majeed
Anyone looking for a contract gig with a gov't client? I can forward your info onto the manager of the company looking. His name is Chris Ullrich, a good manager I worked for previously.. Must be a US Citizen and able to obtain a Public Trust security clearance..
21-Mar-2024 04:16:PM by: Tony Miller
We'll be live in 5 minutes!! Join us! https://apex.oracle.com/officehours https://twitter.com/hashtag/orclAPEX?src=hashtag_click|#orclAPEX https://twitter.com/OracleAPEX|@oracleAPEX We're going to have another fun and fantastic hour today!
21-Mar-2024 01:54:PM by: Jayson Hanes - Oracle APEX PM
In APEX 23.2 compared with previous version have we changed how in `Collapsible Region` value `Remember Collapsible State` is stored? Was it previously stored in local storage and now in session storage?
21-Mar-2024 01:12:PM by: Indrek T
I was doing some changes in my app - added css classes to make a floating button on a page. I did the changes in the application working copy but after the merge CSS styles are lost. Is this expected behavior?
20-Mar-2024 07:45:PM by: pocelka
Hello! We have migrated the app from 18.2 to 22.2 and now we are having a hard time with the new datepickers. Datepicker shows every month beginning at day 2 and the days are offset by one day with the week day, e.g. 20th March - Thursday instead of wednesday In globalization we have: • App Primary Lang: PT-pt • Application Lang Derived From: FSB_LANGUAGE_PREFERENCE (_that is set to PT-pt_) • html header: <html class="no-js page-31 app-A1101" lang="pt" > For reference: Dom = Sunday Can anyone point me in the right direction on how to solve this? Thanks.
20-Mar-2024 12:55:PM by: hmarques
Hi. I had a question regarding the *table owner* in Apex, *i want to select the table from different User Schema but here in Table owner i am not able to see that schema.* Checked in the *workspace settings but there the schema is assigned to workspace*, for Table owner does that need to be set from somewhere else or some grants are required? If someone have an idea about that? Thanks.
20-Mar-2024 11:51:AM by: Muhammed Sharjeel Arshad
Hi, I have a GANTT chart, but I want to restrict the hours displayed each day, to only business hours, to more efficiently use the horizontal space. (As I will only have tasks with a start_time >= 8:00 and end_time <= 18:00) At the moment, it just shows from 00:00 to 23:59, effectively wasting the red marked area in the attached image... This is a similar concept to calander region settings: pOptions.slotMinTime = "08:00:00"; pOptions.slotMaxTime = "18:00:00"; A *second* question - does anyone know how to completely supress the "progress" bar under a task. (I dont need to show it at all) Regards, Alister (Apex 23.1)
20-Mar-2024 06:00:AM by: Alister Miller
Anyone worked with Oracle Analytics Cloud with older versions of Apex (5.1)? We are trying to work out how to invoke a report from Apex and get the resultant PDF as a blob. This blog post is very close but the apex API calls don't exist or a different in 5.1 https://www.rittmanmead.com/blog/2023/02/oracle-apex-reporting-using-bi-publisher-server/
20-Mar-2024 01:12:AM by: Trev
Hello experts, I have an oracle transportation management (OTM) Rest API. Eith this API, I was able to get data from OTM using the apex rest data source feature and I wasn't able to POST data back to OTM. How can I achieve this? Can I be able to do this using PLSQL functions? Can anyone please let me know possible approach? Thanks in advance Sridhar
19-Mar-2024 06:30:PM by: Sridhar Utukuri
Hello Guys, Just wanted to share an AI Project I'm developing using Oracle APEX + OCI + GPT + Live2d. If you have a moment. please take look and share your thoughts with me https://www.linkedin.com/posts/paulo-augusto-kunzel_orclapex-oracle-oraclecloud-activ[…]415849283584-SlBb?utm_source=share&utm_medium=member_desktop
19-Mar-2024 05:37:PM by: Paulo Künzel
hey all, how can we restrict particular date in calendar based on our predefined dates( predefined Holiday list )
19-Mar-2024 08:50:AM by: mayurmehar003
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

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
L_a_u_r_a
18-Feb-2022 16:16
Is it possible to submit EBS request set from APEX and get the request id for each request?
Link
User_TFX19
18-Feb-2022 15:54
APEX_WEB_SERVICE and client certificates?
Link
User_6X3A4
18-Feb-2022 15:38
Multiple drop downs in a page
Link
Munaf Rafique
18-Feb-2022 14:42
Error in Callback URL at apex and the below is the debug from sqlplus . can you please Help ?
Link
SmithJohn45
18-Feb-2022 13:55
IG: Dynamic Action sometimes not Set Value but sometimes does?
Link
PJ
18-Feb-2022 12:45
APEX - apex.server.process pass clob to client
Link
fac586
18-Feb-2022 09:56
BUG: UT 21.2: Search Engine pagination misalignment
Link
User_O8O4V
18-Feb-2022 09:39
YYYYMMDD Validation
Link
gernot1
18-Feb-2022 08:44
workspace login using http header variable authentication
Link
User_8849S
18-Feb-2022 07:25
Apex web service REST call returning null
Link
SmithJohn45
18-Feb-2022 04:56
IG: selected value thru PopUp LOV should not appear in next row
Link
User_NF3HC
18-Feb-2022 03:10
Authentication failed for REST Enabled SQL service.
Link
partlycloudy
18-Feb-2022 02:43
Auto dismiss notification messages - All pages
Link
Joe R
17-Feb-2022 18:48
Deploying an Application with Subscribed Authorization Scheme's - 21.2.3
Link
srgarg-Oracle
17-Feb-2022 17:41
Set Value DA -> Submit DA -> Processing
Link
partlycloudy
17-Feb-2022 16:56
Region button - Update click target
Link
Geert01
17-Feb-2022 08:25
Badge List: Change the blue color when hovering over the card
Link
Brad Chriss
16-Feb-2022 18:50
Close Dialog event
Link
Suat GURSES
16-Feb-2022 12:24
Oracle APEX Interactive Grid -Master/Child Table Issue
Link
Sushmitha Sun
16-Feb-2022 09:18
How to remove the default notification that comes when a process is successful
Link
Ace1
14-Feb-2022 13:57
Interactive grid dynamic sum in a total row
Link
Suat GURSES
23-Dec-2021 08:07
APEX BUG
Link
CaribbeanUser
26-Nov-2021 20:23
Setting a Popup LOV column in an interactive grid doesn't show the display value
Link
Amico
26-Jul-2021 13:33
After update to Apex 21.1.2 refreshing interactive grid duplicates rows
Link
Javier P
27-Jun-2021 07:57
Duplicate records showed in a result set of an Interactive Grid
Link

CSS for Home-Pages 1,10,20