Last updated on JULY 18, 2017
Applies to:Oracle Fusion Financials Common Module Cloud Service - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.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 ?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms