Skip to main content

All 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 = :...
Eng Habib's user avatar
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 ...
No Body's user avatar
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 &...
chuckle_out_loud's user avatar
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 ...
user2470764's user avatar
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 ...
abi's user avatar
  • 11
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 ...
Matei Duta's user avatar
-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 ...
sayed mohamed's user avatar
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....
Shankar's user avatar
  • 53
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 ...
abi's user avatar
  • 11
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 ...
Divya Rose's user avatar
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 ...
Halil İbrahim Çamur's user avatar
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, ...
user avatar
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 ...
CodeGuide1000's user avatar
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 ...
CodeGuide1000's user avatar
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 ...
amol bhosale's user avatar

15 30 50 per page
1
2 3 4 5
36
X