Toggle navigation
Tutorials
Oracle DBA
Oracle Apps
Weblogic
Oracle DataGaurd
Oracle RAC
Linux
Important Queries and Scripts
Oracle Ace Journey
Contact US
Disclaimer
Sitemap
Submit
HAPPY NEW YEAR 2021
For Any queries,collaborations please mail us at support@funoracleapps.com
Finding EBS/Oracle Apps Version
Himanshu
APPS R12.2 Architecture
,
funoracleapps
,
Oracle Apps
,
R12.2
,
scripts
No comments
We can use below query to identify Oracle Application Version.
SQL> select release_name from apps.fnd_product_groups;
RELEASE_NAME
--------------------------------------------------
12.2.6
Newer Post
Older Post
No comments :
Post a Comment
Subscribe to:
Post Comments ( Atom )
Oracle Jobs - Via Jooble
Popular Posts
Query to find Responsibility for which Menu / Form Function is assigned
Query to find Responsibility for which Menu / Form Function is assigned To get responsibility based on Menu SELECT DISTINCT a.respon...
Understanding Different Phases for ADOP
In the previous post, we have seen an overview about ADOP . Now we will try to understand Various phases of ADOP in detail. Prepare Phase...
Finding the Weblogic URL and Port from R12.2 Context File
We can find the weblogic URL and port from the CONTEXT_FILE by using the below variable. Steps: 1. Go to Application Tier 2. Set the R...
Query to find Form Function attached to which Responsibility
Query to find Form Function attached to which Responsibility Script: SELECT DISTINCT faa.application_name application, rtl.respon...
Finding Scheduled Concurrent Program
The below query can be used for getting all the details for a scheduled concurrent program. select a.requested_by,a.status_code,a.phase...
Query to get list of EBS users with responsibility and last login date (responsibility wise)
Query to get list of EBS users with responsibility and last login date (responsibility wise) Script: SELECT usr.user_name, rsp.respo...
FRM-40735: ON-ERROR trigger raised unhandled exception ORA-6508
Error: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-6508 Cause: This may be occur while opening forms after clone or if ...
FRMCMP for FMB and PLL compilation
frmcmp Module=<pll name> Userid=<userid/password> [Parameters]. Optional parameters with default values given: Mo...
Query to find Concurrent Request Details from Concurrent Program Name
Query to find Concurrent Request Details from Concurrent Program Name Script SELECT distinct user_concurrent_program...
Stopping and Starting RAC Services
STOP ORACLE RAC 1. emctl stop dbconsole 2. srvctl stop listener -n racnode1 3. srvctl stop database -d RACDB 4. srvctl stop ...
Have you taken taking from me!! Request for a Certificate
"Certificate is just to showcase your learning! Its not the measurement of your Knowledge". Please note this section will be opened for students
About Me
I am an Oracle Ace
UrbanPro
Followers
CONTACT US
Articles Index
►
21
(29)
►
Feb
(13)
►
Jan
(16)
►
20
(148)
►
Dec
(11)
►
Nov
(22)
►
Oct
(16)
►
Sep
(14)
►
Aug
(11)
►
Jul
(4)
►
Jun
(15)
►
May
(13)
►
Apr
(18)
►
Mar
(13)
►
Feb
(6)
►
Jan
(5)
►
19
(55)
►
Dec
(4)
►
Nov
(5)
►
Oct
(5)
►
Sep
(5)
►
Aug
(3)
►
Jul
(3)
►
May
(9)
►
Apr
(7)
►
Mar
(4)
►
Feb
(5)
►
Jan
(5)
▼
18
(48)
►
Nov
(1)
►
Oct
(1)
►
Sep
(3)
►
Aug
(2)
►
Jul
(3)
►
Jun
(7)
►
May
(11)
►
Apr
(6)
►
Mar
(4)
►
Feb
(2)
▼
Jan
(8)
Finding EBS/Oracle Apps Version
Apply WLS Patches using BSU
Understanding FS Clone in ADOP
Query to check if Patch applied to Patch Edition
Understanding Different Phases for ADOP
ADOP : Application DBA Online Patching
Finding the Weblogic URL and Port from R12.2 Conte...
Query To Find OPP Log File for a Request ID and Fi...
►
17
(16)
►
Aug
(1)
►
Apr
(3)
►
Feb
(10)
►
Jan
(2)
►
16
(1)
►
Dec
(1)
►
15
(3)
►
Nov
(2)
►
May
(1)
►
14
(14)
►
May
(4)
►
Mar
(9)
►
Jan
(1)
►
13
(35)
►
Dec
(3)
►
Nov
(3)
►
Oct
(4)
►
Sep
(8)
►
Aug
(5)
►
Jul
(2)
►
May
(10)
►
12
(61)
►
Dec
(7)
►
Oct
(5)
►
Sep
(2)
►
Aug
(4)
►
Jul
(5)
►
Jun
(12)
►
May
(5)
►
Apr
(1)
►
Mar
(20)
Copyright Funoracleapps.com@2020. Powered by
Blogger
.
No comments :
Post a Comment