Oracle Cloud

How to Create Service Connection from Cloud Fusion API in VBCS

Introduction: – While building applications in Oracle Visual Builder Cloud Service (VBCS), one of the common requirements is to fetch real-time data from Oracle Cloud Fusion applications (like HCM, Finance,…

Read More

ERP Cloud Financials Fusion – Cash Management Auto Reconciliation

ERP Cloud Financials Fusion – Cash Management Auto Reconciliation Introduction Bank Statement Reconciliation – Match Statement Lines and Transactions – Automatic and Manual Reconciliation – 1 to 1, 1 to…

Read More

OIC Steps to create Visual builder instance

oic-steps-to-create-visual-builder-instance

Read More

Logistics Network Modeling-Oracle Cloud Transportation Management

Introduction  Logistics Network Modeling is an essential feature of Oracle Transportation Management. It allows for the simulation of multiple scenarios and the analysis of the best fit solution without having…

Read More

How to change the Database sys password in OCI

Introduction: In OCI Database Administrator user sys password change using OCI console.   Changing the Sys Password: Step 1: Login to a database where you want to change the sys…

Read More

How to Enable the private endpoint for the Database management

Introduction: During the enable of the Database management we need the private endpoint for that operation. In this post, you will see the step to create the private endpoint. Step…

Read More

Get Lookup Values from Cloud Using REST API

Introduction: This blog has the REST API Webservice details that can be used to Get the lookup values from Oracle Cloud application. Cause of the issue: For an integration process…

Read More

Backup Oracle Database to Oracle Cloud Infrastructure Object Storage

Backup Oracle Database to Oracle Cloud Infrastructure Object Storage Introduction: Oracle databases benefit from continuous backup, providing organizations with crucial protection during disasters. Implementing a backup strategy is complex and…

Read More

Migrate to Oracle Cloud Database within “1-Click”

Introduction: Oracle provide a tool called MV2OCI(Move to Oracle Cloud Database) and it is a new tool is permitting the load data and migration from “on premises” to Oracle Cloud…

Read More

Terminated Employee Pending Expenses with Manager details in the Cloud

Problem : Terminated Employee Pending Expenses with Manager details in the Cloud. Solution : Query created to find the inactive employee’s expense report select CARD_PROGRAM_NAME,EXPENSE_REPORT_NUM,EXPENSE_STATUS_CODE,ORIG_REIMBURSABLE_AMOUNT,DESCRIPTION,EXP_CREATION_DATE,ACTUAL_TERMINATION_DATE,PERSON_NUMBER,FULL_NAME,Manager_Emp_number,Manager_Name from (select ecp.CARD_PROGRAM_NAME, eer.EXPENSE_REPORT_NUM, eer.EXPENSE_STATUS_CODE,…

Read More