FND_FILE is the standard API provided by Oracle Apps. Package FND_FILE contains routines that allow as concurrent programs to write to the request log and output files, stored under /log and /out. The FND_FILE.PUT_LINE() calls use the UTL_FILE package to write the line to a temporary file in the $APPLPTMP directory. Text written by the […]
How to work with date Functions in Oracle sql
This post I am trying to explain many things about date in oracle like oracle sql date functions,oracle sql date format, oracle sql date comparison, oracle date difference in years,oracle date difference in days, oracle date difference in months Oracle has provided date and timestamp types for storing the date and time information in the […]
How to change date format in oracle database
We often need to change the date format while checking. Here are some ways which you can use to change the date format in Oracle database Oracle Default Date Format The default date format in oracle is controlled by the value of the NLS_DATE_FORMAT parameter. The following query can be used to find the current […]
Script to check locks in oracle database
Script to check locks in oracle database ( Single Instance) SELECT inst_id,DECODE(request,0,’Holder: ‘,’Waiter: ‘)||sid sess, id1, id2, lmode, request, type FROM V$LOCK WHERE (id1, id2, type) IN (SELECT id1, id2, type FROM V$LOCK WHERE request>0) ORDER BY id1, request ; In case of RAC ,below query is used check locks in oracle database SELECT inst_id,DECODE(request,0,’Holder: […]
How to find EBS R12 components Version
We are often asked How to find EBS R12 components Version. This is includes all R12.0/R12.1 and R12.2. I will try to explain how to find out that with various EBS R12 version with command and reports. Apache Version/how to check oracle application server version in r12 $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v Perl Version $IAS_ORACLE_HOME/perl/bin/perl -v|grep built Java […]
Query to Find oracle EBS failed login attempts
Before moving directly into query for oracle EBS failed login attempts and oracle ebs user login history, lets find out how to enable signon audit in EBS to collect this data and other important stuff Introduction to EBS Signon Auditing Oracle EBS has lot of auditing features to check the information of user login to […]
