Hi all, i have a question related to modal dialogs. I have two modal dialogs, From the 1st modal dialog i want to open the second modal dialog but i don't want that the window of first modal dialog gets closed. I tried different settings but somehow it get's closed when i open second modal dialog. If someone can help out here? Thanks

I have implemented Single Sign-On (SSO) in Oracle APEX, and I noticed that there doesn’t seem to be a built-in way to restrict access for specific users. Once authentication is successful, APEX grants access without any additional checks. I know about Authorization Schemes but it is too late, user has valid session (not public session), I would like to block user on log-in process. How is this scenario intended to be handled in APEX? If I need to block a certain user from accessing the system, what would be the recommended approach?

Hi team, I'm working on requirement below for payment_account column suppose first 2 rows value is negative. When i press release button i want to minus 1 row payment_account value with last row and set 1 row value to 0 and store updated value in last row column and do same to 2 row column until value on last row column becomes zero. I have tried using cursor for loop but didn't work. Instead of using process if i want to do this using javascript based on selecting APEX$ROW_SELECTOR how can i achieve that Any suggestion or help will be appreciated. Thank you.

greetings everyone, does anyone have a reliable resource on how to upload many files or attachments into Apex forms (I have an attachments table, but I am facing errors on the page designer level and processes when inserting into the table ) ?

Just a tech question, When we deploy custom APEX application on a client onprem, how do we make sure the code base is not available for customers to make changes. I would like to package it and install with a customer than sharing the code base to the client. Any thoughts?

Hi: There is this requirement for a specific app I wrote in APEX 24.1 where the user password can never expire. I set it here but it still prompts the user periodically. Have I missed something?:

Hi APEX team, I've read here https://www.linkedin.com/pulse/oracle-apex-centralize-your-app-messages-text-mauro-martins-pagnez-h36vf that we can use use &APP_TEXT$Message_Name*$Lang*. Do you use this *$Lang* parameter and does it work ? Thanks for advices

Error when saving subscriptions in Interactive Reports. 'Strip Richtext' setting is not saved and is also not saved in WWV_FLOW_WORKSHEET_NOTIFY. If you manually set the value in WWV_FLOW_WORKSHEET_NOTIFY, it is displayed correctly in the dialog, but as soon as you save again, the value is set to NULL in the table. Can someone tell the development team about this? Many thanks!

Got another one I hope someone can help me with. I'm on page 295 and I want to add a new customer contact, so I hit a button on P295 that takes me to page 41 where I enter the details of the new contact and once I'm done it returns me to page 295, so far so good. On dialog close I refresh the select list and then do a set value using the dialog return value of P41_ID but I am not getting the name of the person I just created. I use a dialog return to bring back the ID of the record I just made and it gets inserted into my Select List field on P295_CONTACT_ID, but the name of the person I just created on P41 does not come up. The select list does contain the name of the new person, but i have to choose it. is there a way to make it populate properly?

Hi all, I am receiving this string from another system. *ARMANDO AVENDAñO.* When calling our Application, the item P0_CRM_USER is set that way in the URL: It's supposed to be *ARMANDO AVENDAÑO* Is there any decoding function in oracle I can apply to the first string to get the second one, the right one? I know you might say the calling system should handle this, but it would be more complex for them to do that change in CRM. Just checking if I can find a way locally. But of course if this is not easy to do on our side, then I will have to let them do it... Beside that I am learning as well....

What is currently to best way to do multi-language applications with APEX? I am looking for the best workflow, lessons learned and what might have changed since APEX 21.2? Who is known in the community to use translations in their applications? Any blogs / presentations you can point me to? We are looking at the following languages: German, English, French, Polish, and Russian. Thanks :slightly_smiling_face:

Hello! I'm trying to adjust the width of a Popup LOV item (Inline Popup), but I can't get it to work. Is it possible?

Hi, i am having this issue with Interactive grid. As soon i change the value of coloumn from dropdown then click Save button then it works fine but the row for changed value is dissappeared, when i manually refresh the page then the Grid shows that value again. If someone has any clue what could be doing it? Thanks.

Something weird with Radio Group fields.... I have a simple Radio Group where I'm putting some text in the POST TEXT field but I can't get it to move over to the left. Here is what it looks like. I want the text to be right beside the two radio buttons. I've also included what my POST TEXT actually contains. Is there some secret to getting that text to slide over to the left?

Hello dear Community, I’m an experienced Oracle APEX and PL/SQL developer with 7+ years of experience, but until now, I’ve only worked on projects for companies. I want to take the next step and build my own software product using APEX, targeting small businesses as customers. However, since this is my first time creating a product for sale, I’d love to get advice from those who have done it before. Here are some key questions I have: 1. *Product Development:* What should I consider when building an APEX-based product for multiple clients? 2. *Hosting & Deployment:* Should I host the application myself, use Oracle Cloud, or offer on-premises installations? 3. *Licensing & Pricing:* How do I handle Oracle licensing when selling an APEX-based solution? What pricing models work best for small businesses? 4. *Marketing & Sales:* How do I attract customers and sell an APEX-based solution successfully? 5. *Support & Maintenance:* What’s the best approach for handling updates, bug fixes, and customer support? If anyone has experience selling APEX applications, I’d really appreciate your insights! Thanks in advance.

I don't know if any of you did that, but since we're talking about APEX, let's help this person by sharing what you think. https://docs.google.com/forms/d/e/1FAIpQLSeZ6ArySlRRF2CW60xQUmDYkspmgjGJC4mqsi-OSRwje0lqCA/viewform

What are people using for automated UI/browser testing for APEX? I've taken a look at Selenium in the past and it seemed not obvious how to locate cells in reports. I've seen references to Cypress, from 2019, that look but are there others? FREE options only please - no budget for this.

I will attempt to use threads in the future..

why do you all refuse to use threads - makes it hard to see new unrelated posts as well as see what is new vs old

If I remove the blob column and the value for it, the insert works.. So something in the hextoraw function call is upsetting sql developer..

SQL Error:

could you also share the error message you're getting?

SQL Developer has issues with inserting this row.. Can anyone shine a light on what is wrong with it?

And this script to insert a row:

I have the following table:

I have a chart in APEX where the y2 axis labels do not format correctly. Notice the screenshot below. The y2 axis is currency, but the labels (bottom of bars) are shown as decimals just like the y1 axis. Any idea how to format the labels for the Y2Axis?

Hi all. I've made changes in the working copy of my application, and now I want to compare these changes with the main application and merge them into main. However, that doesn't seem to work, and I keep getting an "Internal Server Error." Has anyone encountered this issue with working copies before or has any insights on how to resolve it?

Are there any Problems on apex.oracle.com ? Today i Worked on an App on 1 PM without Problems and now i cant Login into the app on 10PM!

Is there a trick to determining which page component is causing an APEX error? Sometimes the errors give the Oracle error and lots of lines, but don't seem to say what specific item caused it. Example Above.

After page submit I want to keep value in my page item. How do I achieve that?

Hi team, how do I know when to use client side/server side condition in apex? Should I use server side condition when using value in session state?

Today arrived :heart: :heart_eyes:

Is there a way to send the 'Install App' feature so they can directly install the PWA? We have an APEX application where our customer wants to deploy to all of their 200 tablets in the field through centralized deployment. Is there a way to have them deploy the PWA directly? The only way I know how to do this currently is to have them deploy the app URL, then the user hits the 'Install App' link on top after they login.

Hey guys, anyone can help me. I need basic accounting application

Hello! In Oracle APEX 24.2.2 after refreshing of the Classic Report using Dynamic action, Percent Graph columns become unfilled. In 23.2 everything worked fine. Has anyone encountered this?

Hi, Is there a way to migrate "Classic Navigation Bar Entries" to the newer "Navigation Bar List" without re-creating the whole list from scratch? Thanks!

Hello! I have an Interactive Grid with 18 columns, but when I select Actions > Group By, the column select list next to Function only shows 2 of the 18 columns available. The select list at the top of the window shows all 18 columns. Any idea why some columns are not appearing next to the function selector? Thank you

Hi! I'm using APEX 24.1.7, I need to add tooltips to some fields on a page I'm working on but I don't see the HTML attributes field anymore. I'm I missing something?

Hello Guys, Is there anyone here know how to configure Generative AI on localhost because i tried it on Oracle Database 23ai and Oracle Apex 24.2 but the open ai is not working.

Long, but as thorough as possible.

Problem: Tables without primary keys, inability to create reports that tie into forms for data modification. System Configuration: Oracle 19c with all relevant patches applied. Oracle forms 10.x or 11.x (not sure). APEX 14.2 (current version installed last week). I'm trying to get an APEX report and form to function properly. The wizard was used to generate an interactive grid and form. The table has no primary key. A column was added to the table combining three columns that when combined, are unique. A unique constraint has been applied to that column. A query retrieving a record based on that column value returns 1 row. An identity column was also added to the table. Retrieving a row based on the identity column also returns 1 row. The Oracle Forms system is running on the same database, but we are not allowed to create any primary keys on any of the tables. The wizard was used to create the report using the rowid and can see the data on the form created at that time. Because you are not allowed to enter a rowid, I removed it from submission to the database. An identity column was created, and I was told to use that for the link to the form. I'm now unable to see any data on the form. I'm trying to get them to create an index on the new identity column, none exists yet. I'm building a function to update the table based on values entered on the page, but it's not complete yet. Any thoughts on possible remedies? Any ideas would be appreciated?

I have cleaned up my previous question and am submitting it again for a possible solution.

I was wondering if any of you have some sexy way of handling a Y/N question where we start out as a NULL but the user must choose a yes or a no. I was wondering if something other than 2 checkboxes or maybe a checkbox group would be a good solution? Do any of you have some secret sauce you like to use for this? The goal is that you open a form and you must actually click on something to say "Yes" or "No". If you don't then you will get a validation error. But I also need it so that the user can tell what has been selected, or if no selection has been made. I say that because with a checkbox if the field is NULL then you cannot tell, it looks the same as when you click on it and click on it again, making it a "N". I need something more obvious for the users so they can see that "N" was selected.

I'm trying to create a form based on a working report. I can view the page if I use the rowid as my linking column, but updating is not possible. Any suggestions?

We are able to update existing records in the table but are unable to create records.

Can Oracle APEX (any version) function properly without a database-level primary key?

Hi all. I am having apex related issue. When I don't set friendly URL on then this download functionality works fine using the Application Process.

<a href="f?p=&APP_ID.:2:&APP_SESSION.:APPLICATION_PROCESS=DOWNLOAD_JASPER:::DOWNLOAD_JASPER:#CREATEISSUE#">
    <i class="fa fa-download" aria-hidden="true"></i> </a>

But i want to do the same after Setting Friendly URL's on but somehow it's not working. If someone can guide here regarding this issue?

<a href="&APP_ALIAS./2?session=8719534806457&request=APPLICATION_PROCESS=DOWNLOAD_JASPER">
    <i class="fa fa-download" aria-hidden="true"></i>
</a>

hello everyone, In Region display selector i want to move tab by button one region to another region

Hi, i had a query regarding Apex charts. Just some Apex related issue as it doesn’t format the label as i set the date format in the properties.

Im looking for options to connect to On-Prem EBS Database from ADB hosted in cloud. Any pointers would be appreciated.