How to find Patch Set Level in Oracle E-Business Suite
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;
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.
How to find out the patch level of any product you have installed in E-Business Suite
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;
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;
How to License a new product in R12 E-BUSINESS SUITE
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 >
1. Generate Message Files
2. Generate Forms Files
3. Generate Report Files
4. Generate Product JAR Files
- Return to Main Menu and choose Option 3 – Compile/Reload Applications Database Entities Menu >
1. Compile APPS Schema
2. Compile Menu Information
3. Compile Flexfields
- Return to Main Menu and exit from ADADMIN.
- Run autoconfig.
How to enable India Localization in Oracle Apps R12
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)
a. jai_enable_trg.sql
Connect sqlplus apps user
SQL> @jai_enable_trg.sql
PL/SQL procedure successfully completed.
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)
a. jai_enable_trg.sql
Connect sqlplus apps user
SQL> @jai_enable_trg.sql
PL/SQL procedure successfully completed.
How to Install SQL Developer on Linux Mint
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 416469574 Sep 19 00:02 sqldeveloper_19.2.1-248.2212_all.deb
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 416469574 Sep 19 00:02 sqldeveloper_19.2.1-248.2212_all.deb
4. Install SQL Developer package now.
You can user GUI to install the package
or
Run below command on terminal
himanshu@himanshu-ThinkPad-T430 ~/Downloads $ sudo dpkg -i sqldeveloper_19.2.1-248.2212_all.deb
Selecting previously unselected package sqldeveloper.
(Reading database ... 256436 files and directories currently installed.)
Preparing to unpack sqldeveloper_19.2.1-248.2212_all.deb ...
Unpacking sqldeveloper (19.2.1-248.2212) ...
Setting up sqldeveloper (19.2.1-248.2212) ...
Processing triggers for libc-bin (2.23-0ubuntu11) ...
5. Open SQL Developer, First time it will ask for jdk path, please provide same path as done in step 1
himanshu@himanshu-ThinkPad-T430 /usr/local/bin $ ls -ltr sqldeveloper
-rwxr-xr-x 1 root root 34 Sep 5 03:58 sqldeveloper
himanshu@himanshu-ThinkPad-T430 /usr/local/bin $ ./sqldeveloper
Oracle SQL Developer
Copyright (c) 2005, 2018, Oracle and/or its affiliates. All rights reserved.
Default JDK not found
Type the full pathname of a JDK installation (or Ctrl-C to quit), the path will be stored in /home/himanshu/.sqldeveloper/19.2.1/product.conf
/usr/lib/jvm/java-8-openjdk-amd64
Subscribe to:
Posts
(
Atom
)
No comments :
Post a Comment