Skip to content

good trick for changing password securly in oracle

Good information,




Concurrent program migration

If your developer asked you to migrate concurrent program from dev or UAT to production, As a system administrator you need to do follow steps


Example :

Concurrent Program :

Concurrent program name : XX Report for Statement

Shortcut : xx_rep_stat

Application : XX Custom Application


XML Publisher :

Data definition code : xx_rep_stat

Template (rtf) :  XX Report for Statement.rtf


rdf file on the custom top

Report File (rdf): xx_rep_stat.rdf

Step 1: 
On development

System Administrator — > Concurrent  –> Program –> define

Query — > “XX Report for Statement”

Download the ldt file on application tier :


How to find out application short name :

SELECT fa.application_id “Application ID”,
fat.application_name “Application Name”,
fa.application_short_name “Application Short Name”,
fa.basepath “Basepath”
FROM fnd_application fa,
fnd_application_tl fat
WHERE fa.application_id = fat.application_id
AND fat.language = USERENV(‘LANG’) and fat.application_name =’XX Custom Application’
— AND fat.application_name = ‘Payables’ — <change it>
ORDER BY fat.application_name;

The output — > “XXREP”

Once downloaded ldt file, you please copy to production application server which is concurrent program running server. If its linux, you please use SCP to transfer the file or winscp

Step 2:

On development,

Download the Template

XML Publisher Administrator — >

Query code –> ” xx_rep_stat”

Download the rtf and save it on your desktop

Step 3:

On Production,

Upload the ldt file on production server which you’re copied ldt file.

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct xx_rep_stat.ldt

Once uploaded, you please check on your application whether its uploaded or not


System Administrator — > Concurrent  –> Program –> define

Query — > “XX Report for Statement”


Step 4: 

Transfer the “xx_rep_stat.rdf” file from development custom top report to production custom top report location

Step 5: 

On production application,

Create data definition and template as same as development

–> create data definition

Once Done Data definition,

–> create Template

Here you please upload that Template file which you’re downloaded from development.

Example :

Create Data Definition :


Create Template


Step 6:

Please check with your developer any Objects you need to migrate to production which is related to this report.

If yes, please migrate those objects also from development to production


Step 7: 

Add your report file to related request group


Unable to See the Legal Entity List of Values in the Bank Account Owner Field

A user was tried to select the legal entity list of values in the bank account, It does not appear in LOV.


Solution :

you can review the below support document

R12: CE: Unable to See the Legal Entity List of Values in the Bank Account Owner Field (Doc ID 415529.1)

Note:  I selected “Payable Role” instead of Cash Management

ORA-01017: invalid username/password ora_dba group

C:\Users\mazar>sqlplus / as sysdba

SQL*Plus: Release Production on Sun Jan 7 14:15:59 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

ORA-01017: invalid username/password; logon denied


Solution: added ora_dba group to user

C:\Windows\system32>net localgroup

C:\Windows\system32>net localgroup ora_dba mazar /add
The command completed successfully.


C:\Users\mazar>sqlplus / as sysdba

SQL*Plus: Release Production on Sun Jan 7 14:21:45 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release – 64bit Production



DATA MASKING on EBS 12.1.3 with Enterprise Manager

Please follow the step by step document of Data masking on EBS 12.1.3


find the files older than 30 days in linux

cd /u01/app/12c/oracle/trace

find *.trc -maxdepth 1 -mtime +30 -type f -exec ls -l {} \;



Data pump command import exclude

impdp system/Admin123 directory=exp_dir dumpfile=exp_dump.dmp logfile=exp_dump.log schemas=scott exclude=TABLE:\”IN \(\’EMP\’,\’DEPT\’\)\”

Trigger for open all pdb

create trigger open_all_pdbs
after startup on database
execute immediate ‘alter pluggable database all open’;
end open_all_pdbs;

Drop database link using sys

Step 1:

select * from dba_db_links

Step 2:  create a procedure

Create or replace procedure Drop_DbLink(schemaName varchar2, dbLink varchar2 ) is
plsql varchar2(1000);
cur number;
uid number;
rc number;
u.user_id into uid
from dba_users u
where u.username = schemaName;
plsql := ‘drop database link “‘||dbLink||'”‘;
cur := SYS.DBMS_SYS_SQL.open_cursor;
c => cur,
statement => plsql,
language_flag => DBMS_SQL.native,
userID => uid
rc := SYS.DBMS_SYS_SQL.execute(cur);



Step 3: Drop database link using sys


exec Drop_DbLink(‘owner’,’dblinkname’);

Maintenance Mode enabled in obiee

Maintenance Mode enabled in obiee using

[oracle@obidev catalogmanager]$ ./ -cmd maintenanceMode -on -online -credentials /u01/oracle/MiddlewareHome/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalogmanager/login.txt
Maintenance Mode is now ON