A workaround for Data Control Refresh in BPM-ADF Application

Hello Everyone,

Today i will be sharing my experience over the issue I have been facing related to data control refresh in BPM-ADF application, like if you add or delete or change any element in Human Task then it will not directly update the existing data controls in the existing ADF Project but creats a new adf related folder structure and duplicate dcx files in BPM project only.

For this issue, I have found a workaround to let the JDeveloper create new files for data controls and then carefully replace the ADF project files with the newly generated files. This process need to be done with proper backups of the code.

Then restart the JDeveloper and issue stands resolved.

I hope my this learning would be helpful.

Greetings,
Ankit Chhabra

Creating ADF Portal based on a properties file

Hello Everyone,

This post is based on a requirement where we need to creat a ADF page which should have a table based on data present in a properties file, and the table need to be populate data on page load.

For this, I have created a JSF page and added the property file as a resource bundle to the Faces.config file. These configs will be accessible as a value bindings to the table columns.

This solution helped me to achieve my requirement.

Hope it will help others too....

Have a great day!!!!

Greetings,
Ankit Chhabra

Using Properties File with Java Code in SOA12c

-------------------------------------------------------------------
This blog post contains few points which I learnt through my experience while working in Oracle SOA 12c Server Setup and Deployments.
-------------------------------------------------------------------- 

I was working on a issue where I have to read properties file called in a Java Code through BPEL component. We copied the file in the code location, but post deployment it is not bee called by Java Class file. Then the best way we found to read the file as a Library present in SCA-INF folder, and this resolved our issue.

So, while calling a properties or any other file to be used by SOA component is to copy in <<Code_Location>>/sca-inf/lib folder.

Note:- This workaround is used when you are not allowed to copy the file at some server location or not allowed to copy it in MDS.

Please help me with your feedback and comments.

Import MDS in SOA 12c without using WLST Scripts

-------------------------------------------------------------------
This blog post contains few points which I learnt through my experience while working in Oracle SOA 12c Server Setup and Deployments.
--------------------------------------------------------------------

In this post we will be going over the steps for Importing MDS in SOA 12c without using WLST Commands.

Before going over the Deployment steps, here are few of the Pre-Requisites to perform the deployment and verification.

1. We should be having Admin access to the server.
2. We should be having DB Credentials of MDS for verification.
3. The Files need to be imported should be available.

Using below steps we would be able to import the MDS.

1. Open JDeveloper 12c, and Create a New SOA Application "MDSApplication".
2. Create a Projects with Folder structure you want your MDS looks like.
3. Import the WSDL's and XSD's and Other files which you want in your MDS, in your Project.
4. Compile your Application and Check for any errors.
5. Create a New Deployment Profile for your application, and choose the application type of "SOABundle"
6. Under Files Section, Select the project jar files of your MDSApplication, so it would be imported in MDS.
7. Now Deploy your MDSApplication and Create a Jar File of the same.
8. Once Jar is prepared, Login to SOA Em Console
9. Go To SOA, and Right Click On SOA_INFRA and Go To Administration --> MDS Configuration.
10. For Import of MDS, choose the option provided by default and Browse the file generated in Step#7, and click Import.
11. Repeat the Step#9 and #10 for other Managed Servers as well.

This Process will Import your DB Based MDS. For Verification create a SOA-MDS Resource in your JDeveloper IDE and provide the MDS Credentials used during Installation.

I hope this will be helpful. Feedback is always welcome....

Important Features of Enterprise Scheduling Services in Oracle Fusion Applications

-------------------------------------------------------------------
This blog post contains few points which I learnt through my experience while working in Fusion Apps Customization.
--------------------------------------------------------------------
ESS(Enterprise Scheduling Services) is one of the Key technology used in Oracle Fusion Apps, which is a scheduling system similar to the Concurrent Request and Concurrent Manager in Oracle E-Business Suite.

ESS consist of 2 parts:

• ESS Job and
• ESS Job Sets 

There are various types of ESS Jobs, like 

1. PlSql JobType
2. Java JobType
3. C JobType and many more

We can execute the ESS Jobs using a Webservice call to essService or by calling through a DB procedure in ESS Metadatastore.

 

The Metadata Repository Schema for ESS jobs is FUSION_ORA_ESS and the main base tables for checking ESS Job Status is REQUEST_HISTORY.

 
Please help with suggestions over the post. I am planning to add one more post with few more details over ESS Job Creation using JDeveloper and Deployments.

Starting up with Oracle Fusion Applications 11g

Oracle Fusion Applications is one of the latest technology which is being used by many customers for managing their Products and Process Information's.

The Technical Part of Oracle Fusion Applications consists of below technologies:

• Oracle ADF (Application Development Framework) for all UI based Forms
• Oracle ADF BC services which are used to create and update the data in the tables
• Oracle PL/Sql API's similar to what we use to have in Oracle E-business Suite R12.
• Enterprise Scheduling Services, Scheduling Jobs and Job Sets similar to E-business Suite concurrent programs.
• Oracle SOA Suite Components for Integrating and Workflow management like Approval Processes and Seeded Integrating component.

For stating working in Oracle Fusion Applications, we should be aware of above technical stacks to prepare RICEFW components and customizing Fusion Apps and Integrating other legacy systems with Fusion Apps.

Some Facts for converting xsl:for-each-group to xsl:for-each

XSLT 2.0 has provided many new features out of which one is of <xsl:for-each-group> defined as:

---------------------------------------------------------------

<xsl:for-each-group
  select = expression
  group-by? = expression
  group-adjacent? = expression
  group-starting-with? = pattern
  group-ending-with? = pattern
  collation? = { uri }>
</xsl:for-each-group>

---------------------------------------------------------------

In SOA 11g I have faced such an issue where <xsl:for-each-group> was not getting executed and producing errors. For such scenarios we need to convert the <xsl:for-each-group> to <xsl:for-each> of version 1.0. Hence some logic has been implemented for this conversion.

We can try to implement this conversion by Implementation of a Key based on some of the Common_Id's like some ID/Number. By this we can implement the logic of group-by function.

The main element used in this implementation if <xsl:key>

The pseudo code for implementing the logic is like:

---------------------------------------------------------------

<xsl:key
name="<<KEY_NAME>>"
match="<<Element_Match>>"
use="<<Common_ID>>"/>

---------------------------------------------------------------

<xsl:for-each select="key('<<KEY_NAME>>','<<Common_ID>>')">
    <xsl:value-of select="<<Common_ID>>"/>

    <xsl:value-of select="<<Element_Value>>"/>

</xsl:for-each>

---------------------------------------------------------------

Feedback and comments provided will be very beneficial.

Thanks.

References: www.w3.org/TR/xslt20/#xsl-for-each-group

                 www.w3schools.com/xsl/