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

Hi All, we have huge app (500+ pages). We are developing it in language x (primary lang) and then we translate it into language y. Now we are playing with idea that it would be easier to develop when primary language would be the y. Is there some procedure that would help us switch language? Is it at all doable without much coding or manual work?

> If you are using Oracle Autonomous Database or Oracle APEX Application Development Service, Oracle automatically applies Patch Set Bundles to your database soon after they are published. My OCI instances of APEX are still on 24.1.1 instead of the most recent patchset 24.1.5. Does anybody with APEX service or Oracle managed APEX have a more recent patch than 24.1.1? https://apex.oracle.com/ has 24.1.5

Is it Grid column or a page item?

I notice that in a column that is part of a primary key (number) that is defined as an identity column, If I insert into this table without specifying a value for the primary key via sqlplus, it populates it with no problem. In APEX I get ORA-01400. Can someone explain why this happens and how to mitigate it?

Anyone have a nifty way to move a button into the header of an Interactive Grid? Since that is NOT an option when creating a custom save button for a grid? (Don't ask, customer does NOT like the standard save button displayed in a read/write grid)..

hi, someone ever encountered an error when opening the page designer and got the error - ' JSON.WRITER.NOT_OPEN ' and could not be able to work on the page.. ? an image is attached

Hi All, Question on release notes for 22.1. Section 8.2 lists Desupported Properties "Region Image" and "Image Tag Attributes. In APEX 18.2, I was able to find those settings in table wwv_flow_page_plugs (columns "region_image" and "region_image_attr"). However, in APEX 22.2 region_image still exists, but seemed to have moved to another region setting for "File URL" under the Image settings (see picture). So can anyone confirm? It seems region_image_attr is really the only thing that was dessuported, and region_image is still supported, but just changed where it is found in the builder. Thank you! https://docs.oracle.com/en/database/oracle/apex/22.2/htmrn/desupported-features.html#GUID-4966D4CC-E23D-4B1D-AA8C-438233A2793A

Hello guys :wave: I am facing a weird issue. This query:

       ROW_NUMBER() OVER (ORDER BY V_COUNTER ASC) AS CHUNK,
       V_COUNTER,
       V_END,    
       V_TIME1,
       V_TIME2
  from MY_TABLE
 where V_PARENT IS NULL AND V_STORY = 7;

is reflecting following result in developer (Attached developer screenshot). But same query is giving false results in values for V_COUNTER and V_END. Can someone please just have a quick look, what do I miss this time :confused:

Hi, We have a problem with apex_web_service. From SYS user, simple UTL_HTTP is working but where as APEX_WEB_SERVICE is failing. From the target we are getting certificate error using APEX_WEB_SERVICE. Checked ACL and don't find any issue. Also gave below privileges. begin DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE( host => '*', ace => xs$ace_type( privilege_list => xs$name_list('connect'), principal_name => 'APEX_230200', principal_type => xs_acl.ptype_db)); commit; end; / Any idea how to debug issue with APEX_WEB_SERVICE. Any help is appreciated. Thanks

Given a button inside an APEX page, if I choose for it to redirect to a URL, can the URL contain any sort of variable? If so, how does that work? Would it be &VARIABLE. or #VARIABLE# or is it preferable to do this with a Dynamic Action?

Hi, I am using APEX 21.2 and I am trying to get a select list to auto populate with a value if there is only one value in the list on either a page load or a cascaded select list. Any ideas would be greatly appreciated

Hi All, I am working on an upgrade from APEX 18.2 to APEX 22.2. I have noticed many pages in the application have some deprecated "positions" or might be called "template points" in other places. Neither the "Upgrade Application" or "Advisor" make any mention of these issues. Is there a way to find all deprecations in the system? I noticed that I CAN find "BODY_3" in the exports, and this helps me identify those. But that doesn't tell me what other deprecations may have so far gone unnoticed. Any advice on how I might search for such things? Thank you!

Good evening - is it possible: i have one calender Region with all tasks for example and then i have calender Region for every colluege. Can i Drag and drop the task trough calender regions or a Plugin? Best example - Outlook Calender

I want to use existing database credentials to authenticate to an app I'm working on. If the user is defined in the database, they should be able to access the application. Under Shared Components > Authentication Schemes I set it to "Database Accounts". I am getting "You are not authorized to view this application, either because you have not been granted access, or your account has been locked. Please contact the application administrator." The rest says:

Technical Info (only available for developers)
is_internal_error: true
apex_error_code: APEX.AUTHORIZATION.ACCESS_DENIED
component.type: APEX_APPLICATION_AUTHORIZATION
component.id: 2210073575181779
component.name: Reader Rights
error_backtrace:
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
00007FF74BE86530       981  package body APEX_220200.WWV_FLOW_ERROR.INTERNAL_GET_ERROR
00007FF74BE86530      1049  package body APEX_220200.WWV_FLOW_ERROR.INTERNAL_ADD_ERROR
00007FF74BE86530      1522  package body APEX_220200.WWV_FLOW_ERROR.RAISE_INTERNAL_ERROR
00007FF714FFE9B0       853  package body APEX_220200.WWV_FLOW_AUTHORIZATION.IS_AUTHORIZED
00007FF73BC99CE0      2918  package body APEX_220200.WWV_FLOW.SHOW
00007FF73BC99CE0      5393  package body APEX_220200.WWV_FLOW.RESOLVE_FRIENDLY_URL
00007FF7360C5350         2  anonymous block

I am running Apex 22 on 12c. What have I overlooked? I don't think I have to create the users inside of APEX as well, do I?

Hello, trying to disable debugging using APEX_DEBUG like:

apex_session.set_debug ( 
	p_session_id => :APP_SESSION, 
	p_level => null 
); 

but is not willing to collaborate... based on docs "The debug level. NULL disables debug, 1-9 sets a debug level." 0 doesn't help either... any idea?

in apex workflow , how can I assign a workflow to someone to trigger the workflow , when I activate the workflow from development into production i receive this message :

If you'd like a more robust built in data loader for apex please vote for my idea here: https://apexapps.oracle.com/pls/apex/r/apex_pm/ideas/details?idea=FR-4079&cs=1cWUU54At[…]hp9d6t5hoQhgsj_CPxwxIrQmHDqFEmFopPRJuVmGjlPOg6mr-yN-2Ggk6Ow