foalabs

We can use below query to find Patch Set Level in Oracle  E-Business Suite. Query: select abbreviation ,codelevel from ad_trackable_entities where abbreviation in( 'ad','txk','fnd','fwk','atg_pf','icx' ) order by abbreviation; Note: We can change product in where condition as required.

We can use below query to  find out the patch level of any product you have installed in e-Business Suite Query: sqlplus apps/  SELECT substr(APPLICATION_SHORT_NAME,1,8) product, substr(PRODUCT_VERSION,1,14) version, substr(PATCH_LEVEL,1,11) patch_level FROM fnd_application a, fnd_product_installations p WHERE a.application_id = p.application_id ORDER BY application_short_name;

We have to follow below process to license a new product on existing R12 E-Business Suite. Steps: License the product in License Manager. Generate product related components by ADADMIN. 1. License new product from License Manager: To license the new product follow the below steps. Login to E-Bisuness Suite. Navigate to Oracle Application Manager > License Manager. Click on ‘Product’ link under ‘License’ tab. Select ‘License Application Product’ and ‘Continue’. Check the product you want to license and complete the action in License manager. Now the product is licensed in system, but not ready to use. 2. Generate product related files. To generate product related files in system follow below steps. Login to Application server with applmgr user. Set environment file. Run ADADMIN and choose below options: Option 1 – generate Application Files Menu >                 ...

We have to follow below steps for enabling India Localization. STEPS 1. Click System Administrator ---> Oracle Applications Manager -->License Manager ---> Country-specific Functionalities ----> Select Singapore ----> Click Next ----> Click Submit ----> Click Ok. 2. Check the India Localization licensed or Not Click Syatem Administrator ---> Oracle Applications Manager --> Licensed Products ---> check Status of JA-Asia/Pacific Localizations licensed or Not. If status is licensed means India localization is enabled 3. Go to $JA_TOP/patch/115/driver/ [oracle@funoracleapps driver]$ pwd /u01/TEST/apps/apps_st/appl/ja/12.0.0/patch/115/driver [oracle@funoracleapps driver]$ ls ja12axdo.drvx jai5188052.drv 4.  Enable the triggers Go to /u01/TEST/apps/apps_st/appl/ja/12.0.0/patch/115/sql Compile the files (Path: $JA_TOP/patch/115/sql)                     ...

In this post I am going to share the steps for installation of SQL Developer on Linux Mint OS or Ubuntu. SQL developer will require to jdk as pre-requisites. Steps: 1. Install jdk 8 or above.  sudo apt-get install openjdk-8-jdk It will be installed in below folder /usr/lib/jvm/java-8-openjdk-amd64 2. SQL Developer which we wil download from Oracle Website would in rpm format. I am going to use alien tool to covert it in debian(deb) format. sudo apt-get install -y alien 3. Convert the SQL developer rpm to debain format. himanshu@himanshu-ThinkPad-T430 ~/Downloads $ ls -ltr sqldeveloper-19.2.1.247.2212.noarch.rpm -rw-rw-r-- 1 himanshu himanshu 420128668 Sep 18 23:46 sqldeveloper-19.2.1.247.2212.noarch.rpm himanshu@himanshu-ThinkPad-T430 ~/Downloads $ sudo alien sqldeveloper-19.2.1.247.2212.noarch.rpm Once done we can see below deb file. himanshu@himanshu-ThinkPad-T430 ~/Downloads $ ls -ltr sqldeveloper_19.2.1-248.2212_all.deb -rw-r--r-- 1 root root 4164...