Home › Discussions › Questions & Answers › Batch Export of Report Definitions (CLOB Output)

Batch Export of Report Definitions (CLOB Output)

Avatar photoCustomer Questions & Answers 3 replies

I need to export a defined set of reports programmatically, maybe a hundred reports, all into one single file for migration. Which function should I use and how do I pass the list of reports?

3 replies

  • Support Enginatics

    You should use the function `XXEN_API.export_file_data`. This function is designed for batch export and returns the data as a CLOB. You pass the list of report identifiers using the input parameter `p_ids`, which must be of the type `fnd_table_of_number`.

  • Avatar photoCustomer

    Does this function support different export types besides just the current report definitions?

  • Support Enginatics

    Yes, the primary type is ‘Reports’, but the `p_type` parameter can also be set to values like ‘SQLs’, ‘Templates’, ‘LOVs’, ‘Assignments’, ‘Column Translations’, or ‘SQL Versions’, depending on what you need to export.

  • You must be logged in to reply to this post.