How to find Patch Set Level in Oracle E-Business Suite

No comments
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.

No comments :

Post a Comment

How to find out the patch level of any product you have installed in E-Business Suite

No comments
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;


No comments :

Post a Comment

How to License a new product in R12 E-BUSINESS SUITE

No comments
We have to follow below process to license a new product on existing R12 E-Business Suite.

Steps:
  1. License the product in License Manager.
  2. 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.
Now we can successfully use the new product.

No comments :

Post a Comment

How to enable India Localization in Oracle Apps R12

No comments
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.




No comments :

Post a Comment

How to Install SQL Developer on Linux Mint

No comments
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


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



No comments :

Post a Comment