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).

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:

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.

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.

Leverage the power of BI Publisher in Cloud integrations

By now we are all accustomed to running Applications in the Cloud and it has reached the next phase: extensibility and integrating of the Cloud Applications with other applications in our enterprise architecture. Oracle is investing a lot on this area with PaaS, IaaS, DBaaS, MWaaS, JaaS and everything else that ends with aaS. This will work fine if you are a Sales Cloud customer, where you have the ability to create custom objects, outbound calls, etc.

But what if you're a Cloud ERP or HCM customer? Integration here is currently limited to file based extracts, file based loaders, spreadsheet loaders and web services that have been made available to be consumed externally. In real-time integrations you may be confronted with data needs that are not (yet) available by the web services provided in Cloud Applications, but you also do not the tooling to create custom web services for these needs. Or do you?

Inspired by this blog of FA Developer Relations, I would like to demonstrate how you can create custom real-time data extracts on nearly any data that resides in Fusion, using the PublicReportService

Oracle Fusion HCM Cloud Implementation Partner Bootcamp

I am pleased to announce that Oracle invites partners to participate in the Oracle Fusion HCM Cloud Implementation Bootcamp. And I am even more pleased to announce that I am personally attending this bootcamp.

This hands-on two week workshop is delivered by Oracle Fusion HCM Development.  It consists of presentations, live demos and hands-on laboratory exercises. The objective is to help delivery consultants understand how to implement the latest release (R7) of Oracle Fusion HCM’s Global Human Resources and common architecture features before embarking on an Oracle Fusion HCM Applications Cloud implementation project.

Oracle Open World: Day 3

After attending Oracle Open World for three days, it looks like the future is all about handling big data, flash, hardware, mobile and social media and all of this in the cloud. And Oracle is supplying all of these, although we see competitive products from partners. Oracle is really making cloud the new standard for your business and you can see this in all the keynotes. No more on premises hardware, maintenance, upgrade, just a monthly fee and you are up and running with your entire infrastructure.

Fusion Applications in the Cloud

Oracle Open World 2011 was mainly dominated by Exalogic. Exalogic is hardware and software engineered together to provide extreme performance for Java applications, Oracle Applications, and all other enterprise applications.

And yes, now Oracle is also offering Oracle Fusion Applications HCM and CRM in the Cloud!