Skip to Main Content

What's new in Oracle APEX 24.1 - Part 4

In this session, we presented and demonstrated the following marquee features of APEX 24.1:

00:00 - Announcements & Updates 
06:08 -Generate PDF documents using the natively integrated Document Generator Service - Menno Hoogendijk
21:34 - Date Picker Support in Faceted Search and Smart Filters - Ronnie Weiss
29:18 - REST Souce Infrastructure: Support Nested JSON responses - Carsten Czarski

Question And Answer

  • #SELECTION#
    #ICON_HTML#

    Am I correct that the Document Generator is only available through OCI. Any plans to offer the Document Generator on-premise?

    Correct, this is only available on OCI. I'm not aware of any plans to offer it on-premises.

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Can this be used to directly send receipts to POS printers? any link about it?

    Remember the UI for APEX apps is all in the browser, so you can pop up a print dialog, or the user will have to click a button, or use their browser print feature

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Do template support vertical loop (dynamic columns)

    Yes, please install and review the docgen sample app to learn more

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Does the PDF Generator work on Oracle 23FREE?

    This is a REST Endpoint that you need to stand up on a paid OCI tenancy - but will work from your database.

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    How are charts and BLOBs supported for pdf printing? I have used APEX Office Print before and printing charts and pictures was quite challenging…

    Document Generator supports dynamic images but that is not yet part of the 24.1 integration. Charts is also something we are looking into for a future release.

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    How can i get mobile application source, want to download and install our environment like apex.oracle.com gallery based?

    The code for our sample apps are available in GitHub: https://github.com/oracle/apex;remember, you can install these sample apps from the APEX Gallery - once you install them, you can go under the hood with APEX Builder and page designer and see how each page is configured

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    How to send JSON Payload in REST DataSource in PL/SQL procedure ?

    Our APEX API docs should help you through learning how to do this https://apex.oracle.com/api

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    I have created an IR on top of the REST DataSource and from the Nested JSON Columns and now I need to make the data that is inside the Columns as a Link so that when I click on that It can redirect to another page and I can pass on the values, But when a Save the page after making the page Item as LINK then it again converted into Plain Texts what to do ?

    Please create a new post regarding this on https://apex.oracle.com/forum so that we and other community members can help you

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    I'm getting the following error in my autonomous 24.1: APEX - The DBMS_CLOUD package is not available on this system.

    This is a known issue that will be addressed when APEX 24.1.2 patch is deployed to Autonomous Database, tentatively in early August.

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    IS only DOCX possible or also other like XLSX?

    XLSX is on the roadmap!

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    In Report Queries when the query is set the JSON gets downloaded but when we set the template and test the report it thorws out an LOB error "ORA-06502: PL/SQL: value or conversion error: invalid LOB locator specified: ORA-22275" the same error appears when used in a Dynamic Action. The same query works very well in a classic report when used for printing

    That probably requires some investigation; would you mind raising this as a question on the APEX forum? https://apex.oracle.com/forum

    Please also provide some details about your setup, so that we can investigate and diagnose.

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is an enhancement to Document Generator Service something I should post on APEX Ideas, or is the forum the best place to post support for other formats than PDF?

    You can certainly post such on the Ideas app - if for some reason it doesn't fit, we'll redirect as needed.

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is document generator natively integrated or we have set it up?

    With APEX 24.1, you can set up a Document Generator function as a Print Server. You need to provision a document Generator function on OCI to integrate this

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is it possible to join two source queries? For example when you have many invoice headers and many lines for each header?

    absolutely - you can build your query as needed

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is it possible to scan any X-ray documents and relevant suggestions and then convert into PDF for the patient to view it?

    most anything is possible with APEX - if it can be done on the internet, APEX can do it too :)

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is it similar to AOP print?

    It is the same concept - an external Document Generator service with which your APEX environment and apps integrate.

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is that app available to download?

    The Sample Document Generator is available in the App Gallery.

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is the document generator function limited to PDF only? A word doc export would be a great enhancement to consider

    Yes, at present, this is limited to PDF. The Document Generator team is working on more formats

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Is there any plans for future versions of document generator to be fully supported within an on-premise DB and not request calls out to OCI?

    Not currently as this is targetted as an OCI feature right now

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    It's possible to send the PDF file to a printer?

    The user would have to print - via JS, button click, file>print, etc

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    One more question please...If i configure prebuilt function Doc Gen in a paid instance (OCI) can i use it / configure it in a free instance in oracle APEX ?

    Yes, that's totally possible. Today I used a similar architecture.

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    The video recording for What's new in Oracle APEX 24.1 - Part 3 is now available!

    Please go to https://apex.oracle.com/go/playlist

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    When do you plan to support Excel in document generator?

    Yes, Excel is on the roadmap. XLSX to XLSX, and XLSX to PDF.

    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    When linking to a faceted search page, can you set some of the facets by sending item values based on the link being clicked by the user? For interactive reports I know you can use IR_ID and then &ID. Is there

    Facets are treated like page items, so you can just build URL syntax to set page items. If that references facets, things should just work

    #MISC#
    #ACTIONS#

Featured Speakers

  • Speaker

    Jayson Hanes


    Oracle APEX PM

  • Speaker

    Carsten Czarski


    Architect

  • Speaker

    Menno Hoogendijk


    Principal Member of Technical Staff

  • Speaker

    Ronny Weiss


    Principal Member of Technical Staff

Workshop Info

Session Has Completed - 25 July 2024
1 Hour
APEX Office Hours
English
Oracle APEX Service, Oracle APEX