Output format of ExportBulkData: FinOutbound ESS Job

(Doc ID 2287267.1)

Last updated on JULY 18, 2017

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.12.1.0.0 version, Technology Management - Reports/Analytics

How to run BI report with eText template using exportBulkData: FinOutbound ESS job

We have a BI report that has been built using eText template and the default output has been set to Text since the output required is a "fixed length format" text file. The report can be run successfully when run via the BI - view output. But since we want to orchestrate this using SOA CS, we are invoking the BI report from a SOA CS web service using the ERP Integration Webservice -> exportBulkDataOperation.


The ESS job runs but completes in error with the following error :Caught exception for BIP Onlyoracle.j2ee.ws.client.jaxws.JRFSOAPFaultException: Client received SOAP Fault from server : PublicReportService::generateReport for reportAbsolutePath [/Custom/Financials/XXXX.xdo] failed: due to oracle.xdo.server.ServerException: oracle.xdo.servlet.data.DataException: Invalid format requested: csv

1) Does FinoutBoundESS job can only trigger BI reports with output as CSV ?
2) What parameter value must be passed in the webservice for FinoutBoundESSJob to get the output as TEXT ?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms