UMS Configurations in SOA Weblogic Server

To send/ receive emails, we use UMS adapter in SOA BPEL. you can check my previous post on how to use UMS adapter in SOA BPEL.

There is some email driver configuration has to be done in weblogic em console to send/ receive emails.

Sending Emails – email driver setup: 

Without this email driver configuration to send emails, emails will not be sent. In this setup you need to create an Email Driver and set few properties (like Outgoing mail server, username [email Id] & password) to it so that post this setup when you try to send emails from SOA BPEL using UMS adapter then emails will be sent.

Steps for the configuration:

login to em console -> Navigator Menu -> click on ‘User Messaging Service’ -> select usermessagingdriver-email.

ums1

Click on Email Driver Properties.

ums2

Click on Create + icon.

ums3.PNG

Give Name and Capability as ‘SEND‘ and scroll down to set few more properties. 

ums4.PNG

set the Outgoing mail Server, Outgoing Password properties. In Outgoing Password section, based on Type of Password LOV selection below fields will vary which is highlighted in below screenshot. 

ums5

This completes setup for email driver for UMS – SEND.

 

Receiving Emails – email driver setup:

Without this email driver configuration to receive emails, emails will not be received. In this setup you need to create an Email Driver and set few properties (like Incoming mail server & port,  username [email Id] & password, Incoming MailIds, Incoming UserIds) to it so that post this setup emails will be received (the mentioned email Ids) and are read by UMS adapter in BPEL.

Steps for the configuration:

Click on Create + icon.

ums3

Give Name and Capability as ‘RECEIVE‘ and scroll down to set few more properties. 

ums6.PNG

Set the Incoming Mail Server, Incoming Mail Server PortOutgoing Password, Incoming Mail IDs, Incoming User IDs properties.  

ums7.png

This completes setup for email driver for UMS – RECEIVE. 

ums8.png

Hope you enjoyed the post!

Advertisements

UMS adapter configuration and changing its properties at run time in SOA BPEL

We use UMS adapter in Oracle SOA mainly to send or receive emails/SMS.  We’ve to configure separate adapter for each send & receive if we require both.

UMS Adapter Configuration to receive emails:

soa_ums1a

soa_ums1b.png

For UMS Inbound operation (to receive emails) generally it’ll be the starting activity of BPEL which is ‘Receive‘. If you want to edit the properties at run time in BPEL which are set during adapter configuration,  click on Receive activity which is invoking UMS adapter and click on properties and set below properties based on requirement.

jca.ums.subject -> subject of email which is received.

jca.ums.to ->  list of email ids to whom the mail has been sent.

jca.ums.return-path -> from which mail Id the mail has been received.

jca.ums.from -> sender details of the email (Name and mailId). [This is similar to above property but it gives additional info like Name of person configured for that mailId also]

soa_ums2

Back end code would be as given below.

soa_ums3

Hope you enjoyed the post!

Git Extensions Authentication Issue

If you are using Git Extension to push the files to your remote branch and it’ll ask for authentication for the first time and remembers it. But if you change your GitHub credentials and then try to push the changes from your local repository to remote repository it’ll show you ‘Authentication Error’.

So all we need to do is, resetting the old password in windows machine where it got stored.

Process to edit your old Git Extension password:

Control panel->credential manager->windows credentials->update github with new credentials (Edit) and give new password.

GitExtensionsPwdChange

Close and reopen Git Extensions and then try to push your  changes again, it’ll work.

Happy Coding 🙂

SOA 12c – Error while processing audit information. failure due to exception fetching audit xml

While testing in SOA EM Console, if you get below error message for audit trail on launch of flow trace instead showing the actual flow it means that the flow message size is bigger than the default value which is set to 1048576.

Error Message: Error while processing audit information. failure due to exception fetching audit xml

So to view the flow, all you need to do is increase the default size given for audit trial. To do that follow below steps.

Right Click on your node server -> SOA Administration -> Common Properties -> More SOA Infra Advanced Configuration Properties (bottom link) -> Click on ‘Audit Config’ attribute from the list -> Increase the value (eg: 10485760) -> Apply.

This slideshow requires JavaScript.

Hope this is helpful.

Invoking Oracle Fusion Cloud REST services from SOA-CS

In this post I’ll brief about how we can trigger Oracle Fusion ERP Cloud REST services from Oracle SOA-CS.

Let’s take a requirement that to update a fusion cloud database table record. As we aware we won’t have access to cloud database and the only option left to us is making use of REST services provided by oracle.

So let’s go with the specific requirement that to update Expenditure Items table (pjc_exp_items_all). Simply search with the table name in google, you’ll get complete details about the table and columns in it.

This table belongs to Project Portfolio Management, so to search for any REST services available to update tables related to this, go through below Navigation.

Google -> Search for OER (Oracle Enterprise Repository) and open the site -> Select ‘Project Portfolio Management’ tab -> Under ‘Tables & Views’ category, select latest release (Release 13 Update 17b  by the time this post is blogged) -> In the left under REST API click on Project Portfolio Management -> In the page you can see all the available APIs.

Direct link for the same: https://docs.oracle.com/en/cloud/saas/project-portfolio-management/r13-update18a/fapap/api-Expenditure%20Items.html

There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select method ‘PATCH’ which is used to update an expenditure Item) .

Now in the page copy the path to be used for the method to invoke /fscmRestApi/resources/11.13.17.11/projectExpenditureItems/{ExpenditureItemId}

And In the examples, check the sample request and response, which we use to build our schema for input to the REST service.

1.png

Now let’s go into the development.

  • I’ve created a SOA project with BPEL (service defined later).
  • In the BPEL, first let’s create a Schema for the REST service. Make sure the schema attribute names must match with the attribute names given in the sample request, response.

4.PNG

  • In the schema two elements are created one is the primary key of table (ExpenditureItemId) and the other is updatable attribute (ExternalBillRateSourceName) in the cloud table (not all attributes are updatable).
  • Create REST service in the composite file and right click on it and ‘configure SOA WS policy‘ add security policy [oracle/wss_http_token_client_policy] and edit the policy, set csf-key (e.g: CW-key)
  • Put an Invoke activity in BPEL and call the REST service. In the Invoke add properties as given below.

[rest.binding.http.X-HTTP-Method-Override = ‘PATCH’,  rest.binding.http.Accept = ‘application/json’]

  • Create Assign activity and map the required values to the REST input variable.

This slideshow requires JavaScript.

Result: So if you pass ExpenditureItemId, ExternalBillRateSourceName values to REST service, it’ll update the  attribute ‘EXT_OVRD_BILL_RATE_SOURCE_NAME’ with the value coming from ‘ExternalBillRateSourceName’ for the already exist record with given ExpenditureItemId in the ‘pjc_exp_items_all’ table.

Reference (more details about security): http://www.ateam-oracle.com/invoke-fusion-cloud-secured-restful-web-services/

Hope you enjoyed the post!

Translation Error while doing Transformations in SOA

In the Transformation file (.xsl) we map source variable attributes to destination variable attributes.

Let’s say out destination is DBAdapterWriteInputVariable which has 25 columns. In the Transformation file if you map only 15 columns from source to destination (DBAdapterWriteInputVariable) and left the remaining 10 attributes as blank, then at the Transformation step of composite you’ll get this Translation error. This error is because target system is expecting values with respect to its defined schema (25 values) but the transformation file doesn’t map all the values according to the schema (only maps 15), so the error come here.

So all you need to do is, though you are not assigning any values to few attributes, they must be declared (present in source code of XSL file) like <attribute7/> having no value.

To declare them right click on each attribute in design mode which is not present in Source mode, and click on Edit Text and Enter (No need to give any value), so that attribute declaration will be saved which you can see in the source mode.

SOA_TranslationError.png

Hope this is helpful!

View the Job Details and run the jobs manually in Oracle Fusion Cloud Application

This post will be helpful in providing the navigation to find the job details and run them from the oracle cloud fusion application. As an example in this post I’ll show the FBDI (File Based Data Import) job details which is much used in real time.

Navigation to view the Job details:

  • Login to Oracle Fusion Cloud Application
  • Click on ‘Setup and Maintenance’ Icon from the home page.
  • Select the required Module from left drop down (Financials)
  • Search with the keyword ‘Manage Custom Enterprise Scheduler Jobs’
  • Select the link ‘Manage Custom Enterprise Scheduler Jobs for Financial and Supply Chain Management and Related Applications’
  • Search with the required Job in the Name column search box (or) in the Display Name column. [search with ‘Load’ keyword in Display Name column search box]
  • Select the required Job from the list and and view the Job details (You can see details like Job Name, Display Name, description, job path, job execution type (Java/ PL SQL/ Process). Using the options provided in the top you can ‘Edit’ the job, ‘Duplicate’ this job, ‘Export to Excel’.

This slideshow requires JavaScript.

Navigation to Run the Jobs:

  • Go to the Home page and click on Tools -> ‘Scheduled Processes’
  • Click on ‘Schedule New Process’, which will open a popup.
  • Click on ‘Search..’ link under Name drop down.
  • Search with the required job ‘Load Interface’ and select the job name ‘Load Interface File for Import’ from the list.
  • Basically this job will take the data file (FBDI CSV File) and executes the jobs which we select like ‘Import Projects Billing Events’ job. So the billing data which we upload will be moved to the Project billing events Interface table and from there they’ll be moved to the base tables [means billing events will be created in the cloud application]. This is how we can move the data to oracle cloud application.
  • Select the Import Process ‘Import Projects Billing Events’ and upload appropriate FBDI file and Submit the job.

This slideshow requires JavaScript.

Hope you like the post!