Oracle Communities

Oracle Analytics and AI

Child Item

Generate ZIP file out of CSV-XML Output from Report

Description

We have requirement to generate the zip file consist of BI report CSV and XML output and have to upload it to UCM server for further processing

Use Case and Business Need

We have requirement to generate the zip file consist of BI report CSV and XML output and have to upload it to UCM server for further processing

More details

Currently this functionality is not supported

Original Idea Number: 636fb5e065

Find more posts tagged with

Submitted

Others

Supply Chain

ERP Analytics Content

Status: Submitted

Comments

user5017886

Hi BI/Analytics Team

could you please review the requirement and provide solution approach.

Regards

Mahesh

user5017886

Hello Team
do you have any update?

Maheshhs

mgoswami

Hi Mahesh,

Is it OTBI analyses or OBIEE/OAS/OAC analyses? Did you check the BI Publisher? I will check it and come back to you if I find anything. I am not sure about generating zip file but I think there is something for UCM.

User_405PI

Hi Mahesh,

I have worked on the above requirement with a slight modification to it. I am zipping a text file. You can modify the below bursting query as per your requirement.

Also, note that when you schedule the report in BIP, do not forget to choose the option Compress output prior to Delivery. This REQ is not possible to achieve if we schedule the report via ESS Job.

SELECT 1 AS "KEY",

'XLA_TRANSACTION_ENTITIES TEMPLATE' TEMPLATE,

'ETEXT' TEMPLATE_FORMAT,

'en-US' LOCALE,

'text' OUTPUT_FORMAT,

'WCC' DEL_CHANNEL,

'SERVER_NAME' PARAMETER1,

'FAFusionImportExport' PARAMETER2,

'XLA_TRANSACTION_ENTITIES_Extract'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')||'.zip' PARAMETER5,

'XLA_TRANSACTION_ENTITIES_Extract'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')||'.zip' PARAMETER6,

'true' parameter9

FROM

dual

Sandeep Pati-Trinamix

Hi Team, Through ESS we are triggering the BIP. there is No provision for the zip Output, Only csv option available. as this is an old discussion, do we have a provision as of 24C now ?

Jayant Ajayrao Deshmukh

To achieve the requirement of generating a ZIP file containing both CSV and XML output from a BI report and uploading it to the UCM (Universal Content Management) server in Oracle Fusion, you can implement a workaround using Oracle BI Publisher’s scheduling and file generation capabilities along with PL/SQL or Java to manage the ZIP creation and upload.

Generate Reports in CSV and XML Formats:
- Schedule the BI Publisher report to generate outputs in both CSV and XML formats.
- Configure the outputs to be saved to a specified location or sent as email attachments to a common accessible location.