Questions tagged [oracle-apex]
Oracle Application Express (Oracle APEX) is a rapid Web application development tool that lets you share data and create applications. Using only a Web browser and limited programming experience, you can develop and deploy applications that are fast and secure.
oracle-apex
7,005
questions
0
votes
1
answer
19
views
Redirect to another page after downloading PDF file from REST api in Oracle Apex
I have an interactive report, in which a column is clicked and then a PDF file downloaded by calling a REST API. This column is a link to another page where Before page header process runs and ...
- 473
0
votes
2
answers
32
views
Oracle Apex How to use date column in item filters
I have an Interactive grid:
select emp_id, emp_name, joining_date from employees
where (:P1_EMP_NAME ='All' or :P1_EMP_NAME !='All' and emp_name=:P1_EMP_NAME);
On top of it i have a filter.
...
- 471
0
votes
1
answer
24
views
Oracle Apex How to restrict grid data on the basis of responsibilities
I have a page which displays account_data on basis of dept.
First there are list of responsibilities(similar to roles on basis of which authorizations would be set up..
Responsibilities
...
- 471
-1
votes
1
answer
15
views
Oracle Apex Clob display column throwing error for null value
I have an Interactive Grid in Apex where i need to dispaly clob column.
I followed the below link and set up exactly till step 10.
It works fine if there is data. But in case of null it throws PL/SQL ...
- 471
0
votes
1
answer
39
views
Oracle Apex tree child node returning multiple times
I have an apex tree with 3 layers: (Apex version 22.1)
BU_NAME
ORG_UNIT_NAME
DEPT_NAME
Source Table:
DEPT_BU_LIST
DEPT_ID BU_NAME ORG_UNIT_NAME DEPT_NAME
1 A_BU AX_ORG A1_DEPT
2 ...
- 471
0
votes
1
answer
20
views
Apex Oracle: multi-column popup lov
I have a multi-column popup LOV based on the query:
SELECT name d,
id r,
code d2
FROM employees
WHERE codes IN ('ABC','DEF','GHI')
ORDER BY name
When retrieving its selected value, ...
- 6,795
0
votes
1
answer
22
views
Oracle Apex REST response - PDF File not returning correctly
I have an REST API which take a PDF form and the data to fill this pdf form with. In response, pdf form with filled data is returned.
I have tested this API in Postman, work fine.
Now I am making a ...
- 473
0
votes
1
answer
47
views
Is there a way to modify the Rich Text Editor toolbar in an apex application when the editor is in a column inside an interactive grid?
I am currently working on an Apex application. I have added the rich text editor per request of the user to both Interactive Grid columns and to a Form. I can modify the editor toolbar when it is in a ...
- 5
0
votes
0
answers
15
views
How to post multiple objects in oracle apex rest api?
I am trying to post data like below
{
"ORG_ID": "81",
"TRX_DATE": "30-JAN-2024",
"TRX_NUMBER": "240006078&...
0
votes
1
answer
22
views
In Oracle Apex, how do i set value to page item on a selected tree region row?
I'm encountering an issue with my Oracle APEX application. When I click on a row on my global tree region, I want to assign the value of a column (The "ID") from the clicked row to a page ...
0
votes
2
answers
20
views
Oracle Apex Add Filter item to filter only active employees based on start and end date
I have an Interactive grid:
select emp_id,emp_name,dept,bu,start_date,end_Date;
On top of grid i have item fiters like P1_EMPNAME,P1_DEPT etc.
I need to add an Active button/list/checkbox which when ...
- 471
1
vote
1
answer
56
views
Loading CSV files with double quotes in field values via Oracle Loader External table
Requesting your help and expertise on the below:
Oracle DB 19c on UNIX server
Requirement:
CSV files come in on a daily basis in a Unix directory (where the database resides) and gets loaded to a ...
- 41
0
votes
1
answer
30
views
Oracle APEX conditionally show button in IG row
I have an IG with the query:
select null as link, emp_id,emp_name from employees;
Here the link column has html attributes.
Now I need to add the server-side condition as I only want the link
column ...
- 471
0
votes
0
answers
25
views
Oracle Apex Display clob column as link to file
I have a grid in oracle Apex (22.1)
Select fin_id, fin_name,fin_details,fin_desc,fin_unit,fin_results;
FIN_ID->NUMBER
FIN_RESULTS->CLOB
Rest all are varchar2(100)
In grid the fin_results ...
- 471
0
votes
0
answers
15
views
Dynamically display column in B page based on the display_type in A page in oracle apex 23.1.1
In Oracle Apex. There are two pages A and B
In A we will create datapoints which becomes a column in page B to achieve this we have created page items for all the columns of page B and synced it with ...
