|
Is there a PLSQL API procedure to select a different Web Credential when calling a REST Data Source on the same remote server? There are multiple credentials to be used on the same remote server for the same APIs. For example REST Data Source get_sales_orders using credential user_abc, then call get_sales_orders using credential user_def. Trying to avoid creating a REST Data Source for each credential
23-Apr-2024 07:26:PM by: Joe Kerr
|
|
hi! i have IR on page and it take a long time to load. on debug view after execution of query there are many messages "found item user_id idx=122 type=1 filter=true value=221". what does it means and how avoid them?
23-Apr-2024 02:54:PM by: walla
|
|
Hello everyone,
I am working with apex calendar , when i use "date selected " event in dynamc action I want to restrict the range to be only 1 hour, I didn't find a clear way to do it.
and I want the calendar to start from sysdate+1 (the previous dates won't be showing up)
any ideas ?
23-Apr-2024 01:03:PM by: Achraf Gharbi
|
|
Migrating data from one system to another? Oracle Forms migration? Check out the new post https://jkerr.hashnode.dev/upgrading-systems-transitioning-legacy-data-to-a-new-system
22-Apr-2024 11:47:PM by: Joe Kerr
|
|
Hello all,
We have made a change to our Network / Application Server infrastructure. We were using a load balancer F5 in front of 3 applications servers that connect to 3 different Databases.
Now the F5 has been replaced by another one called KEMP.
I need to make full testing from Apex Applications stand point to validate new solution.
We have many applications, across the 3 different DBs (having resp. apex 4.2, Apex 5.0, and Apex 19.2)?
I don't think I can avoid running the Apex APPs one by one, otherwise could someone give me some advises as how to do this whole test?
What are key/major things to check? I know we have some webservices that I need to check, but is there any specific procedure/methodology to follow in this case of load balancer change?
22-Apr-2024 07:30:PM by: eureka7
|
|
How can I alter URL user is directed to after login?
1. App sits behind nginx proxy which hides /ords/
2. User navigates around some public pages
3. User clicks link to secured page and arrives at login page
4. User logs in
5. User is then delivered at their intended target secure page
6. I want to manipulate that URL to remove /ords/
7. How might I do that?
19-Apr-2024 09:52:PM by: Jason Stortz
|
|
Has anybody put in place any AUDIT features along with their APEX App? Don't want to re-invent the wheel, so taking advantage of ADB-S and / or APEX features would be great. Thanks
19-Apr-2024 04:08:PM by: Si
|
|
Is it possible to get the *process Name/ID* of an apex PRE-PLSQL Process directly in this PLSQL Process to log it?
Is there some "undocumented" APEX constant to solve this?
There is an Info in the view *wwv_flow_debug_messages.message:*
like --> "...Process "<my_process_name" - Type: NATIVE_PLSQL
I think , it will be done via calling some UTL_STACK Routines.
Thank you for any ideas!)
19-Apr-2024 10:39:AM by: Josef C.
|
|
@matt_mulvaney @roelhartman @Pierre Hi All, how to add condition based background colour between event starting date and event end date in Oracle Apex calendar.
From 15th to 17th date will be in green and from 15th to 16th date will be in orange colour.
17-Apr-2024 02:21:AM by: Amit
|
|
can the default file encoding be changed for the apex data loader? not a data loader page, but the developer one you get to from the object browser
also opened a forum thread, no response though
https://forums.oracle.com/ords/apexds/post/can-the-default-import-file-encoding-be-set-to-utf-8-1461
16-Apr-2024 10:28:PM by: Travis Caruth
|
|
Please help with liquibase.
I have existing schema, I create files with `lb genschema -split -sql`
I love to develop in DB. How I can get list of objects what I have changed after the first gen schema?
Can I compare object info in folder with objects in DB?
16-Apr-2024 05:58:PM by: Indrek T
|
|
From 15 to 18 background will be in green colour and 15 to 16 background will be in orange colour.
16-Apr-2024 09:50:AM by: Amit
|
|
Hi All, i am working on calendar. how to put start date and end date background in colour. If status is active or inactive it is showing a particular description only in colour. But whole cell background how to set from event starting date and event end date.
16-Apr-2024 09:46:AM by: Amit
|
|
On APEX 23.2, when using a Rich Text Editor (TinyMCE library), how can a user put an image in the content? Does the image need to be externally hosted then manually put the <img> tag directly into the HTML?
15-Apr-2024 03:56:PM by: EJ Egyed
|
|
Hello! If anyone willing to save a click every time you login into APEX Application Builder https://apexapps.oracle.com/pls/apex/r/apex_pm/ideas/details?idea=FR-3735&session=2621048188042
15-Apr-2024 03:13:PM by: lucashir
|
|
Hi, Thanks in advance, but has anyone got a solution to the below issue when attempting to open a different domain in an iframe?
`in a frame because it set 'X-Frame-Options' to 'sameorigin'.`
15-Apr-2024 02:10:PM by: Nigel
|
|
anybody seen any news about features that might be coming in the next update? assuming they're keeping the same release schedule, an update should come in May
it seems like with 23.2 we were spammed with features and office hours, and this time theres been nothing.
11-Apr-2024 04:46:PM by: Travis Caruth
|
|
Hello Everyone,
I am getting Ora-28817:PLSQL function returned an error. While using APEX_IR.EXPORT_SAVED_REPORTS() function.
I have called this function on page submit process.
11-Apr-2024 09:19:AM by: Hocco
|
|
Using Apex Data loaded page when loading large files getting "Error: Gateway Time-out" after 5 minutes.
We need atleast 10 minutes plus to process certain files.
How can we address this in OCI?
Thanks for your help
09-Apr-2024 07:35:PM by: Ravi Kiran
|
|
Ok, we have a set of applications that use an oAuth authentication scheme.. Each app has a Devl/Test scheme and a Prod scheme due to the url for the OAuth verification being different.. Is it possible to allow the scheme to switch based upon the environment it is running in? Majority of code is within auth scheme, when I tried calling via procedure/package setup scheme was crashing with pl/sql errors..
08-Apr-2024 05:04:PM by: Tony Miller
|
|
Our APEX OCI service stopping every 5-10 minutes. Re started few times but it's stopping after 5 minutes.
Please advise what needs to be done.
Thanks for your help
08-Apr-2024 02:59:PM by: Ravi Kiran
|
|
In an OCI policy what resource type is an APEX Service instance? If I want to set a policy to restrict who can create them what resource type is that?
05-Apr-2024 01:23:PM by: Jason Stortz
|
|
Hello everyone,
We have recently configured all our oracle apex application with IDCS *SSO*. The authentication works fine but the problem is after users login we are redirecting users to different pages of the application based on their user role which is defined in database table. This step is failing because we are no longer using the Page 9999 for login. We are using the SSO which automatically logs the users when they launch the application URL. Please help on how to achieve this functionality. What are the other options available.
I put plsql code ---function returning a page on Home page(Page 1) and point of execution in Before Header
*DECLARE*
*Psts VARCHAR2(64);*
*result VARCHAR2(100);*
*user_session VARCHAR2(20);*
*BEGIN*
*user_session := APEX_CUSTOM_AUTH.GET_SESSION_ID;*
*Psts := APEX_UTIL.GET_SESSION_STATE('GLOBAL_STATUS_ITEM');*
*If Psts='Admin' then result:= '2';*
*ELSIF Psts='Manager' then result:='29';*
*ELSE result:='28';*
*END IF;*
*-- Use the result as needed, or print it to see the value*
*DBMS_OUTPUT.PUT_LINE('Result: ' || result);*
*RETURN result;*
*END;*
05-Apr-2024 05:11:AM by: mayurmehar003
|
|
Hi, had a question regarding setting page item value using SQL Statement. In the sql Developer, the query returns value something like *CG$CTRL->EVNT_ORDERBY_PB->CHANGE_EVENT_ORDER_BY*. But in apex the same query sets the value in page item with a different symbol *CG$CTRL->EVNT_ORDERBY_PB->CHANGE_EVENT_ORDER_BY.*
If someone have clue about that, what could be wrong?
04-Apr-2024 10:45:AM by: Muhammed Sharjeel Arshad
|
|
Hi. Getting this error with my application ORA-01476: divisor is equal to zero after migrating to new platform. If someone can recommend how to resolve that? On other platform works perfectly fine
03-Apr-2024 08:03:AM by: Muhammed Sharjeel Arshad
|
|
The next big Oracle APEX related event is only 10 days away. If you have the option, you are all very welcome to join us in Maribor, Slovenia at the APEX Alpe Adria Conference. The agenda is again packed with full of insightful sessions by amazing experts https://www.aaapeks.info/agenda
I hope to meet some of you there in person :eyes:
02-Apr-2024 08:23:AM by: Aleš Kravos
|
|
Hi! Is it possible to customize task retention period value to be greater than 30 days?
02-Apr-2024 06:23:AM by: omar elsaid
|
|
Hi! Is it possible to disable alert on form update/insert?
01-Apr-2024 07:57:AM by: walla
|
|
Ok, a fellow developer presented an interactive grid challenge to me.. We have a grid based upon a table of participants.. When need to add a new participant, we want to have a column with a popup lov to select from a list of available people to add. When the item is selected in the popup lov, Need to populate value for the id in the new row and other columns (first, last, middle) was wondering anyone had done something like this?
I normally would have free form text fields in grid for them to enter values..
27-Mar-2024 08:15:PM by: Tony Miller
|
|
Hello everyone!
I'm trying to create REST Data Source, but a problem that resulting JSON does not have an array.
Sample JSON:
```{
"Квадрат_100_1,0037": {
"prodAmount": 111,
"prodId": "Квадрат_100_1,0037",
"prodMaterial": "1,0037 | St37-2 | S235JR | Ст3"
},
"Квадрат_100_1,0570": {
"prodAmount": 440,
"prodId": "Квадрат_100_1,0570",
"prodMaterial": "1,0570 | St52-3 (St55) | S355JR | 17Г1С | 09Г2С"
}
}```
I use Oracle APEX 23.2. Can anyone guide me how to fix it?
27-Mar-2024 06:14:PM by: alexey_br
|
|
Thanks for the reply!
27-Mar-2024 01:12:PM by: Alberto Barrio
|
|
You cannot use temporary tables in an APEX context because these are tied to a database session. And you don’t get the same database session on each APEX request.
You should definitely switch to collections.
27-Mar-2024 01:09:PM by: roelhartman
|
|
Hello everyone, currently I'm working on an application that was migrated from Oracle Forms. On one page, there was a temporary table being queried. Sometimes I retrieve information from the temporary table, and sometimes I don't. Should I switch to using Oracle APEX collections?
27-Mar-2024 01:06:PM by: Alberto Barrio
|
|
Is apex.oracle.com down for anyone? I'm currently getting this error
26-Mar-2024 06:01:PM by: EJ Egyed
|
|
Is there a way in a cards region to have it display in 1 Column? Out of the box the lowest # of columns seems to be 2 and I have a need to display a list of "cards" in one column..
25-Mar-2024 06:15:PM by: Tony Miller
|
|
Using Social Sign-In auth, Where and how I can add validation, example is account locked or not, so user will see nice error message?
25-Mar-2024 01:49:PM by: Indrek T
|
|
In OCI APEX, clicking on object browser is giving CREATE option instead of NAVIGATING to object browser...This suddenly happened and there is no way to go to objects! Please help or is there any alternative way to see objects!?
Thanks
25-Mar-2024 01:26:PM by: Ravi Kiran
|
|
hello, am trying to upload my plug-in into apex world, but it gives me this
if you could help me please !
25-Mar-2024 01:11:PM by: ouadia
|
|
Hello all,
I would like to know how to use a short and meaningful URL to redirect to the long apex URL, hiding all the parameters.
Just to have something like this: https://customer-portal.ourcompany.net
where is this configured?
Any good Doc?
We are using Apex 19.2 on Oracle Database 12c Standard Edition Release 12.1.0.2.0
22-Mar-2024 08:15:PM by: eureka7
|
|
Modernizing the eye clinic module in Oracle APEX! :rocket: Introducing a single-page solution for doctors to examine and highlight eye issues using interactive eye anatomy. Enhancing patient care and efficiency in ophthalmology clinics.
22-Mar-2024 05:39:AM by: Awais Majeed
|
|
Anyone looking for a contract gig with a gov't client? I can forward your info onto the manager of the company looking. His name is Chris Ullrich, a good manager I worked for previously.. Must be a US Citizen and able to obtain a Public Trust security clearance..
21-Mar-2024 04:16:PM by: Tony Miller
|
|
We'll be live in 5 minutes!! Join us! https://apex.oracle.com/officehours https://twitter.com/hashtag/orclAPEX?src=hashtag_click|#orclAPEX https://twitter.com/OracleAPEX|@oracleAPEX
We're going to have another fun and fantastic hour today!
21-Mar-2024 01:54:PM by: Jayson Hanes - Oracle APEX PM
|
|
In APEX 23.2 compared with previous version have we changed how in `Collapsible Region` value `Remember Collapsible State` is stored? Was it previously stored in local storage and now in session storage?
21-Mar-2024 01:12:PM by: Indrek T
|
|
I was doing some changes in my app - added css classes to make a floating button on a page. I did the changes in the application working copy but after the merge CSS styles are lost. Is this expected behavior?
20-Mar-2024 07:45:PM by: pocelka
|
|
Hello! We have migrated the app from 18.2 to 22.2 and now we are having a hard time with the new datepickers.
Datepicker shows every month beginning at day 2 and the days are offset by one day with the week day, e.g. 20th March - Thursday instead of wednesday
In globalization we have:
• App Primary Lang: PT-pt
• Application Lang Derived From: FSB_LANGUAGE_PREFERENCE (_that is set to PT-pt_)
• html header: <html class="no-js page-31 app-A1101" lang="pt" >
For reference: Dom = Sunday
Can anyone point me in the right direction on how to solve this? Thanks.
20-Mar-2024 12:55:PM by: hmarques
|
|
Hi. I had a question regarding the *table owner* in Apex, *i want to select the table from different User Schema but here in Table owner i am not able to see that schema.* Checked in the *workspace settings but there the schema is assigned to workspace*, for Table owner does that need to be set from somewhere else or some grants are required? If someone have an idea about that? Thanks.
20-Mar-2024 11:51:AM by: Muhammed Sharjeel Arshad
|
|
Hi,
I have a GANTT chart, but I want to restrict the hours displayed each day, to only business hours, to more efficiently use the horizontal space.
(As I will only have tasks with a start_time >= 8:00 and end_time <= 18:00)
At the moment, it just shows from 00:00 to 23:59, effectively wasting the red marked area in the attached image...
This is a similar concept to calander region settings:
pOptions.slotMinTime = "08:00:00";
pOptions.slotMaxTime = "18:00:00";
A *second* question - does anyone know how to completely supress the "progress" bar under a task.
(I dont need to show it at all)
Regards,
Alister (Apex 23.1)
20-Mar-2024 06:00:AM by: Alister Miller
|
|
Anyone worked with Oracle Analytics Cloud with older versions of Apex (5.1)? We are trying to work out how to invoke a report from Apex and get the resultant PDF as a blob. This blog post is very close but the apex API calls don't exist or a different in 5.1 https://www.rittmanmead.com/blog/2023/02/oracle-apex-reporting-using-bi-publisher-server/
20-Mar-2024 01:12:AM by: Trev
|
|
Hello experts,
I have an oracle transportation management (OTM) Rest API. Eith this API, I was able to get data from OTM using the apex rest data source feature and I wasn't able to POST data back to OTM. How can I achieve this? Can I be able to do this using PLSQL functions? Can anyone please let me know possible approach?
Thanks in advance
Sridhar
19-Mar-2024 06:30:PM by: Sridhar Utukuri
|
|
Hello Guys,
Just wanted to share an AI Project I'm developing using Oracle APEX + OCI + GPT + Live2d.
If you have a moment. please take look and share your thoughts with me
https://www.linkedin.com/posts/paulo-augusto-kunzel_orclapex-oracle-oraclecloud-activ[…]415849283584-SlBb?utm_source=share&utm_medium=member_desktop
19-Mar-2024 05:37:PM by: Paulo Künzel
|