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.

Sunday, December 06, 2015

Complement your Oracle ERP conversion with CRM File Based Data Import

On a customer Fusion ERP implementing project and on our own Fusion ERP Cloud implementation, I had the privilege of creating and running the conversion of suppliers to Fusion ERP. Fusion provides to necessary File Based Data Import to load Suppliers, Supplier Addresses, Sites, Assignments and Bank Accounts.
To be able to load the Supplier Bank Accounts, the bank and bank branches need to be converted to Cash Managent first, for this the RapidImplementionForCashManagement sheet can be utilised.
Because these implementations have CGI validation enabled for SEPA payment files, it is enforced to have an address for the bank branches, al least a country code and this is where it's getting exciting.

Friday, January 23, 2015

Oracle HCM Cloud: Lessons learned and Tips & Tricks for a succesful implementation

The past couple of months, we worked on several global implementations of Oracle HCM and Talent Management Cloud. One of the projects (see press release) consisted of a Oracle HCM and Talent Management Cloud implementation in 40 countries as replacement of the current PeopleSoft HCM 9.0 environment. During this period we gained a lot of experience and expertise, that we would like to share with you as our lessons learned and tips & tricks.