You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to send excel output to legacy system

edited Jul 2, 2024 9:58AM in Integration

Hi,

We have a custom ESS job and generates the output in excel format and can't enable it in csv format as it's exporting all the columns which we don't want. 
We have a requirement to submit the job from a third party system using a web service and pull the output from oracle to the  third party. Following steps executed.
1. Submit ESS Job 

URL https://xxxx/fscmService/ErpIntegrationService?wsdl

Operation - submitESSJobRequest


2.  Send the output to legacy system

https://****/xmlpserver/services/ScheduleReportWSSService?wsdl


getScheduledReportOutputInfo
getDocumentData

When we invoke getDocumentData operation from the third party system then output extracts in incorrect format. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!