 |
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)..
06-Nov-2024 05:35:PM by: Tony Miller
|
 |
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
06-Nov-2024 08:13:AM by: Yaara
|
 |
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
04-Nov-2024 06:08:PM by: Doug S
|
 |
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:
04-Nov-2024 10:54:AM by: Hammad Iftikhar
|
 |
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
03-Nov-2024 02:08:PM by: Ravi Kiran
|
 |
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?
31-Oct-2024 08:38:PM by: Fernando Luna
|
 |
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
31-Oct-2024 11:34:AM by: Jim McCluskey
|
|
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!
30-Oct-2024 09:37:PM by: Doug S
|
 |
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
30-Oct-2024 08:05:PM by: Andi Oberhauser
|
|
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?
30-Oct-2024 02:50:AM by: Fernando Luna
|
 |
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?
29-Oct-2024 10:14:PM by: lucashir
|
 |
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 :
28-Oct-2024 08:43:AM by: XENO_NEMSESIS
|
 |
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
27-Oct-2024 01:11:PM by: Stirl
|
|
How would I go about changing settings in Apache so that anyone pointing a browser to myapp.company.local gets redirected to machine:8080/ords/r/schema/app/home ?
(Currently running apex 24.1 on oracle 19c with tomcat)
26-Oct-2024 12:01:AM by: Fernando Luna
|
 |
HOW TO HIDE OR SHOW BOTTONS ON ONE PAGE BY APPROACHING PAGE IN DIFFERENT WAY. BY REDIRECTING TO PAGE BY BUTTON OR BY APPROACHING PAGE THROUGH INTERACTIVE REPORT
25-Oct-2024 10:30:AM by: saurabh shirke
|
 |
Does anyone have used cypress and ghost inspector on APEX applications configured with Microsoft Azure Authentication?
25-Oct-2024 02:30:AM by: Mclovin
|
 |
Does anyone know if when an Execution Chain (running in the background) is launched, is it still tied to the APEX session? In the background process, I am trying to modify collections, and it does not seem to be populating any collection information for the session.
24-Oct-2024 04:30:PM by: EJ Egyed
|
 |
ZUGFeRD and eRechnung (xInvoice) do become inevitable wef. 1.1.2025 for companies in the EU to exchange invoices on a B2B basis; especially the german standard called ZUGFeRD consists of a an invoice in a PDF/A3 format (like a PDF with attached xml-file).
I outlined my development status in my APEX blog: and wonder if anybody wud like to contribute.
Thanks for ur time !
24-Oct-2024 02:07:PM by: BernhardFW
|
 |
Apex 5.0 on Oracle 19.24. When I try to save changes to a Interactive Report Apex shows the “Changes Saved” message but it doesn’t actually save it. If you try to navigate away from the page you get the “Changes not saved” warning message. This is a new issue I first encountered yesterday. Any points on tracking down the cause of this issue?
24-Oct-2024 12:18:AM by: Trev
|
|
Ok, I have a weird case here and need assistance.. I have an interactive grid with 1 updateable column, there can be 1 row of numerous. it is a date column, and after its changed I wish to write it out to the table it is queried from. I initially tried using an on change dynamic action with an update statement:
Update <table> set <column_name> = :REVIEW_DUE_DATE where id = :ID;
Now the issue is the column gets the changed attribute set (upper right corner turns blue) and when I do other operations on page I am getting a warning about unsaved changes on page.. Is it possible to disable this message for the grid? I have the Warn on unsaved changes turned off for the page..
23-Oct-2024 07:26:PM by: Tony Miller
|
 |
Hello colleagues, I recently heard that the rich text element "TinyMCE" is going to be discontinued and will be replaced by the "Oracle Rich Text Library." I am currently using "TinyMCE" because it allows me to paste image content from my clipboard, but the "Oracle Rich Text Library" does not allow me to paste that type of content. Is there any way to configure "Oracle Rich Text Library" to allow me to paste binary content (images) from the clipboard?
Thanks!!
23-Oct-2024 07:04:AM by: Juan Carlos Pérez
|
 |
Hi all. I had a question. At the moment in my apex application i am achieving the side navigation *using this Plugin Splitter. splitter dynamically divides the available space for two sub regions horizontally or vertically.*
Can i achieve it without using any plugins? Thanks for your guidance regarding that.
22-Oct-2024 11:27:AM by: Muhammed Sharjeel Arshad
|
 |
Hi everyone,
I thought this was a common question, but I couldn't find anything using the search. I have two servers running Oracle APEX: one for development and the other for production. There are many processes that send notification emails to users within the company.
Is there a way, or a script, to automatically update the "To:" fields with the actual users who should receive the notifications when moving from DEV to PROD? Currently, I do this manually for each page that has an email-sending process. It wasn't too difficult at first, but as the application grows, it's becoming harder to keep track of all the pages.
21-Oct-2024 10:22:PM by: Isaac Lañado
|
 |
Goal: Add an IR Pivot table column that totals the values in each Pivot row.
How can I do that when defining the IR Pivot? Do I need to do something with the SQL defining the IR?
21-Oct-2024 04:06:PM by: Joe Kerr
|
 |
Hi All,
Good day!
We have created an APEX Automation which is working fine on demand but the scheduled automation is not working. Any ideas on this? Thanks
21-Oct-2024 12:45:PM by: Venky Royal
|
|
There is a Double // in the url?! Maybe thats the Problem
18-Oct-2024 11:28:AM by: Andi Oberhauser
|
|
Hi all. I am having this issue with using VS-Code Editor plugin inside the apex application. Getting this error, could not load a library. If someone has clue what could be wrong or missing here? Thanks.
18-Oct-2024 08:37:AM by: Muhammed Sharjeel Arshad
|
 |
We're using Social Sign In (OpenId-AD). We would like to redirect to different screens based on roles after AD login. But, we get too many redirects error when implemented. Sample code below. Any suggestions are much appreciated:
17-Oct-2024 10:32:PM by: Kumar V
|
|
Asking for a friend on another site.. Has ANYONE implemented an APEX Application Exception handler using Logger? I tried a quick search and found AOP folks doing something homegrown, just wondering anyone else has done something like this?
17-Oct-2024 06:14:PM by: Tony Miller
|
 |
Hi All
In Apex 23.1, I am trying to tie an OnClick DA to a tab header (not the region below the tab). (see (1) in attached image).
When I had the tabs defined with RDS (Region Display Selector) region, my OnClick DA worked fine, with the jquery selector as being:
#my-tab-container-region-static-id *.a-RDS-item .a-RDS-link*
But Ive altered the tabs now to be children of a top level "Static Content" region...
From inspecting the page source, I believe this should be the jQuery selector:
#my-tab-container-region-static-id *.t-Tabs-item .t-Tabs-link*
but the DA doesnt fire at all (I have a console.log as the first step, to determine this, and it doesnt fire.)
17-Oct-2024 02:31:AM by: Alister Miller
|
 |
Hi everyone! I was wondering if it's possible to configure a third-party SMTP server in OCI, or is it mandatory to use Oracle Email Delivery Service for outbound emails?
16-Oct-2024 08:49:PM by: Alberto Barrio
|
 |
For anybody on Mac and maybe already using Alfred: I created a small workflow to quickly jump to any PL/SQL or JS documentation page or quickly look up Icons, Views, CSS classes/vars, etc. directly from your spotlight without leaving your editor.
If you are interested check out my video demo or my blog post on it.
16-Oct-2024 09:41:AM by: Philipp Hartenfeller
|
 |
Hello everyone,
I am new in Oracle apex. Need your help i am facing this below error msg during run my application.
I am going to create master detail form.
I
15-Oct-2024 01:34:PM by: Yousaf
|
|
@Indrek T Speaking of AI, I just tried to convince ChatGPT to generate a query that calculates today + N days, excluding weekends... the results weren’t great. So, I had to rely on my own intelligence for the task... Bloody free AI! Here’s the query in case anyone needs something similar—it works both ways. Any improvements are welcome; I aim for perfection.
```SELECT
d
FROM
(
SELECT
d,
ROWNUM rn
FROM
(
SELECT
sysdate + ( ( level ) * abs(:p_offset) / :p_offset ) d,
TO_NUMBER(to_char(sysdate +(level), 'D')) AS target_date
FROM
dual
CONNECT BY
level <= abs(:p_offset) * 2
)
WHERE
target_date NOT IN ( 1, 7 )
)
WHERE
rn = abs(:p_offset);```
15-Oct-2024 10:08:AM by: lucashir
|
 |
Trying to create D-link between Oracle generic setup with APEX and AWS Postgres DB - able to establish connection, but it times out very quickly.
1. IS anyone using PG as a connected DB
2. Has anyone experienced this issue and found a workaround/fix for it.
I can provide additional details, just wanted to get the question out there as we are evaluating moving to APEX.
14-Oct-2024 01:18:PM by: Steve DeYoe
|
 |
Subject: Google Authentication not working in Oracle APEX application after upgrade.
I have an Oracle APEX application with Google Authentication. https://dev.acolyteapplications.com/. The environment configuration is...
Platform: Oracle Linux8 in OCI
Database: Oracle 23c
APEX: 23.2
ORDS: 21.4 installed on second Oracle Linux8 in OCI.
I created a new upgraded environment and imported same application. https://acolyteapplications.com/. The new environment configuration is...
Platform: Oracle Linux9 in OCI
Database: Oracle 23ai
APEX: 24.1
ORDS: 24.3 installed on second Oracle Linux9 in OCI.
I am getting error: Null username passed to login procedure.
When I set Debug Level to APEX Trace, there is NO error and authentication works fine.
I tried by setting Debug Level to Application Trace, error is there as below.
I find it very strange the by changing Debug Level, application behaves differently.
Kindly help. Any suggestion is very appreciated.
```Exception in "POST https://oauth2.googleapis.com/token":
Error Stack: ORA-01841: (full) year must be between -4713 and +9999, and not be 0```
12-Oct-2024 09:25:AM by: Abhishek Arora
|
 |
I have a Smart Filter page and a Faceted page both equipped with the same query and filters/facets. The page works, search is great. The filters/facets correctly filters the results down as desired.
With one small exception. We have a Date Picker range filter/facet as described here: https://blogs.oracle.com/apex/post/date-picker-support-241 that we implemented shortly after upgrading to 24.1. We noticed that when you use the Date Picker range filter/facet, all the other filter chips disappear and the other facet areas become empty. The date range filter is working. And if we have other filters/facets selected before using the Date Picker range those selections are still active and working. After looking at the animated screenshot at the end of the blog post, I noticed that their other smart filter chips also disappear.
Is this intended functionality?
11-Oct-2024 09:20:PM by: Derek Anderson
|
|
I read in an Oracle forum that there is no effective upper bound for number of pages that can be created in an application - but, in terms of best practice... is this a good idea?
I am looking at replacing a screen written in forms that has a tree menu. There are 61 menu entries, 485 reports and 137 forms. At the moment I'm basically just calling the Oracle Reports as is so that part is done (for now). With respect to the 137+ pages that will be created to replace the 137 forms, is that unwieldy for maintenance or not a big deal?
Is it preferable to have each form re-written individually? What does that do for the behavior of the apps. Does switching from one to another require you to re-authenticate? I'm trying to avoid unnecessary re-authentication as well.
Any thoughts appreciated.
[EDIT] - it seems I can use Session Sharing to avoid re-authenticating... In some cases, the user may have to re-authenticate because it's a completely different app. In those cases I'd probably create the app in a different work space to further bring home how separate the app is. Does this work?
10-Oct-2024 07:49:PM by: Fernando Luna
|
 |
i want to create a search filed on top of classic report, where that search filed should give me matched results, from which i can select one.. i mean search filed should have like operator functionality..
10-Oct-2024 12:56:PM by: Harsha Vardhan Reddy
|
|
Hi Team,
10-Oct-2024 12:53:PM by: Harsha Vardhan Reddy
|
 |
Hi Guys,
is there anybody out there who might have a clue how to connect apex rest data source to Docuware DMS?
i tried various approaches, none of them lead to a positive result.
I cannot successfully request a auth token.
Testing the REST API with Postman works like charm.
After deeply inspecting logs of APEX and Docuware maybe i found the root cause
Docuware expects "username" and "password" attributes in the connect/token request
APEX API apex_web_service.oauth_authenticate only provides "ClientID" and "ClientSecret" when sending the Request.
I did not find any clue how to send the expected data.
Any idea how i can overcome that problem?
Maybe i can request the token using APEX_WEB_SERVICE.MAKE_REST_REQUEST calls. But how should i integrate this call into the REST Datasource definition so i can leverage the Shared Component for using them as valid Datasources for example in an IG
09-Oct-2024 02:26:PM by: p.ettinger
|
 |
In APEX 24.1 Popup LOV acts differently then previously? I have Popup LOV that will return Additional Outputs. Previously when I did not open search and typed value into text field then search was made and Additional Outputs was returned, now it does not return Additional Outputs values. Only when I open search and pick a value
09-Oct-2024 02:15:PM by: Indrek T
|
|
Hello together - i have an other question today. Is there a possibility to download APEX Patches without an Support Identifier? I updated my ORDS today and now my SQLDeveloper Web struggles.... i'm on APEX 24.1
The Server has no connection to the internet and is only for internal use!
09-Oct-2024 11:30:AM by: Andi Oberhauser
|
|
In APEX 24.1.3 and 24.1.5 how to get date picker value in JS. `apex.items.P4_MY_DATE.value` will return `undefined` (for text and select itmes at least it will return value). Can be tested in apex.oracle.com
Seems that `apex.items.P4_MY_DATE.getValue();` and `apex.item( "P4_MY_DATE" ).getValue()` works.
is `apex.items.P4_MY_DATE.value` deprecated or BUG?
09-Oct-2024 07:33:AM by: Indrek T
|
|
Hello everyone, i have a litte question about Supporting Objects. I have an app and i want make an "License Check" before Installation or after the installation. I tried it with an Pre-Installation SQL Statement to check if the entry exists but it always fails. Any Ideas?
08-Oct-2024 10:56:AM by: Andi Oberhauser
|
|
In Apex 23.1
PopupLOV seem to have an inbuilt search functionality, where what a user types is used to restrict rows returned in the LOV where the entered user text is *anywhere* in the row of the LOV.
ie under the hood, APEX does a like "%<entered text>%"
Our users have stated they want it to only restrict rows where the entered text is "at the start of a field".
ie like "<entered text>%"
Has anyone had a similar request, and how did they go about it.
I appreciate almost certainly a solution wont be able to be done with PopupLOV
REgards,
08-Oct-2024 02:09:AM by: Alister Miller
|
|
With a tree implementation, how would I use prepare_url to create a link that is opened in a new tab (is there a way to inject target="_blank"_ into the prepare_url call maybe?)
That is: Can I get the link that is used in the SQL query for a tree menu to open in a new tab? (Here is the Sample Trees app for context)
05-Oct-2024 12:20:AM by: Fernando Luna
|
 |
anybody got an example of a sql query in a data load definition that references another column in that definition? the documentation isn't there, and they don't show any examples. i tried searching and found nothing.
04-Oct-2024 10:07:PM by: Travis Caruth
|
 |
Hello all,
I need a custom domain in my oracle application url, how can I get it. Can someone please help to get ut
Example: my application is used for ticket booking.
So, I want url like ticketbook.mycompany.com
Thanks,
Sridhar
04-Oct-2024 01:54:PM by: Sridhar Utukuri
|
|
If I have an interactive grid showing a number of columns and the last column is truncated with NO SCROLL bar, how can I add a scroll bar to region to allow users to see last of the column value?
04-Oct-2024 01:51:PM by: Tony Miller
|