Slack

hi @daljitraju you have exactly understood my case. And I will implement your suggestion and we will see what happens :wink:
16-Feb-2019 06:52:PM by: Souleman
Thanks @daljitraju i’ll check it out.
16-Feb-2019 08:51:AM by: jimmccluskey
Good evening everyone. I am looking for a solution. here is my case. I am on a form of creation and I have a list of value which does not contain the information that I want. how can I save the information in the LOV table and update the lov of the creation form and pointing to the information I just recorded :nerd_face:
16-Feb-2019 12:38:AM by: Souleman
Hi everyone:slightly_smiling_face: I posted an Issue https://community.oracle.com/thread/4200745 but somehow it's not shown on apex.world... however, I would be super grateful if someone could help me Thanks and best regards Leo
15-Feb-2019 09:28:AM by: Leo Stalder
Hi All, This is probably a stupid question but I am having issues in a classic report when I refresh the region using a dynamic action, it seems to refrsh the report back to page 1. I have created a test case here https://apex.oracle.com/pls/apex/f?p=86934:1 The first report is using an sql query as the report source. I paginate to the second page in this report and click the refresh region button. This causes the report region to refresh and stay on the correct page exactly how I would wish. The second report is using plsql returning sql. I paginate to the second page in this report and click the refresh region button. This causes the report to move back to the first page. Does anyone have a workaround for this? Thanks Jim
14-Feb-2019 09:25:PM by: jimmccluskey
Hi. Is there a way to hide button based on tab selection in a region
14-Feb-2019 08:48:PM by: pritham9
Yes I am. It's normal in this business... But main questions are: Does APEX have bug ? or Does APEX have hidden limitation ? Mybe somebody from Oracle team can says something.
14-Feb-2019 06:56:AM by: apexutil_an
:astonished: you're displaying 10k lines/items to the users in a single page?
13-Feb-2019 07:04:PM by: maxime_tremblay
it's not native tabular form it's report with dynamic items. We process orders with 10000 and more rows
13-Feb-2019 03:36:PM by: apexutil_an
are you trying to submit a tabular form with 10k lines?
13-Feb-2019 02:27:PM by: maxime_tremblay
Hi We have problem with apex bug/limitation. Yesterday we asked oracle forums but no response. Maybe you can help: https://community.oracle.com/thread/4200590
13-Feb-2019 02:24:PM by: apexutil_an
try something similar to that
13-Feb-2019 11:37:AM by: turntablez
If your doing your own process on a tabular form you dont need to reference the apex_application.g_f01 items. You can do it like this ```begin case :APEX$ROW_STATUS when 'C' then insert into emp ( empno, ename, deptno ) values ( :EMPNO, :ENAME, :DEPTNO ) returning rowid into :ROWID; when 'U' then update emp set ename = :ENAME, deptno = :DEPTNO where rowid = :ROWID; when 'D' then delete emp where rowid = :ROWID; end case; end; ```
13-Feb-2019 11:36:AM by: turntablez
screen shot also shared
13-Feb-2019 11:23:AM by: Amit
what i did wrong id is primary key here please help me on this.
13-Feb-2019 11:19:AM by: Amit
actually i put never to this process into tabular form APPLY_MRU and APPLY_MRD and write our own update process like begin for i in 1..apex_application.g_f01.count loop update abc set jan = apex_application.g_f06(i), feb = apex_application.g_f07(i), mar = apex_application.g_f08(i), apr = apex_application.g_f09(i), may = apex_application.g_f10(i), jun = apex_application.g_f11(i), jul = apex_application.g_f12(i), aug = apex_application.g_f13(i), sep = apex_application.g_f14(i), oct = apex_application.g_f15(i), nov = apex_application.g_f16(i), dec = apex_application.g_f17(i) -- where id = :P9999_ID and org_id = :P9999_ORG_ID; where org_id = apex_application.g_f03(i) and id = apex_application.g_f18(i); end loop; end;
13-Feb-2019 11:18:AM by: Amit
Hi all when i am going to update tabular form in 5.0 then i got this error Current version of data in database has changed since user initiated update process.
13-Feb-2019 11:15:AM by: Amit
Hello. When i export a classic report that has Totals on a Break Column, the exported file includes html tags, specifically around the heading total, for example <b>Major Category Total:</b>. this is something automatically applied and I don't have control over it. Is there anything I can do to strip the <b> </b> during the export process? Thank you
12-Feb-2019 08:23:PM by: abul_feed
I'm using https://apex.oracle.com and trying to get an Apex app to authenticate using Social Sign-in with ADFS - anybody on here tried this before? I'm looking for ideas on how to debug..
12-Feb-2019 02:43:PM by: John Phillips
Glad to help
12-Feb-2019 01:05:PM by: shaun.mauer
@lschilde No problem
12-Feb-2019 01:05:PM by: shaun.mauer
@shaun.mauer What can I say? Genius. Thank you I got it working now.
12-Feb-2019 01:04:PM by: lschilde
Appreciate your thoughts on this one
12-Feb-2019 12:42:PM by: lschilde
@shaun.mauer Let me give that a go now. I didn't get it right first time around. :slightly_smiling_face:
12-Feb-2019 12:42:PM by: lschilde
@vincent.morneau Check the forums for an answer to your question as well. Working example on same page above
12-Feb-2019 09:20:AM by: shaun.mauer
@lschilde - A workaround, define the column as `'<img src="apex_world/r/files/static/v5/FNDCANCE.gif" />'` and mark the column as an `HTML expression` with the value `&IMG_SRC.`. Update your `Detail View` -> `For Each Row` to be `<div class="t-Card-titleWrap"><h3 class="t-Card-title">&NAME.</h3>&IMG_SRC.</div>` Working example https://apex.oracle.com/pls/apex/f?p=33053:20
12-Feb-2019 08:30:AM by: shaun.mauer
Any one had this issue on Interactive Grid Detail view -> https://community.oracle.com/message/15061587#15061587? Appreciate your feedbacks
12-Feb-2019 05:14:AM by: lschilde
I am quite new to Apex. I wanted to check if there is possibility of writing a trigger on table APEX_WORKSPACE_DEVELOPERS. Ultimately I want to automate adding an end user to a custom application automatically as soon as user is given access to a workspace. I tried writing a Trigger. Initially I got an error asking to use INSTEAD OF trigger, after I updated the Trigger, I am getting an error saying that I do not have sufficient privileges.
11-Feb-2019 01:30:PM by: rosyparmar
Looking at the HTML in the emailed report that is missing headers, the entire "headers" row is missing.
10-Feb-2019 09:13:PM by: trevorh
Apex 5.1.4. An interactive report with multiple "Public" formats(?) created against it. Users are subscribing to these reports and they are getting the emails, BUT, some of them don't include the column headers, and others do.
10-Feb-2019 09:11:PM by: trevorh
I'm trying to integrate Oracle EBS 12.2.5 with APEX 18.2 installed on separate database. I'm following Mark Wereen's blog http://apex4ebs.blogspot.com/p/integration-of-oracle-apex-and-e.html I created a package APPS.XX_APEX_EBS_AUTH_PKG with function check_ebs_credentials in EBS db, gave execute grants to APPS_EBS_EXTENSION schema in EBS db. Then I created private synonym XX_APEX_EBS_AUTH_PKG in APEX_EBS_LOCAL schema on APEX db and called it in APEX Authorization scheme. The issue is check_ebs_credentials function has apps.icx_sec.getsessioncookie, it is returning -1 instead of actual session cookie. Please advise.
08-Feb-2019 08:26:PM by: Kishore Ryali
I figured out the problem. For example if my static region id is TEST, i was putting in the URL IR[RTEST] to match IR[R<region_id>] but it looks like I don't need to add an 'R' before the static id. that worked!! thank you so much
08-Feb-2019 04:03:PM by: abul_feed
when I set a static ID (under the region's advanced attribute) I can see that the download request is using that static ID and not the region's ID
08-Feb-2019 03:58:PM by: maxime_tremblay
I looked at our different environments and it seems that the region id's are the same but I am not sure that it's guarranteed
08-Feb-2019 03:49:PM by: abul_feed
I tried that, it didn't work
08-Feb-2019 03:48:PM by: abul_feed
try to define a static ID for the region
08-Feb-2019 03:47:PM by: maxime_tremblay

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
Laury
16-Feb-2019 18:32
Work-around for Page Template Region Position 8 with Universal Theme
Link
1 replies - last reply: 16-Feb-2019 21:01- by: fac586
fac586
16-Feb-2019 12:08
BUG 18.2.0.00.12: List template component export/import
Link
0 replies
Sgodavar-Orac
15-Feb-2019 22:01
Export the Application and object dependencies
Link
2 replies - last reply: 16-Feb-2019 08:43- by: fac586
rajk5
15-Feb-2019 21:35
Apex 5.1.3 Form submission
Link
1 replies - last reply: 16-Feb-2019 02:20- by: LA County APEX
buggleboy007
15-Feb-2019 20:48
Unable to translate an expression in a filter from English to French
Link
3 replies - last reply: 16-Feb-2019 22:54- by: fac586
jmarc
15-Feb-2019 17:28
How to make apex bind variable work in a cursor ?
Link
2 replies - last reply: 17-Feb-2019 00:54- by: Fernando Lima
user7259503
15-Feb-2019 16:39
apex 18.2 Editable IG make some updateable columns and not updatable columns
Link
1 replies - last reply: 17-Feb-2019 03:29- by: Samuistu
3328747
15-Feb-2019 16:16
Is it possible to create multiple IRs using SQL or some other type of Script?
Link
0 replies
user455943
15-Feb-2019 10:38
Calling dbms_lock.sleep / APEX_UTIL.PAUSE procedure does not work in SSL APEX environment
Link
1 replies - last reply: 16-Feb-2019 19:49- by: Fernando Lima
Grizzled
15-Feb-2019 02:10
Record navigation selector for interactive grid single row view?
Link
1 replies - last reply: 15-Feb-2019 20:20- by: Grizzled
jort2
14-Feb-2019 10:30
how to change background color of all pages with pl/sql
Link
8 replies - last reply: 17-Feb-2019 05:04- by: Samuistu
bac27691-8811
13-Feb-2019 14:38
Mobile Sample with JQuery
Link
2 replies - last reply: 16-Feb-2019 10:35- by: fac586
jtm
13-Feb-2019 13:18
Classic Report Pagination Refresh issues on PLSQL Returning SQL
Link
2 replies - last reply: 15-Feb-2019 15:57- by: Carsten Czarski-Oracle
DejanH
13-Feb-2019 07:14
Region-subregion master-detail
Link
1 replies - last reply: 15-Feb-2019 20:44- by: LA County APEX
rajk5
12-Feb-2019 22:00
Oracle apex 5, display "number of characters left:" message for a text field
Link
5 replies - last reply: 15-Feb-2019 14:22- by: rajk5
rajk5
12-Feb-2019 21:54
Apex 5.1.3 submitting form
Link
1 replies - last reply: 15-Feb-2019 16:51- by: rajk5
Patryk Mrozic
12-Feb-2019 14:32
Problem with limit of apex_application.g_f01
Link
1 replies - last reply: 15-Feb-2019 18:01- by: martinbn
Soukaina IDRI
12-Feb-2019 13:42
How to create dynamic home navigation menu
Link
9 replies - last reply: 15-Feb-2019 19:35- by: mskamene
2985914
12-Feb-2019 10:06
Logout particular user from the system
Link
1 replies - last reply: 15-Feb-2019 20:45- by: LA County APEX
Eslam_Elbyaly
11-Feb-2019 11:50
How to check column total in IG
Link
3 replies - last reply: 17-Feb-2019 10:47- by: Eslam_Elbyaly
user7322321
11-Feb-2019 11:26
How to prevent apexrefresh to set focus to window
Link
1 replies - last reply: 16-Feb-2019 02:47- by: LA County APEX
Laury
02-Feb-2019 15:54
Embedding HTML with JavaScript in PL/SQL
Link
1 replies - last reply: 15-Feb-2019 20:37- by: LA County APEX
Mónica Godoy
01-Feb-2019 01:10
APEX Message Box - Other Languages
Link
9 replies - last reply: 15-Feb-2019 21:37- by: micles
Sunil Bhatia
28-Jan-2019 06:05
APEX_JSON close the temporary clob
Link
16 replies - last reply: 15-Feb-2019 14:32- by: fac586
Omar Baig
01-Dec-2018 06:12
Export Application with Schema
Link
10 replies - last reply: - by:

News

X
    
 
ImageNewsFavoriteForward
Joel Kallman  Other
4 New Job Offers: Oracle, APEX Dev Team, Evangelists, permanent, free location
Jobs
Link
13-Feb-2019 16:52:24 by: Juergen Schuster
Marc Sewtz  Other
New Job Offer: Oracle, APEX Dev Team, Full Stack Developer, permanent, free location
Jobs
Link
13-Feb-2019 12:51:57 by: Juergen Schuster
Oliver Lemm  Other
Speed up Interactive Grid
Interactive Grid
Link
15-Feb-2019 11:28:08 by: Juergen Schuster
Ronny Weiß    Other
New Meetup: Germany, Dresden
Meetups
Link
14-Feb-2019 10:51:34 by: Juergen Schuster
Lino Schildenfeld  
IG Detail View Bug in 18.2
Bugs, Interactive Grid
Link
13-Feb-2019 03:28:09 by: Jackie Mcilroy
Michelle Skamene  
The APEX community rocks!
Link
13-Feb-2019 03:16:17 by: Jackie Mcilroy
Anton Nielsen  Other
Consolidated Help Text
Help
Link
13-Feb-2019 03:12:51 by: Jackie Mcilroy
Tomas Vitasek  
Interactive Grid Calculations and Validations
Interactive Grid, Validation
Link
13-Feb-2019 03:07:32 by: Jackie Mcilroy
Tim St. Hilaire  
Auth-N and Auth-Z Using Oracle Identity Cloud Service (IDCS)
Authentication, Cloud
Link
13-Feb-2019 03:02:52 by: Jackie Mcilroy
Sylvain Martel  
Extending EBS Part 2
EBS
Link
13-Feb-2019 02:53:12 by: Jackie Mcilroy
Niels de Bruijn  Other
New Job Offer: Germany, Frankfurt, permanent, MT-AG
Jobs
Link
12-Feb-2019 14:23:31 by: Juergen Schuster
Carsten Czarski  
19.1 new Forms functionality beyond REST
APEX 19, Form (APEX)
Link
12-Feb-2019 10:34:23 by: Juergen Schuster
John Snyders  
New Inline Popup and Dialog Regions
APEX 19, Regions
Link
12-Feb-2019 04:57:43 by: Jackie Mcilroy
Dimitri Gielis  
Display Content only when Logged in as Developer
Application Builder, Debugging
Link
11-Feb-2019 03:13:05 by: Jackie Mcilroy
Marc Sewtz    Other
Video Office Hours: 19.1 New Features
APEX 19, Videos
Link
08-Feb-2019 21:02:21 by: Juergen Schuster
Lino Schildenfeld  
Google reCAPTCHA v3
Authentication, Security
Link
08-Feb-2019 16:06:41 by: Juergen Schuster
Peter Raganitsch    Other
Results of the APEX survey: State of the APEX development
Press
Link
08-Feb-2019 09:56:26 by: Juergen Schuster
Adrian Png    Other
Earn your APEX Challenge Coin!
Fun, Press
Link
08-Feb-2019 09:52:19 by: Juergen Schuster
Jackie Mcilroy    Other
New Podcast: Larry, please make APEX whole again! #LowHighPodcast
Podcast
Link
08-Feb-2019 08:40:36 by: Juergen Schuster
Michelle Skamene  
Sizing Images with Apex Office Print (AOP)
AOP, Images
Link
08-Feb-2019 04:04:17 by: Jackie Mcilroy
Anton Nielsen  
SSO with and without MS Azure and Office 365
SSO
Link
07-Feb-2019 22:51:38 by: Juergen Schuster
Francis Mignault    Other
Promo Code for Kscope19, $100.- off
Conferences
Link
07-Feb-2019 14:56:23 by: Juergen Schuster
Jaydip Bosamiya  
Unexpected token % in JSON at position 0 in AOP
AOP
Link
07-Feb-2019 14:51:44 by: Juergen Schuster
Jaydip Bosamiya  Other
Use Workspace Images in AOP
AOP
Link
07-Feb-2019 14:42:35 by: Juergen Schuster
Carsten Czarski    
Quick and Easy Data Loading with 19.1
APEX 19, Data Loading, Excel
Link
07-Feb-2019 11:40:58 by: Juergen Schuster
Monica Godoy    
Women in APEX
Press
Link
06-Feb-2019 12:55:30 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Germany, Frankfurt, permanent, onsite
Jobs
Link
06-Feb-2019 09:40:32 by: Juergen Schuster
Joel Kallman    Other
19.1 Early Adopter is out!
APEX 19
Link
05-Feb-2019 21:34:30 by: Juergen Schuster
Marc Sewtz    Other
Updated Statement of Direction 19.1 & 19.2 (SoD)
APEX 19, SoD
Link
06-Feb-2019 02:12:43 by: Jackie Mcilroy
Jackie Mcilroy    Other
Newsletter #32 is out!
Newsletter
Link
06-Feb-2019 15:21:10 by: Jackie Mcilroy
Rodrigo Mesquita  
Calling PL/SQL from JavaScript
JavaScript, PL/SQL
Link
04-Feb-2019 13:31:59 by: Juergen Schuster
Lucas Jellema    Other
Small steps with APEX
Application Builder
Link
03-Feb-2019 10:38:04 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20