APPS DBA MATERIAL: 2017

Tuesday 11 July 2017

how to find database is running with pfile or spfile?

SQL> select decode(value,null,'PFILE','SPFILE') "init file type" from sys.v_$parameter where name='spfile';

init f
------
PFILE

SQL> show parameter spfile;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

spfile string

if it doesnt returns any value it means the database is started with pfile.

Monday 27 March 2017

validating the front end user in oracle apps R12?

If we need to validate the front end user password is working fine or not then we can fire the below query to check the authentication of password.

SQL> select fnd_web_sec.validate_login('GUEST','welcome') from dual;

FND_WEB_SEC.VALIDATE_LOGIN('GUEST','WELCOME')
--------------------------------------------------------------------------------
Y

query to check work flow mailer status?

SELECT component_status
FROM apps.fnd_svc_components
WHERE component_id =
(SELECT component_id
FROM apps.fnd_svc_components
WHERE component_name = 'Workflow Notification Mailer');

(or)

select component_status from apps.fnd_svc_components where component_name='Workflow Notification Mailer';

Sunday 26 March 2017

unable to launch the java virtual machine sqldeveloper?

while installing sqldeveloper if you face this error.follow the below steps to resolve this issue:-

copy the mscvcr100.dll file from C:\Users\subbu\Downloads\sqldeveloper-4.2.0.16.356.1154-x64\sqldeveloper\jdk\jre\bin\msvcr100.dll to C:\sqldeveloper\sqldeveloper\bin\

Monday 20 March 2017

ORA-27154,ORA-27300,ORA-27301,ORA-27302?

while starting the database if we get the following errors

ORA-27154 : past/wait create failed.
ORA-27300 : OS System dependent operation segment failed.
ORA-27301 : OS failure msg : no space left on device
ORA -27302 : failure occurred at :sskgpsemsper

sql>exit

go to root user----> vi /etc/sysctl.conf

As per the oracle the semaphore value should be set to

kernel.sem=250 32000 100 200

can we change characterset and tablespace block size after database creation?

If Tablespace block size is showing 4096.It is because while creating the database we had given db_block_size=4096,so after creation of database we cannot able to change the block size to 8192.
And also we cannot able to change the change the characterset after the database creation.

If you want to find the block size of tablespaces?

select block_size from dba_tablespaces;

If you want to find the characterset of the database?

select * from NLS_DATABASE_PARAMETERS;

select * from NLS_DATABASE_PARAMETERS where parameter='NLS_CHARACTERSET';

Friday 24 February 2017

Difference between Oracle EBS R12.1.3 and Oracle EBS R12.2.4?

There are lot of differences.

1)In R12.2 we have to kind of filesystems fs1(run filesystem) and fs2(patch filesystem) where as In R12.1.3 we only deal with one application filesystem.

2)In R12.2 we have the Application servers replaced by Weblogic server to manage the technology statck.
The 10.1.3 Home is replaced by FMW (Fusion Middleware Home) i.e $FMW_HOME

The major change in R12.2 is involvement of Weblogic server to manager all the forms,oacore servers
where as in R12.1.3 we had the Application server 10.1.3 to manage the web home or Java Home

3)The adpatch(patching) in R 12.1.3 is replaced by adop(online patching) in R 12.2.4

adop(online patching) utility involves 5 phases to apply a standard patch in Oracle EBS R12.2.
adop involves 5 phases
1)prepare => prepare phase involves synchronization of the filesystems fs1 (run ,filesystem) and fs2(patch filesystem), filesystems are inter changeable.
2)apply=>In this phase we apply all the patches
Note: These patches need to be copied in fs_ne (non editioned filesystems)
3)finalize =>In this phase we are getting ready for cutover phase
4)cutover =>In cutover phase the filesystem switchover takes place. Previously the filesystem which was patch filesystem will now become run filesystem.)
5) cleanup =>In cleanup phase all the obsolute objects gets compiled .

adop online patching utility doesn't require downtime. It involves minimal downtime during cutover phase where switching of filesystems happens. We can apply lot of patches and do cutover any time to minimize downtime

where as in adpatch we just apply patch most of the times by bringing down applications or in hot patch mode.

4)'Apps' user Password change:
The 'apps' user password change involve 3 steps in R12.2.4
1)Change the password with FNDCPASS
2)Change the password in EBS Datasource from Weblogic admin console

Where as in R 12.1.3 It only involves 2 steps:
1)Change the password with FNDCPASS
2)Run Autoconfig
5)Log files locations:
All the oacore,forms log files are placed in $EBS_DOMAIN_HOME in R12.2. I will explain this in details in my upcoming posts.
Where as in R12.1.3 all the logs for oacore,forms are under $LOG_HOME/ora/10.1.3

Tuesday 14 February 2017

opatch?

OPATCH---->oracle patch

To apply Opatch conditions are database and listener both must be down.
As opatch will update your current ORACLE_HOME with patches.In single instance it is not possible.
But for RAC instance it is possible.As in RAC there will be two separate oracle home and 2 separate instances running one
instance on each oracle home.

Steps before applying patch:---

1)check database status:-

select name,open_mode,database_name,created,log_mode,platform_name from v$database;

NAME OPEN_MODE DATABASE_NAME CREATED LOG_MODE
--------------- --------------- --------------- --------------- ---------------
PLATFORM_NAME
---------------
VIS READ WRITE VIS.subbuapps 31-OCT-16 NOARCHIVELOG
.COM
Linux x86 64-bit

2)check the invalid objects:-

select owner,count(*) from dba_objects where status like '%INVALID% GROUP BY owner;

3)Check Opatch version using opatch -v
if opatch version is not compatible check the readmefile and download the latest version and uncompress in $ORACLE_HOME

4)Check oraInst.loc file pointing to your current $ORACLE_HOME or not.
cat /etc/oraInst.loc

inventory_loc=/u01/app/oracle/10.2.0/GlobalOraInv
inst_group=dba

5)If your server have more then one $ORACLE_HOME then comment the other $ORACLE_HOME and
uncomment the current $ORACLE_HOME

inventory must point to the current $ORACLE_HOME which is getting patched.

6)Unzip the patch,go to patch directory and then bring down the listener,bring down the database.

7)export Opatch
export PATH=$PATH:$HOME:$ORACLE_HOME/OPatch:/bin

8)Apply Patch
opatch apply

Monday 13 February 2017

How to find the character set of oracle database?

SQL> select * from NLS_DATABASE_PARAMETERS;

PARAMETER VALUE
------------------------------ ---------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AL32UTF8
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_NCHAR_CHARACTERSET UTF8

PARAMETER VALUE
------------------------------ ---------------
NLS_SAVED_NCHAR_CS WE8ISO8859P1
NLS_TIME_FORMAT HH.MI.SSXFF AM

(OR)

SQL> select * from NLS_DATABASE_PARAMETERS where parameter='NLS_CHARACTERSET';

PARAMETER VALUE
------------------------------ ---------------
NLS_CHARACTERSET AL32UTF8

The database character set in oracle determines the set of characters can be stored in the database. It is also used to determine the character set to be used for object identifiers and PL/SQL variables and for storing PL/SQL program source.

Friday 3 February 2017

free space in tablespaces in MB's?

SQL> select tablespace_name,round(sum(bytes)/1024/1024) free_space_mb from dba_free_space group by (TABLESPACE_NAME);

TABLESPACE_NAME FREE_SPACE_MB
------------------------------ -------------
CWMLITE 24
DW_DERIVED_TBS 100
TS_SIM_X 50
OPMOR 1
IAS_META 35
WCRSYS_TS 1
DW_BASE_IDX 100
APPS_TS_QUEUES 651
OWAPUB 10
DW_DM_TBS 100
SYSAUX 126

TABLESPACE_NAME FREE_SPACE_MB
------------------------------ ------------
DSGATEWAY_TAB 2
DISCO_PTM5_META 1
B2B_DT 11
RE 1
TS_SALES_DATA_ENGINE_X 50
TS_SALES_DATA_ENGINE 50
DISCO_PTM5_CACHE 17
APPS_TS_ARCHIVE 201
APPS_CALCLIP 1544
BAM 2
APPS_TS_NOLOGGING 279

invalid objects in database?

SQL> desc dba_objects;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER VARCHAR2(30)
OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(19)
CREATED DATE
LAST_DDL_TIME DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NUMBER
EDITION_NAME VARCHAR2(30)

SQL> select count(*) from dba_objects where status like '%INVALID%';

COUNT(*)
----------
450

SQL> select count(*) from dba_objects where status='INVALID';

COUNT(*)

----------

450

If we want to check the owner,object_name,object_type of the invalid objects?

select owner,object_name,object_type from dba_objects where status like '%INVALID%';

How to find the database startup date and time?

SQL> select host_name,instance_name,to_char(startup_time,'DD-MON-YYYY HH24:MI:SS AM') startdate from v$instance;

HOST_NAME INSTANCE_NAME STARTDATE
--------------- --------------- --------------------------------
subbuapps.erp.com 03-FEB-2017 14:32:29 PM

How to find the instance name and host name?

SQL> select host_name,instance_name from v$instance;

HOST_NAME INSTANCE_NAME
--------------- ---------------
subbuapps.erp.com VIS

Friday 27 January 2017

How to get the current Patchset level of Oracle Applications products in R12 ?

Login to oracle applications manager---OAM support cart---collect---select product information and click on view(spectacles sysmbol).Here we can find Application name,current patch level,product version,status(whether the product is installed or not.

We can also retreive the patchset level information by using the diagnostic script adutconf.sql

It will be in the location cd $AD_TOP/sql

(/home/u02/e02/apps/apps_st/appl/ad/12.0.0/sql)

After running the adutconf.sql the output file will be in the same location as adutconf.lst

Oracle Applications Database Configuration Report

All dates are shown in DD-MM-YYYY format

Report Date : 27-01-2017 14:36:53
Database name: VIS

--> Sql*Plus PAUSE setting

PAUSE is OFF

--> Sql*Plus NEWPAGE setting

newpage 1

--> Rollback Segment Information

Name Tablespace Initial (K) Next (K) Min X Max X Appl Status
---------- ---------- ----------- -------- -------- -------- --------------
RBS1 SYSTEM 64 64 2 32765 OFFLINE
RBS_MIG2 RBS_MIG 2048 1024 1 32765 OFFLINE
SYSTEM SYSTEM 56 520 2 505 ONLINE
_SYSSMU1_1 UNDO_TBS 128 64 2 32765 ONLINE
228296233$

_SYSSMU22_ UNDO_TBS 128 64 2 32765 ONLINE
1228241915
$

_SYSSMU23_ UNDO_TBS 128 64 2 32765 OFFLINE
1228241915
$

_SYSSMU24_ UNDO_TBS 128 64 2 32765 OFFLINE
1228241915
$

_SYSSMU26_ UNDO_TBS 128 64 2 32765 OFFLINE
1228241915
$

_SYSSMU28_ UNDO_TBS 128 64 2 32765 OFFLINE
1228241915
$

_SYSSMU29_ UNDO_TBS 128 64 2 32765 OFFLINE
1228241915
$

_SYSSMU2_1 UNDO_TBS 128 64 2 32765 ONLINE
228296233$

_SYSSMU30_ UNDO_TBS 128 64 2 32765 OFFLINE
1228241915
$

_SYSSMU31_ UNDO_TBS 128 64 2 32765 OFFLINE
1228241915
$

_SYSSMU32_ UNDO_TBS 128 64 2 32765 OFFLINE
1228241915
$

_SYSSMU33_ UNDO_TBS 128 64 2 32765 OFFLINE
1228241915
$

_SYSSMU3_1 UNDO_TBS 128 64 2 32765 ONLINE
228296233$

_SYSSMU4_1 UNDO_TBS 128 64 2 32765 ONLINE
228296233$

_SYSSMU5_1 UNDO_TBS 128 64 2 32765 ONLINE
228296233$

_SYSSMU6_1 UNDO_TBS 128 64 2 32765 ONLINE
228296233$

_SYSSMU7_1 UNDO_TBS 128 64 2 32765 ONLINE
228296233$

_SYSSMU8_1 UNDO_TBS 128 64 2 32765 ONLINE
228296233$

_SYSSMU9_1 UNDO_TBS 128 64 2 32765 ONLINE
228296233$

22 rows selected.

--> Rollback Segment Sizes

Name Tablespace Size (K) Num Extents Owner
---------- ---------- ---------- ----------- ----------
SYSTEM SYSTEM 1552 7 SYS
_SYSSMU1_1 UNDO_TBS 229504 34 PUBLIC
228296233$

_SYSSMU22_ UNDO_TBS 180352 25 PUBLIC
1228241915
$

_SYSSMU2_1 UNDO_TBS 163968 29 PUBLIC
228296233$

_SYSSMU3_1 UNDO_TBS 311424 40 PUBLIC
228296233$

_SYSSMU4_1 UNDO_TBS 237696 31 PUBLIC
228296233$

_SYSSMU5_1 UNDO_TBS 403584 52 PUBLIC
228296233$

_SYSSMU6_1 UNDO_TBS 221312 29 PUBLIC
228296233$

_SYSSMU7_1 UNDO_TBS 172160 58 PUBLIC
228296233$

_SYSSMU8_1 UNDO_TBS 221312 29 PUBLIC
228296233$

_SYSSMU9_1 UNDO_TBS 229568 38 PUBLIC
228296233$

11 rows selected.

--> Start of Application Information Gathering

--> Product Group Information

ID Product Group Name Appl Sys Name Release Type
---- ---------------------------- --------------- ------------ ----------
Arguments
--------------------
1 Default product group VIS 12.1.3 Standard

1 row selected.

--> Multi-Org enabled?

Yes

1 row selected.

--> Existing Operating Units

ORGANIZATION_ID
---------------
NAME
-------------------------------------------------------------------------------
202
Vision Corporation

204
Vision Operations

229
Singapore Distribution Center

458
Vision Services

498
Vision ADB

600
Vision Project Mfg

626
Vision Industries

887
Vision Sweden

888
Vision France

889
Vision Netherlands

911
Vision Germany

912
Vision Korea

916
Vision Corporation Japan

917
Vision Services Japan

996
PRU-Vision Process Industries (US)

1016
Vision Spain

1017
Vision Italy

1018
Vision Belgium

1081
Vision Services R+D

1448
Progress Master

1468
Progress Administration

1646
Vision Australia

1668
Progress UK

1733
Vision Communications (USA)

1759
Vision University

1885
US Federal Government

2052
Progress DE

2541
Vision Financial Services (USA)

2869
Vision Health Services

3078
Progress FR

3200
Vision Leasing

3535
Vision Taiwan

3536
Vision Thailand

3537
Vision Switzerland

3561
Vision Czech

3562
Vision Poland

3603
Vision Finland

3623
Vision Greece

3643
Vision Utilities

3644
Vision Utilities HQ

3647
Vision Norway

3687
Vision Argentina

3812
Sao Paulo (BR)

3813
Rio de Janeiro (BR)

3944
Vision Portugal

3964
Vision Chile

3965
Vision Denmark

3966
Vision Hungary

3968
Vision Turkey

4044
Vision Columbia

4225
Progress Transportation

4555
Vision China

4698
Vision Project Manufacturing USD

4843
Progress Canada

5186
Vision Construction

5317
ITSA OU/INV

5379
Vision Russia

6646
Progress BE

6666
Progress UK Health Services

6946
Vision Romania

7046
Vision India Hyderabad

7047
Vision India Mumbai

7186
SSC US 01

7188
SSC US 02

7206
SSC Italy

7207
SSC France

7328
Vision Ukraine

7831
2546RT France OU

68 rows selected.

--> Multi-Currency enabled?

Yes

1 row selected.

--> Registered Applications

ID Short name Basepath
------ ---------- --------
0 FND FND_TOP
1 SYSADMIN FND_TOP
3 AU AU_TOP
40 EMS EMS_TOP
41 PTX PTX_TOP
50 AD AD_TOP
60 SHT SHT_TOP
99 OAM OAM_TOP
101 SQLGL GL_TOP
140 OFA FA_TOP
160 ALR ALR_TOP
168 RG RG_TOP
170 CS CS_TOP
172 CCT CCT_TOP
174 ECX ECX_TOP
175 EC EC_TOP
177 POS POS_TOP
178 ICX ICX_TOP
185 XTR XTR_TOP
186 QRM QRM_TOP
190 AZ AZ_TOP
191 BIS BIS_TOP
200 SQLAP AP_TOP
201 PO PO_TOP
202 CHV CHV_TOP
203 AME AME_TOP
204 XLE XLE_TOP
205 IA IA_TOP
206 LNS LNS_TOP
207 IPM IPM_TOP
210 ZPB ZPB_TOP
222 AR AR_TOP
230 ITG ITG_TOP
231 BNE BNE_TOP
235 ZX ZX_TOP
240 PN PN_TOP
242 AMW AMW_TOP
250 QA QA_TOP
260 CE CE_TOP
265 FRM FRM_TOP
266 GCS GCS_TOP
270 EAA EAA_TOP
271 BSC BSC_TOP
272 ABM ABM_TOP
273 EVM EVM_TOP
274 FEM FEM_TOP
275 PA PA_TOP
278 IZU IZU_TOP
279 AS AS_TOP
280 ASN ASN_TOP
283 CN CN_TOP
298 POM POM_TOP
300 OE OE_TOP
385 WMS WMS_TOP
388 WPS WPS_TOP
390 MST MST_TOP
396 PON PON_TOP
401 INV INV_TOP
403 MIA MIA_TOP
405 MWA MWA_TOP
407 WMA WMA_TOP
410 WSM WSM_TOP
415 ISX ISX_TOP
420 IPD IPD_TOP
425 MQA MQA_TOP
426 EAM EAM_TOP
429 DNA DNA_TOP
430 DDD DDD_TOP
431 EGO EGO_TOP
432 DOM DOM_TOP
435 FUN FUN_TOP
436 BLC BLC_TOP
437 RCM RCM_TOP
438 ITA ITA_TOP
440 FPA FPA_TOP
450 FII FII_TOP
451 OPI OPI_TOP
452 POA POA_TOP
453 HRI HRI_TOP
454 ISC ISC_TOP
455 ENI ENI_TOP
501 AN AN_TOP
502 PBR PBR_TOP
505 ZFA ZFA_TOP
506 ZSA ZSA_TOP
507 PFT PFT_TOP
508 FTP FTP_TOP
509 RMG RMG_TOP
510 OKC OKC_TOP
511 CSC CSC_TOP
512 CSD CSD_TOP
513 CSF CSF_TOP
514 CSS CSS_TOP
515 OKS OKS_TOP
516 ME ME_TOP
517 BIM BIM_TOP
518 BIC BIC_TOP
519 IES IES_TOP
520 AMV AMV_TOP
521 AST AST_TOP
522 ASF ASF_TOP
523 CSP CSP_TOP
524 OKX OKX_TOP
525 ODQ ODQ_TOP
530 AMS AMS_TOP
531 XNM XNM_TOP
532 XNC XNC_TOP
533 XNS XNS_TOP
534 XNP XNP_TOP
535 XDP XDP_TOP
536 XNA XNA_TOP
537 XNT XNT_TOP
538 FPT FPT_TOP
539 IEO IEO_TOP
540 OKL OKL_TOP
541 OKR OKR_TOP
542 CSI CSI_TOP
543 CUE CUE_TOP
544 ASL ASL_TOP
545 IEC IEC_TOP
546 IEV IEV_TOP
547 IET IET_TOP
548 IEP IEP_TOP
549 IBC IBC_TOP
550 GMA GMA_TOP
551 GMI GMI_TOP
552 GMD GMD_TOP
553 GME GME_TOP
554 GMP GMP_TOP
555 GMF GMF_TOP
556 GML GML_TOP
557 GR GR_TOP
558 PMI PMI_TOP
559 GMW GMW_TOP
560 GMO GMO_TOP
600 AX AX_TOP
601 AK AK_TOP
602 XLA XLA_TOP
603 XDO XDO_TOP
660 ONT ONT_TOP
661 QP QP_TOP
662 RLM RLM_TOP
663 VEA VEA_TOP
665 WSH WSH_TOP
666 IBW IBW_TOP
667 QPR QPR_TOP
670 IBA IBA_TOP
671 IBE IBE_TOP
672 IBU IBU_TOP
673 IBY IBY_TOP
674 IBP IBP_TOP
675 IBT IBT_TOP
676 BIL BIL_TOP
677 BIX BIX_TOP
678 BIE BIE_TOP
679 BIN BIN_TOP
680 IEM IEM_TOP
681 OZP OZP_TOP
682 OZF OZF_TOP
683 OZS OZS_TOP
689 ASG ASG_TOP
690 JTF JTF_TOP
691 PV PV_TOP
694 PRP PRP_TOP
695 IEX IEX_TOP
696 IEU IEU_TOP
697 ASO ASO_TOP
698 CSR CSR_TOP
699 IEB IEB_TOP
700 MFG MFG_TOP
701 CLN CLN_TOP
702 BOM BOM_TOP
703 ENG ENG_TOP
704 MRP MRP_TOP
705 CRP CRP_TOP
706 WIP WIP_TOP
707 CST BOM_TOP
708 CZ CZ_TOP
709 EDR EDR_TOP
710 RLA RLA_TOP
711 VEH VEH_TOP
712 PJM PJM_TOP
714 FLM FLM_TOP
716 FTE FTE_TOP
718 RRS RRS_TOP
719 RRC RRC_TOP
722 MSD MSD_TOP
723 MSO MSO_TOP
724 MSC MSC_TOP
725 RHX RHX_TOP
726 MSR MSR_TOP
747 GNI GNI_TOP
777 OKE OKE_TOP
778 JMF JMF_TOP
800 PER PER_TOP
801 PAY PAY_TOP
802 FF FF_TOP
803 DT DT_TOP
804 SSP SSP_TOP
805 BEN BEN_TOP
808 HXT HXT_TOP
809 HXC HXC_TOP
810 OTA OTA_TOP
821 IRC IRC_TOP
860 MIV MIV_TOP
861 IMT IMT_TOP
862 BIV BIV_TOP
863 BIY BIY_TOP
864 AHM AHM_TOP
865 OKB OKB_TOP
866 CUG CUG_TOP
867 AHL AHL_TOP
868 CSL CSL_TOP
869 ASP ASP_TOP
870 OKI OKI_TOP
871 OKO OKO_TOP
872 XNI XNI_TOP
873 CSE CSE_TOP
874 JTM JTM_TOP
875 JTS JTS_TOP
876 OKP OKP_TOP
877 OKT OKT_TOP
878 IAM IAM_TOP
879 IMC IMC_TOP
880 QOT QOT_TOP
881 XNB XNB_TOP
882 AMF AMF_TOP
883 CSM CSM_TOP
1292 PJI PJI_TOP
1776 DUMMY_GMO DUMMY_GM
O_TOP

3000 HCC HCC_TOP
3001 HCN HCN_TOP
3002 CTB CTB_TOP
3003 HCP HCP_TOP
3004 HCA HCA_TOP
3005 HCT HCT_TOP
3006 CDR CDR_TOP
7000 JA JA_TOP
7002 JE JE_TOP
7003 JG JG_TOP
7004 JL JL_TOP
8301 GHR GHR_TOP
8302 PQH PQH_TOP
8303 PQP PQP_TOP
8400 IGI IGI_TOP
8401 PSB PSB_TOP
8402 GMS GMS_TOP
8403 PSP PSP_TOP
8404 IGW IGW_TOP
8405 IGS IGS_TOP
8406 IGF IGF_TOP
8407 IGC IGC_TOP
8450 PSA PSA_TOP
8721 IPA IPA_TOP
8722 CUI CUI_TOP
8723 CUP CUP_TOP
8724 CUF CUF_TOP
8725 CUR CUR_TOP
8726 CUC CUC_TOP
8727 CUS CUS_TOP
8729 CUN CUN_TOP
8731 CUA CUA_TOP
8901 FV FV_TOP
9000 DPP DPP_TOP
9001 MTH MTH_TOP
9003 DDR DDR_TOP
9004 INL INL_TOP
13014 CLE CLE_TOP
13015 CLL CLL_TOP
13016 CLJ CLJ_TOP
13017 CLA CLA_TOP
20001 DEM DEM_TOP
20021 CLR CLR_TOP
20041 ADS ADS_TOP
20061 CUSTOM CUST_TOP
20062 ADS_DEV ADS_TOP
20063 PRGC PRGC_TOP
20064 BANKING BANKING
20065 COREBANK COREBANK
ING

20066 INSTITBANK INSTITBA
NK

20090 CPGC CPGC_TOP
20114 OUC OUC_TOP
20139 PSR PSR_TOP
20159 TEST TST_TOP
20160 OKC_REP_TX OKC_TOP
T_INDEX_SY
NC

20161 OKC_REP_TX OKC_TOP
T_INDEX_OP
TIMIZE

20180 CSN CSN_TOP
20200 DEM01 DEM_TOP

288 rows selected.

--> Registered ORACLE Schemas

ID Schema Inst Grp Type In DBA_USERS? Default TS Temp TS
------ ------------ -------- ---- ------------- ------------ ------------
0 APPLSYS 0 E Yes APPS_TS_TX_D TEMP
ATA

1 APPLSYSPUB 0 C Yes APPS_TS_TX_D TEMP
ATA

103 GL 0 A Yes APPS_TS_TX_D TEMP
ATA

140 FA 0 A Yes APPS_TS_TX_D TEMP
ATA

168 RG 0 A Yes APPS_TS_TX_D TEMP
ATA

170 CS 1 A Yes APPS_TS_TX_D TEMP
ATA

172 CCT 1 A Yes APPS_TS_TX_D TEMP
ATA

174 ECX 1 A Yes APPS_TS_TX_D TEMP
ATA

175 EC 1 A Yes APPS_TS_TX_D TEMP
ATA

177 POS 1 A Yes APPS_TS_TX_D TEMP
ATA

178 ICX 0 A Yes APPS_TS_TX_D TEMP
ATA

185 XTR 1 A Yes APPS_TS_TX_D TEMP
ATA

186 QRM 0 A Yes APPS_TS_TX_D TEMP
ATA

190 AZ 0 A Yes APPS_TS_TX_D TEMP
ATA

191 BIS 0 A Yes APPS_TS_TX_D TEMP
ATA

200 AP 1 A Yes APPS_TS_TX_D TEMP
ATA

201 PO 1 A Yes APPS_TS_TX_D TEMP
ATA

204 XLE 0 A Yes APPS_TS_TX_D TEMP
ATA

205 IA 0 A Yes APPS_TS_TX_D TEMP
ATA

206 LNS 0 A Yes APPS_TS_TX_D TEMP
ATA

207 IPM 0 A Yes APPS_TS_TX_D TEMP
ATA

210 ZPB 0 A Yes APPS_TS_TX_D TEMP
ATA

222 AR 1 A Yes APPS_TS_TX_D TEMP
ATA

230 ITG 0 A Yes APPS_TS_TX_D TEMP
ATA

231 BNE 0 A Yes APPS_TS_TX_D TEMP
ATA

235 ZX 0 A Yes APPS_TS_TX_D TEMP
ATA

240 PN 0 A Yes APPS_TS_TX_D TEMP
ATA

242 AMW 0 A Yes APPS_TS_TX_D TEMP
ATA

250 QA 0 A Yes APPS_TS_TX_D TEMP
ATA

260 CE 1 A Yes APPS_TS_TX_D TEMP
ATA

265 FRM 0 A Yes APPS_TS_TX_D TEMP
ATA

266 GCS 0 A Yes APPS_TS_TX_D TEMP
ATA

271 BSC 0 A Yes APPS_TS_TX_D TEMP
ATA

274 FEM 0 A Yes APPS_TS_TX_D TEMP
ATA

275 PA 1 A Yes APPS_TS_TX_D TEMP
ATA

278 IZU 0 A Yes APPS_TS_TX_D TEMP
ATA

279 OSM 1 A Yes APPS_TS_TX_D TEMP
ATA

280 ASN 1 A Yes APPS_TS_TX_D TEMP
ATA

283 CN 1 A Yes APPS_TS_TX_D TEMP
ATA

298 POM 0 A Yes APPS_TS_TX_D TEMP
ATA

300 OE 1 A Yes APPS_TS_TX_D TEMP
ATA

385 WMS 1 A Yes APPS_TS_TX_D TEMP
ATA

388 WPS 1 A Yes APPS_TS_TX_D TEMP
ATA

390 MST 0 A Yes APPS_TS_TX_D TEMP
ATA

396 PON 0 A Yes APPS_TS_TX_D TEMP
ATA

401 INV 1 A Yes APPS_TS_TX_D TEMP
ATA

405 MWA 1 A Yes APPS_TS_TX_D TEMP
ATA

410 WSM 1 A Yes APPS_TS_TX_D TEMP
ATA

426 EAM 0 A Yes APPS_TS_TX_D TEMP
ATA

429 DNA 0 A Yes APPS_TS_TX_D TEMP
ATA

430 DDD 0 A Yes APPS_TS_TX_D TEMP
ATA

431 EGO 0 A Yes APPS_TS_TX_D TEMP
ATA

432 DOM 0 A Yes APPS_TS_TX_D TEMP
ATA

435 FUN 0 A Yes APPS_TS_TX_D TEMP
ATA

438 ITA 0 A Yes APPS_TS_TX_D TEMP
ATA

440 FPA 0 A Yes APPS_TS_TX_D TEMP
ATA

450 FII 1 A Yes APPS_TS_TX_D TEMP
ATA

451 OPI 1 A Yes APPS_TS_TX_D TEMP
ATA

452 POA 1 A Yes APPS_TS_TX_D TEMP
ATA

453 HRI 1 A Yes APPS_TS_TX_D TEMP
ATA

454 ISC 1 A Yes APPS_TS_TX_D TEMP
ATA

455 ENI 0 A Yes APPS_TS_TX_D TEMP
ATA

505 ZFA 0 A Yes APPS_TS_TX_D TEMP
ATA

506 ZSA 0 A Yes APPS_TS_TX_D TEMP
ATA

507 PFT 0 A Yes APPS_TS_TX_D TEMP
ATA

508 FTP 0 A Yes APPS_TS_TX_D TEMP
ATA

510 OKC 1 A Yes APPS_TS_TX_D TEMP
ATA

511 CSC 1 A Yes APPS_TS_TX_D TEMP
ATA

512 CSD 1 A Yes APPS_TS_TX_D TEMP
ATA

513 CSF 1 A Yes APPS_TS_TX_D TEMP
ATA

515 OKS 1 A Yes APPS_TS_TX_D TEMP
ATA

517 BIM 1 A Yes APPS_TS_TX_D TEMP
ATA

518 BIC 1 A Yes APPS_TS_TX_D TEMP
ATA

519 IES 1 A Yes APPS_TS_TX_D TEMP
ATA

520 AMV 1 A Yes APPS_TS_TX_D TEMP
ATA

521 AST 1 A Yes APPS_TS_TX_D TEMP
ATA

522 ASF 1 A Yes APPS_TS_TX_D TEMP
ATA

523 CSP 1 A Yes APPS_TS_TX_D TEMP
ATA

524 OKX 1 A Yes APPS_TS_TX_D TEMP
ATA

530 AMS 1 A Yes APPS_TS_TX_D TEMP
ATA

534 XNP 1 A Yes APPS_TS_TX_D TEMP
ATA

535 XDP 1 A Yes APPS_TS_TX_D TEMP
ATA

539 IEO 1 A Yes APPS_TS_TX_D TEMP
ATA

540 OKL 1 A Yes APPS_TS_TX_D TEMP
ATA

542 CSI 1 A Yes APPS_TS_TX_D TEMP
ATA

544 ASL 1 A Yes APPS_TS_TX_D TEMP
ATA

545 IEC 1 A Yes APPS_TS_TX_D TEMP
ATA

549 IBC 1 A Yes APPS_TS_TX_D TEMP
ATA

550 GMA 1 A Yes APPS_TS_TX_D TEMP
ATA

551 GMI 1 A Yes APPS_TS_TX_D TEMP
ATA

552 GMD 1 A Yes APPS_TS_TX_D TEMP
ATA

553 GME 1 A Yes APPS_TS_TX_D TEMP
ATA

554 GMP 1 A Yes APPS_TS_TX_D TEMP
ATA

555 GMF 1 A Yes APPS_TS_TX_D TEMP
ATA

556 GML 1 A Yes APPS_TS_TX_D TEMP
ATA

557 GR 1 A Yes APPS_TS_TX_D TEMP
ATA

558 PMI 1 A Yes APPS_TS_TX_D TEMP
ATA

560 GMO 0 A Yes APPS_TS_TX_D TEMP
ATA

600 AX 0 A Yes APPS_TS_TX_D TEMP
ATA

601 AK 0 A Yes APPS_TS_TX_D TEMP
ATA

602 XLA 0 A Yes APPS_TS_TX_D TEMP
ATA

603 XDO 0 A Yes APPS_TS_TX_D TEMP
ATA

660 ONT 1 A Yes APPS_TS_TX_D TEMP
ATA

661 QP 1 A Yes APPS_TS_TX_D TEMP
ATA

662 RLM 0 A Yes APPS_TS_TX_D TEMP
ATA

663 VEA 0 A Yes APPS_TS_TX_D TEMP
ATA

665 WSH 1 A Yes APPS_TS_TX_D TEMP
ATA

666 IBW 1 A Yes APPS_TS_TX_D TEMP
ATA

667 QPR 0 A Yes APPS_TS_TX_D TEMP
ATA

671 IBE 1 A Yes APPS_TS_TX_D TEMP
ATA

672 IBU 1 A Yes APPS_TS_TX_D TEMP
ATA

673 IBY 1 A Yes APPS_TS_TX_D TEMP
ATA

674 IBP 1 A Yes APPS_TS_TX_D TEMP
ATA

676 BIL 1 A Yes APPS_TS_TX_D TEMP
ATA

677 BIX 1 A Yes APPS_TS_TX_D TEMP
ATA

680 IEM 1 A Yes APPS_TS_TX_D TEMP
ATA

682 OZF 1 A Yes APPS_TS_TX_D TEMP
ATA

689 ASG 1 A Yes APPS_TS_TX_D TEMP
ATA

690 JTF 1 A Yes APPS_TS_TX_D TEMP
ATA

691 PV 1 A Yes APPS_TS_TX_D TEMP
ATA

692 JTI 1 A Yes APPS_TS_TX_D TEMP
ATA

693 JTR 1 A Yes APPS_TS_TX_D TEMP
ATA

694 PRP 1 A Yes APPS_TS_TX_D TEMP
ATA

695 IEX 1 A Yes APPS_TS_TX_D TEMP
ATA

696 IEU 1 A Yes APPS_TS_TX_D TEMP
ATA

697 ASO 1 A Yes APPS_TS_TX_D TEMP
ATA

698 CSR 1 A Yes APPS_TS_TX_D TEMP
ATA

699 IEB 1 A Yes APPS_TS_TX_D TEMP
ATA

700 MFG 1 A Yes APPS_TS_TX_D TEMP
ATA

701 CLN 0 A Yes APPS_TS_TX_D TEMP
ATA

702 BOM 1 A Yes APPS_TS_TX_D TEMP
ATA

703 ENG 1 A Yes APPS_TS_TX_D TEMP
ATA

704 MRP 1 A Yes APPS_TS_TX_D TEMP
ATA

705 CRP 1 A Yes APPS_TS_TX_D TEMP
ATA

706 WIP 1 A Yes APPS_TS_TX_D TEMP
ATA

708 CZ 1 A Yes APPS_TS_TX_D TEMP
ATA

709 EDR 0 A Yes APPS_TS_TX_D TEMP
ATA

712 PJM 1 A Yes APPS_TS_TX_D TEMP
ATA

714 FLM 1 A Yes APPS_TS_TX_D TEMP
ATA

716 FTE 0 A Yes APPS_TS_TX_D TEMP
ATA

718 RRS 0 A Yes APPS_TS_TX_D TEMP
ATA

722 MSD 1 A Yes APPS_TS_TX_D TEMP
ATA

723 MSO 1 A Yes APPS_TS_TX_D TEMP
ATA

724 MSC 1 A Yes APPS_TS_TX_D TEMP
ATA

726 MSR 0 A Yes APPS_TS_TX_D TEMP
ATA

777 OKE 1 A Yes APPS_TS_TX_D TEMP
ATA

778 JMF 0 A Yes APPS_TS_TX_D TEMP
ATA

800 HR 0 A Yes APPS_TS_TX_D TEMP
ATA

804 SSP 0 A Yes APPS_TS_TX_D TEMP
ATA

805 BEN 0 A Yes APPS_TS_TX_D TEMP
ATA

808 HXT 0 A Yes APPS_TS_TX_D TEMP
ATA

809 HXC 0 A Yes APPS_TS_TX_D TEMP
ATA

810 OTA 0 A Yes APPS_TS_TX_D TEMP
ATA

862 BIV 1 A Yes APPS_TS_TX_D TEMP
ATA

866 CUG 1 A Yes APPS_TS_TX_D TEMP
ATA

867 AHL 1 A Yes APPS_TS_TX_D TEMP
ATA

868 CSL 1 A Yes APPS_TS_TX_D TEMP
ATA

869 ASP 1 A Yes APPS_TS_TX_D TEMP
ATA

870 OKI 1 A Yes APPS_TS_TX_D TEMP
ATA

873 CSE 1 A Yes APPS_TS_TX_D TEMP
ATA

874 JTM 1 A Yes APPS_TS_TX_D TEMP
ATA

875 JTS 1 A Yes APPS_TS_TX_D TEMP
ATA

879 IMC 0 A Yes APPS_TS_TX_D TEMP
ATA

880 QOT 1 A Yes APPS_TS_TX_D TEMP
ATA

881 XNB 1 A Yes APPS_TS_TX_D TEMP
ATA

883 CSM 0 A Yes APPS_TS_TX_D TEMP
ATA

900 APPS 1 U Yes APPS_TS_TX_D TEMP
ATA

1292 PJI 0 A Yes APPS_TS_TX_D TEMP
ATA

7000 JA 1 A Yes APPS_TS_TX_D TEMP
ATA

7003 JG 1 A Yes APPS_TS_TX_D TEMP
ATA

7004 JL 1 A Yes APPS_TS_TX_D TEMP
ATA

8400 IGI 0 A Yes APPS_TS_TX_D TEMP
ATA

8401 PSB 1 A Yes APPS_TS_TX_D TEMP
ATA

8402 GMS 1 A Yes APPS_TS_TX_D TEMP
ATA

8403 PSP 1 A Yes APPS_TS_TX_D TEMP
ATA

8404 IGW 1 A Yes APPS_TS_TX_D TEMP
ATA

8405 IGS 1 A Yes APPS_TS_TX_D TEMP
ATA

8406 IGF 1 A Yes APPS_TS_TX_D TEMP
ATA

8407 IGC 1 A Yes APPS_TS_TX_D TEMP
ATA

8450 PSA 1 A Yes APPS_TS_TX_D TEMP
ATA

8721 IPA 1 A Yes APPS_TS_TX_D TEMP
ATA

8722 CUI 1 A Yes APPS_TS_TX_D TEMP
ATA

8723 CUP 1 A Yes APPS_TS_TX_D TEMP
ATA

8724 CUF 1 A Yes APPS_TS_TX_D TEMP
ATA

8727 CUS 1 A Yes APPS_TS_TX_D TEMP
ATA

8731 CUA 1 A Yes APPS_TS_TX_D TEMP
ATA

8901 FV 1 A Yes APPS_TS_TX_D TEMP
ATA

9000 DPP 1 A Yes APPS_TS_TX_D TEMP
ATA

9001 MTH 0 A Yes APPS_TS_TX_D TEMP
ATA

9003 DDR 0 A Yes APPS_TS_TX_D TEMP
ATA

9004 INL 0 A Yes APPS_TS_TX_D TEMP
ATA

20001 APPS_US 1 D No Unknown Unknown
20002 APPS_UK 1 D No Unknown Unknown
20003 APPS_JP 1 D No Unknown Unknown
20004 APPS_CAN 1 D No Unknown Unknown
20005 APPS_DIST 1 D No Unknown Unknown
20045 APPS_SERV 1 D No Unknown Unknown
20065 APPS_ADB 1 D No Unknown Unknown
20085 RESTRICTED_U 0 D Yes APPS_TS_TX_D TEMP
S ATA

20129 CTXSYS X Yes CTXSYS TEMP
20149 EDWREP 1 A No Unknown Unknown
20169 ODM X Yes ODM_DATA TEMP
20170 AUTHORIA 1 A Yes APPS_TS_TX_D TEMP
ATA

20171 SMS 1 A No Unknown Unknown
20172 ILEARN41 1 A Yes APPS_TS_TX_D TEMP
ATA

20173 ILEARN41_RPT 1 A Yes APPS_TS_TX_D TEMP
ATA

20174 DGRAY 1 A Yes APPS_TS_TX_D TEMP
ATA

20175 ADSEUL_US 1 A Yes APPS_TS_TX_D TEMP
ATA

20176 PORTAL30_DEM 1 A No Unknown Unknown
O

20178 PORTAL30_PUB 1 A No Unknown Unknown
LIC

20180 HCC 1 A Yes APPS_TS_TX_D TEMP
ATA

20181 OWAPUB X Yes OWAPUB TEMP
20182 ADS 1 A No Unknown Unknown
20183 CFD 1 A Yes APPS_TS_TX_D TEMP
ATA

20184 SCOTT 1 A Yes APPS_TS_TX_D TEMP
ATA

20185 SERVICES 1 A Yes APPS_TS_TX_D TEMP
ATA

20186 DMS 1 A Yes APPS_TS_TX_D TEMP
ATA

20187 WH 1 A Yes APPS_TS_TX_D TEMP
ATA

20189 RE X Yes RE TEMP
20190 MTR X Yes MTR TEMP
20209 PORTAL30_SSO X No Unknown Unknown
20210 PORTAL30 X No Unknown Unknown

222 rows selected.

--> Product Installation Status, Version Info and Patch Level

Product Appl Status Version Patchset Level Update Date
-------- -------------- -------- -------------------- --------------------
AD Shared 12.0.0 R12.AD.B.3 26-Mar-2009
AHL Installed 12.0.0 R12.AHL.B.3 26-Mar-2009
AK Installed 12.0.0 R12.AK.B.3 26-Mar-2009
ALR Installed 12.0.0 R12.ALR.B.3 26-Mar-2009
AME Installed 12.0.0 R12.AME.B.3 26-Mar-2009
AMS Installed 12.0.0 R12.AMS.B.3 26-Mar-2009
AMV Shared 12.0.0 R12.AMV.B.3 26-Mar-2009
AMW Installed 12.0.0 R12.AMW.B.3 26-Mar-2009
AP Installed 12.0.0 R12.AP.B.3 26-Mar-2009
AR Installed 12.0.0 R12.AR.B.3 26-Mar-2009
AS Installed 12.0.0 R12.AS.B.3 26-Mar-2009
ASF Installed 12.0.0 R12.ASF.B.3 26-Mar-2009
ASG Shared 12.0.0 R12.ASG.B.3 26-Mar-2009
ASL Installed 12.0.0 R12.ASL.B.3 26-Mar-2009
ASN Installed 12.0.0 R12.ASN.B.3 26-Mar-2009
ASO Installed 12.0.0 R12.ASO.B.3 26-Mar-2009
ASP Installed 12.0.0 R12.ASP.B.3 26-Mar-2009
AST Installed 12.0.0 R12.AST.B.3 26-Mar-2009
AU Installed 12.0.0 -- Not Available -- 26-Mar-2009
AX Installed 12.0.0 11i.AX.J 26-Mar-2009
AZ Installed 12.0.0 R12.AZ.B.3 26-Mar-2009
BEN Installed 12.0.0 R12.BEN.B.3 26-Mar-2009
BIC Installed 12.0.0 R12.BIC.B.3 26-Mar-2009
BIL Installed 12.0.0 R12.BIL.B.3 26-Mar-2009
BIM Installed 12.0.0 R12.BIM.B.3 26-Mar-2009
BIS Installed 12.0.0 R12.BIS.B.3 26-Mar-2009
BIV Installed 12.0.0 R12.BIV.B.3 26-Mar-2009
BIX Installed 12.0.0 R12.BIX.B.3 26-Mar-2009
BNE Installed 12.0.0 R12.BNE.B.3 26-Mar-2009
BOM Installed 12.0.0 R12.BOM.C.3 26-Mar-2009
BSC Installed 12.0.0 R12.BSC.B.3 26-Mar-2009
CCT Installed 12.0.0 R12.CCT.B.3 26-Mar-2009
CE Installed 12.0.0 R12.CE.B.3 26-Mar-2009
CHV Installed 12.0.0 R12.CHV.B.3 26-Mar-2009
CLN Installed 12.0.0 R12.CLN.C.3 26-Mar-2009
CN Installed 12.0.0 R12.CN.B.3 26-Mar-2009
CRP Installed 12.0.0 R12.CRP.B.3 26-Mar-2009
CS Installed 12.0.0 R12.CS.B.3 26-Mar-2009
CSC Installed 12.0.0 R12.CSC.B.3 26-Mar-2009
CSD Installed 12.0.0 R12.CSD.B.3 26-Mar-2009
CSE Installed 12.0.0 R12.CSE.B.3 26-Mar-2009
CSF Installed 12.0.0 R12.CSF.B.3 26-Mar-2009
CSI Installed 12.0.0 R12.CSI.B.3 26-Mar-2009
CSL Installed 12.0.0 R12.CSL.B.3 26-Mar-2009
CSM Installed 12.0.0 R12.CSM.B.3 26-Mar-2009
CSP Installed 12.0.0 R12.CSP.B.3 26-Mar-2009
CSR Installed 12.0.0 R12.CSR.B.3 26-Mar-2009
CUA Shared 12.0.0 -- Not Available -- 26-Mar-2009
CUF Installed 12.0.0 -- Not Available -- 26-Mar-2009
CUG Installed 12.0.0 R12.CUG.B.3 26-Mar-2009
CUI Shared 12.0.0 -- Not Available -- 26-Mar-2009
CUP Shared 12.0.0 -- Not Available -- 26-Mar-2009
CUS Installed 12.0.0 -- Not Available -- 26-Mar-2009
CZ Installed 12.0.0 R12.CZ.B.3 26-Mar-2009
DDD Installed 12.0.0 R12.DDD.C.3 26-Mar-2009
DDR Installed 12.0.0 R12.DDR.B.3 26-Mar-2009
DNA Installed 12.0.0 R12.DNA.C.3 26-Mar-2009
DOM Installed 12.0.0 R12.DOM.B.3 26-Mar-2009
DPP Installed 12.0.0 R12.DPP.B.3 26-Mar-2009
DT Shared 12.0.0 R12.DT.B.3 26-Mar-2009
EAM Installed 12.0.0 R12.EAM.B.3 26-Mar-2009
EC Installed 12.0.0 R12.EC.B.3 26-Mar-2009
ECX Installed 12.0.0 R12.ECX.B.3 26-Mar-2009
EDR Installed 12.0.0 R12.EDR.B.3 26-Mar-2009
EGO Installed 12.0.0 R12.EGO.C.3 26-Mar-2009
ENG Installed 12.0.0 R12.ENG.C.3 26-Mar-2009
ENI Installed 12.0.0 R12.ENI.B.3 26-Mar-2009
FA Installed 12.0.0 R12.FA.B.3 26-Mar-2009
FEM Installed 12.0.0 R12.FEM.B.3 26-Mar-2009
FF Shared 12.0.0 R12.FF.B.3 26-Mar-2009
FII Installed 12.0.0 R12.FII.B.3 26-Mar-2009
FLM Installed 12.0.0 R12.FLM.B.3 26-Mar-2009
FND Installed 12.0.0 R12.FND.B.3 26-Mar-2009
FPA Installed 12.0.0 R12.FPA.B.3 26-Mar-2009
FRM Installed 12.0.0 R12.FRM.B.3 26-Mar-2009
FTE Installed 12.0.0 R12.FTE.B 26-Mar-2009
FTP Installed 12.0.0 R12.FTP.B.3 26-Mar-2009
FUN Installed 12.0.0 R12.FUN.B.3 26-Mar-2009
FV Installed 12.0.0 R12.FV.B.3 26-Mar-2009
GCS Installed 12.0.0 R12.GCS.B.3 26-Mar-2009
GHR Installed 12.0.0 R12.GHR.B.3 26-Mar-2009
GL Installed 12.0.0 R12.GL.B.3 26-Mar-2009
GMA Installed 12.0.0 R12.GMA.B.3 26-Mar-2009
GMD Installed 12.0.0 R12.GMD.B.3 26-Mar-2009
GME Installed 12.0.0 R12.GME.B.3 26-Mar-2009
GMF Installed 12.0.0 R12.GMF.B.3 26-Mar-2009
GMI Installed 12.0.0 R12.GMI.B.3 26-Mar-2009
GML Installed 12.0.0 R12.GML.B.3 26-Mar-2009
GMO Installed 12.0.0 R12.GMO.B.3 26-Mar-2009
GMP Installed 12.0.0 R12.GMP.B.3 26-Mar-2009
GMS Installed 12.0.0 R12.GMS.I 26-Mar-2009
GR Installed 12.0.0 R12.GR.B.3 26-Mar-2009
HRI Installed 12.0.0 R12.HRI.B.3 26-Mar-2009
HXC Installed 12.0.0 11i.HXC.C 26-Mar-2009
HXT Installed 12.0.0 R12.HXT.B.3 26-Mar-2009
IA Installed 12.0.0 R12.IA.B.3 26-Mar-2009
IBC Installed 12.0.0 R12.IBC.B.3 26-Mar-2009
IBE Installed 12.0.0 R12.IBE.B.3 26-Mar-2009
IBP Installed 12.0.0 -- Not Available -- 26-Mar-2009
IBU Installed 12.0.0 R12.IBU.B.3 26-Mar-2009
IBW Installed 12.0.0 R12.IBW.B.3 26-Mar-2009
IBY Installed 12.0.0 R12.IBY.B.3 26-Mar-2009
ICX Installed 12.0.0 R12.ICX.B.3 26-Mar-2009
IEB Installed 12.0.0 R12.IEB.B.3 26-Mar-2009
IEC Installed 12.0.0 R12.IEC.B.3 26-Mar-2009
IEM Installed 12.0.0 R12.IEM.B.3 26-Mar-2009
IEO Installed 12.0.0 R12.IEO.B.3 26-Mar-2009
IES Installed 12.0.0 R12.IES.B.3 26-Mar-2009
IEU Installed 12.0.0 R12.IEU.B.3 26-Mar-2009
IEX Installed 12.0.0 R12.IEX.B.3 26-Mar-2009
IGC Installed 12.0.0 -- Not Available -- 26-Mar-2009
IGF Installed 12.0.0 -- Not Available -- 26-Mar-2009
IGI Installed 12.0.0 R12.IGI.B.3 26-Mar-2009
IGS Installed 12.0.0 R12.IGS.A.2 26-Mar-2009
IGW Installed 12.0.0 R12.IGW.B.3 26-Mar-2009
IMC Installed 12.0.0 R12.IMC.B.3 26-Mar-2009
INL Installed 12.0.0 R12.INL.B.3 26-Mar-2009
INV Installed 12.0.0 R12.INV.B.3 26-Mar-2009
IPA Shared 12.0.0 R12.IPA.B.3 26-Mar-2009
IPM Installed 12.0.0 -- Not Available -- 26-Mar-2009
IRC Installed 12.0.0 R12.IRC.B.3 26-Mar-2009
ISC Installed 12.0.0 R12.ISC.B.3 26-Mar-2009
ITA Installed 12.0.0 R12.ITA.B.3 26-Mar-2009
ITG Installed 12.0.0 R12.ITG.B.3 26-Mar-2009
IZU Installed 12.0.0 R12.IZU.B.3 26-Mar-2009
JA Installed 12.0.0 R12.JA.B.3 07-Oct-2002
JE Installed 12.0.0 R12.JE.B.3 07-Oct-2002
JG Installed 12.0.0 R12.JG.B.3 26-Mar-2009
JL Installed 12.0.0 R12.JL.B.3 07-Oct-2002
JMF Installed 12.0.0 R12.JMF.B.3 26-Mar-2009
JTF Installed 12.0.0 R12.JTF.B.3 26-Mar-2009
JTM Installed 12.0.0 R12.JTM.B.3 26-Mar-2009
JTS Installed 12.0.0 11i.JTS.E 28-Oct-2005
LNS Installed 12.0.0 R12.LNS.B.3 26-Mar-2009
MFG Shared 12.0.0 R12.MFG.B.3 26-Mar-2009
MRP Installed 12.0.0 R12.MRP.B.3 26-Mar-2009
MSC Installed 12.0.0 R12.MSC.B.3 26-Mar-2009
MSD Installed 12.0.0 R12.MSD.B.3 26-Mar-2009
MSO Installed 12.0.0 R12.MSO.B.3 26-Mar-2009
MSR Installed 12.0.0 R12.MSR.B.3 26-Mar-2009
MST Installed 12.0.0 R12.MST.B 26-Mar-2009
MTH Installed 12.0.0 R12.MTH.B.3 26-Mar-2009
MWA Installed 12.0.0 R12.MWA.B.3 26-Mar-2009
OE Shared 12.0.0 R12.OE.B.3 26-Mar-2009
OKC Installed 12.0.0 R12.OKC.B.3 26-Mar-2009
OKE Installed 12.0.0 R12.OKE.H 26-Mar-2009
OKI Installed 12.0.0 R12.OKI.B.3 26-Mar-2009
OKL Installed 12.0.0 R12.OKL.B.3 26-Mar-2009
OKS Installed 12.0.0 R12.OKS.B.3 26-Mar-2009
OKX Installed 12.0.0 R12.OKX.B.3 26-Mar-2009
ONT Installed 12.0.0 R12.ONT.B.3 26-Mar-2009
OPI Installed 12.0.0 R12.OPI.B.3 26-Mar-2009
OTA Installed 12.0.0 R12.OTA.B.3 26-Mar-2009
OZF Installed 12.0.0 R12.OZF.B.3 26-Mar-2009
PA Installed 12.0.0 R12.PA.B.3 26-Mar-2009
PAY Installed 12.0.0 R12.PAY.B.3 26-Mar-2009
PER Installed 12.0.0 R12.PER.B.3 26-Mar-2009
PFT Installed 12.0.0 R12.PFT.B.3 26-Mar-2009
PJI Installed 12.0.0 R12.PJI.B.3 26-Mar-2009
PJM Installed 12.0.0 R12.PJM.B.3 26-Mar-2009
PMI Installed 12.0.0 R12.PMI.B.3 26-Mar-2009
PN Installed 12.0.0 R12.PN.B.3 26-Mar-2009
PO Installed 12.0.0 R12.PO.B.3 26-Mar-2009
POA Installed 12.0.0 R12.POA.B.3 26-Mar-2009
POM Installed 12.0.0 R12.POM.B.3 26-Mar-2009
PON Installed 12.0.0 R12.PON.B.3 26-Mar-2009
POS Installed 12.0.0 R12.POS.B.3 26-Mar-2009
PQH Installed 12.0.0 R12.PQH.B.3 26-Mar-2009
PQP Installed 12.0.0 R12.PQP.B.3 26-Mar-2009
PRP Installed 12.0.0 R12.PRP.B.3 26-Mar-2009
PSA Installed 12.0.0 R12.PSA.B.3 26-Mar-2009
PSB Installed 12.0.0 R12.PSB.B.3 26-Mar-2009
PSP Installed 12.0.0 R12.PSP.B.3 26-Mar-2009
PV Installed 12.0.0 R12.PV.B.3 26-Mar-2009
QA Installed 12.0.0 R12.QA.B.3 26-Mar-2009
QOT Installed 12.0.0 R12.QOT.B.3 26-Mar-2009
QP Installed 12.0.0 R12.QP.B.3 26-Mar-2009
QPR Installed 12.0.0 R12.QPR.C.3 26-Mar-2009
QRM Installed 12.0.0 R12.QRM.B.3 26-Mar-2009
RG Installed 12.0.0 R12.RG.B.3 26-Mar-2009
RLM Installed 12.0.0 R12.RLM.B.3 26-Mar-2009
RRS Installed 12.0.0 R12.RRS.B.3 26-Mar-2009
SHT Shared 12.0.0 R12.SHT.B.3 26-Mar-2009
SSP Installed 12.0.0 R12.SSP.B.3 26-Mar-2009
SYSADMIN Installed 12.0.0 -- Not Available -- 26-Mar-2009
VEA Installed 12.0.0 R12.VEA.B.3 26-Mar-2009
WIP Installed 12.0.0 R12.WIP.B.3 26-Mar-2009
WMS Installed 12.0.0 R12.WMS.B.3 26-Mar-2009
WPS Installed 12.0.0 R12.WPS.B.3 26-Mar-2009
WSH Installed 12.0.0 R12.WSH.B.3 26-Mar-2009
WSM Installed 12.0.0 R12.WSM.B.3 26-Mar-2009
XDO Installed 12.0.0 R12.XDO.B.3 26-Mar-2009
XDP Installed 12.0.0 R12.XDP.B.3 26-Mar-2009
XLA Installed 12.0.0 R12.XLA.B.3 26-Mar-2009
XLE Installed 12.0.0 R12.XLE.B.3 26-Mar-2009
XNB Installed 12.0.0 R12.XNB.B.3 26-Mar-2009
XNP Installed 12.0.0 R12.XNP.B.3 26-Mar-2009
XTR Installed 12.0.0 R12.XTR.B.3 26-Mar-2009
ZFA Installed 12.0.0 -- Not Available -- 28-Oct-2005
ZPB Installed 12.0.0 R12.ZPB.B.3 26-Mar-2009
ZSA Installed 12.0.0 -- Not Available -- 28-Oct-2005
ZX Installed 12.0.0 R12.ZX.B.3 26-Mar-2009
id 692 Installed 12.0.0 -- Not Available -- 21-Dec-1999
id 693 Installed 12.0.0 -- Not Available -- 21-Dec-1999

204 rows selected.

--> Product Database Configuration

Product Schema DB Status Inst Grp Size% Main TS Index TS
-------- ------------ ------------- -------- ------ ------------ ------------
AD APPLSYS Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

AHL AHL Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

AK AK Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ALR APPLSYS Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

AME HR Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

AMS AMS Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

AMV AMV Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

AMW AMW Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

AP AP Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

AR AR Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

AS OSM Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ASF ASF Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ASG ASG Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ASL ASL Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ASN ASN Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ASO ASO Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ASP ASP Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

AST AST Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

AU APPLSYS Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

AX AX Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

AZ AZ Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

BEN BEN Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

BIC BIC Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

BIL BIL Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

BIM BIM Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

BIS BIS Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

BIV BIV Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

BIX BIX Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

BNE BNE Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

BOM BOM Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

BSC BSC Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CCT CCT Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CE CE Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CHV PO Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CLN CLN Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CN CN Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CRP CRP Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CS CS Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CSC CSC Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CSD CSD Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CSE CSE Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CSF CSF Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CSI CSI Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CSL CSL Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CSM CSM Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CSP CSP Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CSR CSR Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CUA CUA Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CUF CUF Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CUG CUG Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CUI CUI Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CUP CUP Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CUS CUS Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

CZ CZ Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

DDD DDD Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

DDR DDR Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

DNA DNA Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

DOM DOM Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

DPP DPP Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

DT HR Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

EAM EAM Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

EC EC Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ECX ECX Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

EDR EDR Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

EGO EGO Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ENG ENG Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ENI ENI Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

FA FA Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

FEM FEM Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

FF HR Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

FII FII Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

FLM FLM Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

FND APPLSYS Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

FPA FPA Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

FRM FRM Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

FTE FTE Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

FTP FTP Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

FUN FUN Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

FV FV Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

GCS GCS Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

GHR HR Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

GL GL Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

GMA GMA Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

GMD GMD Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

GME GME Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

GMF GMF Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

GMI GMI Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

GML GML Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

GMO GMO Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

GMP GMP Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

GMS GMS Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

GR GR Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

HRI HRI Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

HXC HXC Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

HXT HXT Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IA IA Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IBC IBC Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IBE IBE Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IBP IBP Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IBU IBU Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IBW IBW Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IBY IBY Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ICX ICX Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IEB IEB Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IEC IEC Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IEM IEM Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IEO IEO Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IES IES Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IEU IEU Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IEX IEX Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IGC IGC Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IGF IGF Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IGI IGI Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IGS IGS Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IGW IGW Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IMC IMC Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

INL INL Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

INV INV Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IPA IPA Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IPM IPM Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IRC HR Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ISC ISC Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ITA ITA Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ITG ITG Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

IZU IZU Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

JA JA Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

JE JG Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

JG JG Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

JL JL Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

JMF JMF Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

JTF JTF Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

JTM JTM Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

JTS JTS Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

LNS LNS Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

MFG MFG Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

MRP MRP Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

MSC MSC Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

MSD MSD Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

MSO MSO Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

MSR MSR Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

MST MST Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

MTH MTH Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

MWA MWA Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

OE OE Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

OKC OKC Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

OKE OKE Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

OKI OKI Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

OKL OKL Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

OKS OKS Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

OKX OKX Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ONT ONT Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

OPI OPI Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

OTA OTA Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

OZF OZF Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

PA PA Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

PAY HR Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

PER HR Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

PFT PFT Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

PJI PJI Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

PJM PJM Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

PMI PMI Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

PN PN Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

PO PO Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

POA POA Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

POM POM Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

PON PON Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

POS POS Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

PQH HR Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

PQP HR Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

PRP PRP Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

PSA PSA Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

PSB PSB Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

PSP PSP Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

PV PV Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

QA QA Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

QOT QOT Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

QP QP Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

QPR QPR Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

QRM QRM Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

RG RG Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

RLM RLM Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

RRS RRS Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

SHT APPLSYS Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

SSP SSP Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

SYSADMIN APPLSYS Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

VEA VEA Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

WIP WIP Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

WMS WMS Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

WPS WPS Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

WSH WSH Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

WSM WSM Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

XDO XDO Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

XDP XDP Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

XLA XLA Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

XLE XLE Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

XNB XNB Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

XNP XNP Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

XTR XTR Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ZFA ZFA Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ZPB ZPB Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ZSA ZSA Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

ZX ZX Installed 0 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

id 692 JTI Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

id 693 JTR Installed 1 100 APPS_TS_TX_D APPS_TS_TX_I
ATA DX

204 rows selected.

--> Localization Module Information

Product Schema Module Version Appl Status Update Date
-------- ------------ -------- -------- -------------- --------------------
JA JA jaauloc 12.0.0 Installed 11-Aug-2006
JA JA jacaloc 12.0.0 Installed 11-Aug-2006
JA JA jacnloc 12.0.0 Installed 11-Aug-2006
JA JA jajploc 12.0.0 Installed 11-Aug-2006
JA JA jakrloc 12.0.0 Installed 11-Aug-2006
JA JA jasgloc 12.0.0 Installed 11-Aug-2006
JA JA jathloc 12.0.0 Installed 11-Aug-2006
JA JA jatwloc 12.0.0 Installed 11-Aug-2006
JE JG jeatdloc 1.2.52 Installed 06-Feb-1997
JE JG jeatloc 12.0.0 Installed 11-Aug-2006
JE JG jebeloc 12.0.0 Installed 11-Aug-2006
JE JG jechloc 12.0.0 Installed 11-Aug-2006
JE JG jeczloc 12.0.0 Installed 11-Aug-2006
JE JG jedeloc 12.0.0 Installed 11-Aug-2006
JE JG jedkloc 12.0.0 Installed 11-Aug-2006
JE JG jeesloc 12.0.0 Installed 11-Aug-2006
JE JG jefiloc 12.0.0 Installed 11-Aug-2006
JE JG jefrloc 12.0.0 Installed 11-Aug-2006
JE JG jegbloc 12.0.0 Installed 11-Aug-2006
JE JG jegrloc 12.0.0 Installed 11-Aug-2006
JE JG jehuloc 12.0.0 Installed 11-Aug-2006
JE JG jeilloc 12.0.0 Installed 11-Aug-2006
JE JG jeisloc 12.0.0 Installed 11-Aug-2006
JE JG jeitloc 12.0.0 Installed 11-Aug-2006
JE JG jenlloc 12.0.0 Installed 11-Aug-2006
JE JG jenoloc 12.0.0 Installed 11-Aug-2006
JE JG jeplloc 12.0.0 Installed 11-Aug-2006
JE JG jeptloc 12.0.0 Installed 11-Aug-2006
JE JG jeseloc 12.0.0 Installed 11-Aug-2006
JE JG jetrloc 12.0.0 Installed 11-Aug-2006
JG JG jgzzloc 12.0.0 Installed 11-Aug-2006
JL JL jlarloc 12.0.0 Installed 11-Aug-2006
JL JL jlboloc 12.0.0 Installed 11-Aug-2006
JL JL jlbrloc 12.0.0 Installed 11-Aug-2006
JL JL jlclloc 12.0.0 Installed 11-Aug-2006
JL JL jlcoloc 12.0.0 Installed 11-Aug-2006
JL JL jlcrloc 12.0.0 Installed 11-Aug-2006
JL JL jldoloc 12.0.0 Installed 11-Aug-2006
JL JL jlecloc 12.0.0 Installed 11-Aug-2006
JL JL jlgtloc 12.0.0 Installed 11-Aug-2006
JL JL jlhnloc 12.0.0 Installed 11-Aug-2006
JL JL jljmloc 12.0.0 Installed 11-Aug-2006
JL JL jlmxloc 12.0.0 Installed 11-Aug-2006
JL JL jlniloc 12.0.0 Installed 11-Aug-2006
JL JL jlpaloc 12.0.0 Installed 11-Aug-2006
JL JL jlpeloc 12.0.0 Installed 11-Aug-2006
JL JL jlprloc 12.0.0 Installed 11-Aug-2006
JL JL jlpyloc 12.0.0 Installed 11-Aug-2006
JL JL jlsvloc 12.0.0 Installed 11-Aug-2006
JL JL jlttloc 12.0.0 Installed 11-Aug-2006
JL JL jluyloc 12.0.0 Installed 11-Aug-2006
JL JL jlveloc 12.0.0 Installed 11-Aug-2006

52 rows selected.

--> Registered Data Groups

ID Data Group Name Dflt Created By Updated By
------ ----------------------------- ---- ----------- ------ ----------- ------
-99 Multiple Reporting Currencies No 08-11-1997 1 08-11-1997 1
0 Standard Yes 29-04-1992 1 29-04-1992 1

2 rows selected.

--> Base language and other Installed languages

Type Code NLS Language
--------- ---- ------------------------------
Base US AMERICAN

1 row selected.

--> NLS Settings

NLS_NCHAR_CHARACTERSET: UTF8
NLS_CHARACTERSET......: AL32UTF8
NLS_DATE_FORMAT.......: DD-MON-RR
NLS_NUMERIC_CHARACTERS: .,
NLS_LANGUAGE..........: AMERICAN
NLS_SORT..............: BINARY

--> Replication Package Installed?

Not Installed

--> End of Application Information Gathering

APPS DBA MATERIAL