Dear Rajesh,


Good to see your lines and happy to provide you with available solutions.

Please let me know the Release of the application and deployment model of Oracle Fusion you are using to provide with right solution.

Meanwhile you can select the right option from OER which will guide you with the required API;s

http://www.oracle.com/webfolder/technetwork/docs/html/oer-redirect.html


Even after if you need any assistance please let me know with the details.

Thanks & Regards
Krishna Roshan

Thanks Krishna. In SAAS environment - where you don't have an option to connect to Oracle but only BI Publisher. Not sure even if you have on-premise fusion payable then you can use API in BI Publisher reports. Therefore looking forward to hear if we can use API in SAAS environment. Also in onpremise application.

Looking forward to hear.

Dear Rajesh,

Yes you are right in SAAS environment, normally the role provisioned to you will not have the privileges to trigger any web service. You need to get in touch base with your system integrator( Oracle on-demand or any other third party company who is managing SAAS) to act on your behalf and trigger the required API.

In On-Premise you can download the required API/Webservice from OER and update the attributes/parameters either in HTML or normal format and execute itif your role having the privileges to update webservice/package.

There are certain certificates and other security authentications which you need to enter before inputing the arguments. Once you select the WSDL you need to parse it to validate it before selecting the operation.

Thanks & Regards
Krishna Roshan