This post will help you to understand, how effectively you can amend the “Colombian Withholding Tax type certificate footer information” There is a standard setup to setup the footer information…
Read MoreThis script is useful when the dev Team asks larger number of concurrent request outfiles frequently. Before running this script copy the required concurrent request id to conrequestid.txt file. To…
Read MoreThe requirement is to update/attach a new Bill To Location to existing supplier sites. The below script can be used to update the Bill To Location for the existing supplier…
Read MoreINTRODUCTION: The below steps shows how to drop and recreate undo tablespace, by doing this activity we can gain more space in mount points and the database size will be reduced. STEP 1: Check the DB size using the below query, col “Database Size” format a20 col “Free space” format a20 col “Used space” format a20 select round(sum(used.bytes) / 1024 / 1024 / 1024 ) || ‘ GB’ “Database Size” , round(sum(used.bytes) / 1024 / 1024 / 1024 ) – round(free.p / 1024 / 1024 / 1024) || ‘ GB’ “Used space” , round(free.p / 1024 / 1024 / 1024) || ‘ GB’ “Free space” from (select bytes from v$datafile union all select bytes from v$tempfile union all select bytes from v$log) used , (select sum(bytes) as p from dba_free_space) free group by free.p / STEP 2: Check the list of undo tablespaces using the below query, column tablespace format a20…
Read MoreINTRODUCTION The below steps will describe how to perform Rman Scratch. STEP 1: Take a RMAN full backup of the database [oracle@Clone oradata]$ export ORACLE_SID=Product [oracle@Clone oradata]$ sqlplus…
Read MoreINTRODUCTION: The activity of moving redo logs online can gain us more space in mount points. STEPS: STEP 1: Check the size of the mount points using df -h STEP 2: Moving the datafiles without bringing down the database, Issue the following command, ALTER DATABASE MOVE DATAFILE ‘/prdadata01/oracle/PRODA/db/apps_st/sample/sample.dbf’ TO ‘/prdadata01/oracle/PRODA/db/apps_st/data/sample.dbf’; STEP 3: Moving the redo logs from one mount point to another mount point, Bring down the application node, sh $ADMIN_SCRIPTS_HOME/adstpall.sh apps/<appspassword> Bring down the listener and database lsnrctl stop shut immediate STEP 4: Issue the following OS command mv /prdadata02/oracle/PRODA/db/apps_st/data/log01a.dbf to /prdadata01/oracle/PRODA/db/apps_st/data/log01a.dbf mv /prdadata02/oracle/PRODA/db/apps_st/data/log01b.dbf to /prdadata01/oracle/PRODA/db/apps_st/data/log01b.dbf mv /prdadata03/oracle/PRODA/db/apps_st/data/log02b.dbf to /prdadata01/oracle/PRODA/db/apps_st/data/log02b.dbf mv /prdadata03/oracle/PRODA/db/apps_st/data/log02a.dbf to /prdadata01/oracle/PRODA/db/apps_st/data/log02a.dbf…
Read MoreThis error occurred when we install Oracle EBS R12.1 on oracle cloud. CAUSES OF ISSUE The http port number and instance public ip is blocked by the vcn network. There…
Read MoreOne of the index table FND_CONCURRENT_REQUESTS_N9’s block is corrupted. Causes of issue: Abnormal server down Steps to solve this issue: 1.Find table name of corrupted block SELECT k.owner, k.segment_type, k.segment_name,…
Read MoreThis os level command used to get the oracle EBS R12.2 web logic url. echo “http://”$(cat $CONTEXT_FILE | grep s_webhost | cut -d ‘>’ -f2 | cut -d ‘<‘ -f1)”.”$(cat…
Read MoreThis query will extract the PO amendment details for the revised PO’s SELECT po_number, po_date, approved_date, buyer_name, revision_number,po_header_description, amendment_by, amendment_date,CASE when (((NVL(old_price,-1)NVL(new_price,-1)) and old_price is not null) and ((NVL(old_quantity,-1)NVL(current_qty,-1)) and…
Read More