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.

Sunday, November 02, 2014

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