07:53:27 | Eric | Good morning David! |
07:53:38 | Eric | Or at least morning from here! |
07:53:53 | * David Peake | Morning Eric |
07:57:39 | Bhavesh | Hello David |
07:58:53 | * David Peake | Please keep your videos turned off as we are recording this session |
07:59:31 | Denis Savenko | Hello, the great APEX community :-) |
08:19:46 | Anca | Could 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 Kallman | Hi 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:24 | Anca | Thank you Joel! |
08:28:53 | * Joel Kallman | If 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:00 | Denis Savenko | A 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:04 | Denis Savenko | So 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:30 | tomisczak | what about SSO like SAML 2.0 or ADFS from Microsoft |
08:31:02 | tomisczak | this is one of issues which I met to integrated application in company which I work |
08:31:13 | Kevin Zhang | Is 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:27 | tomisczak | does anyone have some expierience and links to sources where we could find some help regarding such integration |
08:31:28 | tomisczak | ? |
08:32:16 | Elizabeth | SAML 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:41 | Denis Savenko | @Kevin Zhang, as far as I know, themes for the App Builder will be implemented in some upcoming versions of APEX. |
08:33:18 | Brenda.Todd | Please i do need some help.. |
08:33:32 | Eric | THATS WHAT I WANT. AN APP FROM A TABLE!!!! |
08:34:10 | * Joel Kallman | Eric - you're ready to go! |
08:34:10 | chelhp | Can 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 Kallman | Brenda - what help do you need? |
08:35:16 | Eric | @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:26 | Alastair | Is there going to full session on Team Development? |
08:35:58 | Brenda.Todd | Please 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:59 | Eric | @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:34 | Eric | @Joel. Just like app from a spreadsheet? |
08:36:56 | Bhavesh | What version of Apex is used for the demo? |
08:37:05 | * Joel Kallman | It's apex.oracle.com. APEX 18.1 |
08:37:17 | Bhavesh | Thanks |
08:37:43 | Denis Savenko | The version is witten in right bottom corner, btw |
08:37:51 | Denis Savenko | written* |
08:38:04 | Kevin Zhang | I 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:06 | chelhp | Please show how to add CHECK ALL check box in Interactive Grid |
08:38:16 | Bhavesh | Do you know if 18.1 will work on 12.1 database? |
08:38:57 | Denis Savenko | Sure |
08:39:09 | Denis Savenko | It works even om my 11g XE instances |
08:39:19 | Bhavesh | Cool Thanks |
08:41:55 | Ross Henderson | @Kevin, I'd also like that. |
08:42:25 | Kevin Zhang | Can APEX build PWA application? |
08:43:06 | Kevin Zhang | Is APEX compete with Wordpress technology? |
08:43:07 | tomisczak | what is a PWA application |
08:43:44 | mruel | Progressive Web App |
08:43:48 | Kevin Zhang | PWA: Progressive WEb Apps |
08:43:59 | Venkat | Progressive Web App? Enables web apps to turn into a mobile app basically? |
08:44:07 | * Doug Gault | APEX is not Wordpress and Vice Versa. Wordpress is an extensible Content Management System, not a programming platform per-se. |
08:44:16 | 263840933 | Yes Kevin |
08:44:16 | * Doug Gault | You could write a CMS with APEX, for sure. |
08:44:19 | Alastair | What 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:24 | 263840933 | PWA already supported by APEx |
08:44:38 | tomisczak | yes you can build bussines application |
08:44:49 | 263840933 | Its single appss will used on All screens |
08:45:07 | Alastair | *Their |
08:45:09 | 263840933 | @tomisczak: Yes we can |
08:45:43 | 263840933 | Its mostly used in Bussiness apps |
08:45:58 | Kevin Zhang | Wordpress 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:19 | Kyle 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:16 | Kevin Zhang | Can 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:18 | Denis Savenko | A 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 Rahman | Also, there was a good presentation by @vincentmorneau (Twitter handle) on how to build PWAs with APEX. |
08:48:42 | Bhavesh | Any plan to integrate with Okta? |
08:49:49 | tomisczak | what about ADFS whch is used by companies |
08:50:02 | Kevin Zhang | Can 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:07 | tomisczak | this is not exactly the same like Azure Authentication |
08:50:53 | Olivia Ding | After made a "Highlight" in a report and saved it as "Primary", can we hidden the Legend above the report ? |
08:51:04 | Kevin Zhang | What 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:42 | Denis Savenko | @Olivia Ding - yes, you can, it can be done in the interactive report attributes |
08:52:44 | Bhavesh | @Kevin, We use with EBS. There's a pacth to inetegrate with EBS |
08:53:01 | Kevin Zhang | For web serverice, can APEX offer features to leverage GraphQL? |
08:53:02 | Eric | lurk..... 18C XE when? ;) |
08:53:29 | * Doug Gault | @Eric - SOON… ;-) |
08:53:44 | Elijah | Can 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 Uvarov | 18c XE in October - https://community.oracle.com/thread/4153790 |
08:54:52 | Daxlai | default universal theme is not suitable for ERP what will be the solution for it |
08:55:29 | Kevin Zhang | can 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:58 | Denis Savenko | The reason is it's a `low-code` |
08:56:04 | Venkat | Universal theme is nice but it is not going to be a distributable mobile app. The URL is a little ugly. |
08:56:11 | * Joel Kallman | If 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:26 | Denis Savenko | All the technologies you mentioned is different things, and about only fronend development using JavaScript |
08:56:39 | Kevin Zhang | is Font APEX in APEX 18 SVG font? |
08:56:52 | * Shakeeb Rahman | No, it is not. |
08:57:07 | Pete 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 Koratamaddi | Why use Oracle APEX? https://apex.oracle.com/en/platform/why-oracle-apex/ |
08:57:24 | Kevin Zhang | any plan to boost APEX font to SVG font? |
08:58:08 | * Chaitanya Koratamaddi | https://apex.oracle.com/en/platform/low-code/ |
08:58:16 | * Shakeeb Rahman | Absolutely.. at some point. We are planning to open source font apex |
08:58:36 | Kevin Zhang | Can you APEX query data from NoSQL database or Big Data storage (e.g. Hive table)? |
08:59:02 | Ross Henderson | In regards to Font APEX: Do you have a process for getting brand icons included? I.e. my companies logo? |
08:59:39 | Kevin Zhang | Can 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 Rahman | No, 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:58 | chelhp | Can we remove the enclosed by when downloading csv |
09:01:04 | Ross Henderson | That's fair, thanks for answering. |
09:01:08 | Kevin Zhang | From the slide, it seems Oracle drop "Glassfish" for the middle tier. Any reason? |
09:01:10 | Alastair | cheers |
09:01:11 | Eric | Thanks all! |
09:01:21 | * Christina Cho | @chelhp, enclosed by can be null in report attributes Download attributes |
09:01:47 | Ahmad Khattab | Thank you |
09:01:53 | Anca | Thank you! |
09:01:58 | Ram Gurram | Thanks |