All Questions
Tagged with oracle-apex oracle-apex-5
534 questions
0
votes
0
answers
25
views
apex globle page issue
aoa developers
i am working in apex application globle page is deleted by mistake now i want to create new globle page 0 and set value for app user likei
select user_code
from users
where userid = :...
0
votes
0
answers
31
views
Why is the Oracle Apex Apex_application.G_FNN.COUNT returning 0 in apex 5.1.3 interactive grid
I have an Interactive Grid with 7 Columns exclusind Row Selector and Row Action.
The Columns are named aaa, bbb, ccc until ggg (7 cols).
I want to validate this columns, also the ones who where just ...
1
vote
1
answer
90
views
Selecting a column in a where statement
I know someone can do this... just not me. I want to have a select list that will return a "where" statement I can use in my report query. For example, I have a column in my table called &...
0
votes
0
answers
73
views
Control menu popup by hide/show items based on another column values
I have an interactive report region (statis ID "RequestList") with three main columns, one is configured as HTML button as below (static ID "MenuButton") and the others are current ...
0
votes
1
answer
165
views
authorization scheme on page item in oracle apex
I am trying to authorize page item in apex through authorisation_schema, for this i have created authentication user control in cloud and created authorise schema for that authentication return value ...
0
votes
1
answer
336
views
Trying to create a filter based on year in a faceted search in Apex Oracle and it doesn't work
I'm trying to create a filter for my faceted search based on the release year of a movie in my database.
Created a new facet, made it a checkbox group, the source data it's based on is in the correct ...
-1
votes
1
answer
81
views
I want to create an APEX report or table that has 2 sheets on the same report and extract it as 2 sheets in the same excel
I want to create an APEX report or table that has 2 sheets on the same report and extract it as 2 sheets in the same excel , how to make something like that as in detailes as i am new to apex
i have ...
0
votes
1
answer
255
views
Oracle APEX(v21.1.2): DatePicker inconsistent
I'm on Apex Version: 21.1.2
I'm facing a weird issue with an Item(P2_Invoice_From_Date) of type DatePicker.
The Item is formated to display the selected date as ‘DD-MON-YYYY’ in the appearance section....
0
votes
0
answers
176
views
Javascript error in Apex while navigating the page to different url oracle apex
I have grid column and that should get the page url and redirect to that page which i click that column name, but i am getting JS error and its not moving to another page from the URL the link taken ...
0
votes
1
answer
190
views
How to add a button at the end of each node in a tree region in oracle apex?
I have a tree region in oracle apex which shows parents and children in a tree structure. I want to display a + button at the end of each node. On clicking this button i need to open a pop up which ...
0
votes
1
answer
584
views
how to split one row into 2 lines, interactive grid oracle apex?
There are a lot of columns to edit in this interactive grid, i want to split the row into 2 lines
interactive grid
like this
i do not know if possible or not
is there a way to do it?
I did a lot of ...
0
votes
2
answers
33
views
Oracle SQL ignores page item in a criteria, when it is null
When my page loads the page item :P2136_LEAVE_TYPE is null.
i have this query
WITH Emp_Leaves AS
(select ID,
EMPLOYEE_ID,
LEAVE_YEAR,
LEAVE_TYPE,
...
0
votes
0
answers
834
views
How to export PLSQL Dynamic Content Table to Excel File?
I have created an HTML table region using PLSQL Dynamic Content, and I want to create a button that exports or converts the region content (HTML TABLE) to an Excel file. Is that possible or not? Can ...
0
votes
1
answer
2k
views
Passing item value in PLSQL dynamic content in ORACLE APEX for where clause using button?
I want to pass items in PLSQL dynamic content region to be used for where clause. Is this not possible or I just did it wrong?
I tried to set variable with item value and add it to where clause but it ...
1
vote
1
answer
520
views
oracle apex current version 4.0 we can upgrade latest version 22.2
Please see below details for Apex:
Current is: DB 11.2.0.2.0 and APEX version 4.0
Linux server
It's opensuse 13.2. Very old version
32GB ram, 8 core CPU and 2TB
On a virtual machine.
Required
Database ...