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.

Dear All, I’m exploring Oracle APEX integration with DocuSign. If anyone has blogs, resources, or insights to share, I’d greatly appreciate it.

Is it possible to copy multiple pages from one application into another application? We have some standardized documentation pages (about 20 pages), that we want to copy to a couple other applications. Obviously copying one by one works, but I was wondering if there was a way to copy all 20 at once.

Hello, need your help to understand where the issue is in this code? See error in the screenshot.

declare 
	l_query varchar2(1000);
begin
	l_query := q'[begin
                    insert into cifhist.TEMP_DATA
                    select *
                    from cif_control.tr_call_fact partition (:a)
                    where rownum < 4
                    and K_PLAT_ENTRY_CARRIER like 'MX%'
                    and (k_leg_type like '%T%' or k_leg_type like '%B%');
                  end;]';

	for rec in (select partition_name 
				from user_tab_partitions 
				where table_name = 'TR_CALL_FACT'
				and rownum < 3)
	loop
		DBMS_OUTPUT.PUT_LINE('rec.partition_name = '||rec.partition_name);
		execute immediate l_query
        using rec.partition_name;
	end loop;
	
	commit;
end;
/

Both queries taken separately, work fine (The insert statement in the l_query variable, and the query in the loop).

we just upgraded to APEX 24.1.3 in our development environment. i exported an app and attempted to re-import it and received an error during import. it is related to a 4MB RTF file saved as a report layout. i am the second comment on this discussion forum post: https://forums.oracle.com/ords/apexds/post/copy-application-in-oracle-apex-24-6660. any suggestions would be greatly appreciated.

After great feedback from you, I have improved the APEX Assistant, so that it now prioritises the App Builder User's Guide first, then the APEX API documentation (with additional instructions to first find more general use cases and only then add specific use cases), and only give Javascript APIs as an alternative. I hope it gives even better responses now.

Hi I am trying to run this query but don't understand why the error

with TB as (select ani from cifhist.search_ani)
Select T.call_id, T.call_date, T.plat_entry_point, T.new_ani, T.called_number, connect_time, plat_exit_point, egress_duration
From cifprot.call PARTITION(P202407)
Where 1 = 1
and rownum < 10000
and (called_number Like '%'||TB.ani Or new_ani Like '%'||TB.ani)
and egress_duration > 0
and substr(cost_error_code, 1, 3) Like '%E';

ORA-00904: "TB"."ANI": invalid identifier Error is at Line 7: _and (called_number Like '%'||TB.ani Or new_ani Like '%'||TB.ani)_ How can I refer to the ANI from the _cifhist.search_ani_ table without joining with the partition table _cifprot.cal_l , which is a huge table?

Broad question here but in 23.2 or 24.2 has anyone encountered display issues with Edge and APEX interactive report pages?

Hi, has anyone had experience of producing their own fonts to compliment the APEX set? Be grateful for any pointers. Thanks James

Hi everyone, I got a stacked combination chart with 3 series (bar chart, line chart and area chart). To get the total value of the stacked bars I use the property stack in Attributes/Appearance and JS like options.stackLabel = "on"; in Attributes/JS.. both on region level. This works fine for the bar chart but does not work for the area chart. Do you know why? (pay no attention to the color design^^)