Based on the below projects:
- VIN: the SSN for the vehicle
- Luhn Checker web service: how to validate a credit card
- US ZIP codes web service with MySQL & GeoNames
- SOA and Gmail [the same details can be used for Yahoo]
The DB table sql are below:
WLS Users
Data Sources + DBAdapter details
BPM
Start
SCA: External References
Below is the DBAdapter that will write/save the info in a specific DB table.
- eis/DB/HR_ORCL
SCA: Components
Below is the BPEL component.
Use the below pictures as demo only since I had issues once the project was deployed. The real details I used are below [as text only]:
- round(oraext:square-root(number($Invoke_VIN_OUTPUT.payload/DeliveryCharges) * number($inputVariable.payload/salary) * number(12)) div number(12))
Below is the BPMN component.
Below steps cover the new Business Objects [type] + Data Objects [variable] we will need
The below steps cover the Users
The below steps cover the flow
The below steps cove the service activity
The below steps cover the Data Associations
The below details cover the Human Tasks
The below details cover the Gateways
The below steps cover the Email activity. For now a generic email will be used. In the future the Client _In email value should be used.
The below steps cover the Human Task UI steps
SCA: Exposed Services as DBAdapter
The below steps cover the "Exposed Services" alternative to the current SOAP. A DB will be used.
- eis/DB/HR_ORCL
SCA Deployment + UI ADF projects
To handle the future tasks, make sure you change the URL:
