Oracle Integrations

 

Oracle Integration Cloud

Topic Details

Integrations

 

1. Introduction to OIC.

Click Here

2. Integration Designer Options in OIC

Click Here

3. SOAP Basics

Click Here

4. REST API Basics

Click Here

5. OCI Overview OIC instance and User creation

Click Here

6. Build first REST API in OIC

Click Here

7. Build first SOAP Service in OIC

Click Here

8. Integration Activation Options, Invoke.

Click Here

9. Build File Transfer Service in OIC

Click Here

10. Inbound Integration design considerations

Click Here

11. Build Journal Import service in OIC and test it

Click Here

12. Fault Handling in OIC.

Click Here

13. Purchase Order API in OIC.

Click Here

14. FBDI Automation Service Design.

Click Here

15. Build FBDI main service in OIC

Click Here

16. Build FBDI call back service in OIC

Click Here

17. FBDI Stage file options in OIC

Click Here

18. User ATP DB in FBDI service

Click Here

19. Publish subscribe to OIC service

Click Here

20. Publish Subscribe vs App Driven

Click Here

21. Salesforce to ERP service

Click Here

22. HCM Data loader in OIC

Click Here

23. Outbound flow in OIC

Click Here

24. BIP report other usages

Click Here

25. HCM Extract Automation Service.

Click Here

26. HCM Atom Feed Service

Click Here

27. Saas to On-premise

Click Here

28. Migration, versioning and cloning of Integration

Click Here

VBCS

 

29. VBCS HR WebApp

Click Here

30. VBCS lifecycle migration and versioning

Click Here

31. VBCS use REST API's as source data

Click Here

32. VBCS AR Invoice WebApp

 

PCS

 

33. PCS travel approval process

Click Here

34. PCS AR Invoice Approval process

Click Here

35. ICS AR Invoice API for E2E flow, E2E flow link, E2E solution test

Click Here

36. PCS Decision Model Process

Click Here

37. PCS Dynamic and Mix Match process, VBCS Mobile App.

Click Here

Comments

Post a Comment

Popular posts from this blog

Oracle SQL

SQL Course Content Topic_Details  1. DB,DBMS,RDBMS,ORDMBS & DB development lifecycle Click Here 2. About Oracle Click Here 3. Client/Server Click Here 4. About SQL Click Here 5. Data, data definitions, schema, and SQL Developer tool and DB install process. Click Here 6. Creating a User/Schema/Account in Oracle DB. Click Here 7. Data types in Oracle. Click Here 8. Creating,inserting a Table in Oracle DB. Click Here 9. Operators in Oracle DB. Click Here 10. Displaying data from Oracle DB. Click Here 12. Where Clause Click Here 13. In,between,Like,Is Operators Click Here 14. Alias, All_users,User tables. Click Here 15.Order by, Distinct,fetch clauses ...
Read more

SubQueries

Single Row_SubQuery -------------------- Single-Row Sub-Queries Returns one value SELECT <columns> FROM <table_name> WHERE <col_name> <OP> (SELECT STMNT); > , >=, <, <=, =. <> A single-row subquery in Oracle SQL is a subquery (a query nested inside another query) that returns only one row. The main/outer query uses the inner query result as its conditions If single row sub-query returns more than one row then you will get an error ORA-01422: exact fetch returns more than requested number of rows) It can be used in Select, Where, Having clauses Single Row_SubQuery -------------------- --1. Find who is getting highest salary in the employee table? select max(sal) from emp; select *from emp where sal=(select max(sal) from emp); select max(salary) from employees; select *from employees where salary=(select max(salary) from employees); --2.Find second maximum salary emp? select *from emp where sal=( select max(sal) from emp where sal!=(select max(sa...
Read more

With Clause

 WITH Clause  ====================================== What? With Clause is a Sub-Query factoring or (Common Table Expressions-CTEs) This features is introduced in Oracle 9i.Using this feature: We assign query result set to a temporary tables. We can access data from temporary tables in main Select clause as many times we require with out repeating the sub-queries. When? Usage of (2,3 level-Nested Queries) can  be minimized or avoided when using With Clause. If we use sub-queries up to 1 level then performance may be good but when we use 2 level or 3 level sub-queries then there may chance of performance issues when we try to fetch large large volume of data. How to implement CTEs ====================== SELECT deptno,        Sum(sal) total_sal FROM   emp GROUP  BY deptno; --fetch sum of sal for each dept. SELECT Avg(total_sal) FROM  (SELECT deptno,               Sum(sal) total_sal     ...
Read more