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?

I work on an app that I have to deploy to about 12 customers local environments, all difference workspace ids, etc. Once I deploy the app I drop in their themeroller json, logo file, etc Authentication is done from a component group I have in a different app BUT my biggest problem is deploying updates. I redeploy the app, and then have to remake the 3 items above (themeroller json, logo, authentication copy from the 'sso-tester' app I always do locally Is there an easier way to make localizations on authentication and themeroller. Logo seems like I could make it a workspace logo file and always have it the same name or something.

Hii Team, how can set default value for combobox , in below case users should not remove Accounts Team or Data Privacy Team .

Hi, What are the tables and views associated with working copies feature of Oracle APEX? Is there an audit table feature that keep tracks of the difference between working copy of the app and main version of the app in APEX240100 schema? If not, how we can view the differences using an query instead the view differences option in GUI?

I'm running APEX in my autonomous database in OCI, trying to set up APEX Assistant to use OpenAI. I follow the instructions I find on the web to the letter but can't OpenAI declines the request. I know this is not enough detail to really help me, but if there is a really good tutorial out there that actually shows ALL necessary steps, that would be helpful.

Hi everyone! I have a question regarding to displaying running balance in accounting application using views table in oracle apex. is it possible that the application will slowdown in processing view tables?

Hello all, I have a requirement not to delete a row in a table for a specific value of a column (Call_ID), if the table contains only that single row for that value. But if we are inserting a new row (Same Call_ID), then we have to delete the old row, even if there is only that row. It seems a bit confusing or contradictory. In short the Call_ID is unique but once inserted, should no longer be deleted until further notice. Can only be updated, or replaced entirely... We can add a column to deactivate it if needed. I keep running into "_Mutating Table Error_" when I am trying to run a count on the table in a trigger before deleting. What's the way to handle this requirement in a trigger?

Hi everyone! :wave: I have a switch-type page item and I need to pass its value to another Modal page using a button with 'Redirect to Page' action, but the value is coming through as null on the Modal page. Does anyone know what might be happening? Am I using the item incorrectly?

Hello Everyone, Earlier, I was able to export APEX applications as YAML files, but I no longer see that option. Could someone guide me on how to locate it and assist me with exporting the application in YAML format? Your help would be greatly appreciated. Thanks in advance! Sridhar

I'm trying to access knowledge article 742060.1 to view database release schedules, support timelines, etc. but with the new support site changes, the document seems to have been moved to the "cloud" support portal. My company runs our databases on-premise so we do not have a "Subscription ID" or "Account Name" since we don't use any cloud services. Anybody know how we can access that article?

Hi All. I had a question. Does oracle apex has out of the box treemap component functionality? So instead of plugin i want to use the out of the box functionality from apex. At the moment i am doing it using the plugin. Thanks for your responses to this.

A maybe simple question. I have an apex _ldap.search which works. But how can i search for a wildcard :man-shrugging: it dont works with * or % The searchfilter is: p_search_filter => 'cn=' || apex_escape.ldap_search_filter('*')

Hi guys! How are you doing today? :) Let me try to find out if someone else is facing this scenario... I have a region type URL. This region presents a form that belongs to other apps in the APEX solution created. For most of the cases, these forms are static, but I have one where the items are shown or hiddden based on selection of specific values. When using this region using prior versions of MS Edge / Chrome / Firefox, it works. However, on latest version of any browser the region doesn’t display correctly. I’m attaching a couple of screenshots to show the issue: a couple of them belong to Chrome, latest version of the browser, and a couple of them belong to Firefox v127 Any hints on a possible work around? Thanks in advance!!

Hi, I have a requirement to track which user has downloaded an interactive report. A quick search led me to this blog from 2018, is this still the best way to do it? https://spendolini.blogspot.com/2018/04/logging-apex-report-downloads.html

does apex restricts the developer with number of opened sessions or taps ? if yes , is there a way to increase this number ( number of opened tabs for the oracle apex developers )

All my google searches yield links that are 15+ years old and are stale/dead. Looking to see if anyone has ever created a serviceable wiki with APEX. I don’t have an immediate need but am curious.

Hello Team, can we make single column of IR editable? If yes , how? Any idea

Hello Team, can we make single column of IR editable? If yes , how? Any idea

Is it possible to hide the download button on reports for some users based on roles, or alternatively password protect the download button? The requirement is to have view only and view and download roles for certain reports.

Sounds like a dynamic action with a confirmation action, if it is confirmed, next action is fired, if not its completed..

Hi team, i have a small query. Suppose in my process when certain condition meet I want to display confirmation dialog in front end. If i press YES execution of my code continues and i press NO my process terminates right there. Any idea? Thanks

Hi every one, just to know what tool do you use in your dev process to organise roadmap and ci/cd documentations. Looking one easy to fit with APEX. Thanks :)

Hiii Team, how can we change unwanted url in alert message while sign out.I used below configuration on Nevigation bar to show alert message.

currently these fields are appearing in Vertical so i need to change few fields to left side and and right side... or indirectly i want to split the region into two parts

Hi Team, In a static region i have to show around 10 to 20 fields as part of search... So here when i create page items they are automatically appearing vertically on after one ... but for me need to show few fields in left side and few fields in right side of the static region.. so could you please suggest me with any idea or help

Hi all, I have an application with an interactive report on P1 which has a link to another page, P2. This opens in a new tab and populates a field :P2_USER_ID based on the user they select. This page contains a form and a few classic reports pertaining to the user . The issue we are having is the client wants to be able to open multiple tabs within a single session (i.e. on page 1 be able to click on say 3 user names and open 3 separate tabs), this works until they try to paginate through one of the reports, at which point it uses the newly set :P2_USER_ID from the next open tab, resulting in form information displaying for the original user but report information for the user id that hast been clicked last. Is there a simple fix for this? The reports can contain tens of thousands of rows so don't want to load it all on a single page. Would something like refreshing the page on paginate to reset the user_id work? TIA

Have there been any APEX Office Hours for 24.2? Looking to see what features will be in the next version

Hi can we exclude oracle APEX internal workspace from using workspace SSO

have anyone faced before this kind of error in page designer when submitting a form , • Session state protection violation: This may be caused by manual alteration of protected page item P43_WARNING. If you are unsure what caused this error, please contact the application administrator for assistance.

in my application , I used git ( working copy ) of my app , I have the main branch and another branch which I made more features and changes in it , now how can I merge this branch into the main one , when I select the option merge into main , an internal server error occurs.

@Jonathan Rosen "this" being the APEX AI assistant? It requires the integration with an AI service. Open AI, Oracle AI (on OCI) or coherant. But you can configure it from on-prem as well as any cloud service. Assuming you can reach one of the services.

Does this only run with the autonomous server?

Hi guys, it took a while, lot's of small detail work but *apex.world 2.0 is now available with AI Assistant*. Check the video to see the new features, let us know what you think :v: https://youtu.be/RaYsJT__S5E?t=1148

but where should i use below code---function (pCurrentDate) { // Ignore the pCurrentDate and format every day the same return { disabled: false, /* Day is not disabled */ class: "customDayStyle", /* Use this CSS class */ tooltip: "Choose a delivery date" /* Use this tooltip */ }; }

have a look at this blogpost https://diveintoapex.com/2023/01/30/custom-date-picker-formatting/

Just to be sure, you are talking about the date picker item, right?

?

how can disable tomorrow and day after tomorrowdate from calender page item

hiii everyone,

Question.. when I have a page with a few popup lov's, I need to make some of these un-editable for some users. I initially set them to have a server side read-only condition but ran into the LOV's displaying the LOOKUP value instead of the DISPLAY value when the read-only condition occurs. I solved this with a dynamic action to disable the LOV's, but wanted to see if this is a known issue..

I am almost certain I've used the functionality to have a Data Load Definition selector with multiple column values before. Is this possible? I have an Excel file that users inconsistently change the column heading and they refer to it as COST CODE or COST CENTRE. See example image below of what I think was possible, but not certain what the delimiter is. I have tried space, comma, pipe, semi-colon and colon.

:wave: Hi everyone!

Hi All, Weird thing - we upgraded from 18.2 to 22.2 recently. I have page to view an object's details, and it includes a classic report that shows related child records. The classic report only shows 24 rows, with paging. In 18.2: If I view the page with Object A, and it has 50 children records in the classic report, I can go to page 2 of the classic report. If I then view the page with Object B, and it has 5 children only, there is nothing to display on page 2 of the classic report, and this region shows "No data found" (which isn't accurate). In 22.2: If I view the page with Object A, and it has 50 children records in the classic report, I can go to page 2 of the classic report. If I then view the page with Object B, and it has 5 children only, the page doesn't even emit HTML for the page 2, and I am left with "bad html" and the page renders really poorly. It feels like a bug, but wanted to know if there is an easy solution. MANY pages in the application link to this page, so updating all links to include "reset pagination" will be a pain in the behind. I'm not sure if there's some other solution to this (somehow reset pagination every time the page is accessed?) Thank you!

what is the most reliable method in creating a log in system for my apps in oracle apex ? create 2 tables ( users table and roles table ) and assign each user to a role ?

Hi - Apex version is 23.1.0 For a POPUP LOV, Ive been using the "Additional Outputs" feature fine, if the output is a field on the page. Im trying to output a LOV column to an *Application Item* - is there a special way of specifying this? ie PID:P1_PID works, and sets the LOV column PID into the page field P1_PID but PID:CURRENT_PID doesnt set the LOV column PID into the application_item CURRENT_PID . Do I need to specify it differently? Or is it not not possible to output to an application_item • Note the help text says: ◦ "Define a mapping of LOV column name, to page item name or Interactive Grid column Static ID." so i suppose not... ◦ But I was also a bit confused with: "Supported Substitutions: Application, Page Items and System Variables"

Question for the community: All page items all of a sudden are no longer showing in the layout editor, only on the left hand tree. This is for all apps on my APEX installation. Any ideas?? v20.1 Thanks in advance

has anyone tried to make a ticker moving bar in their apps ticker moving bar is the bar that is used to a moving display data just like the stock market bar and the news bar