Oracle Application Express version 20.2 - released Oct 2020. Superseded in May 2021 by version 21.1.
Use this tag in addition to oracle-apex if your question is specifically related to Oracle APEX version 20.2.
Questions tagged [oracle-apex-20.2]
55 questions
2
votes
1 answer
How to reset list to blank using javascript in Oracle apex
I have a select list component in Oracle apex and one button
Select list drop down as below values I can choose any one
-
A
B
C
On button click I have written a java script
if $('#P1_DROPDOWN').val() == 'A'
{
alert.message('A value is…
kiric8494
- 195
- 1
- 7
2
votes
0 answers
How to access an entered Interactive Grid column value in a Javascript dynamic action on the Change event in order to ensure uniqueness
I am trying to prevent duplicate items from being entered in an Interactive Grid in Oracle Apex 20.2. I do get a unique constraint error when this happens, but this is for a barcode scanning stock control app and the unique constraint error only…
Superdooperhero
- 7,584
- 19
- 83
- 138
2
votes
3 answers
How to include values that count nothing on certain day (APEX)
I have this query:
SELECT
COUNT(ID) AS FREQ,
TO_CHAR(TRUNC(CREATED_AT),'DD-MON') DATES
FROM TICKETS
WHERE TRUNC(CREATED_AT) > TRUNC(SYSDATE) - 32
GROUP BY TRUNC(CREATED_AT)
ORDER BY TRUNC(CREATED_AT) ASC
This counts how many tickets where created…
tycho de vink
- 41
- 5
2
votes
2 answers
Oracle APEX cards region does not escaping characters
I am using the new Cards region of APEX 20.2 the problem I am facing is that I cannot escape characters on this region.
For example I want to create a card region that each card will have multiple thumbnails based on the following select
Select…
Vagelis Nastos
- 21
- 2
1
vote
2 answers
Oracle Apex Cards Region Rendering time
I have a cards region on page 1 in my application which is paged and is set to show 32 cards on a page. When the user clicks a card, it takes the user to a different page which is page 11. There is a button on page 11 that brings the user back to…
Ahsan Anwar
- 39
- 1
- 1
- 9
1
vote
1 answer
How to get column values dynamically in Oracle Apex Interactive Grid
I want to concatenate a static sql statement with a dynamic string represent for some of dynamic column which have defined by another sql statement like this
select column1, column2, '|| v_select ||' from my_table. v_select have example value like…
Thuan Le
- 11
- 6
1
vote
2 answers
Oracle APEX: Is it possible to disable IG select conditionally
I want to disable select on my IG when a page item P1_CONDITION meets certain criteria. I hid row action and row selector when condition is met, but if I click on any of the rows, they are still getting selected - custom delete button shows up in…
Coding Duchess
- 6,445
- 20
- 113
- 209
1
vote
0 answers
ORACLE APEX doesn´t pass ITEM to next page
ORACLE APEX 20.2
I'm trying to pass the value of an Interactive grid column to a modal page. I created a page_item to receive the value and used a JavaScript action to load the column value via the selection change [interactive grid] event.
var i,…
Roberto Cavalcante
- 11
- 1
1
vote
2 answers
show table update time in oracle Apex
I have a scenario where I am updating an table in oracle APEX (v 20.2.0.00.20) every day.
I would like to display the information in the page navigation bar at top or as a card anywhere on the page, as when the table gets updated as
"Last updated :…
Rebecca
- 37
- 5
1
vote
3 answers
Oracle APEX: Session state protection violation error on Display Only page item
I'm trying to update Display Only page item with a dynamic action on one select lists and want to display the value in that display only item.
My code works and page item gets set but once I try to submit the page I get an error: Session state…
Coding Duchess
- 6,445
- 20
- 113
- 209
1
vote
1 answer
WWV_FLOW_DYNAMIC_EXEC.PARSE_AS_USER errors on multiple buttons and LOVs
After an upgrade of a very old app to APEX 20.2, everything works surprisingly well except for a few pages where all buttons and LOVs throw one of two errors when calling WWV_FLOW_DYNAMIC_EXEC.PARSE_AS_USER:
Could not validate caller for user ""…
Steve
- 21
- 3
1
vote
0 answers
ACL information for connecting rest services
I am new to Oracle APEX, i am trying to create Rest Data Source in Oracle APEX but i am getting an error which is attached screenshot,
enter image description here
So i have checked with my DBA, he want some information like below.
ACL Name:
lower…
1
vote
1 answer
Installing ORACLE APEX on client with different server for database
I have an oracle database installed on different server.
Now I want to install ORACLE APEX on my PC but I always fail, since it can't locate the SQLPLUS command.
Is it possible to install it this way or not?
Hope you can help me with this.
Thanks
user3312649
- 190
- 1
- 4
- 17
1
vote
2 answers
How to convert a date to a different format without making it a varchar?
I have a date that looks like this: 29-DEC-2020 00:00
I want to format it to dd-mon like this: 29-DEC
How do I convert this without doing it with to_char()?
tycho de vink
- 41
- 5
1
vote
1 answer
Oracle Apex Select List LOV conditional query
I have an Editable Interactive Grid (for product_sale table) with a Select List (to select a product) in Oracle Apex 20.2 app.
Currently I'm using below query to populate this list of values.
SELECT productName,productId FROM product WHERE…
Bishan
- 15,211
- 52
- 164
- 258