Yearly Archives: 2021

Steps to scp file from one server to another server in oracle cloud

INTRODUCTION: The below steps shows us how to enable the scp for file transfers in oracle cloud. Open the puttygen Import the target server ppk file It will ask for the target server ppk file we are going to scp Select the file and click open The ssh keys will be generated. Select the Export OpenSSH Key Save the File with ssh extension move the file to source server in /etc/ssh folder Now we are able to move the pfile to target server.

Read More

Moving Table from one tablespace to another tablespace

    The alter table  move command moves rows down into un-used space and adjusts the HWM but does not adjust the segments extents, and the table size remains the same. …

Read More

Opening Files from Server in Oracle Forms

Opening Files from Server in Oracle Forms. Introduction: Script to open the Pdf or Image files from Server in Oracle Forms. Cause of the issue: In Oracle Forms user requested…

Read More

Dynamic Alert Message in Oracle Forms

Dynamic Alert Message in Oracle Forms. Introduction: The Alert Message need to be changed at run time based on the condition criteria. Cause of the issue: In Oracle Forms, we…

Read More

API to Approve the POs

API to Approve the POs. Introduction: API to Approve the POs. Cause of the issue: In PO Migration from one unit to another unit, the old unit POs need to…

Read More

Data Fix -Delete records – Customer Interface Table

Execute the below scripts for Backup Table Step1:- “CREATE TABLE scratch.RA_CUST_INT_INC0054156 as select * from apps.RA_CUSTOMERS_INTERFACE_ALL where org_id =****; / CREATE TABLE scratch.RA_CUST_PRO_INC0054156 as select * from apps.RA_CUSTOMER_PROFILES_INT_ALL where org_id=****;…

Read More

How to Update the Employee Details in Oracle apps R12 ?

Updating the Employee Details/Location/Address   Responsibility: HRMS Manager Navigation:Personnel->employees->query with employee last name Step1: Update the Manager   Step 2: Click on more and then click on assignments Click on…

Read More

RMAN – Backup Based Clone

RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server…

Read More

Recycle Bin in Oracle

  Oracle database has the recycle bin which is a data dictionary table and contains information about dropped objects.  Until we don’t use the purge option, all dropped tables and…

Read More

ORA-08104: this index object is being online built or rebuild

” ORA-08104: this index object 4357688 is being online built or rebuilt ” error in index Rebuild. Details of error are as follows. SQL> ALTER INDEX MSDBA.TEST_INDEX REBUILD TABLESPACE MYTBS…

Read More