How to count the procedure out put node variable values?

Example to count the procedure output node

count(bpws:getVariableData('Invoke_OrderProcessService_OrderProcessService_OutputVariable','OutputParameters','/ns8:OutputParameters/ns8:X_HEADER_TBL_VAL/ns8:X_HEADER_TBL_ITEM_VAL/ns8:ORD_LINE_TBL_VAL/ns8:ORD_LINE_TBL_ITEM_VAL[ns8:LINE_STATE = "BOOKED"]/ns8: LINE_STATE '))

How to set meaning full title for BPEL Process?

Step1: Create Application in Jdev and Create BPEL Project.

Step2: Change the XSD as required.

Step3: Assign order number to variable, create variable

Step4:   Add JavaEmbeded activity and Write below java code in java embeded activity.

/*Write your java code below e.g.

                System.out.println("Hello, World");

*/       

//the title should uniquely identify the transaction      

String t_instance_title = (String)getVariableData("Variable_OrderNumber");                           

//set instance title                      

setTitle(t_instance_title);               

setIndex(1,t_instance_title);

Step5: Deploy the BPEL Process and test.

DVM Syntax?

Syntex:

dvm:lookupValue(dvmMetadataURI as string, SourceColumnName as string,SourceValue as string, TargetColumnName as string, DefaultValue as string)

Example:

dvm:lookup-dvm("ERROR_CODE_MAPPING_DVM","Error_Key","INVALID_INPUTS_ERROR","Error_Desc","InputError")

Functions used to get instance id,process name and current date time?

Below functions used.

To get InstanceIDàora:getInstanceId()

To get ProcessIDàora:getProcessId()

To get  current date and timeàora:getCurrentDateTime()

Positives and negatives of EDN?

Positives and negatives of EDN....

Positive	No interaction with other systems No worries if other systems are unavailable
Positive	Not required to transform data to different system format
Negative	One way pattern – not for replacing request response pattern
Negative	Subscriber not durable – message loss if one of the subscriber is not running – these can be avoided in a clustered environment
Negative	No info on who is receiver – granularity of event is question

How to change DVM values at runtime in SOA11g?

1.Oracle SOA Composer used to edit Domain Value Maps in soa 11g
2.Refer below link to get more details
http://docs.oracle.com/cd/E28271_01/dev.1111/e10224/med_dvm_ui.htm

About XSLT Error XPath expression failed to execute (FOTY0001: type error)

Some times we face below error in real-time.
We can’t find this error in compilation time we can see this only in execution time
in console.To resolve this we need to open the code in JDeveloper click on Transformation
wait up to source part and target part to open then test the XSLT close
and save the project and redeploy the code.

How to create DVM in 10g?

Here we will discuss about how to cerate DVMs in SOA 10g.
1. Log in to ESB Console and go to DVM MAP Section.

 
2.In DVM Map Click on Create a new map it displays below screen.
                     Create a new map and Import a new map.
   

3.Edit name by double clicking on New DVM, Change domain names and add values as
      per requirements as given in screen below.
     Example: changed New DVM as “Course_Status”
                                Domain1 as “Course”
                                Domain2 as “Status”
                                 Entered the Value1 as “MCA” and Value 2 as “Active"

4.Click on OK and save the changes.

5.You can add or edit existing DVM (at Runtime).
   Example to ADD: Click on Add button, you will get below options.
                               Then clik on row you will get below screen to add values.

           Example: Added Course as “MBA” and Status as “Active”

         Example to edit: click on tha values which you want to modify and update as per requirement
                               Updated MCA Course Status as “Inactive” From “Active”

6.You can delete the rows by selecting and clicking on delete button and  You can delete complete DVM by selecting and clicking the Delete button.

How to import the WSDL in SOAP UI?

Follow the below steps to import WSDL in SOUP UI..

STEP1: Take the WSDL from service which you want to test/Import.
Example WSDL:
                http://ip:port/orabpel/operations/BPELProcess1/1.0/BPELProcess1?wsdl

STEP2: Open SOUP UI…You will get below screen...

STEP3:Click on file and click on new SOUP UI..You will get below screens.

STEP4: Give the project Name and import WSDL and Click OK. 

          After you will get request response screens.Now the service is ready for test.
          We can say you have successfully imported WSDL in SOUP UI.

How the testing issues tracked in real-time?

Here I want to give some points regarding how the testing issues tracked in real-time.
Most of the organizations use HP QC for tracking issues throughout the application life cycle.
1.HP Quality Center is the QA infrastructure used by enterprise to support all essential aspects of centralized test management throughout the application life cycle.
2.It provides a consistent, repeatable process for gathering requirements, planning and scheduling tests, analyzing results and managing defects and issues.
3.HP Quality Center software enables organizations to digitize specific quality processes and procedures within the larger application life cycle, and supports high levels of communication and collaboration among IT teams.
Key benefits of QC:
• Prioritize testing based on business risk
• Access testing assets anytime, anywhere
• Schedule and execute tests automatically, 24x7
• Analyze readiness with integrated graphs and reports
• Manage defects and trace them to tests and requirements

What is Dehydration store in soa 11g? What are the Tables for that?

BPEL dehydration store :
1.Oracle BPEL PM utilizes a database to store metadata and instance data during runtime.
  The process of updating process state in the database is called Dehydration.
  This data is stored in what is known as the Dehydration store, which is simply a database schema
  The Dehydration Store database is used to store process status data, especially for asynchronous      BPEL processes,   like BPEL’s metadata and instance data. This exists in x_SOAINFRA schema created by running RCU.
2. The Dehydration Store database is used to store process status data, especially for asynchronous BPEL processes.
3.A very important to remember if a BPEL process fails without reaching a
dehydration point then the instance will not show up on the BPEL console.
This instance never gets stored to the database.
Below are the main Dehydration tables for BPEL:
1.CUBE_INSTANCE
2.CUBE_SCOPE
3.AUDIT_TRAIL
4.AUDIT_DETAILS
5.DLV_MESSAGE
6.DLV_MESSAGE_BIN
7.INVOKE_MESSAGE
8.INVOKE_MESSAGE_BIN
9.DLV_SUBSCRIPTION
10.TASK
11.WORK_ITEM
Following are processes state codes and their meaning
State                          Code
Closed and Aborted 8
Closed and Cancelled 7
Closed and Completed 5
Closed and Faulted 6
Closed and (Pending or Cancel) 4
Closed and Stale 9
Initiated 0
Open and Faulted 3
Open and Running 1
Open and Suspended 2

What is diff b/w FlowN and While Activities?

1.FlowN activity is replaced by the forEach activity in BPEL 2.0 projects,
  forEach executes its contained scope N times,
2.The flowN activity creates multiple flows equal to the value of N,
  which is defined at run time based on the data available and logic within the process.
  Index variable increments each time
3.while executes its contained scope repeatedly until a condition is no longer true.

What is diff b/w Transient and Durable?

Transient process:
1.Synchronous process is the example of transient process- hence no dehydration activity.
2.No mid process breakpoint activities (Receive, onMessage, onAlarm, Wait)
3.No non-idempotent invoke And No non-blocking invoke
Durable process:
1.Long Running Process Has mid process breakpoint activities (Receive, onMessage, onAlarm, Wait)
2.Has non-idempotent invoke or Has non-blocking invoke

What are BPEL Specification?

Below are the two specifications in BPEL.

BPEL 1.1 Specification

Creates a BPEL project that supports the BPEL 1.1 specification. This is the default selection.

BPEL 2.0 Specification

Creates a BPEL project that supports the BPEL 2.0 specification.

What are the templates available in ‘Create BPEL Process’ wizard?

There are 5 templates available in the ‘Create BPEL Process’ wizard.

1. Synchronous BPEL Process

2. Asynchronous BPEL Process

3. OneWay BPEL Process

4. Define Service Later

5. Base on a WSDL

6. Subscribe to Events

What are Oracle File and FTP Adapters read and write file formats?

The Oracle File and FTP Adapters can read and write the following file formats and use the adapter translator component at both design time and run time:
1. XML (both XSD- and DTD-based)
2. Delimited
3. Fixed positional
4. Binary data
5. COBOL Copybook data

What are the Operations in MQ Adapter?

Below are the operations in MQ Adapters.
1. Put Message into MQ
  Operation Name: Enqueue
2. Get Message from MQ
  Operation Name: Dequeue
3. Send Message to MQ and Get Reply/Reports
     Send Operation Name: Enqueue
     Get Operation Name: Dequeue
4. Get Message from MQ and Send Reply/Reports
        Asynchronous:
          Send Operation Name: Enqueue
          Get Operation Name: Dequeue
        Synchronous:
          Operation Name: DequeueEnqueue

What are the Operation Types in AQ Adapter?

Operation Types in AQ Adapter:
 1) Dequeue
 2) Enqueue

What are the file types and operation types in FTP Adapter?

File Types in FTP Adapter Configurations:
 1) Ascii
 2) Binary
Operation Types in FTP Adapter Configurations:
1) Get File
2) Put File
3) Synchronous Get File

What are the operation types in File Adapter Configuration?

Operation Types in File Adapter:
1) Read File
2) Write File
3) Synchronous Read File

What are the operations in DB Adapter Configuration?

Operation Types in DB Adapter:
1. Call a Stored Procedure or Function
2. Perform an Operation on a Table
       i) Insert or Update (Merge)
      ii) Insert Only
      iii) Update Only
      iv)  Delete
     v) Select
3. Poll for New or Changed Records in a Table
4. Execute Custom SQL

Basic and important Questions on SOA Deployment.

1). How to deploy your composite into your SOA server?

2). How many ways we can deploy your composite into soa server?

3). How to deploy your composite one environment to another environment?

4). what is ANT Scripts. What it’s contains?

: java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1 [Caused by: ORA-01403: no data found issue in Database Adapter

ERROR:
file:/u01/app/oracle/product/10.1.3/bpel/domains/xl/tmp/.bpel_CreateManifest_1.0_b4e96c3ac640a4edb6c0fd2ca0c8156a.tmp/CreateManifestDetailsInODS.wsdl [ CreateManifestDetailsInODS_ptt::CreateManifestDetailsInODS(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'CreateManifestDetailsInODS' failed due to: Error while converting to a Java struct object.Unable to convert the XSD element PI_MANIFEST_REC whose user defined type is ODS.XX_ODS_MANIFEST_REC. Cause: java.sql.SQLException: ORA-01403: no data foundORA-06512: at line 1
[Caused by: ORA-01403: no data found

ORA-06512: at line 1

]

; nested exception is: 

                    ORABPEL-11802

Error while converting to a Java struct object.

Unable to convert the XSD element PI_MANIFEST_REC whose user defined type is 

ODS.XX_ODS_MANIFEST_REC. Cause: java.sql.SQLException: ORA-01403:

 no data found ORA-06512: at line 1

 [Caused by: ORA-01403: no data found

ORA-06512: at line 1

]

 Solution:

 I have I tried below to resolve the issue.

 1. One thing surprised me that the same code working in other environments 

     but not working only one environment i.e SIT.

 2. Initially I thought some thing going wrong in package..Record structure…

    that may be different from other environments but …I have verified package …

    after analyzing code I found that is not the reason for this error…

    package looks fine..

3. I have created one DB adapter against SIT DB and deployed it works fine…

   But this is not my final goal my old code should work in SIT also because this 

   is working in all environments and I should not develop code 

   for each environment one version.

4. Later I compared XSDs of both SIT and others I found DB user is the problem…

 For example XX_ODS_MANIFEST_REC is the record type in DB.

 ODS.XX_ODS_MANIFEST_REC àin BPEL XSD

 But the SIT user ID is some thing like SITODS so XSD should have 

SITODS.XX_ODS_MANIFEST_REC but current XSD have only 

ODS.XX_ODS_MANIFEST_REC due to that we are facing above error.

5. I have changed XSD and deployed it works fine …J

What are important activities to develop BPEL?

BPEL Provide end to end business process by using BPEL activities Like
1)    Assign activity
2)    Switch activity
3)    Receive activity
4)    Reply activity
5)    Flow activity
6)    FlowN activity
7)    Invoke activity    
8)    Pick activity
9)    Transform     
10)    Scope activity 
11)    Email activity   
12)    Throw activity
13)    Wait activity   
14)    While activity 

What are Oracle Fusion Middleware Components?

Following are the oracle fusion middleware components:

·       Oracle WebLogic Server

·       Oracle Metadata Repository

·       Oracle Identity Management

·       Oracle WebCenter

·       Oracle Business Intelligence

·       Oracle SOA Suite

·       Oracle Fusion Middleware Application Components

What can be represented with XML?

      1. Textual information, such as scripts

2. Simple, flat-file, databases

3. Any information that needs to be transferred across applications and platforms.

What is XML?

1. XML—Extensible Markup Language—is an open, standard, format for transporting data.

2. It resembles HTML, with a difference:  You define your own tags to describe your data

3. XML is not so much a language, but a means of defining our own markup languages for specific applications.

What are Web Services Key Enablers?

Web Services Key Enablers

•         XML

–         Web language for facilitating

•         Data exchange between computers

•         Providing information for human consumption

•         WSDL

–         Specifies an XML framework for describing a web service

•         SOAP

–         Remote Procedure Call

–         Message Passing

•         UDDI

–         Contains the web services

What are Sensors in soa?

Sensors Used to monitor specific BPEL activities, variables, faults during run time.

   Kinds of sensors:

–         Activity sensors

–         Variable sensors

–         Fault sensors

What are different Adapters in SOA?

Enable you to integrate BPEL processes with file systems, FTP servers, database tables, database Queues, oracle applications etc.

   Kinds of Adapters:

–         File

–         FTP

–         Database

–         AQ

–         Oracle Applications

–         JMS

–         MQ

What are Key Benefits of SOA?

1. Lower integration, development and maintenance costs

2. Reusability

3. Better security

4. Better scalability

     5. Higher Availability

What is a Service ?

1. A unit of work done by a service provider

          2. Services encapsulate reusable business functionality

          3. Could be built in any technology

4.      A service can be dynamically located and invoked

What is SOA ?

–

I can say in simple words as below:

1. Designed to achieve loose coupling among all the involved components / applications

2. Provides greater flexibility in development, integration and management of applications

3. NOT a language ---A technology independent architectural style

Component development process.

I have listed here few points from requirement analysis to release into prod as per my experience... :)

 Once the requirement analysis has been finished, we will design technical design document as per business requirement.

Then sent this document to TL or PM for approval purpose. After getting approval from the respective person then we will start implementation process with maintenance of all proper documents like technical design document, test case document and prepare code pack.

This code pack will sent to TL or PM for code reviewing purpose.

If any modification is required, developer need to change the code accordingly then sent it to review purpose again.

If all is fine code will be placed in version controlling system (SVN, CVS, etc).

The code will be released into any one of the test environment as per agreement with client and it will handover to test team,

If any defects have been found in testing time, the component will be assigned to

Development team for modification purpose and will modified accordingly.

After fixing the defects it will sent to review purpose and will sent to release team again.

Release/Deployment team will move the components to different Test environments.

Finally code will be deployed to Production instance.

How to check ESB Activity Current Time Stamp?

To check whether the ESB instances are getting creating with current time stamp or not we have to follow the following steps.

i)The ESB_ACTIVITY Table is the standard ESB in ORA_ESB Schema.

ii)Use the below query to get time stamp value.

   select max(timestamp) from esb_activity.

iii)Get the output of this query and divide it by 1000 and use the following link to get the latest time at which the table ESB_Activity is updated. If this doesn't show current date, chances are there that the timestamp is wrongly updated in the table.

iii)http://www.onlineconversion.com/unix_time.htm

Example:

1)select max(timestamp) from esb_activity.

Output:1284378681279

2)Devide it by 1000.

  1284378681.279

3)Open http://www.onlineconversion.com/unix_time.htm

and copy the above value in UNIX TimeStamp: text box and submit it.

We will get Mon, 13 Sep 2010 11:51:21 GMT

4)Then login into ESB console and Click on instances tab and check whether instances are creating with current time stamp or not.

What are deployment procedures in soa?

Hi All,

I have given below as per my experience.. :)

1.       There are various deployment process are available in SOA like deploying through Application Server, SAR, ANT scripts.But Mostly we use ANT Scripts in real-time environments.

2.       Once the component development, reviews and unit testing completed that will be sent to release management to release the code into any one of the test environment.

3.       The developed code packs will be uploaded into version any one of the version control system.

4.       The release management/deployment team downloads the codes form version control system.

5.       Move the codes to appropriate server location where the ant configurations have done.

6.       After moving the code deployment team promotes the code, compile the code and deploy the code by using ANT Scripts.

7.       After deployment the deployment team check for WSDL URL access and end point URLs etc..

8.       After successful deployment the code deployed environment will be handover to respective team.

What is Basic difference between BPEL and ESB?

1). ESB is good for routing message to multiple destinations. It is also good for doing transformations that have little to no business rules.

2).BPEL is used for bringing together multiple services.  There is much more functionality and allows implementation of complex business logic.

3).Exception handling can be done in BPEL.

4). ESB does not have the sensors which can be used to monitor the activities that can send actions to BAM or DB/JMS.

5).BPEL can use Business Rules, Human Task and Notifications.

6). BPEL primarily used for Orchestration, Data enrichment and also for Human interactions where as ESB is used for Store and forward transport data. 

Whats is basic difference between SOA10g and SOA11g.?

1). Basically all the soa components like BPEL,ESB(Called mediator in 11g) and OWSM are brought into one place in 11g using SCA Composite.

2).The major difference b/w 10g and 11g would be the application server container 10g by default runs on OC4J While 11g runs on web logic server.

3). in 10g every BPEL is a separate project, But in 11g several components can make one project as sca.

4). in 10g consoles are separate for BPEL an ESB, But in 11g EM contains all.

5).In 10g we have to deploy each project separately, but in 11g we can deploy SCA which contains all.

6). in 10g BAM and Business Rules are outside the soa suite, But in 11g they are in soa suite.