Friday, December 16, 2016

Special characters not returned correctly in Oracle Cloud services?

Special characters not returned correctly in Fusion Cloud services, that is the statement/question I recently got from a Cloud HCM customer. As you can see in de screenshots above, my last name contains a special character that get's returned incorrectly from Cloud HCM Rest Api.
But why does this happen, it is stored and displayed correctly in Cloud HCM?

Thursday, November 17, 2016

Automate File Based Data Import using ErpIntegrationService

A lot of customers are past the point of adapting Oracle Cloud Applications and are moving to the next step of the lifecycle, being integrating Oracle Cloud Applications within their enterprise architecture. Oracle is currently providing a plethora of CRUD web services, REST and SOAP for integration.
But in some cases the only ability to interface data is still through File Based Data Imports (FBDI).

Monday, November 07, 2016

Nullify fields using Oracle Cloud HCM web services

Recently I got a question from an Oracle HCM Cloud customer, which is using SOAP services to interface HCM data. The question was: How do I clear field data using web services?
Using HCM Data Loader you specify the value #NULL to explicitly pass a null value to a field, also this is used throughout ERP services, however the WorkerService did not respond like that.

Saturday, June 04, 2016

Fusion Cloud web services: Deprecated does not mean obsolete

During a Fusion Cloud implementation we had the task of creating the conversion to Enterprise Contracts. To load the conversion data we created a script that utilises Fusion Cloud web services. During the implementation also a release upgrade was planned from Fusion Cloud R10 to R11. This release brought and unexpected occurrence with it, being the web service we used to invoke in our conversion script being deprecated and resulting in the following response:

Saturday, March 05, 2016

Integration with Oracle Fusion Applications Enterprise Contracts using web services

During our move at Profource from Oracle E-Business Suite R12 and Oracle Fusion R7 on-premise to Oracle Fusion ERP Cloud R10, we had the challenge to migrate projects and create Enterprise Contracts.
Although Oracle Fusion provides a way to create contracts using File Import Activities, the current functionality and scope of creating contracts was not sufficient for our line of business.