foalabs

Applications Start Page in Oracle Apps R12 The "Applications Start Page" feature provides a user an option to set a particular page as his/her preferred start. The user will be taken to this page at login. A user can choose from the set of functions available under his/her responsibilities. The value is recorded in a profile option named "Applications Start Page (APPLICATIONS_START_PAGE)" as "functionId$$$respId$$$appId". How to Enable Application Start Page 1. Make sure the profile "Self Service Personal Home Page Mode" is set to "Framework only" at the site level or at user level for which user you intend to provide the "Applications Start Page" feature. 2. log in to Applications as the End-user. 3. Navigate to the Preferences link on top of the page. 4. You can find a section "Start Page" under General Preferences page.  Select the Responsibility from which you would like to choose the Function (For e.g. Payables ...

Enterprise Manager 11g FMW Console Hangs While Showing Loading Animation in Oracle Apps R12.2 When login to em for Oracle Apps R12.2 the animation screen is stuck and not progressing. Solution: Run the JVM in Headless mode.It removes the dependency on X-windows access and has rendering performed by JVM code. Perform the following steps to add this parameter to the Java startup parameters for the WLS Admin Server: Navigate to the Context Editor in Oracle Applications Manager or edit context file . Locate the setting for s_nm_jvm_startup_properties. Add the end of the value add the following: -Djava.awt.headless=true. Save the changes. Run Autoconfig Bounce the WLS Admin Server using adadminsrvctl.sh script. Connect to Oracle Enterprise Manager 11g FMW console to confirm this not proceeds to expected page. If you like please follow and comment

How to Mount AWS S3 Bucket on Linux (OEL/Centos/Ubuntu) I am going to use  S3FS solution which is FUSE (File System in User Space). Using this we can use commands like cp, mv on the system. It will be a normal mount on the Linux system. Prerequisites:   You must create s3 bucket in AWS console. I created a folder funmount. Steps:   1: Remove Existing Packages Login to your Linux instance.  First of all, check whether you have already installed any existing fuse or S3FS on your server. In case it exists, then remove it to avoid conflicts on the server. For CentOS OR RHEL Users:  # yum remove fuse fuse-s3fs For Ubuntu Users:  $ sudo apt-get remove fuse   2: Install dependency Packages. Now you must install packages that are required for fuse and s3cmd. For CentOS or RHEL users: #  yum install openssl-devel gcc libstdc++-devel gcc-c++ fuse fuse-devel curl-devel libxml2-devel mailcap git automake For Ubuntu User...

How to run Opatch in Silent mode without User Interaction In this post, I am going to share the steps on how to run the Opatch in Silent mode. This is helpful when you want to automate Opatch utility and don't want any user interaction. Steps: 1)Download and install the latest opatch tool. Patch # 6880880 Select a Release: 10.2  -OR-  11.1 -OR-  11.2 -OR-  12.1  2)Create a response file and copy the created response file at any required location. Syntax : export ORACLE_HOME=<my_oracle_home_path> $ORACLE_HOME/OPatch/ocm/bin/emocmrsp  -no_banner -output <specify_the_location>/file.rsp * creates the response in location specified by the parameter "-output" * running without "-output <specify_the_location>/file.rsp"  creates the file in current directory with default name(ocm.rsp) I don't want to provide any email address to just hit enter and y to stay uninformed. [oracle@ebs122 ~]$/oracleapps/DATABASE/GOLD/12.1.0/OPatch/ocm/bin/emocmrsp...

Understanding Hard Link and Soft Link in Linux To understand the hard link and soft link you must first know What is an inode. Everything in Linux is considered as a  file. An inode is a data structure that stores various information about a file in Linux, such as the access mode (read, write, execute permissions), ownership, file type, file size, group, number of links, etc. Each inode is identified by an integer number. An inode is assigned to a file when it is created. A file system is divided into two parts – data blocks and inodes. The number of blocks is fixed once created, and can’t be changed. The name, path, location, links and other file attributes are not located in the directory. Directories are simply tables that contain the names of the files with the matching inode number. To view, a file’s inode number use the below command root@fundb:/HS# ls -li total 10 865675319 -rwxrwxrwx 1 root root 1782 Aug 25 15:19 file_password_update.sh 865675318 -rwxrwxrwx 1 root root...

Trying to resume a failed cutover session giving Invalid Credentials in Oracle Apps R12.2 If you attempt to resume a failed session after cutover exits with cutover_status=3, I receive an 'Invalid Credentials' error. To check the status you can use the query as earlier posted. This will be because the database patch edition has already been promoted to be the new run edition. To resume and complete cutover successfully, run the command: $ adop phase=cutover action=nodb If you like please follow and comment

Useful Scripts related to Editioned Database in Oracle Apps There are a number of SQL*Plus scripts that can provide useful information about the state of your editioned database environment. All ADZD* scripts are found under $AD_TOP/sql. ADZDDBCC - the database compliance checker, shows violations of the database object development standards. Warning: this script takes a long time to run. ADZDSHOWED - Show database editions and current editions. ADZDSHOWLOG - Show full diagnostic log for online patching infrastructure. ADZDSHOWLOGEVT - Show only event and error messages from the online patching diagnostic log (a useful summary, without the detailed statement text). ADZDSHOWLOGERR - Show only error messages from online patching diagnostic log. ADZDSHOWEV TABLE_SYNONYM_NAME - Show editioning view column mapping for the table. ADZDSHOWTAB TABLE_SYNONYM_NAME - Show table information and related objects. ADZDSHOWMV MVIEW_NAME - Show materialized view information and related objects....

Different Status of Cutover and their Meaning on Oracle Apps R12.2 The cutover operation is the most critical phase of an online patching cycle. Although other adop operations can be left to run unattended, you should carefully monitor the progress of cutover, so that you can respond quickly in case of any issues. If cutover fails to complete, check log messages for any problems that may require correction. Then try executing the cutover command again. When cutover is re-executed after a previous failure, adop will restart cutover processing at the failure point for any nodes that did not complete, and the processing may be successful this time. If we run the below script, we can see various status codes for cutover. These can be helpful if the cutover has failed and we need to perform the next steps to fix it. Script select NODE_NAME,ADOP_SESSION_ID, PREPARE_STATUS , APPLY_STATUS  ,CUTOVER_STATUS, CLEANUP_STATUS , ABORT_STATUS , STATUS from AD_ADOP_SESSIONS order by ADOP_SESSION_I...

How to execute an Empty Patching cycle in Oracle Apps R12.2 In this post, I am going to share the way to run an empty patching cycle in Oracle Apps R12.2  without applying any patch. This might be needed for testing purposes, switching the filesystem from fs1 to fs2, or vice versa. In most interviews also you will see this question. Simple Command adop phase=prepare,finalize,cutover,cleanup If you like please follow and comment

How to Install Apache (httpd) webserver on Linux 7 In post, I will how to install an apache webserver on OEL 7/oel7. 1)Install http package [root@oel7 ~]# yum install httpd 2)Start httpd service [root@oel7 ~]# service httpd start Redirecting to /bin/systemctl start  httpd.service 3)Check the status of httpd service: [root@oel7 ~]# service httpd status 4)Enable service to be started after reboot [root@oel7 ~]#systemctl enable httpd 5)Add hostname:IP in http configuration  [root@oel7 ~]# echo 'ServerName oel7.lab:80' >> /etc/httpd/conf/httpd.conf [root@oel7 ~]# service httpd restart 6)Enable firewall sudo firewall-cmd --permanent --add-service=http sudo firewall-cmd --reload 7)Now try to access the IP or host name http://oel7.lab:80 http://192.168.56.110 8)We can also create simple index page to test [root@oel7 ~]# echo "APACHE Testing on oel7" > /var/www/html/index.html Reload your browser to see your new index.html page Note: Configuration file for Apache is ...

The certificate /usr/share/rhn/ULN-CA-CERT is expired. Error: On running yum command on Oracle Enterprise Linux 7(OEL), I was getting below error. yum repolist Loaded plugins: langpacks, ulninfo The certificate /usr/share/rhn/ULN-CA-CERT is expired. Please ensure you have the correct certificate and your system time is correct. Solution: This is due to an expired certificate of the repository. Manually replace the SSL certificate To manually replace the client SSL certificate on an Oracle Linux machine, run the following steps as root on each server: # cp /usr/share/rhn/ULN-CA-CERT /usr/share/rhn/ULN-CA-CERT.old # wget https://linux-update.oracle.com/rpms/ULN-CA-CERT.sha2 # cp ULN-CA-CERT.sha2 /usr/share/rhn/ULN-CA-CERT If you like please follow and comment

How to Retrieve Forgotten Apps Password in Oracle EBS R12 I am going to share steps to retrieve the password in Oracle Apps. But no guarantee that it will work on all EBS version. I have tested in R12.2.3. Steps:  1: log in to the database server with sys user  sqlplus / as sysdba  2: Create Function to decrypt the encrypted password  SQL> create FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2)  RETURN VARCHAR2  AS  LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';  /  3 : Query for Encrypted password SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME='GUEST';  Output  ENCRYPTED_FOUNDATION_PASSWORD  --------------------------------------------------------------------------------  ZG37E123746712BDB2D99E048FE44AE662F2713E2EDB443391BABA0414CADDB7A2E6DD45BBAFA7270A663E5EEB...

What is Oracle Data Redaction with Examples (Mask your sensitive Data) Oracle Data Redaction is one of the new features introduced in Oracle Database  Oracle 12c and back-ported to 11.2.0.4 via patch set ( Some examples of implementing Data Redaction using DBMS_REDACT (Doc ID 1588270.1)) . This new feature is part of the Advanced Security option and enables the protection of data shown to the user in real-time, without requiring changes to the application. Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by applications. You can redact column data by using one of the following methods: Full redaction. You redact all of the contents of the column data. The redacted value returned to the querying application user depends on the data type of the column. For example, columns of the NUMBER data type are redacted with a zero (0), and character data types are redacted with a single space. Partial redaction. You redact a portion of the column ...

Query to find the last access date for a Responsibility in R12 Script: SELECT frt.responsibility_name,fu.user_name,        Max(flr.start_time) "Last Connect" FROM   applsys.fnd_login_responsibilities flr,        applsys.fnd_user fu,        applsys.fnd_logins fl,        applsys.fnd_responsibility_tl frt WHERE  fl.login_id = flr.login_id        AND fl.user_id = fu.user_id       AND fu.user_name = '&Username' -- Comment for Complete User List        AND frt.responsibility_id = flr.responsibility_id        and frt.responsibility_name = '&ResponsibilityName' -- Comment for Complete Responsibility List GROUP  BY frt.responsibility_name ,fu.user_name If you like please follow and comment

How can we change the Web Port in EBS 12.2 Oracle HTTP server (OHS) configuration is managed by FMW  in R12.2, so there is a difference when changing the webport when compared to previous releases. Steps  1) Launch EM Console and login as weblogic user http://<s_wls_admin_host>.<s_wls_admin_domain>:<s_wls_adminport>/em 2) Select the web tier instance from the Web Tier dropdown 3) Select the Oracle HTTP server component and Advanced Configuration 4) Choose httpd.conf  and Modify the Listen port value 5) Apply the changes 6) Run Context File Synchronization $AD_TOP/bin/adSyncContext.pl perl $AD_TOP/bin/adSyncContext.pl contextfile=$CONTEXT_FILE Note:  Manually update the $CONTEXT_FILE if old port values are still present Ideally, the values will get updated 7) Stop all services 8) Run autoconfig 9) Start all application services and validate the new URL. If you like please follow and comment