OIC Topics-Use cases
Learn through Real Time Use Cases
Introduction
Adapters and Connections
Integration Patterns
Rest and SOAP Services:
- Sample REST service — Trigger and Invoke
- Sample SOAP service — Trigger and Invoke
File/SFTP ::
3. Read Files from SFTP server in chunks
4. Split CSV based on a column
5. Create Fixed length file in OIC
6. Internal or Embedded SFTP (File Server)
7. Process different types of files: >100MB, >1GB
FBDI ::
8. Load Suppliers data in Oracle Fusion ERP using FBDI.
9. Configure Callback
Events ::
10. Publish to OIC, Subscribe to OIC
11. Business Events from ERP. Filter the events from ERP.
ERP Adapter ::
12. Outbound and inbound
Database ::
13. Connect ATP DB with/without wallet
14. Call DB Procedure asynchronously from OIC
15. PL SQL procedure call in batches.
16. Read millions of records from DB
17. Bulk Insert into a table
18. Insert into multiple tables having relationship
BIP ::
19. BIP Report execution with/without parameters.
20. Retrieve BIP report and place File in OCI Object Storage.
21. Overcome BIP report timeout.
Get Manikanta kumar K’s stories in your inbox
Join Medium for free to get updates from this writer.
22. Bursting of BIP report
REST ::
23. Push records in batches to target service in Oracle Integration
25. Accept attachments in REST API — Inbound and Outbound
Error Handling and REST:
26. Build Retry logic using scope, Global Fault Handlers, recursive REST calls.
VBCS ::
27. Basics of VBCS
28. Invoke VB Business objects in OIC
OCI features in OIC ::
29. Invoke OCI Functions from OIC
30. Data Science: Extract data from images using OCI vision service in Oracle Integration
31. Encrypt/Decrypt data using OCI Vault
32. Publish/Subscribe OCI Streaming messages
33. Invoke ERP ESS job in OIC
Connectivity Agent ::
34. Connectivity Agent setup, High Availability
B2B ::
35. Schmas, Documents
36. Trading Partners, Host Profile
37. Stand-alone B2B Mode with one use case.
38. Trading Partner mode with one use case.
Security::
39. OAuth Two Legged Authentication
40. Private End Point
OIC Gen2 — Gen3 ::
41. OIC Gen2 Vs Gen3
42. Projects in Gen3.
Observability ::
43. Monitoring & Tracking Instances
44. Feature Flag in OIC
45. Recipes and Accelerators
46. Some OIC New Features









