12c SOA - Business Rules - use of generic rule

Input: id, name, designation (like PAT, A, SA, M etc.).

Output: eligible_trutime_topup_per_fortnight (like 10,20,0 etc.)

Step1: Create SOA Project.

Now project created.

Step2: Drag and drop bpel process and select synchronous process.

Now bpel created as like below.

Step3: Prepare schema as per your requirement.

Step4: Drag and drop business rules component.

Now you can import schema input and output.

Import input schema.

Input schema imported successfully, now import output schema.

Both schema’s imported successfully.

Step5: Double click business rules.

Now create rule.

Add the condition and hard code the output value.

Add then condition.

Select target processResponce.

Hard code output value.

Add remaining conditions also.

Step6: Double click bpel process and add Business Rules.

Double click rules and and select Business rules.

After selection now showing like below image.

Click ok, Now composite automatically invoke businessrules and created activity’s.

Step7:  Now composite like below and deploy the composite and test.

Testing:

Input:

<?xml version="1.0" encoding="UTF-8"?><inputVariable>

   <part xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" name="payload">

      <ns1:process xmlns:ns1="http://xmlns.oracle.com/POC/BussinessRulls_Poc/TopupBPEL">

            <ns1:ID>12345</ns1:ID>

            <ns1:NAME>Suri</ns1:NAME>

            <ns1:DESIGNATION>A</ns1:DESIGNATION>

        </ns1:process>

   </part>

</inputVariable>

Output:

<?xml version="1.0" encoding="UTF-8"?><outputVariable>

   <part xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" name="payload">

      <processResponse xmlns="http://xmlns.oracle.com/POC/BussinessRulls_Poc/TopupBPEL">

         <Eligibletopup>15</Eligibletopup>

      </processResponse>

   </part>

</outputVariable>

Unix/AIX box - Certificate expiration date check

Run the following openssl command 

echo | openssl s_client -servername NAME -connect HOST:443 2>/dev/null | openssl x509 -noout –dates

Example: If you have a server name ="test.server.com" and port="443"

echo | openssl s_client -servername test.server.com -connect test.server.com:443 2>/dev/null | openssl x509 -noout -dates

12c SOA - How to check BPEL recovery Pool from SOAInfra DB

Sometimes EM Composite BPEL instances have failures and thus they are moved to BPEL recovery pool. We can check  them from SOAINFRA DB and delete the struck instances if not needed.

Query 1: based on date

select count(*) from dlv_message where dlv_type = 1 and state = 0 and receive_date like '%08-JUL-19%'

Query2: based on a period

select count(*) from dlv_message where dlv_type = 1 and state = 0 and receive_date 

between TO_DATE('2020-01-01 00:00:01', 'YYYY-MM-DD HH24:Mi:SS') and TO_DATE('2020-05-31 23:40:59', 'YYYY-MM-DD HH24:Mi:SS')

To delete:

delete from dlv_message where dlv_type = 1 and state = 0 and receive_date like '%08-JUL-19%'

12c SOA - Business Rules - use of decision table

Here I will show you how to create and use decision table using business rule.

Input: id, name, designation (like PAT, A, SA, M etc.).

Output: eligible_trutime_topup_per_fortnight (like 10,20,0 etc.)

Step1: Create SOA Project.

Now project created.

Step2: Drag and drop bpel process and select synchronous process.

Now bpel created as like below.

Step3: Prepare schema as per your requirement.

Step4: Drag and drop business rules component.

Now you can import schema input and output.

Import input schema.

Input schema imported successfully, now import output schema.

Both schema’s imported successfully.

Step5: Double click business rules.

Create decision tables.

Now decision table like below.

Select process Designation like below.

Click Actions and hard code the top up value.

After hard coding the value diagram like below.

Create another rule and give remaining conditions like below.

After creating all condition rules diagram like below.

Step6: Double click bpel process and add BusinessRules.

Double click rules and and select Business rules.

After selection now showing like below image.

Click ok, now composite automatically invoke business rules and created activities.

Step7:  Deploy the composite and test.

 

Testing:

Input:

<?xml version="1.0" encoding="UTF-8"?><inputVariable>

   <part xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" name="payload">

      <ns1:process xmlns:ns1="http://xmlns.oracle.com/POC/DecisionTable_Poc/BPELProcess1">

            <ns1:ID>12345</ns1:ID>

            <ns1:NAME>Suri</ns1:NAME>

            <ns1:DESIGNATION>A</ns1:DESIGNATION>

        </ns1:process>

   </part>

</inputVariable>

Output:

<?xml version="1.0" encoding="UTF-8"?><outputVariable>

   <part xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" name="payload">

      <processResponse xmlns="http://xmlns.oracle.com/POC/DecisionTable_Poc/BPELProcess1">

         <EligibleTopup>15</EligibleTopup>

      </processResponse>

   </part>

</outputVariable>

Database - create package and procedure

Here showing you an insert events package and procedure creation.

Package creation:

create or replace PACKAGE "PCK_PROVISIONING"

AS

  /* enter package declarations (types, exceptions, methods etc) here */

PROCEDURE INSERT_EVENT_IN_PROGRESS(

    EMP_NUMBER     VARCHAR2,

    EMP_COUNTRY    VARCHAR2,

    BPEL_INST_ID   VARCHAR2,

    EMP_LAST_NAME  VARCHAR2,

    EMP_FIRST_NAME VARCHAR2,

    EV_ID OUT NUMBER );

END pck_provisioning;

Package body:

create or replace PACKAGE BODY "PCK_PROVISIONING"

AS

PROCEDURE INSERT_EVENT_IN_PROGRESS

  (

    EMP_NUMBER     VARCHAR2,

    EMP_COUNTRY    VARCHAR2,

    BPEL_INST_ID   VARCHAR2,

    EMP_LAST_NAME  VARCHAR2,

    EMP_FIRST_NAME VARCHAR2,

    EV_ID OUT NUMBER

  )

AS

BEGIN

/* calling the Insert_Event() procedure*/

  INSERT_EVENT

  (

    EV_TYPE => 'T', EMP_NUMBER => EMP_NUMBER , EMP_COUNTRY => EMP_COUNTRY, EV_STATUS => 2,            -- 2.- In Progress

    BPEL_INST_ID => BPEL_INST_ID, LAST_NAME => EMP_LAST_NAME, FIRST_NAME => EMP_FIRST_NAME, STS => 1, -- 1.- Active

    EV_ID => EV_ID

  );

END INSERT_EVENT_IN_PROGRESS;

/* called the Insert_Event() procedure body with Table.field%type */

PROCEDURE INSERT_EVENT(

    EV_TYPE EMPLOYEE_EVENT.EVENT_TYPE%type, 

    EMP_NUMBER EMPLOYEE_EVENT.EMPLOYEE_NUMBER%type,

    EMP_COUNTRY VARCHAR2,

    EV_STATUS EMPLOYEE_EVENT.EVENT_STATUS%type,

    STS EMPLOYEE_EVENT.STATUS%type,

    BPEL_INST_ID EMPLOYEE_EVENT.BPEL_INSTANCE_ID%type,

    LAST_NAME EMPLOYEE_EVENT.EMPLOYEE_LAST_NAME%type,

    FIRST_NAME EMPLOYEE_EVENT.EMPLOYEE_FIRST_NAME%type,

    EV_ID OUT EMPLOYEE_EVENT.EMPLOYEE_EVENT_ID%type )

AS

BEGIN

--Calling a sequence to get the event id.

  SELECT EMPLOYEE_EVENT_SEQ.NEXTVAL INTO EV_ID FROM DUAL;

--Inserting data to Employee_event table

  INSERT INTO EMPLOYEE_EVENT(

      EVENT_DATETIME,

      EVENT_TYPE,

      EMPLOYEE_NUMBER,

      EMPLOYEE_COUNTRY,

      EVENT_STATUS,

      STATUS,

      BPEL_INSTANCE_ID,

      EMPLOYEE_FIRST_NAME,

      EMPLOYEE_LAST_NAME,

      EMPLOYEE_EVENT_ID

    )

    VALUES(

      SYSDATE,

      EV_TYPE,

      EMP_NUMBER,

      EMP_COUNTRY,

      EV_STATUS,

      STS,

      BPEL_INST_ID,

      LAST_NAME,

      FIRST_NAME,

      EV_ID

    );

END INSERT_EVENT;

END pck_provisioning;

Unix or AIX box - remove zero size files from a directory

In our AIX box, we observed, when the files system got 100% utilized, it used to create files with zero size for all the incoming files via file adapter. so need to clear all the zero size files at a fly.

This works for plain BSD so it should be universally compatible with all flavors.

Command:

find . -size 0 |  xargs rm

12c SOA - Weblogic - delete JMS Queue messages from persistent store level

Sometimes we are facing a situation where a gigantic amount of messages are stored in the JMS queue but not processing at all and we are also not able to remove them from the queue itself. There is one alternate option to clear the messages from the persistent store level itself.

Solution steps:

Step1: Check the persistent store path, go to the path and delete SOA_JMSFILESTORE.DAT file

cd app/Oracle/Middleware/Oracle_Home/user_projects/domains/soa-osbdomain/servers/soa_server1/data/store/default

 ll

total 4112

-rw-r-----    1 oracle   dba         1052672 Apr 09 21:21 SOA_JMSFILESTORE1000000.DAT

rm SOA_JMSFILESTORE1000000.DAT

Step2: Restart the affected the manage servers. Like in this case, I have restarted the SOA1 Manage Server.