Home › Discussions › Questions & Answers › Programmatic Export of Report XML to Database Filesystem

Programmatic Export of Report XML to Database Filesystem

Avatar photoCustomer July 26, 2023 at 6:56 am

I need to automate report migration. How can I use the Blitz Report API to export report definitions as XML (CLOB) and then write that file onto the application server’s filesystem?

Viewing 4 reply threads
  • Author
    Replies
    • Support July 28, 2023 at 7:12 am  

      You can use the function `XXEN_API.export_file_data` or `XXEN_API.export_report_` to retrieve the report XML data as a CLOB.

    • Avatar photoCustomer July 28, 2023 at 9:26 pm  

      And how is the CLOB physically written to the file system?

    • Support July 29, 2023 at 4:48 am  

      To write the CLOB to the database filesystem, you use the Oracle procedure `dbms_xslprocessor.clob2file`. This procedure requires pointing to a directory name defined in `dba_directories` (such as ‘OUT_FILE_LOC’) and specifying the desired filename.

    • Avatar photoCustomer July 30, 2023 at 7:08 am  

      Does the API support exporting multiple reports into one file?

    • Support July 30, 2023 at 6:34 pm  

      Yes, `XXEN_API.export_file_data` accepts a list of IDs (`p_ids` of type `fnd_table_of_number`) and exports them all into one single XML file for batch processing.

  • Author
    Replies
Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123720

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 19732

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14593

How to check if a patch is applied in Oracle EBS 12.2 14363

Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3 14053

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11951

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9891

Migration to Java Web Start in Oracle EBS 12.2 instance 9871

Securing sensitive data with Oracle VPD 7775

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6433

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2025
2024
2023
2022
2021
2020
2019
2018