Workflow - Can I not use a passed in parameter as a substitution variable for the Title anymore (when driving from a PK)? Seems to throw an error when following Steve’s blog post - https://diveintoapex.com/2023/11/15/dipping-my-toe-into-workflow/

Can a Workflow definition be exposed to the APEX runtime front end? For example to allow end users to dynamically create / modify a workflow. Does anybody have any examples of such if so?

Boys and girls, i'm looking to convince myself and my partners that we should use APEX for our projects. We looked at some web apps, particularly public web apps and what we've found is that the design is not usually top shelf. Can you recommend website built with APEX that have a top notch web design? Looking forward to your links!

Guys help, I am trying to dynamically change the columns in Apex report. I am using PL/SQL Function Body returning SQL Query and dynamically changing tables and columns for example : IF :P103_USE_SEGMENT1 IS NOT NULL and :P103_USE_SEGMENT1 = 'Y' THEN v_query := v_query || ', mil.SEGMENT1 '; END IF; But new columns does not show up in report ? What am I doing wrong?

Hi everyone! To continue my question from 2 days ago, I tried apex_region.open_query_context to export report data, from a non apex session (sql developer). I get this error: "ora-20876: Stop Apex Engine". That happens on apex 24.1.2. On apex 20.2 it works as expected. Does anybody have some advice? Edit: i am trying to export data from an interactive report, which i use because i need the pivot function.

I have implemented an Oracle APEX application integrated with OpenAI API for SQL query generation based on user prompts. The system uses Oracle ADW metadata for column information and relies on OpenAI for generating SQL queries. However, for complex questions involving formulas (e.g., "What is the attrition rate for the last 3 months?"), I face challenges as the pipeline does not blend database metadata with OpenAI's knowledge repository seamlessly. Is it possible to configure Oracle APEX to dynamically integrate both ADW metadata and OpenAI's knowledge, enabling the generation of more accurate queries? If so, could you provide guidance or best practices for implementing such a blended architecture within the APEX platform?

Different question, when doing a page copy from with APEX builder, having a page open.. If I am in App 100 and wish to copy a page from App 101, it seems that the page alias and page groups are NOT copied from App 101 to App 100. Can I confirm this is a known issue?

Hi everyone! Is it possible to programmatically trigger the action of sending an email for an APEX report? What I want to achieve is to populate an APEX collection dynamically before the email for the report is sent automatically. I hope this makes sense. Any guidance would be greatly appreciated!

Hello

Anyone have documentation on implementing SAML authentication? A person I know is having issues with SAML and popup lov's causing a new session to be attempted when they open..

Hi guys , we would like to have regular Community Calls, let's say one per quarter? It should be an open discussion about everything APEX or apex.world related. Everybody can participate in the discussions. First one next week 22nd, 12-1pm ET. *Things we can talk about could be:* • What do you think of 24.2 • What do you like / dislike in APEX or apex.world • What would you like to see in the future • Are you happy with the general direction of APEX • Ideas for re-activating the community *Things we won't talk about are:* • How do I do this or that in APEX? • I encounter a bug, etc. you get the idea :wink: (You can ask these questions in our apex.world Slack Channel or on the Forum or the apex.world AI Assistant) *Nothing is recorded, No AI Companion, Everything is private, What happens in Zoom, stays in Zoom* :wink: • Means if somebody from the APEX team is joining, no Safe Harbour needed, they are private :wink: • To quote Joel in similar talks: "We are all friends here, let us know what you really think". *The whole point is to participate in discussions* (but of course you are also free to just listen) • We would promote you from attendee to panelist, then we ask you to turn in your video to participate • Zoom would quickly restart when you get promoted or demoted. It's supposed to do that :smirk: We schedule it for an hour, but we stay as long as there is a lively discussion going on. Feel free to share this invitation with others not on this platform. I think it's time we bring the community back together. I'm looking forward if you want to support this and participate :v: Find attached the invitation as .ics file and Google Calendar (.html)

Does anyone know how to connect to the upcoming office hour session, ‘What’s New in APEX 24.2 – Part 1’? I cannot find the link to zoom. Usually it was possible to join a session by clicking a button on the landing page (https://apexadb.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=436790[…]session_page=3&clear=2&debug=LEVEL2&session=216149238823428) but now there is no such button available

Hi All. I had a query regarding apex *classic report pagination*, it's *not showing up in the Classic report with Cards Template.* If someone can guide what can be the issue? Thanks

Is there somewhere you can download old versions of apex? I'm after the "images" folder for apex 5.0.3

Oracle APEX 24.2 is now generally available! This release unlocks new capabilities for AI-powered apps , configure RAG data for AI calls, automate Fusion Applications integration, work directly with JSON data , and much more! https://apex.oracle.com/go/242-is-now-available

Hello, I have a popup Lov for the form field. I want the 'All' value in the drop-down values. When I click on it, all values in the drop-down should get selected. How can I implement this, can someone help me with this requirement. Thank you in advance! Sridhar

Hi, I have a script inserting data into a table in Toad. While scripts is still running, is there a way to know how many records have been inserted in the table so far? If I use another session I cannot see data because no commit was done yet in the first session.

Apex 24.2 is released on Apex.oracle.com

I have a question about "Bulk Collect....Limit". This "limit" here means only 10000 records will be fetched? I have 49 millions of records to upload into a table reading from external table (based on a csv file). It was advised to add the limit syntax to the bulk collect. Which Limit should I used to avoid any problem?

Hello, I have created form with page items having cascading list on values. I'm using same page to edit changes for which i'm using set value dynamic action. The issue is value is in session state but not getting set in page items having cascading list on values. Any help will be appreciated.

Hello, I would like to understand the best practices for customizing interactive and classic reports in Oracle APEX to meet specific project requirements. For instance, I need to modify export functionality, or custom filtering options. Could you please clarify if there are any limitations or recommended approaches to implementing such customizations? Additionally, are there particular guidelines to ensure compatibility with future updates of APEX?

*Hi APEX fans,* I'm planning to split my app into multiple mini-apps for various reasons, guided in part by recommendations from the _apex-lifecycle-management_ document. I have a question about implementing a *Shared Navigation Menu*: What are the pros and cons of using a *static published list* versus a *dynamic published list* (based on table(s))? Looking forward to your insights!

In Apex 24.1.6 Ive got some questions about GANTT charts. 1. Im am always wanting the chart to display data between 7am and 7pm for today. This is easy enough in the where clause. However if no data is found for the chart, it shows the horizontal time axis of "now" to "now plus 24hrs". *** How can I configure this to default to "7am today" and "7pm today" in all cases, whether data is found or not? 2. What's the difference between the setting under "Series" for Timeline and the Viewport ? (tbh, Viewport setting doesnt really seem to do anything for me) 3. If I choose a "Start Date Source" of Item, what format should the "Start Date Item" be? ie if I am choosing a "Hidden" field, how do I ensure that I am putting a correctly formatted "date time" into this field? ie what format to use? 4. Is there any good documentation about all the "options" available to be set in "Initialization JavaScript Function" in Region Attributes for GANTT Charts?

I'm trying to make a classic report with pictures of and the possibility to open the pictures in full size / full screen. I've got the report going but having trouble setting a consistent size of the. Also created a modal to show the pictures but again having trouble setting the size. Can i get some pointers on how to adjust sizes, where to enter css code?

Hello, In oracle apex I created two page. In first page i created one button when I click the button then open one model page .In model page their is a 20 second timer running when the timer will 0:00 then model page will close. I am stuck how to close model page by timer. i have no knowledge of javascript.

Will you be in Austin, Texas for the Oracle CloudWorld Tour this month, or do you live nearby? Come learn about *Oracle APEX* no-code/low-code application development with us (or share with friends and colleagues)! We're hosting an http://apex.oracle.com/|Oracle APEX "https://apex.oracle.com/go/bootcamp-at-austin|Bootcamp @ Austin" event on January 31st at Oracle HQ! This event is the perfect *FREE* EVENT for beginners (or anyone who might benefit from an APEX refresher) who would like to learn how to build no-code/low-code apps on the Oracle Database technology stack. Learn more here: https://apex.oracle.com/go/bootcamp-at-austin https://forums.oracle.com/ords/apexds/domain/dev-community?tags=orclapex|#orclapex

Hello, I am struggling to find a proper formatting for the numbers. In my app, numbers can be very big (45) or very small (0.0345). I need to display numbers with the thousand separator and not mess around with the decimals. The numbers should display like this: 45 should display 45 0.0345 should display 0.0345 1234567.54 should display 1,234,567.54 So far the only options I found when I want to show the thousand separator is to SPECIFY the number of decimals. I want the decimals to be unaffected by the thousand separator. Is there something available. Thank you for your help! Happy New Year! All!

Want to make it easy to add Authenticator App and FIDO security key authentication to the applications you build? Please vote for: https://apex.oracle.com/ideas/FR-4165

Hi everyone, I am currently replacing “confirmDelete” with “apex.confirm”. Is there a way to replace all of them at once?

Happy New Year everyone!! In Oracle Apex I have an Interactive Grid, which is created via a dynamic query. For a kind of matrix table, virtual columns are generated for the next 10 years. Last year it went from 2024 to 2034. Today the application returned an error that 2024 is an invalid ID. To fix the error, I had to reinitiate the dynamic query in the Page Designer. The columns were updated to 2025-2035. To get the years, I use in the code: “extract(year from sysdate)” My question would be whether there is a way to avoid such an error after a year change or to automate the re-initiation of the virtual columns?

Hii....does anyone have azure ad account to check sso with apex ?

Does anyone have resources on file preview functionality? It would be highly appreciated

Looking for help from somebody familiar with spatial https://forums.oracle.com/ords/apexds/post/spatial-query-returning-points-outside-a-polygon-7626

anybody using apex and spatial indexes seen a checkmark appear in this explain plan visualizer?

APEX 24.2 ?

Question.. I have a page with a parent grid (projects) and a child grid (project details) when I have a project row selected I am clicking a button to add a row to the project details grid. However when I close the modal for entering the project detail info, the row I was on in the project grid is deselected. I am capturing the id of the row in a page item, but need a way to reselect the row after closing the modal. Anyone have an idea on this?

Hi all. I had a general question, is it possible to enable debugging automatically when i run the apex application? I tried something like this but seem to not work. If someone can respond to that?

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

Free Course

:mega: Oracle Database 23ai & APEX Iberian Tour is coming to you! https://blogs.oracle.com/apex/post/iberian-tour-2025

I was thinking with the downtime of apex.oracle.com this weekend we would awake to 24.2?? :thinking_face:

Was wondering if it's worth adding another channel. Have some questions on the "AI Assistant", and feel with as big as that topic is, might be a separate channel. Anyways, my company is going to start Microsoft Copilot for Business, since MS already has all our data anyways. From what I have read, APEX 24.1 currently only supports OpenAI, and OCI Gen AI Service. Any plans for when other services will be supported? Or is there ability to add our own service somehow?

HOW would we know what code is behind that? the Oracle portion is just a wrapper to java code in the database, right?

Hello all, Where can I see the full code of the yellow highlighted Java procedure? It's meant to get file from sftp server and push into external table in oracle. I would like to see where is the code that's doing that. Any help?

Hello APEX Family, I know much has been written and said about this topic, but so far I haven't had the need to address it, and I would like to know if there is any option available from APEX itself or from any other approach: I need to be able to copy a private IR report from the owning user to another user. Alternatively, the option to "share" a private report from one user with selected other users would also be valid. *Ideally, a user would create a private report and share it with others of their choice in "read-only" mode.* As always, I appreciate your feedback and collaboration. Best regards, and thank you!

I am doing an advent calendar with short APEX tips and tricks videos every day. The first 11 videos are already online; you can check them out in this playlist: https://www.youtube.com/playlist?list=PLpg61eZsDU4Z4G67ZwX6K5CQh0HhqyM5Z :christmas_tree:

There was some APEX / ORDS patch issue in Ashburn OCI today which caused an outage across multiple Autonomous envs. Does anybody have further info on the issue? or even how we could detect that patching was scheduled or taking place? Ideally this would be visible from the ADB console in OCI.

Hi Hi everyone! Is there a way to restrict access to Public Saved Reports based on user groups? Currently, when a report is saved as Public, all users can see it, but I need to limit which users can access specific public reports.

Hello team, I'm try to update multiple rows using interactive grid custom process. But I'm getting this error *1 error has occurred* • Session state protection violation: This may be caused by manual alteration of protected page item BUDGET_PERIOD. If you are unsure what caused this error, please contact the application administrator for assistance. i have set source attribute for page item (BUDGET_PERIOD) to query only but still not working. This is my custom process BEGIN IF :APEX$ROW_STATUS = 'C' THEN INSERT INTO XXPAN_BUDGET_MONTH_CONSUME ( REC_GUID, BUDGET_PERIOD, BUDGET_YEAR, DEPARTMENT_NAME, VENDOR_CODE, MONTH_AMOUNT, DESCRIPTION, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY ) VALUES ( :P121_GUID, :BUDGET_PERIOD, :P121_BUDGET_YEAR, :P121_LEGAL_CONTENT, :VENDOR_CODE, :MONTH_AMOUNT, :DESCRIPTION, SYSDATE, :SESSION_EMAIL, SYSDATE, :SESSION_EMAIL ); COMMIT; ELSIF :APEX$ROW_STATUS = 'U' THEN UPDATE XXPAN_BUDGET_MONTH_CONSUME SET VENDOR_CODE = :VENDOR_CODE, MONTH_AMOUNT = :MONTH_AMOUNT, DESCRIPTION = :DESCRIPTION, PURCHASE_ORDER_NUMBER = :PURCHASE_ORDER_NUMBER, LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = :SESSION_EMAIL WHERE ID_NO = :ID_NO; COMMIT; END IF; END; Any idea how to solve this error?