OIC - Create an API Gateway to call Oracle Integration REST service

Usecase: we will create an API gateway in OCI console and call rest OIC service.

Highlevel steps:

1. Create a rest OIC service which to be called from API gateway.
2. Create a VCN(it will create two subnets : public and private)
3. Create a security list(to get access) and add to the public subnet of the VCN
4. Create an API Gateway
5. Add deployment of the rest service to the gateway
6. Take the API gatway deployem endpoint url and test in Postman

Detailed steps:

Login to OCI console >> networking >> Virtual Cloud Networks

Select compartment >> start VCN Wizard

Start VCN wizard

Provide VCN name and compartment.

Click create.

VCN created. Click View VCN.

2 subnets created >> private and public

Click Security Lists

Create Security List

Provide security list name, compartment >> add ingress rule

Source  CIDR : 0.0.0.0/0

Destination port range : 443

Security list created >> go to subnets

Open public subnet 

Add security list

Select the compartment >> add the security list.

Developer services >> API Management >> Gateways

Select compartment and create gateway.

Provide Gateway name, type, compartment >> provide VCN name, select public subnet.

Gateway created.

Deployments >> Create deployment

Provide api gatway details:

Name: demo-api

Path prefix : /demo-api/1.0

Compartment: dev

Selecting no authentication which is basic authentication.

Note: you can also go for single or multiple authentication options.

Provide route Service details:

Path: /testHello

Method: POST

Backend type: HTTP

URL

Provide different time out paramters >> click show route request policies

Add the Authorization : Basic base64 representation of username:passoword

Next

Create the deployment

Copy the endpoint of the deployment for testing.

Open in postman >> select basic authentication >> provide OCI user and password

Test url: OCI deploywent Endpoint/path of the URL added in the deployment.

Body >> raw >> json

Provide input data

Hurahha!!! It worked. We have received the response.

MS Excel - Add drop down list and add conditional coloring or formatting

Detailed Steps:

Select the cells of the field. Here, Status. >> click on data tab

Data validation

Validation criteria >> allow as List

Source: Provide the list values

See the list is ready.

Now we will add conditional coloring.

Select the cells >> conditional formatting 

Select New Rule

Select Format only cells that contain >> equal to >> specify one value . " Not started". >> Format.

Select a color.

Ok

See its ready for Not started. Similarly , we can add for other values and colors.

MS Excel - Formatting tips and tricks for better project management

5 Tips:

1. Starting with a clean sheet.
2. Formatting the title row
1. Dark cell with light text color and bold
2. Light cell with dark text color and bold
3. Avoid using RAG colors for your title
3. Table borders
1. Alternatively, use white no fill color, it gives default grid lines
4. Text alignment
1. Center for short and standarized data like status, date, completion %
2. Left for mor characters like task name, description and comments.
5. Extra space for title and total row

OIC - ERP - How to submit ESS job and get job status from Oracle Integration

Usecase: submit an ESS job and get job status from Oracle Integration

Highlevel steps:

• Create an Oracle ERP Cloud connection.

https://soalicious.blogspot.com/2023/03/oic-create-erp-cloud-adapter-connection.html

• Create an Scheduled orchestration integration and call the created oracle erp adapter with following operation
• submit ESS job request
• get ESS job status

Detailed steps with screenshots:

Integration Flow:

1. Take an assign and define all the parameters like ESS job definition name, job package name, paramters required etc
2. Drop the Oracle ERP cloud adapter and call operation as "submitESSJobRequest" of ErpIntegrationService and map the required fields.
3. Take another assign and define the parameters for the loop to check job status like inProgressStatus as "true" and essJobStatus as ''
4. Take a while loop with condition as inProgressStatus = "true"
5. Keep a wait for required time. Here, its 30 sec.
6. Drop the Oracle ERP cloud adapter and call operation as "getESSJobStatus" of ErpIntegrationService and map the Submit ess job request response result to request id of get Ess job status.
7. Take an assign and depending on the get ess job response , assign the ess job status and and inprogressstatus.

Note: used a customized javascript function to convert get ess job status to boolean true or false based on the loop iterates.

https://soalicious.blogspot.com/2021/03/oic-js-return-boolean-status-based-on.html