• Session Chats

Breadcrumb

Filter

Chat

TimestampEntered ByComment
07:53:27EricGood morning David!
07:53:38EricOr at least morning from here!
07:53:53* David PeakeMorning Eric
07:57:39BhaveshHello David
07:58:53* David PeakePlease keep your videos turned off as we are recording this session
07:59:31Denis SavenkoHello, the great APEX community :-)
08:19:46AncaCould you please let me know if the Single sign on - transparent authentication can be implemented? (Windows environment). Could you please indicate a link where this is described? Thank you!
08:26:59* Joel KallmanHi Anca - if you're trying to achieve SSO with Windows AD, a partner (Niels de Bruijn from MT AG) has a nice presentation on this subject: https://www.edocr.com/v/lv1rvxvx/nielsdebruijn/Single-Sign-On-for-Oracle-Application-Express-APEX
08:27:24AncaThank you Joel!
08:28:53* Joel KallmanIf you wish to authenticate to Azure Cloud, it gets even simpler. In APEX 18.1, you can use "Social Signon" in your APEX app, and use Microsoft as your OAuth2 authorization server.
08:30:00Denis SavenkoA question regarding migrating from Excel to APEX. One of my clients recieves some data as XLSX files on a regular basis from their contractors. And this data must be loaded to database with some transformations applied (maaping, generating IDs, setting default values and so on). And there's standard functionality to set up a data loader for spreadsheet data in APEX (Data Loading Creation Wizard). The issue is that this functionality expects predictable structure of the file and, a file in CSV format and a database table to load the data (I don't want to give an APEX app permissions to write to any business tables, but do it through a PL/SQL function). It also doesn't support any pre and postprocessing hooks for the data to import.
08:30:04Denis SavenkoSo what would you recommend as the best and the most scalable way to implement a custom XLSX-files loader with some preprocessing (allowing users to map fields and to specify other fields `default values` impossible to be mapped) and postprocessing (data revision by the user and rerunning the import process for the reworked data)?
08:30:30tomisczakwhat about SSO like SAML 2.0 or ADFS from Microsoft
08:31:02tomisczakthis is one of issues which I met to integrated application in company which I work
08:31:13Kevin ZhangIs it possible to choose different theme for the APEX development IDE? I mean I don't like default theme after I login to APEX workshop ...
08:31:27tomisczakdoes anyone have some expierience and links to sources where we could find some help regarding such integration
08:31:28tomisczak?
08:32:16ElizabethSAML 2.0 intgration with APEX was shared by Adrian Png last APEX hours https://insum.ca/saml2-single-sign-on-with-oracle-application-express/
08:32:41Denis Savenko@Kevin Zhang, as far as I know, themes for the App Builder will be implemented in some upcoming versions of APEX.
08:33:18Brenda.ToddPlease i do need some help..
08:33:32EricTHATS WHAT I WANT. AN APP FROM A TABLE!!!!
08:34:10* Joel KallmanEric - you're ready to go!
08:34:10chelhpCan we remove the enclosed by when downloading csv
08:34:19* Shakeeb Rahman@Kevin Zhang: Is there something in particular you don't like in the APEX Builder UI?
08:34:22* Joel KallmanBrenda - what help do you need?
08:35:16Eric@Joel. In 181?
08:35:24* Joel Kallman@Denis - this is a bit of an involved question for this forum. I'd be happy to understand this a bit better offline (you know how to get hold of me).
08:35:26AlastairIs there going to full session on Team Development?
08:35:58Brenda.ToddPlease i do need some help. Am on Apex 5.1 and i upgraded my application to Universal Theme. But my add button wont work in my interactiv grid report. it throws this error "Ajax call returned server error ORA-20987: APEX - ORA-01400: cannot insert NULL into ("ITBINVENTORY"."INV_ITEM_CATEGORY"."ID") for ." Any workaround and advice will be appreciated
08:35:59Eric@Alastair. Good question!
08:36:06* Joel Kallman@Eric - app on a table? It's been there since HTML DB 1.5 (circa 2004).
08:36:34Eric@Joel. Just like app from a spreadsheet?
08:36:56BhaveshWhat version of Apex is used for the demo?
08:37:05* Joel KallmanIt's apex.oracle.com. APEX 18.1
08:37:17BhaveshThanks
08:37:43Denis SavenkoThe version is witten in right bottom corner, btw
08:37:51Denis Savenkowritten*
08:38:04Kevin ZhangI wish in the feature, APEX can package more better example of the sample applications ... So far 90% of those package applications are showing almost same layout (navigation on left) ... I hope APEX team can package more modern better UI sample applications ... Most of us are building APEX applications by learning from packaged sample applications ... maybe you should consider to include Shakeeb's Movie demo application
08:38:06chelhpPlease show how to add CHECK ALL check box in Interactive Grid
08:38:16BhaveshDo you know if 18.1 will work on 12.1 database?
08:38:57Denis SavenkoSure
08:39:09Denis SavenkoIt works even om my 11g XE instances
08:39:19BhaveshCool Thanks
08:41:55Ross Henderson@Kevin, I'd also like that.
08:42:25Kevin ZhangCan APEX build PWA application?
08:43:06Kevin ZhangIs APEX compete with Wordpress technology?
08:43:07tomisczakwhat is a PWA application
08:43:44mruelProgressive Web App
08:43:48Kevin ZhangPWA: Progressive WEb Apps
08:43:59VenkatProgressive Web App? Enables web apps to turn into a mobile app basically?
08:44:07* Doug GaultAPEX is not Wordpress and Vice Versa. Wordpress is an extensible Content Management System, not a programming platform per-se.
08:44:16263840933Yes Kevin
08:44:16* Doug GaultYou could write a CMS with APEX, for sure.
08:44:19AlastairWhat is the APEX teams relationship with AWS like? When is 18.1 going to be available on there? There documentation for setting up APEX is awful.
08:44:24263840933PWA already supported by APEx
08:44:38tomisczakyes you can build bussines application
08:44:49263840933Its single appss will used on All screens
08:45:07Alastair*Their
08:45:09263840933@tomisczak: Yes we can
08:45:43263840933Its mostly used in Bussiness apps
08:45:58Kevin ZhangWordpress is allowed citizen developer quickly build a decent web application ... for this I think APEX is also tries to offer this feature ... This is the reason I ask "Is APEX compete with Wordpress"
08:46:19Kyle Hu@Kevin You can use APEX to build and replicate Wordpress features, but not the other way around.
08:46:46* Shakeeb Rahman@Kevin Zhang: Thanks for the feedback! I think including apps similar to the Movies App is a great idea.
08:48:16Kevin ZhangCan you hightlight what APEX featuers will not available for me between Oracle 11G DB vs. 12c ... My company is still on Oracle 11G DB .... I want to know what cool feature I can't use due to database version limitation ...
08:48:18Denis SavenkoA question about cherry-picking. Imagine I have a really long task which is half complete. Then, I get other set of urgent tasks for business which I must implement and deploy fast. So, the question is how to deploy the needed changes with the urgent tasks done without rollbacking the half-done functionality (because I don't need to waste time on this and then return everything back by hand when return to the task)? In traditional development this is done by repo branches, which is not an option when it comes to APEX afaik
08:48:22* Shakeeb RahmanAlso, there was a good presentation by @vincentmorneau (Twitter handle) on how to build PWAs with APEX.
08:48:42BhaveshAny plan to integrate with Okta?
08:49:49tomisczakwhat about ADFS whch is used by companies
08:50:02Kevin ZhangCan you hightlight what APEX featuers will not available for me between Oracle 11G DB vs. 12c ... My company is still on Oracle 11G DB .... I want to know what cool feature I can't use due to database version limitation ... Can you highlight APEX features that are only available for DB 12c or 18c and not available for 11G
08:50:07tomisczakthis is not exactly the same like Azure Authentication
08:50:53Olivia DingAfter made a "Highlight" in a report and saved it as "Primary", can we hidden the Legend above the report ?
08:51:04Kevin ZhangWhat new integration features APEX offers for Oracle EBS (e.g. EBS R12.x) ...
08:52:33* Doug Gault@Kevin Zhang - I’m not aware of any APEX features that would not be available based on DB Version. The limitation would be more about what DB features you have access to.
08:52:37* Christina Cho@Olivia, the report settings which display highlight conditions can be collapsed and expanded, these are saves along with your report save, you can save with collapsed
08:52:42Denis Savenko@Olivia Ding - yes, you can, it can be done in the interactive report attributes
08:52:44Bhavesh@Kevin, We use with EBS. There's a pacth to inetegrate with EBS
08:53:01Kevin ZhangFor web serverice, can APEX offer features to leverage GraphQL?
08:53:02Ericlurk..... 18C XE when? ;)
08:53:29* Doug Gault@Eric - SOON… ;-)
08:53:44ElijahCan you use APEX only web-based in the same full functionality as on your desktop?
08:53:58* Hilary Farrell@Eric - https://community.oracle.com/thread/4149481
08:54:27* Vladislav Uvarov18c XE in October - https://community.oracle.com/thread/4153790
08:54:52Daxlaidefault universal theme is not suitable for ERP what will be the solution for it
08:55:29Kevin Zhangcan you comment on APEX technology vs other popular web development framework such Angular, React, Vue etc ... what is the reason that we should learn APEX instead of those technologies ...
08:55:58Denis SavenkoThe reason is it's a `low-code`
08:56:04VenkatUniversal theme is nice but it is not going to be a distributable mobile app. The URL is a little ugly.
08:56:11* Joel KallmanIf you follow Gerald Venzl (the PM for XE), you can stay on top of the release date for 18c XE: https://twitter.com/GeraldVenzl/status/1022270359318360064
08:56:26Denis SavenkoAll the technologies you mentioned is different things, and about only fronend development using JavaScript
08:56:39Kevin Zhangis Font APEX in APEX 18 SVG font?
08:56:52* Shakeeb RahmanNo, it is not.
08:57:07Pete K@olivia you can also hide that region with page load javascript and a static id on your report for example: $("#my_report_control_panel").css('display','none');
08:57:18* Chaitanya KoratamaddiWhy use Oracle APEX? https://apex.oracle.com/en/platform/why-oracle-apex/
08:57:24Kevin Zhangany plan to boost APEX font to SVG font?
08:58:08* Chaitanya Koratamaddihttps://apex.oracle.com/en/platform/low-code/
08:58:16* Shakeeb RahmanAbsolutely.. at some point. We are planning to open source font apex
08:58:36Kevin ZhangCan you APEX query data from NoSQL database or Big Data storage (e.g. Hive table)?
08:59:02Ross HendersonIn regards to Font APEX: Do you have a process for getting brand icons included? I.e. my companies logo?
08:59:39Kevin ZhangCan you hightlight what APEX featuers will not available for me between Oracle 11G DB vs. 12c ... My company is still on Oracle 11G DB .... I want to know what cool feature I can't use due to database version limitation ... Can you highlight APEX features that are only available for DB 12c or 18c and not available for 11G
08:59:42* Joel Kallman@Kevin - with respect to NoSQL & Oracle DB, I've seen this integration done via Oracle DB external tables: http://www.oracle.com/webfolder/technetwork/tutorials/obe/nosql/external-tables/cookbook.html
08:59:43* Shakeeb RahmanNo, sorry there is no process for this. You can load a custom brand icon for your own application, but we do not intend to add company logos to Font APEX.
08:59:46* Doug Gault@Kevin - RE Querying from other data sources. There are multiple ways this can be done. One would be to create external tables that access the data, but other way would be to use REST services.
08:59:58chelhpCan we remove the enclosed by when downloading csv
09:01:04Ross HendersonThat's fair, thanks for answering.
09:01:08Kevin ZhangFrom the slide, it seems Oracle drop "Glassfish" for the middle tier. Any reason?
09:01:10Alastaircheers
09:01:11EricThanks all!
09:01:21* Christina Cho@chelhp, enclosed by can be null in report attributes Download attributes
09:01:47Ahmad KhattabThank you
09:01:53AncaThank you!
09:01:58Ram GurramThanks
  • 1 - 110