|
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
|
|
Evening all... Is there a way to modify the error page that shows up when session state protection is violated?
04-Oct-2024 12:43:AM by: Fernando Luna
|
|
Good morning, folks: Have a question related to uploading a file and saving to a BLOB column. This all works just fine but I struggle with the mime type. I have a column in my table to store the MIME type but because it doesn't get populated at all, when it comes time to read the file itself it fails unless I update the database with the correct MIME type. Is there a way to detect what the MIME type is at the time the file is uploaded to the database? Is this something that should be done at the database level (via a trigger perhaps) or can APEX detect this in some way?
[EDIT]. Googling suggests there is no perfect way to derive the MIME type from merely inspecting the contents of a BLOB file. Can APEX detect the file name in some way as it's being uploaded and perhaps I can just make the assumption that a PDF file is in fact a PDF mime type?
03-Oct-2024 06:54:PM by: Fernando Luna
|
|
Hey guys, how is it going?
I'm having some trouble finding an example on how to use Oracle APEX web service to send data in a x-www-form-urlencoded format, more specifically how to add data to the body of a POST request for that format. Does anyone have a link or sample code to share?
03-Oct-2024 01:29:PM by: Paulo Künzel
|
|
hi everyone :slightly_smiling_face: have a scenario in which i have modal page and when i close the modal page i need to refresh the item in parent page or reload parent page. is this possible? i already tried refresh region on same scenario but cant success with this
03-Oct-2024 09:49:AM by: Muhammad Ahmed Khan
|
|
Happy Wednesday folks:
Is it possible to suppress this if the user hasn't authenticated to the app yet?
02-Oct-2024 06:00:PM by: Fernando Luna
|
|
Hi everyone,
I'm encountering an error in Oracle APEX when trying to send emails from APEX:
ORA-27492: unable to run job "APEX_230200"."ORACLE_APEX_MAIL_QUEUE": scheduler unavailable.
Does anyone know how I can re-enable the Scheduler or if there's any step I'm missing to resolve this issue?
02-Oct-2024 05:03:PM by: Alberto Barrio
|
|
Does anyone have advice for sorting in APEX charts?
Specifically, sorting for a Box Plot.
The default sort is alphabetical by name of series/label. I do not want that, I want an alternate order. I am NOT dealing w months so the Time Series does not apply.
For other chart types - bar, line - if I turn Fill Gaps OFF (and adjust the query to fill gaps iff necessary) the chart honors the ORDER BY in the query.
But not for a Box Plot.
I have yet to the the ORDER BY item to work for any chart type.
Any suggestions are welcome. Thank you!
02-Oct-2024 01:36:PM by: thtechnology
|
|
Want to trigger APEX Processes using a custom event, such as from a Dynamic Action, please vote for APEX Idea: https://apex.oracle.com/ideas/FR-4039 This could be especially useful if you want to trigger a process from a Actions or Row Menu item, especially since you can now have processes run in the background. Otherwise you need DBMS_Scheduler, or calling an Automation.
02-Oct-2024 01:31:PM by: Joe Kerr
|
|
Dears, I have already existing APEX application that uses LDAP for authenticating users, the client asked to add sso portal as a third party, when the user authenticated using sso portal he can access all the internal apps using sso jwt token, if the sso is not working go back to LDAP, how to implement this in oracle APEX? anything out of the box or need to be handled in PL/SQL?
30-Sep-2024 03:30:PM by: Mohannad Amarneh
|
|
Good morning everyone!
In a public access application I am developing, I need to be able to select the APEX theme based on certain logic, which I won't explain here. The question is simple: How can I programmatically change the APEX theme? Essentially, I want to choose one of the pre-established themes for the application. Well, it should be quite simple, but I haven't found a clear answer. I appreciate your help in advance.
Best regards to all!
30-Sep-2024 12:03:PM by: Juan Carlos Pérez
|
|
Dears, I hope this finds you well, I am building some template component to customize the client theme, but I couldn't find where to customize the shape of the pagination section, any ideas?
30-Sep-2024 07:22:AM by: Mohannad Amarneh
|