{"id":2063,"date":"2011-05-12T23:17:44","date_gmt":"2011-05-13T04:17:44","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=2063"},"modified":"2015-04-17T13:56:55","modified_gmt":"2015-04-17T18:56:55","slug":"soa-11g-tutorial-po-routing-app","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=2063","title":{"rendered":"SOA 11g Tutorial: PO Routing App"},"content":{"rendered":"
\n

Contents<\/h2>\n
    \n\t
  1. \n\t\tCreate App<\/a>\n\t<\/li>\n\t
  2. \n\t\tAdd Web Service<\/a>\n\t\t
      \n\t\t\t
    1. \n\t\t\t\tCreate WSDL<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
    2. \n\t\tAdd Routing Component<\/a>\n\t<\/li>\n\t
    3. \n\t\tAdd File Adapter<\/a>\n\t<\/li>\n\t
    4. \n\t\tWire Web Service, Mediator and FileAdapter<\/a>\n\t<\/li>\n\t
    5. \n\t\tAdd Transformation Steps<\/a>\n\t\t
        \n\t\t\t
      1. \n\t\t\t\tInput Mapper<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
      2. \n\t\tDeploy<\/a>\n\t<\/li>\n\t
      3. \n\t\tTesting<\/a>\n\t<\/li>\n\t
      4. \n\t\tAdd CreditCardStatus web service (partner link)<\/a>\n\t<\/li>\n\t
      5. \n\t\tAdd BPEL Component<\/a>\n\t<\/li>\n\t
      6. \n\t\tBEPL Approval Process<\/a>\n\t\t
          \n\t\t\t
        1. \n\t\t\t\tAdd Invoke<\/a>\n\t\t\t<\/li>\n\t\t\t
        2. \n\t\t\t\tAdd Assign<\/a>\n\t\t\t<\/li>\n\t\t\t
        3. \n\t\t\t\tAdd Switch<\/a>\n\t\t\t<\/li>\n\t\t\t
        4. \n\t\t\t\tValid Credit Card Branch<\/a>\n\t\t\t<\/li>\n\t\t\t
        5. \n\t\t\t\tInValid Credit Card Branch<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
        6. \n\t\tModify Mediator<\/a>\n\t<\/li>\n\t
        7. \n\t\tReDeploy<\/a>\n\t<\/li>\n\t
        8. \n\t\tTest<\/a>\n\t<\/li>\n<\/ol>\n<\/ol>\n<\/ol>\n<\/div>\n
           <\/div>\n

          This is part of the Oracle SOA11g hands on tutorials<\/a>.<\/p>\n

          Create App<\/h3><\/span>\n

          * File -> New -> General -> Applications -> Generic Application
          \n* On Create Generic Application wizard Step 1, enter
          \nApplication Name: POProcessing
          \nDirectory: C:\\po\\POProcessing
          \nApplicatoin Package Prefix: blank
          \n* On Step 2, enter
          \nProject Name: POProcessing
          \nDirectory: C:\\po\\POProcessing\\POProcessing
          \n* On Step 2, Project Technologies
          \n– Move SOA from left panel to right panel
          \n* On Step 3, select
          \nEmpty Composite
          \n* Click Finish<\/p>\n

          Add Web Service<\/h3><\/span>\n

          * Drag and drop Web Service icon from Component Palette on Exposed Services lane
          \n* On Create Web Service screen, enter
          \nName: receivePO
          \nType: Service
          \n* Click Create WSDL from schema icon (second one to the right of WSDL URL field)<\/p>\n

          Create WSDL<\/h4><\/span>\n

          * On Create WSDL screen, accept
          \nFile Name: receivePO.wsdl
          \nDirectory: C:\\po\\POProcessing\\POProcessing
          \nNamespace: http:\/\/oracle.com\/sca\/soapservice\/POProcessing\/POProcessing\/receivePO
          \nPort Type: execute_ptt
          \nOperation: execute
          \nInterface Type: One-Way Interface<\/p>\n

          Define Input<\/strong>
          \n* click the green plus icon above the Input panel
          \n* On Add Message Part screen, click the browse for schema icon (magnifying glass)
          \n* On Type Choose screen, click the Import Schema File icon (first icon on upper right)
          \n* On Import Schema File screen, enter
          \nCheck: Copy to Project
          \nURL: file:\/C:\/po\/schemas\/po.xsd (or click the magnifying glass and browse to po.xsd file)
          \n– click OK
          \n* On Localize Files screen,
          \n– uncheck maintain original directory structure…
          \n– click OK
          \n* Back on Type Choose screen,
          \n– select PurchaseOrder
          \n– click OK
          \n* Back on Add Message Part screen, enter
          \nPart Name: purchaseOrderPart
          \nURL: xsd\/po.xsd
          \nSchema Element: purchaseOrder
          \n– click OK
          \n* Back on Create WSDL screen, click OK
          \n* Back on Create Web Service screen, click OK<\/p>\n

          Add Routing Component<\/h3><\/span>\n

          * Drag and drop a Mediator from Palette to Components lane, enter
          \nName: routePO
          \nTemplate: Define Interface Later
          \n* Click OK<\/p>\n

          Add File Adapter<\/h3><\/span>\n

          * Drag and drop a File Adapter to External References lane
          \n* Click Next on Step 1
          \n* Step 2, enter
          \n– Service Name: WriteApprovalResults
          \n* Step 3,
          \n– Select “Define from operation and schema<\/em>”
          \n– click Next
          \n* Step 4,
          \n– Select Write File
          \n* Step 5,
          \n– Select Physical path
          \nDirectory for Outgoing Files: c:\\temp\\po
          \nFile naming Convention: order_%SEQ%.txt
          \n* Step 6,
          \n– click magnifying glass icon
          \n* On Type Choose screen, click the Import Schema File icon (first icon on upper right)
          \n* On Import Schema File screen, enter
          \nCheck: Copy to Project
          \nURL: file:\/C:\/po\/schemas\/internalorder.xsd (or click the magnifying glass and browse to internalorder.xsd file)
          \n– click OK
          \n* On Localize Files screen,
          \n– uncheck maintain original directory structure…
          \n– click OK
          \n* Back on Type Choose screen,
          \n– select Order
          \n– click OK
          \n* Back on Step 6, verify:
          \nURL: xsd\/internalorder.xsd
          \nSchema Element: Order
          \n– click Next
          \n* Click Finish<\/p>\n

          Wire Web Service, Mediator and FileAdapter<\/h3><\/span>\n

          * Drag right arrow on upper right of receivePO web service and drop on lower left of routePO.
          \n* Drag right arrow on lower right of routePO and drop on right arrow on upper left of WriteApprovalResults.<\/p>\n

          Add Transformation Steps<\/h3><\/span>\n

          * Double click routePO<\/p>\n

          Input Mapper<\/h4><\/span>\n

          * Click on the transform icon to the right of the “Transform Using” field
          \n* Select Create New Mapper File and click OK
          \n* On the new mapper file,
          \n– drag from left side inp1:PurchaseOrder to right side inp1:Order
          \n* On Auto Map Preferences screen,
          \n– click show Dictionaries button
          \n– click on Add button under Dictionaries panel
          \n– browse to c:\\po\\schemas\\po2internalorders-dictionary.xml
          \n– click OK button (dictionary provides synonyms for words)
          \n* Save and close mapper file<\/p>\n

          * Save all and close routePO.mplan file<\/p>\n

          Deploy<\/h3><\/span>\n

          * Right click POProcessing project
          \n* Select Deploy -> POProcessing
          \n* On Deploy POProcessing screen,
          \n– select Deploy to Application Server
          \n* On Deploy Configuration screen,
          \n– check Overwrite any existing composites with the same revision ID if reploying
          \n– click Next
          \n* One Select Server screen,
          \n– select MyAppServerConnection
          \n– click Next
          \n* Click Finish on Summary screen<\/p>\n

          Testing<\/h3><\/span>\n

          * Login Enterprise Console http:\/\/localhost:7001\/em
          \n* Click Farm_soa_domain -> SOA -> soa-infra -> POProcessing
          \n* Click Test tab
          \n* Under Input Arguments,
          \n– select XML View
          \n– Repace content with that of C:\\po\\input\\po-small-Headsetx1.txt<\/p>\n

          \r\n\r\n    \r\n        \r\n            1111<\/ns1:CustID>\r\n            2121<\/ns1:ID>\r\n            Bluetooth Headset<\/ns1:productName>\r\n            Electronics<\/ns1:itemType>\r\n            49.99<\/ns1:price>\r\n            1<\/ns1:quantity>\r\n            Initial<\/ns1:status>\r\n            Mastercard<\/ns1:ccType>\r\n            8765-8765-8765-8765<\/ns1:ccNumber>\r\n        <\/ns1:PurchaseOrder>\r\n    <\/soap:Body>\r\n<\/soap:Envelope><\/pre>\n
          * Click Test Web Service button
          \n* Check that a new file named order_1.txt is created in c:\\temp\\po directory. Note that this is the directory on the server side. <\/p>\n
          \r\n\r\n   1111<\/inp1:customerId>\r\n   2121<\/inp1:orderId>\r\n   Bluetooth Headset<\/inp1:prodName>\r\n   Electronics<\/inp1:itemType>\r\n   49.99<\/inp1:price>\r\n   1<\/inp1:qty>\r\n   Initial<\/inp1:status>\r\n   \r\n      8765-8765-8765-8765<\/inp1:cardNumber>\r\n      Mastercard<\/inp1:cardType>\r\n   <\/inp1:creditCardInfo>\r\n<\/pre>\n
          Add CreditCardStatus web service (partner link)<\/h3><\/span>\n
          * Drag and drop Web Service icon to External References lane
          \n* On Create Web Service screen, enter
          \nName: getCreditCardStatus
          \n* Click Find existing WSDLs icon to the right of “WSDL URL<\/em>” field
          \n* On SOA Resource Browser screen,
          \n– select Resource Palette from the top drop down box.
          \n– select IDE Connections -> Application Server -> MyAppServerConnection -> SOA -> soa_server1 -> default -> validationForCC[1.0] -> getStatusByCC (ws)
          \nOr enter: http:\/\/locahost:8001\/soa-infra\/services\/default\/validationForCC\/getStatusByCC?WSDL
          \n– Click OK
          \n– Click OK on Create Web Service dialog<\/p>\n
          Add BPEL Component<\/h3><\/span>\n
          * Drag and drop BPEL Process to Components lane
          \n* On Create BPEL Process screen, enter
          \nName: approveLargeOrder
          \nNamespace: http:\/\/xmlns.oracle.com\/POProcessing\/POProcessing\/approveLargeOrder
          \nTemplate: Asynchronous BPEL Process
          \nService Name: approvelargeorder_client
          \nExpose as a SOAP service: Un-checked<\/strong>
          \nInput:
          \n– click on magnifying glass
          \n– select Project Schema Files -> internalorder.xsd -> order
          \n– click OK
          \nOutput:
          \n– click on magnifying glass
          \n– select Project Schema Files -> internalorder.xsd -> order
          \n– click OK
          \n* Click OK
          \n* Wire approveLargeOrder BPEL process to getCreditCardStatus web service by drag and drop a line from the lower right corner of approveLargeOrder to upper left corner of getCreditCardStatus .<\/p>\n
          BEPL Approval Process<\/h3><\/span>\n
          * Open BPEL editor by either
          \n– Double click approveLargeOrder BPEL process icon
          \n– Or right click BPEL process icon and select Edit…<\/p>\n
          Add Invoke<\/h4><\/span>\n
          * Drag and drop Invoke icon right below receiveInput icon
          \n* Drag wire from Invoke icon and connect with getCreditCardStatus partner link.
          \n* On Edit Invoke screen,
          \n– enter
          \nName: invokeCCStatusService
          \n– Click the green plus sign to the right of Variables\/Input and accept defaults
          \n– Click the green plus sign to the right of Variables\/Output and accept defaults
          \n– Click OK<\/p>\n
          Add Assign<\/h4><\/span>\n
          * Drag and drop an Assign icon before <\/strong>invokeCCStatusService
          \n* Double click to bring up the Edit Assign screen
          \n* On General tab:
          \n– Name: assignCCNumber
          \n* Click Copy Rules tab
          \n* Copy one
          \n– Drag from left side
          \nVariables\/Process\/Variables\/inputVariable\/payload\/Order\/creditCardInfo\/cardNumber<\/strong>
          \n– to right side
          \nVariables\/Process\/Variables\/invokeCCStatusService_execute_inputVariable\/creditcardSatusRequestPart\/creditcardStatusRequest\/CCNumber<\/strong>
          \n* Copy two
          \n– Drag from left side
          \nVariables\/Process\/Variables\/inputVariable\/payload\/Order<\/strong>
          \n– to right side
          \nVariables\/Process\/Variables\/outputVariable\/payload\/Order<\/strong>
          \n* Click OK
          \n* Save All<\/p>\n
          Add Switch<\/h4><\/span>\n
          * Drag and drop Switch icon under <\/strong>invokeCCStatusService
          \n* Double click Switch icon to open the Switch dialog.
          \n* On General tab enter
          \n– Name: EvalulateCCStatus
          \nClick OK
          \n* Click condition block and enter
          \nLabel: validCreditCard
          \nCondition:
          \n– Click XPath condition builder, enter condition:<\/p>\n
          bpws:getVariableData('invokeCCStatusService_execute_OutputVariable','creditcardStatusPart','\/ns3:creditcardStatus') = 'VALID'<\/pre>\n
          – Click OK<\/p>\n
          Valid Credit Card Branch<\/h4><\/span>\n
          * Drag and drop Assign icon below condition block
          \n* Double click Assign icon and name it assignApproval on General tab
          \n* Click Copy Rules tab
          \n* Drag the Expression icon (first icon on upper right) and drop onto
          \nVariables\/Process\/Variables\/outputVariable\/payload\/Order\/status<\/strong>
          \n* Enter into the Expression panel
          \n‘approved’
          \n* Click OK
          \n* Click OK on Edit Assign screen<\/p>\n
          InValid Credit Card Branch<\/h4><\/span>\n
          * Repeat previous Assign steps for the otherwise branch but
          \n– Name: assignInvalidCC
          \n– Use value
          \n‘invalidCreditCard’ (with single quotes)
          \n* Save All<\/p>\n
          Modify Mediator<\/h3><\/span>\n
          * Back in composite.xml file
          \n* Wire routePO mediator to approveLargeOrder BPEL process
          \n– Drag a wire from lower right of routePO icon to upper right of approveLargeOrder icon.
          \n* Open routePO.mplan file by double clicking routePO icon
          \n* Enter filter criteria for WriteApprovalResults::Write operation<\/p>\n
          \r\n($in.purchaseOrderPart\/inp1:PurchaseOrder\/inp1:price  * $in.purchaseOrderPart\/inp1:PurchaseOrder\/inp1:quantity) < 1000\r\n<\/pre>\n
          * Enter filter criteria for approveLargeOrder operation<\/p>\n
          \r\n($in.purchaseOrderPart\/inp1:PurchaseOrder\/inp1:price * $in.purchaseOrderPart\/inp1:PurchaseOrder\/inp1:quantity) >= 1000\r\n<\/pre>\n
          * Create transformation map for approveLargeorder
          \n- click on transformation icon
          \n- select Create new Mapper File and accept default file name
          \n- click OK
          \n- drag PurchaseOrder to Order
          \n- click OK on automapping
          \n- drag inp1:ccType to inp1:cardType
          \n- drag inp1:ccNumber to inp1:cardNumber
          \n* Setup Callback Target Operation
          \n- Click cog icon to the right of Callback
          \n- Click Service as target type
          \n- Select POProcessing | References | WriteApprovalResults | Write
          \n- Click OK
          \n* Create transformation map for Callback
          \n- repeat previous steps but drag from Order to Order<\/p>\n
          ReDeploy<\/h3><\/span>\n
          Test<\/h3><\/span>\n
          * Valid credit card input message:<\/p>\n
          \r\n\r\n    \r\n        \r\n            1111<\/ns1:CustID>\r\n            2222<\/ns1:ID>\r\n            iPod shuffle<\/ns1:productName>\r\n            Electronics<\/ns1:itemType>\r\n            145<\/ns1:price>\r\n            30<\/ns1:quantity>\r\n            Initial<\/ns1:status>\r\n            Mastercard<\/ns1:ccType>\r\n            1234-1234-1234-1234<\/ns1:ccNumber>\r\n        <\/ns1:PurchaseOrder>\r\n    <\/soap:Body>\r\n<\/soap:Envelope>\r\n<\/pre>\n
          * order_.txt file (status has changed to approved)<\/p>\n
          \r\n\r\n   1111<\/ns1:customerId>\r\n   2222<\/ns1:orderId>\r\n   iPod shuffle<\/ns1:prodName>\r\n   Electronics<\/ns1:itemType>\r\n   145<\/ns1:price>\r\n   30<\/ns1:qty>\r\n   approved<\/ns1:status>\r\n   \r\n      1234-1234-1234-1234<\/ns1:cardNumber>\r\n      Mastercard<\/ns1:cardType>\r\n   <\/ns1:creditCardInfo>\r\n<\/ns1:Order>\r\n<\/pre>\n
          * Invalid credit card input message:
          \n- change credit card number to 4321-4321-4321-4321 to simulate invalid credit card<\/p>\n
          \r\n\r\n    \r\n        \r\n            1111<\/ns1:CustID>\r\n            2222<\/ns1:ID>\r\n            iPod shuffle<\/ns1:productName>\r\n            Electronics<\/ns1:itemType>\r\n            145<\/ns1:price>\r\n            30<\/ns1:quantity>\r\n            Initial<\/ns1:status>\r\n            Mastercard<\/ns1:ccType>\r\n            4321-4321-4321-4321<\/ns1:ccNumber>\r\n        <\/ns1:PurchaseOrder>\r\n    <\/soap:Body>\r\n<\/soap:Envelope>\r\n<\/pre>\n
          * order_.txt file (status is now invalidCreditCard)<\/p>\n
          \r\n\r\n   1111<\/ns1:customerId>\r\n   2222<\/ns1:orderId>\r\n   iPod shuffle<\/ns1:prodName>\r\n   Electronics<\/ns1:itemType>\r\n   145<\/ns1:price>\r\n   30<\/ns1:qty>\r\n   invalidCreditCard<\/ns1:status>\r\n   \r\n      4321-4321-4321-4321<\/ns1:cardNumber>\r\n      Mastercard<\/ns1:cardType>\r\n   <\/ns1:creditCardInfo>\r\n<\/ns1:Order>\r\n<\/pre>\n
          * Click Launch Message Flow Trace to see process message flow<\/p>\n","protected":false},"excerpt":{"rendered":"
          This is part of the Oracle SOA11g hands on tutorials. Create App * File -> New -> General -> Applications -> Generic Application * On Create Generic Application wizard Step 1, enter Application Name: POProcessing Directory: C:\\po\\POProcessing Applicatoin Package Prefix: … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[100],"tags":[],"class_list":["post-2063","post","type-post","status-publish","format-standard","hentry","category-soa11g"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-xh","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2063","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2063"}],"version-history":[{"count":17,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2063\/revisions"}],"predecessor-version":[{"id":10659,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2063\/revisions\/10659"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2063"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2063"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}