Yearly Archives: 2021

Customer LOGO in R12 Login Page(ORACLE EBS)

INTRODUTION The below steps will demonstrate how to add the client organization logo in R12 login page. STEP 1:Get the Logo from the customer. STEP2:Login as sysadmin navigate to system…

Read More

Ways to Embrace Hybrid Cloud with the Oracle Cloud Infrastructure (OCI)

We are living in a time where automation takes over the human workforce to simplify the process. Many businesses have started to adapt to this culture and are aware of…

Read More

Working Efficiently with Oracle Support

As an Oracle consultant, there will be many times you will need to raise Oracle support for multiple issues. When there is tight schedule, you will look for quicker responses…

Read More

FS_CLONE Fails with no such files or Directory ADOPValidationUtils.pm

When you run adop phase=fs_clone, this will endup with the error no such files or Directory ADOPValidationUtils.pm in a minute or so, this is due to the patch context file…

Read More

Backing Up a Block Volume in OCI

Description: The backups feature of the Oracle Cloud Infrastructure Block Volume service lets you make a crash-consistent backup, which is a point in time snapshot of a boot volume without application interruption…

Read More

Rename Disk group name

Old disk group name   :      PROD New disk group name :       NEWDG  Check the databases are located in the Disk group srvctl config database -d clouddb Create a…

Read More

Working With Nested Table Oracle

1. Overview This document talks about the steps to working with Oracle nested tables.Nested table is awesome feature of Oracle. You can create table inside a table, Which means one column can…

Read More

Create Currencies and Currency Rates in GL fusion.

Create Currencies and Currency Rates in GL fusion. This chapter contains the following: Currencies Conversion Rate Types Daily Rates Currencies Considerations for Defining Currencies Consider these points about entering the…

Read More

RETURNING CLAUSE with EXECUTE IMMEDIATE

  RETURNING Clause With EXECUTE IMMEDIATE 1. Overview The RETURNING clause allows you to retrieve values of columns (and expressions based on columns) that were modified by an insert, delete…

Read More

RETURNING CLAUSE with BULK COLLECT

  RETURNING Clause Using Bulk Collect   1.          Overview The RETURNING clause can return multiple rows of data, in which case you will use the RETURNING BULK COLLECT INTO form.…

Read More