Using eBS Adapter in Integration Cloud Service – Part 2: Configure and Test ISG REST Services by Stefan Koser

January 4, 2017 Leave a comment

clip_image002

 

Introduction

Integration Cloud Service (ICS) enables connecting applications in the cloud or on-premise. It also provides an adapter for Oracle eBusiness Suite. This eBS adapter is different than the eBS adapter in SOA Suite – it does not use a database connection. Instead it uses the REST services provided by eBS as part of Integrated SOA Gateway (ISG).

This article describes the steps needed to get eBusiness Suite including ISG REST services ready – either for using it with any REST client or with ICS. ISG requires some additional patches on top of eBS 12.2.4 – this was shown in this first part , see here.

In this second part, we will show how to enable the REST services, how to enable the metadata provider for ICS and test eBS REST services, first from a native REST client (SOAPUI) and then from ICS. All steps except chapter 4 are also relevant if you want to use Oracle eBusiness Suite ISG REST services without ICS.

Chapter 1 – Configure Integrated SOA Gateway (ISG) in eBS 12.2.4

Enabling ASADMIN User with the Integration Administrator Role

We will execute the steps in section 3 of the MOS note:

Log in to Oracle E-Business Suite as a SYSADMIN user and enter the associated password.
Expand the User Management responsibility from the main menu of the Oracle E-Business Suite Home Page.

Click the Users link to open the User Maintenance page (under “Vision Enterprises”)
Enter ‘ASADMIN’ in the User Name field and click Go to retrieve the ‘ASADMIN’ user.

Click the Update icon next to the ASADMIN user to open the Update User window.
Remove the Active To date field and click Apply.

Click the Reset Password icon next to ASADMIN user to open the Reset Password window. Make sure that ASADMIN’s password is at least eight characters long.
Enter new password twice and click Submit.

In the Update User window, click Assign Roles.
In the search window, select Code from the Search By drop-down list and enter “UMX|FND_IREP_ADMIN” in the value text box.
Click Select.
Enter a justification in the Justification field and click Apply. You will see a confirmation message indicating you have successfully assigned the role.

In my case, a warning is displayed (which can be ignored because the server is restarted later anyway):

Updates to Role data will not be visible in the application until the following processes are started : Workflow Background Engine. Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture, SOA Tagged with , , , , , , , , ,

HCM Cloud – Bulk Integration Automation Using SOA Cloud Service by Jack Desai

August 23, 2016 Leave a comment

clip_image002

 

Introduction

Oracle Human Capital Management (HCM) Cloud provides a comprehensive set of tools, templates, and pre-packaged integration to cover various scenarios using modern and efficient technologies. One of the patterns is the batch integration to load and extract data to and from the HCM cloud. HCM provides the following bulk integration interfaces and tools:

HCM Data Loader (HDL)

HDL is a powerful tool for bulk-loading data from any source to Oracle Fusion HCM. It supports important business objects belonging to key Oracle Fusion HCM products, including Oracle Fusion Global Human Resources, Compensation, Absence Management, Performance Management, Profile Management, Global Payroll, Talent and Workforce Management. For detailed information on HDL, please refer to this.

HCM Extracts

HCM Extract is an outbound integration tool that lets you select HCM data elements, extracting them from the HCM database and archiving these data elements as XML. This archived raw XML data can be converted into a desired format and delivered to supported channels recipients.

Oracle Fusion HCM provides the above tools with comprehensive user interfaces for initiating data uploads, monitoring upload progress, and reviewing errors, with real-time information provided for both the import and load stages of upload processing. Fusion HCM provides tools, but it requires additional orchestration such as generating FBL or HDL file, uploading these files to WebCenter Content and initiating FBL or HDL web services. This post describes how to design and automate these steps leveraging Oracle Service Oriented Architecture (SOA) Cloud Service deployed on Oracle’s cloud Platform As a Service (PaaS) infrastructure.  For more information on SOA Cloud Service, please refer to this.

Oracle SOA is the industry’s most complete and unified application integration and SOA solution. It transforms complex application integration into agile and re-usable service-based components to speed time to market, respond faster to business requirements, and lower costs.. SOA facilitates the development of enterprise applications as modular business web services that can be easily integrated and reused, creating a truly flexible, adaptable IT infrastructure. For more information on getting started with Oracle SOA, please refer this. For developing SOA applications using SOA Suite, please refer to this.

These bulk integration interfaces and patterns are not applicable to Oracle Taleo.

Main Article

HCM Inbound Flow (HDL)

Oracle WebCenter Content (WCC) acts as the staging repository for files to be loaded and processed by HDL. WCC is part of the Fusion HCM infrastructure.

The loading process for FBL and HDL consists of the following steps:

  • Upload the data file to WCC/UCM using WCC GenericSoapPort web service
  • Invoke the “LoaderIntegrationService” or the “HCMDataLoader” to initiate the loading process.

However, the above steps assume the existence of an HDL file and do not provide a mechanism to generate an HDL file of the respective objects. In this post we will use the sample use case where we get the data file from customer, using it to transform the data and generate an HDL file, and then initiate the loading process.

The following diagram illustrates the typical orchestration of the end-to-end HDL process using SOA cloud service: Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture Tagged with , , , , , ,

PaaS and SaaS: Perfect Together by Debra Lilley

October 6, 2015 Leave a comment

clip_image001Platform as a service, or PaaS, is exciting a lot of our customers—not just those who want to move to the cloud, but also those who see PaaS as a way to build applications faster and more efficiently. As Oracle releases more development tools in the cloud, I believe that PaaS will become the de facto way to extend software as a service (SaaS).

First, let’s explore some of the major benefits of PaaS. With PaaS, you no longer have to worry about the cost and time associated with maintaining hardware or a data center. By bypassing the setup required for a development environment, your organization will achieve faster time to value on projects. Most PaaS offerings are on a consumption model: Much like buying gas, you fill up only when you need to, and you pay for only what you use. Finally, the quick-start, user-friendly, cloud-based development tools enable and foster continuous innovation.

In my work for Certus Solutions, a leader in Oracle Cloud implementations in Europe, the Middle East, and Asia, I have been particularly interested in “PaaS4SaaS,” which is the ability to extend Oracle’s cloud platform and applications with our own mini applications and have them seamlessly co-exist. Here are a few points I’ve observed for Oracle customers looking to do the same. Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture, Cloud Tagged with , , , , , , , , ,

Fusion HCM Cloud Bulk Integration Automation by Jack Desai

October 5, 2015 Leave a comment

 

Introduction

clip_image002Fusion HCM Cloud provides a comprehensive set of tools, templates, and pre-packaged integration to cover various scenarios using modern and efficient technologies. One of the patterns is the bulk integration to load and extract data to/from cloud. The inbound tool is the File Based data loader (FBL) evolving into HCM Data Loaders (HDL). HDL supports data migration for full HR, incremental load to support co-existence with Oracle Applications such as E-Business Suite (EBS) and PeopleSoft (PSFT). It also provides the ability to bulk load into configured flexfields. HCM Extracts is an outbound integration tool that let’s you choose data, gathers and archives it. This archived raw data is converted into a desired format and delivered to supported channels recipients.

HCM cloud implements Oracle WebCenter Content, a component of Fusion Middleware, to store and secure data files for both inbound and outbound bulk integration patterns. This post focuses on how to automate data file transfer with WebCenter Content to initiate the loader. The same APIs will be used to download data file from the WebCenter Content delivered through the extract process.

WebCenter Content replaces SSH File Transfer Protocol (SFTP) server in the cloud as a content repository in Fusion HCM starting with Release 7+. There are several ways of importing and exporting content to and from Fusion Applications such as:

  • Upload using “File Import and Export” UI from home page navigation: Navigator > Tools
  • Upload using WebCenter Content Document Transfer Utility
  • Upload programmatically via Java Code or Web Service API

This post provides an introduction, with working sample code, on how to programmatically export content from Fusion Applications to automate the outbound integration process to other applications in the cloud or on-premise. A Service Oriented Architecture (SOA) composite is implemented to demonstrate the concept.

Main Article

Fusion Applications Security in WebCenter Content

The content in WebCenter Content is secured through users, roles, privileges and accounts. The user could be any valid user with a role such as “Integration Specialist.” The role may have privileges such as read, write and delete. The accounts are predefined by each application. For example, HCM uses /hcm/dataloader/import and /hcm/dataloader/export respectively.

Let’s review the inbound and outbound batch integration flows.

Inbound Flow

This is a typical Inbound FBL process flow: Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture Tagged with , , , , , , ,

Fusion HCM Integration by Kiran Mundy

October 4, 2015 1 Comment

 

clip_image002Because of frequent questions from HCM customers on how they can use BPEL to integrate with Fusion HCM, I’ve put together the details here

Your orchestration layer is the software [such as Oracle’s SOA BPEL or BPM Studio] you currently already use, to wire together Fusion HCM Loader/Extract programs to other apps.

SOA/BPEL
Companies already using SOA/BPEL can just add Fusion HCM into the mix.
Steps to accomplish this are below:.

INBOUND TO FUSION HCM

  1. BPEL’s "File Adapter" to read the data in.
  2. BPEL’s Transform Activity with Domain Value Maps to transform the data.
  3. You need to get the UCM Service exposed externally (In Rel10 it will be exposed, but on Rel9, you’ll need to do the following):
    1. File an SR requesting Fusion HCM to perform a Key Exchange – Aside from allowing you to send "encrypted" files into Fusion, this step will also result in the UCM Service being exposed externally.
      • Ensure you file the SR under Oracle Cloud Global Human Resources Cloud Service.
      • Choose Hosting Services – Application -> Encryption Key Exchange
  4. Use BPEL to Invoke the UCM Soap Service to write the File into UCM.
  1. Invoke the HCM Loader Programs passing them the encryption parameter along with other required parameters.
    • FBL wsdl is the following form: https:// <Hostname>/LoaderIntegrationService?WSDL
    • HDL wsdl is the following form: https:// <Hostname>/hcmCommonDataLoader/HCMDataLoader?wsdl
  2. Find out which user privileges you must assign to the users who call these web services in OER: https://fusionappsoer.oracle.com
  3. Sample Payloads for the above services are available here. [You can enter comments into the sample payloads doc if you find any issues].
  4. Later when REST Services are available (Release 9 Patch Bundle 6 under "controlled availability" most likely), for your lighter weight inbound integrations, such as Fusion/Taleo, you will have the option to switch #3/4/5 to a REST service call to create/update the employee in Fusion. NOTE: Cco-existence scenarios should continue to use batch loaders because:
    • Performance Reasons – services won’t perform as well under heavy loads
    • The breadth of data needed for co-existence isn’t covered (or intended to be covered) by the REST Services.

OUTBOUND FROM FUSION HCM Read the complete article here

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture Tagged with , , , , , , , , ,

Finally My PaaS4SaaS Workshop Blog by Debra Lilley

October 3, 2015 Leave a comment

 

clip_image002I know this posting is a bit late but at the end of January I took part in a proof of concept workshop for PaaS4Sass and it’s been a rollercoaster ride ever since.

When I was thinking about moving to Certus one of the things that attracted me was there intent to write extensions for Oracle’s CloudApplications using the just announced PaaS4SaaS solution.

I attended Oracle Open World with an open mind and trying to learn as much as I could about the solutions. The Larry Ellison demo was really impressive but then Oracle has always been a brilliant marketing company.

I came back to UK and set about validating what was available, some of the components Database and Java Cloud had been available for a while but I wanted or would want to also use the Process and Integration Cloud offerings.

As regular readers of this blog will know, I am an OracleApplications User Experience advocate and am very committed to the user experience work that goes into Oracle Cloud Applications. Extensions delivered by Certus will have this same user experience and I made this video on the half of Certus.

The user experience team have been given funding by Thomas Kurian who is personally committed to making PaaS4SaaS work, to carry out a number of proof of concept workshops with Oracle partners. The UX team asked Certus to be part of this. Certus have not been a development company and so in the same way customers come to us because we are the best at implementing cloud applications we looked for a partner to help us with development, and weselected eProseed who have the same commitment to UX as we do.

The workshop took place in London at the end of January with four people from each of Oracle UX, eProceed and Certus taking part. We work through a use-case taken from an existing Application from one of our customers who is considering modernising this and moving it to the cloud. In three days we were able to build a working application and prove to ourselves that when the customer says, “go” we will be able to deliver what they need.

Oracle UX team have in their blog already covered the workshop and I have also written about it in the AppAdvantage blog I am a guest author for. The following month I took part in the Partner SOA Community Forum in Budapest when we had the opportunity to work with product management teams of both the Process and Integration Cloud offerings and further validate our approach, understanding the possibilities and the constraints. The UX team also had a stand there. I was very pleased on behalf off both Certus and eProceed to accept the first Community Cloud award. These awards are a bit like the Oscars and awarded to individuals Lonneke from eProseed and myself, however we had a similar thank you to all those involved in our acceptance speech. The Community Leader Jurgen Kress said: I awarded my first SOA Community Outstanding Contribution for Cloud to Debra Lilley of Certus Solutions and Lonneke Dikmanns of eProseed because they not only took on board the messaging of PaaS 4 SaaS from the last Oracle Open World, but also their collaboration between an Applications partner and a Middleware partner, sought out answers and training and with Oracle Development giving feedback and  validating their approach in this area. All good things but bringing that back to the community and sharing is the outstanding contribution. Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture, Cloud Tagged with , , , , , , ,

Fusion HCM Integration by Kiran Mundy

September 4, 2015 Leave a comment

 

clip_image002Because of frequent questions from HCM customers on how they can use BPEL to integrate with Fusion HCM, I’ve put together the details here

Your orchestration layer is the software [such as Oracle’s SOA BPEL or BPM Studio] you currently already use, to wire together Fusion HCM Loader/Extract programs to other apps.

SOA/BPEL
Companies already using SOA/BPEL can just add Fusion HCM into the mix.
Steps to accomplish this are below:.

INBOUND TO FUSION HCM

  1. BPEL’s "File Adapter" to read the data in.
  2. BPEL’s Transform Activity with Domain Value Maps to transform the data.
  3. You need to get the UCM Service exposed externally (In Rel10 it will be exposed, but on Rel9, you’ll need to do the following):
    1. File an SR requesting Fusion HCM to perform a Key Exchange – Aside from allowing you to send "encrypted" files into Fusion, this step will also result in the UCM Service being exposed externally.
      • Ensure you file the SR under Oracle Cloud Global Human Resources Cloud Service.
      • Choose Hosting Services – Application -> Encryption Key Exchange
  4. Use BPEL to Invoke the UCM Soap Service to write the File into UCM.
  1. Invoke the HCM Loader Programs passing them the encryption parameter along with other required parameters.
    • FBL wsdl is the following form: https:// <Hostname>/LoaderIntegrationService?WSDL
    • HDL wsdl is the following form: https:// <Hostname>/hcmCommonDataLoader/HCMDataLoader?wsdl
  2. Find out which user privileges you must assign to the users who call these web services in OER: https://fusionappsoer.oracle.com
  3. Sample Payloads for the above services are available here. [You can enter comments into the sample payloads doc if you find any issues].
  4. Later when REST Services are available (Release 9 Patch Bundle 6 under "controlled availability" most likely), for your lighter weight inbound integrations, such as Fusion/Taleo, you will have the option to switch #3/4/5 to a REST service call to create/update the employee in Fusion. NOTE: Cco-existence scenarios should continue to use batch loaders because:
    • Performance Reasons – services won’t perform as well under heavy loads
    • The breadth of data needed for co-existence isn’t covered (or intended to be covered) by the REST Services.

OUTBOUND FROM FUSION HCM Read the complete article here

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture, SOA Tagged with , , , , , ,

ACE Director on Clearing the ConFusion – Oracle Cloud Applications by Debra Lilley

June 21, 2015 Leave a comment

 

clip_image001As I typed that title I cringed. I have been an advocate for Oracle’s development of Next Generation Applications from the day they announced Fusion, and I hated the term quickly coined by pessimists of ‘Fusion – Confusion’. But now as Oracle drops the name Fusion, for its applications, I feel there really is some confusion, so I am going to use this post to clarify to this community.

Why am I writing this post for this blog? Well the problem is Oracle knows it has renamed the products, but their customers don’t. If you are attending COLLABORATE in April the stream is called Fusion Applications, and if it wasn’t the number of attendees would be very small, but more and more you need to recognise the Cloud brand. The components of Cloud that Oracle developed in their technology (okay, Fusion applications), are 100% written on Oracle Fusion Middleware, that hasn’t gone anywhere and continues to be developed, and it is the use of these Oracle Fusion Middleware technologies that Oracle AppAdvantage is all about – extending the capabilities of "Fusion" Applications with Oracle Fusion Middleware. My starting position and reason I became involved with this AppAdvantage initiative is that there is no better shop window for what Oracle Fusion Middleware can do than the applications that Oracle has developed itself.

I did try an explanation on my own blog after Oracle Open World but this time I will be more succinct.

FACT : All Fusion Applications are now Cloud Applications.

Each pillar is now renamed Oracle …. Cloud , so Fusion Financials is now part of Oracle ERP Cloud, within each pillar there are the separate offerings which are normally desecrate process areas and with discrete pricing.

FACT : Not all  Cloud Applications started Life as Fusion Applications.

As part of their Cloud journey, Oracle has acquired some native cloud-delivered applications, such as Taleo and RightNow. The plan, being executed is that these products are being unified, i.e. integrated with other offerings, where possible being delivered on the same technology stack and being given the same User Experience as Oracle’s home grown offerings.

RightNow has for some time been known as Oracle Service Cloud  and the recruiting module from Taleo as Oracle Recruiting Cloud

FACT: Cloud Applications don’t have to be SaaS

Software as a Service is the deployment of an application in a cloud environment. Oracle, or a third party in some cases, hosts the application and look after not only the infrastructure but the patching and security, and in turn you pay a subscription to use charge.

Most of these same applications could be deployed on-premise with you being responsible for all the above and with the more traditional upfront licence costs.

Oracle have called the products Cloud because they are available and are being deployed as such more and more that way.

FACT : Oracle are trying to make it easy for you to find this all in one place.

This is a great place to start: https://cloud.oracle.com/home. The Applications tab goes through the offerings and you can find the PaaS offerings to extend and strengthen your SaaS. Read the article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture Tagged with , , , , , , ,

AppAdvantage On-Demand Webcast Series on-demand

May 13, 2015 Leave a comment

clip_image001· Multi-Channel Enablement for a Digital Business

· Bridge the Cloud Gap with SaaS to On-Premise Integration

· Platform Optimization with Exalogic

· Customer documentary webcasts discussing integration, mobility, digital experience and more: Oracle AppAdvantage IT Leader Series

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture Tagged with , , , , , ,

AppAdvantage Benefits for Partners

April 1, 2015 Leave a comment

clip_image001

 

Thank you once again for a great PartnerCast on November 12! Individual show segments are now hosted on Oracle Media Network’s PartnerCast channel for replay.

Replay links:

§ PartnerCast: Oracle AppAdvantage and Benefit to Partners

§ PartnerCast: Oracle Mobility and Opportunities for Partners

§ PartnerCast: 3Di Systems and Oracle Mobility Projects

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture Tagged with , , , , ,

← Older posts