OIC

 Oracle Integration Cloud

Topics:  OIC Couse Content

OCI/OIC Security 

 

1. OIC  Instance Creation Enable File Server ,VBCS ,PCS
2. Create OIC User and Assign user to Groups 
3. OIC Roles : Assign user to Application Roles

User Roles

• Service Administrator: Super user who can manage and administer all features.
• Service Developer: A user with this role can develop the artifacts like Integration, Processes, etc.
• Service Monitor: A user with this role will be able to monitor the integrations, processes etc.
• Service Deployer: This role is not specific to the Integration feature.
• Service User: A user with this role can view staged and published artifacts.
• Service Invoker: A user assigned to this role can invoke integrations only.
• Service Viewer: A user assigned to this role can view the details of the integration only.
• Service EndUser: A user with this role can view staged and published artifacts.

OIC Monitoring /OIC Support Project -Roles 

SMBC Bank --Monitoring

1. Root cause analysis and Bug fix to the integration fails (Email notifications,Logs )
2. Co-ordination with functional team with respect to data issues after data fix coordinate with TWS team (Job scheduler tool) to rerun the integration .
3. Objects like Create Accounting ,GL Journal Import ,

  Introduction to OIC

1. Get UCM File Content using Webservice
2. Create User and Assign Roles -Automation  using Rest 
3. Schedule OIC integration Using ESS Job/BIP Report
4.  How to overcome BIP Report Payload limitation for data larger than 10 MBIP
5.  Connection Types Invoke and Trigger

6. Difference between synchronous and asynchronous in oic

OIC Inbound Integrations

1. INT.198 TDH Receipts from CEVA to Oracle ERP Cloud --FBDI Approach
2. TDH INT072- Greatplains HHS GL Extract to Oracle ERP Cloud --FBDI Approach
3. Sales Order Inbound Integration 

OutBound Integrations

1. OIC Integration : Supplier : Supplier Interface from Cloud to EBS : PLSQL Concurrent Program

       Code Files 

          1) Supplier Master Data Modified as on 20250120.sql

          2) OBJECT NAME: XXHIL_EBS_SOA_ADAPTER_PKG (Invoke SOA REST/SOAP web-service)

          3) OBJECT NAME: XXHIL_SUPPLIER_INT_PKG --This package will be used to interface supplier from cloud to EBS. Program - XXHIL Import Supplier Cloud (XXHIL_IMPORT_SUPP_CLOUD) 

1. HIL Supplier Registration and Integrations 

 

 

    Connections 

Sr No	Adaptor	Object	Connection Config	Detailed Integration
1	File		View	View
2	FTP/sFTP		View	View
3	REST		View	View
4	SOAP		View	View
5	Oracle ERP Cloud		View	View
6	Oracle HCM Cloud		View	View
7	Oracle E-Business Suite		View	View
8	ATP	BIP TO ATP Through OIC	View	View
9	ADW		View	View
10	DBaaS		View	View
11	Salesforce (SFDC)	Salesforce to ERP Cloud Automation Service	View	View
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
67
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98

Instance