forget triggers and custom code - use oracle business...
TRANSCRIPT
![Page 1: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/1.jpg)
Forget triggers and custom code - use Oracle Business Events with BPEL
Hilal KhanInnowave Technology
![Page 2: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/2.jpg)
Agenda
• About Innowave• Oracle Business Events• Why Use Business Events?• Triggers Vs Business Events• Oracle Applications Adapter• Pre-requisites• Building an Interface - Demo• Tips and Techniques• Q&A
![Page 3: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/3.jpg)
About Innowave• Technology Consulting Firm founded in 2005• Provide unique, innovative solutions using Oracle
Applications and Technology• Integration Experts: Fusion Middleware, SOA Suite,
BPEL & Web services• Implement, upgrade, and enhance Oracle E-Business
Suite, JD Edwards, PeopleSoft, and Siebel Applications and related technologies
• Extensive experience and expertise managing global and local implementations across various industry verticals.
• Provide clients with proven methodologies, tools, and templates specifically tailored to their requirements.
![Page 4: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/4.jpg)
Oracle Business Events
![Page 5: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/5.jpg)
Oracle Business Events System
• A service delivered with Oracle Workflow.• Leverages Oracle Advanced Queuing (AQ).• Ability to extend and configure business logic.• Asynchronous messaging without modifying
standard application Code.• Publish – Subscribe mechanism.
![Page 6: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/6.jpg)
Oracle Business Events System
• Login as Administrator
![Page 7: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/7.jpg)
Oracle Business Events System
• BPEL Subscription.
![Page 8: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/8.jpg)
Why Use Business Events?
![Page 9: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/9.jpg)
Why Business Events?
• Robustness– Guaranteed Delivery
• Scalability– Supports multiple Subscriptions
• Zero Coding– Out of the box functionality
![Page 10: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/10.jpg)
Why Business Events?
• Easier to manage– No Maintenance
• Oracle recommended– No Upgrade issues– No Customizations– Seeded Functionality
![Page 11: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/11.jpg)
Triggers Vs
Business Events
![Page 12: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/12.jpg)
Triggers Vs Business Events
Triggers• Requires Coding • Requires PL/SQL expertise• Involves Maintenance
Business Events• Zero Coding • Minimal Setups• Minimal Maintenance
![Page 13: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/13.jpg)
BPEL Oracle Applications Adapter
![Page 14: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/14.jpg)
Oracle Applications Adapter
• Available out of the box• Supports Business Events• Also supports CPs, APIs …..• Wizard driven configuration• Declarative setup
![Page 15: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/15.jpg)
Oracle Applications Adapter
• Wizard driven configuration
![Page 16: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/16.jpg)
Oracle Applications Adapter
• Wizard driven configuration
![Page 17: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/17.jpg)
Oracle Applications Adapter
• Wizard driven configuration
![Page 18: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/18.jpg)
Oracle Applications Adapter
• Wizard driven configuration
![Page 19: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/19.jpg)
Oracle Applications Adapter
• Wizard driven configuration
![Page 20: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/20.jpg)
Oracle Applications Adapter
• Wizard driven configuration
![Page 21: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/21.jpg)
Oracle Applications Adapter
• Wizard driven configuration
![Page 22: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/22.jpg)
Oracle Applications Adapter
• Wizard driven configuration
![Page 23: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/23.jpg)
Oracle Applications Adapter
• Wizard driven configuration
![Page 24: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/24.jpg)
Pre-requisites
![Page 25: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/25.jpg)
Pre-requisites• System Profile Option – EDR:E-records and E-Signatures
![Page 26: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/26.jpg)
Pre-requisites• Enabling the Business Event
![Page 27: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/27.jpg)
DEMO
![Page 28: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/28.jpg)
Building an Interface
• Inventory Item Synchronization – Build a BPEL Process– Deploy the BPEL Process– Create an Item in EBS– Interface Item information
![Page 29: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/29.jpg)
Building an Interface• Build an Empty BPEL Process
![Page 30: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/30.jpg)
Building an Interface• Configure the Oracle Applications Adapter
![Page 31: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/31.jpg)
Building an Interface• Receive the Business Event
![Page 32: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/32.jpg)
Building an Interface• Gather Item Information
![Page 33: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/33.jpg)
Building an Interface• Assign Item ID to Query
![Page 34: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/34.jpg)
Building an Interface• Configure the File Adapter
![Page 35: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/35.jpg)
Building an Interface• Invoke the File Adapter
![Page 36: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/36.jpg)
Building an Interface• Transform Item Information to Text File
![Page 37: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/37.jpg)
Building an Interface
• Deploy the BPEL Process• Create an Item in EBS• Find the generated .TXT file in the Output folder
![Page 38: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/38.jpg)
Tips and Techniques
![Page 39: Forget triggers and custom code - use Oracle Business ...idealpenngroup.tripod.com/sitebuildercontent/OAUG2008/Collaborate20Collaborate07/pdfs/...Forget triggers and custom code -](https://reader030.vdocuments.us/reader030/viewer/2022040519/5e77854428980844aa65cf70/html5/thumbnails/39.jpg)
Tips and Techniques
• Oracle On-Demand scenario• Reposting Mechanism• Exception Handing