This is simple. If the Odi 12c is installed on linux system, then open the terminal and navigate to odi/studio path and run ./odi.sh script.
Steps with screenshots:
This is simple. If the Odi 12c is installed on linux system, then open the terminal and navigate to odi/studio path and run ./odi.sh script.
Steps with screenshots:
Usecase: Here, we will create an object storage rest connection and using that connection, we will create an app driven integration, configure rest call to object storage and get the file from object storage.
Implementation Steps:
Step1: Create Rest connection.
Oracle home >> Integrations >> Connections >> Create >> Rest
Provide rest API base URL
How to create a OCI object storage bucket, how to get Tenancy OCID, User OCID, API private RSA key and finger print and Namespace, everything mentioned in the previous blog. Pleae check below link.
https://soalicious.blogspot.com/2022/08/oic-how-to-use-oci-object-storage-from.html
UseCase: Here, we will create a OCI object storage bucket. From OIC, read a file and put that file to bucket using Rest connection.
Step 1 : Create a bucket in OCI object storage
In the Oracle console >> Storage >> object storage & Archive storage >> select the required compartment >> create bucket
Step 2 : Create a Object storage Rest connection
To create a Rest connection , we need to collect the following information:
Connection type : REST API Base URL
Connection URL : https://objectstorage.<region>.oraclecloud.com
My case, region is: us-ashburn-1
Securtity: OCI Signature Version 1
Tenancy OCID and Object storage Namespace: get the Tenancy OCID from the OCI console on the Tenancy Details page.
Search Tenancy in the search box
Here we also got the Object storage namespace.
User OCID : get the user's OCID in the console on the User details page.
Profile >> User Settings
Private Key & FingerPrint:
Profile >> User settings >> API Keys >> Add API Key >> download private key >> add >> note the fingerprint.
Oracle home >> Integrations >> Connections >> Create >> Rest
Step 3: Create the Integration
Integration flow:
Save, Add Tracking and activate and test
See the below file uploaded to object storage bucket.
Note: Private key downloaded from the Oracle Cloud Infrastructure Console are in PKCS8 format. The OCI Signature version 1 security policy available with the Rest adapter only supports reading of the private key in RSA format(PKCS1) format.
If you receive the following error, you must convert the private key from PKCS8 to RSA(PKC1) format:
oracle.cloud.connector.impl.rest.security.signature.signatureException: java.lang.ClassCastException: org.bouncycastle.asn1.pkcs.PrivateKeyInfo can not be cast to org.bouncycastle.openssl.PEMKeyPair.
Convert the private key with the following command:
openssl rsa -in private_key_in_pkcs8_format.pem -out new_converted_file.pem
We can also convert it using online availavle site like below:
https://8gwifi.org/pemconvert.jsp
Reference:
OIC interview Q & A:
1. FBDI approach with an example
https://soalicious.blogspot.com/2022/02/oic-erp-supplier-bulk-import-and.html
2. OIC FTP vs OIC File adapter
Answer: https://soalicious.blogspot.com/2021/05/oic-file-adapter-vs-ftp-adapter.html
3. ERP events callback or subscription.
Answer:https://soalicious.blogspot.com/2023/03/erp-register-csf-key.html?m=1
4. Gen1 vs gen2 OIC pack
https://soalicious.blogspot.com/2022/03/oic-gen-1-vs-gen-2-benefits-of-oic.html
5. OIC Agents
https://soalicious.blogspot.com/2020/10/oic-connectivity-agent.html
https://soalicious.blogspot.com/2020/11/oic-connectivity-agent-part-2.html
https://soalicious.blogspot.com/2022/05/oic-install-connectivity-agent-in.html
6. How to handle large file in OIC
https://soalicious.blogspot.com/2021/05/oic-how-to-handle-more-than-10-mb-file.html
7. OIC error handling:
https://soalicious.blogspot.com/2021/12/oic-ootb-error-handling-in-easy-steps.html
8. OIC Integration pattern/ Styles
https://soalicious.blogspot.com/2019/11/oracle-cloud-integrationoic-introduction.html
9. OIC migration from one instance to higher one.
https://soalicious.blogspot.com/2022/02/oic-migration-of-integration-from-one.html
10. What issues you observed in OIC ERP.
https://soalicious.blogspot.com/2021/03/oic-synchronous-integrations.html
11. Can file adapter and ftp adapter support high availability mode using connectivity agent?
https://soalicious.blogspot.com/2023/07/oic-can-file-server-and-ftp-server.html
12. Maximum duration for integration flows | time out time for OIC services | Service limit for Scheduled orchestration or Async or Sync service
https://soalicious.blogspot.com/2023/06/oic-maximum-duration-for-integration.html
13. Why to avoid creating too many scheduled integrations
https://soalicious.blogspot.com/2021/07/oic-why-to-avoid-creating-too-many.html
14. How many different scheduled integrations can run in parallel in Oracle Integration | Decoupled scheduler and Business Logic pattern.
https://soalicious.blogspot.com/2023/09/oic.html
15. Does OIC Support Asynchronous request response service?
- It is permissible to call asynchronous fire and forget(one way).
- Oracle integrations presently does not support modelling an asynchronous request response service. However, all scheduled orchestration patterns implement an asynchronous request response internally, As a result, asyn integration through scheduled orchestration is an anti pattern
16. Why we should use OIC instead SOACS?
https://soalicious.blogspot.com/2024/05/oic-why-should-we-choose-oic-over-soacs.html
17. Version controlling in OIC?
18. How to do monitoring in OIC?
19. How will you implement multiple operation based calculator service in OIC? How will you implement calculator service in OIC?
For Soap:
https://soalicious.blogspot.com/2022/03/oic-managing-multiple-operations-in-oic.html
For rest with multiple verbs:
https://soalicious.blogspot.com/2022/11/oic-use-rest-adapter-with-multiple.html
20. Have you used enrichment service in OIC?
21. What are the OIC integrations you have implemented in your project?
22. How to embed barcode or image in import to erp? How to embed image or barcode in email?
23. We have a Project requirement that we have to schedule a service to load data and also need to do a real time data feed as needed. How you will implement this?
Answer: first create an app driven integration and expose as rest / soap so that client can send data in real time. Second, create a schedule integration to call that app driven integration to run in a scheduled time manner.
24. Rest api vs Erp cloud adapter in terms of FBDI import.
25. Which OIC adaptets you have worked on?
Answer: Ftp, file, DB, ATP, Rest, SOAP, ERP, HCM
26. BIP vs OTBI report
https://soalicious.blogspot.com/2024/05/erp-hcm-bip-vs-otbi.html
27. FAH vs GL when to use for import?
https://soalicious.blogspot.com/2023/12/oic-when-to-use-fah-vs-gl-import.html
28. Can we read excel file in OIC? If no, how we can achieve it?
Answer: OIC does not support excel read. If we really need to read it then follow the below steps:
Create a serverless OCI function with python/Java logic to convert excel to csv >> create a bucket in oci object storage >> create a rest connection to put excel file from oic to Object storage >> do another call to function to convert and save to OS >> do another OS call to get the converted CSV file and use.
29. How to change the email notification from part?
https://soalicious.blogspot.com/2023/06/oic-how-to-change-from-address-for.html
30. What are the diffrent stage action functions?
Answers: we can do the following:
31. BIP report huge size, How to handle this situation?
32. Suppose you are invoking a BIP report and received null or empty file how to handle this so that it should not flow to Downstream applications?
33. There are large number of schedule orchestrated integrations run at the same time. What to do to avoid backlogging??
https://soalicious.blogspot.com/2024/06/oic-there-are-huge-number-of-scheduled.html
34. Have you used PLSQL in xslt or in complex logic processing?
35. Can we call BIP report from database?
36. What is your current role in the project?
37. Suppose we are getting data from ERP and then storing them in a database table. How to avoid the duplicate data to be stored in the database?
38. Apex reports, Can we use plsql in apex?
39. We have a requitement to digitally sign the email while sending the email notification from OIC. Is there any way we can embed an image in the email notification in OIC?
40. How to get the 2nd or 3rd max salary from an employee table using sql query?
Answer:
Using limit and offset
2nd Maximum Salary
SELECT salary
FROM employee
ORDER BY salary DESC
LIMIT 1 OFFSET 1;
3rd Maximum Salary
SELECT salary
FROM employee
ORDER BY salary DESC
LIMIT 1 OFFSET 2;
Method 1: Using Subqueries
2nd Maximum Salary
SELECT MAX(salary) AS SecondHighestSalary
FROM employee
WHERE salary < (SELECT MAX(salary) FROM employee);
3rd Maximum Salary
SELECT MAX(salary) AS ThirdHighestSalary
FROM employee
WHERE salary < (SELECT MAX(salary)
FROM employee
WHERE salary < (SELECT MAX(salary) FROM employee));
41. Can we convert App driven orchestration to Scheduled orchestration integration?
Answer: directly there is no provision to convert from App driven to Scheduled integrations. But we can convert from scheduled to app driven integrations.
As a workaround , we can create a separate scheduled orchestration integration and can call then the app driven the integration from the scheduled one.
42. How to fetch incremental or delta or daily data using BI report?
43. We need to execute a schedule job in oic that will run only on weekdays excluding public holidays?
44. how you will write BIP extension report?
45. Max number of scopes can be created in an integration?
46. Max number of instances of an integration can be run in parallel?
47. Can we use data from one scope to another scope ? If yes, how?
48. While we call HCM extract flow, whih fields we are passing ?
49. What are the diffrent xslt functions you have worked on OIC?
50. How to generate Sequence number and insert to a database table without using Db sequnce?
51. What are the different fault handling actions avaiable in OIC? And their functions?
52. Suppose you are calling an API for invoice bulk import, how you will track any failure for each invoices?
53. Suppose you have a requirement to approve or disapprove some budget from a VBCS page how you will achieve this?
54. What are different OCI storage types available and their fucntions?
55. Suppose we have 2 duplicate in web portal, from OIC, you need to call the service and check duplicacy. How do you do it?
56. How you will connect hybrid model from OIC?
57. What is max size notification action - attachment support?
Answer: 2 MB
58. How to recover a failed intances in oic?
59. How you handle complex mapping in oic?Why we need tracing:
If we choose the Integration level tracing, we can enbale or disable the tracing at individual integration level following below steps:
Go To Integrations Page >> select actions >> Tracing >> Enable Tracing & Include Payload >> Save
Usecase: Here, we will create a sub integration which will take a request id and check if ESS job status, if its succceeded, it will download the report and move the file to desired mail dl or sftp directory.
HighLevel steps:
Request payload:
{
"RequestId":"",
"directoryAdapter":"",
"sourceFileName":"",
"targetDirectory":""
}
Implementation logic steps:
1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper: File⇾Import⇾Service Bus Resources⇾ Se...