Skip to content

User not authorized to execute service (SBL-EAI-04308)

When i try integrate EBS and Siebel, its getting below error in siebel

Error invoking service ‘XXACE_CREATE_RECEIPTS_SIEBEL_PortType_2′, method ‘XXACE_RECEIPTS’ at step ‘Transport’.(SBL-BPR-00162)

Operation ‘XXACE_RECEIPTS’ of Web Service ‘http://xmlns.oracle.com/apps/ar/soaprovider/plsql/xxace_create_receipts_siebel/.XXACE_CREATE_RECEIPTS_SIEBEL_Service’ at port ‘XXACE_CREATE_RECEIPTS_SIEBEL_Port’ failed with the following explanation: “User not authorized to execute service.”.(SBL-EAI-04308):

 

Solution : 

Go to EBS Integrated SOA –> Choose particular interface (Interface type — plsql — Receivable )

revoke sysadmin privilege and then give grant sysadmin privilege again to this object

Oracle 12c (12.1.0.2.0) database step by step installation guide on redhat linux 5.6

 

Download Document here

Oracle 12c database installation guide on redhat linux 5.6

find out which device mapped with oracle asm disk

Step 1 :

 

[oracle@asmoracle ~]$ /etc/init.d/oracleasm listdisks

DISK1
DISK2
DISK3
DISK4

 

Step 2 :

[oracle@asmoracle ~]$ /etc/init.d/oracleasm querydisk -d DISK1
Disk “DISK1″ is a valid ASM disk on device /dev/sdc1[8,33]

The device noted here is (8,33), so go to

 

[root@asmoracle dev]# ls -l sd*
brw-r—– 1 root disk 8, 0 Aug 18 08:39 sda
brw-r—– 1 root disk 8, 1 Aug 18 08:39 sda1
brw-r—– 1 root disk 8, 2 Aug 18 08:39 sda2
brw-r—– 1 root disk 8, 16 Aug 18 08:39 sdb
brw-r—– 1 root disk 8, 17 Aug 18 08:39 sdb1
brw-r—– 1 root disk 8, 32 Aug 18 08:39 sdc
brw-r—– 1 root disk 8, 33 Aug 18 08:39 sdc1 (its belong to this device)
brw-r—– 1 root disk 8, 48 Aug 18 08:39 sdd
brw-r—– 1 root disk 8, 49 Aug 18 08:39 sdd1
brw-r—– 1 root disk 8, 64 Aug 18 08:39 sde
brw-r—– 1 root disk 8, 65 Aug 18 08:39 sde1
brw-r—– 1 root disk 8, 80 Aug 18 08:39 sdf
brw-r—– 1 root disk 8, 81 Aug 18 08:39 sdf1

Support ID : How to enable and retrieve FND debug log messages

If you want to know about FND Debug log configuration in R12, this below document id is useful for you

How to enable and retrieve FND debug log messages (Doc ID 433199.1)

PERWSDOR form compile in r12

export FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US

cd $ORACLE_HOME/bin

[appltrng@ebsdev bin]$   frmcmp_batch module=/u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/forms/US/PERWSDOR.fmb userid=apps/Ace321b output_file=/u02/backup/appltrng/apps/apps_st/appl/per/12.0.0/forms/US/PERWSDOR.fmx module_type=form batch=no compile_all=yes

Compiling WHEN-BUTTON-PRESSED trigger on PREV_MONTH item in CALENDAR data block…
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NEXT_MONTH item in CALENDAR data block…
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NEXT_YEAR item in CALENDAR data block…
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on PREV_YEAR item in CALENDAR data block…
No compilation errors.
Created form file /u02/backup/appltrng/apps/apps_st/appl/per/12.0.0/forms/US/PERWSDOR.fmx

 

 

or adadmin

 
************* Start of AD Administration session *************
AD Administration version: 12.0.0
AD Administration started at: Thu Jul 17 2014 13:05:44

APPL_TOP is set to /u02/backup/appltrng/apps/apps_st/appl

NLS_LANG value from the environment is : American_America.UTF8
NLS_LANG value for this AD utility run is : AMERICAN_AMERICA.UTF8

You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ? No

Please enter the batchsize [1000] : 1000
Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.

The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.

Sample Applications System names are: “prod”, “test”, “demo” and
“Development_2″.

Applications System Name [EBSCLONE] : EBSCLONE *
NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.

Example 1: If you don’t have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.

Example 2: If you don’t have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.

Example 3: If you don’t have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.
Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *
Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *
Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *
Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *
Please enter the name Oracle Applications will use to identify this APPL_TOP.

The APPL_TOP name you select must be unique within an Oracle Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.

Sample APPL_TOP Names are: “prod_all”, “demo3_forms2″, and “forms1″.

APPL_TOP Name [ebsdev] : ebsdev *

 

You are about to use or modify Oracle Applications product tables
in your ORACLE database ‘EBSCLONE’
using ORACLE executables in ‘/u02/backup/appltrng/apps/tech_st/10.1.2′.

Is this the correct database [Yes] ? Yes

AD Administration needs the password for your ‘SYSTEM’ ORACLE schema
in order to determine your installation configuration.

Enter the password for your ‘SYSTEM’ ORACLE schema: *****
Connecting to SYSTEM……Connected successfully.

The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS

Enter the ORACLE password of Application Object Library [APPS] : *****

AD Administration is verifying your username/password.
Connecting to APPLSYS……Connected successfully.

The status of various features in this run of AD Administration is:

<-Feature version in->
Feature Active? APPLTOP Data model Flags
—————————— ——- ——– ———– ———–
CHECKFILE Yes 1 1 Y N N Y N Y
PREREQ Yes 6 6 Y N N Y N Y
CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N
PATCH_TIMING Yes 2 2 Y N N Y N Y
PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y
SCHEMA_SWAP Yes 1 1 Y N N Y Y Y
JAVA_WORKER Yes 1 1 Y N N Y N Y
CODELEVEL Yes 1 1 Y N N Y N Y

 

Connecting to SYSTEM……Connected successfully.

Connecting to APPLSYS……Connected successfully.

Identifier for the current session is 48784

Reading product information from file…

Reading language and territory information from file…

Reading language information from applUS.txt …

AD Administration warning:
Product Data File
/u02/backup/appltrng/apps/apps_st/appl/admin/zfaprod.txt
does not exist for product “zfa”.
This product is registered in the database but the
above file does not exist in APPL_TOP. The product
will be ignored without error.
AD Administration warning:
Product Data File
/u02/backup/appltrng/apps/apps_st/appl/admin/zsaprod.txt
does not exist for product “zsa”.
This product is registered in the database but the
above file does not exist in APPL_TOP. The product
will be ignored without error.
AD Administration warning:
Product Data File
/u02/backup/appltrng/apps/apps_st/appl/admin/jtsprod.txt
does not exist for product “jts”.
This product is registered in the database but the
above file does not exist in APPL_TOP. The product
will be ignored without error.
Reading database to see what industry is currently installed.

Reading FND_LANGUAGES to see what is currently installed.
Currently, the following languages are installed:

Code Language Status
—- ————————————— ———
US American English Base
AR Arabic Install
EL Greek Install

Reading language information from applAR.txt …

Reading language information from applEL.txt …

Your base language will be AMERICAN.

Your other languages to install are: ARABIC, GREEK

Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Connecting to SYSTEM……Connected successfully.

Connecting to APPLSYS……Connected successfully.

Connecting to SYSTEM……Connected successfully.

Reading database for information about how products depend on each other.
Connecting to APPLSYS……Connected successfully.

Reading topfile.txt …

Saving product information.
Connecting to SYSTEM……Connected successfully.

Connecting to APPLSYS……Connected successfully.
AD code level : [B.3]

Connecting to SYSTEM……Connected successfully.

Connecting to APPS……Connected successfully.

Connecting to APPLSYS……Connected successfully.

AD Administration Main Menu
————————————————–

1. Generate Applications Files menu

2. Maintain Applications Files menu

3. Compile/Reload Applications Database Entities menu

4. Maintain Applications Database Entities menu

5. Change Maintenance Mode

6. Exit AD Administration

 

 

 

 

Enter your choice [6] : 1

Generate Applications Files
—————————————-

1. Generate message files

2. Generate form files

3. Generate report files

4. Generate product JAR files

5. Return to Main Menu

 

 

 

 

 

Enter your choice [5] : 2

Connecting to APPS……Connected successfully.

Connecting to SYSTEM……Connected successfully.

Connecting to APPS……Connected successfully.
AD utilities can support a maximum of 999 workers. Your
current database configuration supports a maximum of 109 workers.
Oracle recommends that you use between 8 and 16 workers.
Enter the number of workers [8] : 8

Your current character set is “UTF8″.

Do you want to generate Oracle Forms objects
using this character set [Yes] ? Yes
Do you want to regenerate Oracle Forms PL/SQL library files [Yes] ? Yes

Do you want to regenerate Oracle Forms menu files [Yes] ? Yes

Do you want to regenerate Oracle Forms executable files [Yes] ? Yes

Enter list of products (‘all’ for all products) [all] : per  ( Note Here mention your product name otherwise its take all product )

Generate specific forms objects for each selected product [No] ? y (Note Here you want to compile particular form of a product, you should give yes here then only you can compile particular form otherwise all form of this prodcut)
The current set of installed languages is: US AR EL

Please select languages for generating Oracle Forms files.
You may select all of the above languages, or just a subset.

Enter list of languages (‘all’ for all of the above) [all] : all
You selected the following languages: US AR EL

Is this the correct set of languages [Yes] ? Yes

Reading product form information…

Selecting Oracle Forms PL/SQL library files and menu files to generate…
Selecting library and menu files for Human Resources…

List of libraries and menus in Human Resources :

HRAMER.pll HRAPAC.pll HREMEA.pll HRFCR.pll HRJP.pll
HRKPI.pll HRLOCAL.pll HR_ASG.pll HR_GEN.pll HR_SPEC.pll
PERWSCEL.pll PERWSEMA.pll PERWSEPI.pll

Enter libraries and menus to generate, or enter ‘all’ [all] : HRLOCAL.pll
Selecting product forms to generate…
Selecting forms for Human Resources…

List of forms in Human Resources :

HRTRACE.fmx HRWSPSF.fmx PERACADR.fmx PERAEOBJ.fmx PERBEOBJ.fmx
PERCNOBJ.fmx PERDEAOI.fmx PERDEINS.fmx PERDELIP.fmx PERDEOBJ.fmx
PERDESIO.fmx PERDETAX.fmx PERDKOBJ.fmx PERESOBJ.fmx PERESSOC.fmx
PERESTAX.fmx PERFIOBJ.fmx PERFROBJ.fmx PERGBADR.fmx PERGBOBJ.fmx
PERHUOBJ.fmx PERIEOBJ.fmx PERINOBJ.fmx PERITOBJ.fmx PERJPADR.fmx
PERJPCLF.fmx PERJPDEP.fmx PERJPSCH.fmx PERKRASH.fmx PERKRGRD.fmx
PERKWOBJ.fmx PERMXOBJ.fmx PERNLOBJ.fmx PERNOOBJ.fmx PERPLOBJ.fmx
PERRUOBJ.fmx PERSAOBJ.fmx PERSEOBJ.fmx PERUSECI.fmx PERWIANA.fmx
PERWIASL.fmx PERWICAS.fmx PERWIEBP.fmx PERWIEMP.fmx PERWILAH.fmx
PERWILAS.fmx PERWILAT.fmx PERWILVA.fmx PERWIPOC.fmx PERWIPOR.fmx
PERWIPSL.fmx PERWIPYP.fmx PERWSAAB.fmx PERWSABV.fmx PERWSADR.fmx
PERWSAEI.fmx PERWSAPA.fmx PERWSAPI.fmx PERWSAPL.fmx PERWSAPT.fmx
PERWSAQE.fmx PERWSASH.fmx PERWSASP.fmx PERWSASR.fmx PERWSAST.fmx
PERWSBEN.fmx PERWSBEP.fmx PERWSBFB.fmx PERWSBFO.fmx PERWSBFR.fmx
PERWSCAR.fmx PERWSCCM.fmx PERWSCEI.fmx PERWSCEL.fmx PERWSCHK.fmx
PERWSCPN.fmx PERWSCTR.fmx PERWSCVD.fmx PERWSDAR.fmx PERWSDAS.fmx
PERWSDAT.fmx PERWSDBU.fmx PERWSDCA.fmx PERWSDCF.fmx PERWSDCL.fmx
PERWSDCM.fmx PERWSDCP.fmx PERWSDED.fmx PERWSDEL.fmx PERWSDGR.fmx
PERWSDIS.fmx PERWSDJT.fmx PERWSDLT.fmx PERWSDMG.fmx PERWSDOH.fmx
PERWSDOR.fmx PERWSDPC.fmx PERWSDPF.fmx PERWSDPH.fmx PERWSDPO.fmx
PERWSDPT.fmx PERWSDRA.fmx PERWSDSB.fmx PERWSDSP.fmx PERWSDST.fmx
PERWSDWF.fmx PERWSDWN.fmx PERWSDWU.fmx PERWSEAC.fmx PERWSEAD.fmx
PERWSEBC.fmx PERWSELC.fmx PERWSEMA.fmx PERWSEMP.fmx PERWSEPI.fmx
PERWSEPY.fmx PERWSEQT.fmx PERWSERW.fmx PERWSESA.fmx PERWSEST.fmx
PERWSFAS.fmx PERWSFCR.fmx PERWSFPE.fmx PERWSGCT.fmx PERWSGEB.fmx
PERWSGHR.fmx PERWSGSP.fmx PERWSHRG.fmx PERWSIMG.fmx PERWSINC.fmx
PERWSITS.fmx PERWSJEI.fmx PERWSJGR.fmx PERWSLEI.fmx PERWSLOC.fmx
PERWSMEA.fmx PERWSMGN.fmx PERWSMMV.fmx PERWSPCL.fmx PERWSPDC.fmx
PERWSPDM.fmx PERWSPED.fmx PERWSPEI.fmx PERWSPHN.fmx PERWSPJI.fmx
PERWSPOI.fmx PERWSPOR.fmx PERWSPRV.fmx PERWSPSS.fmx PERWSPTU.fmx
PERWSQHM.fmx PERWSQUA.fmx PERWSREI.fmx PERWSREP.fmx PERWSROL.fmx
PERWSRQL.fmx PERWSRSC.fmx PERWSSAS.fmx PERWSSCP.fmx PERWSSHA.fmx
PERWSSHR.fmx PERWSSHT.fmx PERWSSLH.fmx PERWSSPP.fmx PERWSSSM.fmx
PERWSTAP.fmx PERWSTCW.fmx PERWSTEM.fmx PERWSUPA.fmx PERWSVAC.fmx
PERWSVBI.fmx PERWSWCR.fmx PERWSWIR.fmx PERZAASS.fmx PERZAFQT.fmx
PERZALSA.fmx PERZAOBJ.fmx PERZAQUA.fmx PERZATRA.fmx

Enter forms to generate, or enter ‘all’ [all] : PERWSDOR.fmx
Generating Oracle Forms objects…

 

Connecting to APPLSYS……Connected successfully.
Creating the AD_UTIL_PARAMS table…
Table AD_UTIL_PARAMS already exists, so dropping the table and recreating it.
DROP TABLE AD_UTIL_PARAMS

CREATE TABLE ad_util_params( worker_id number not null,
utility_name varchar2(100) not null, task
varchar2(30) not null, status varchar2(100) not null,
arguments varchar2(2000) not null, rowid1
varchar2(2000), utility_status number not null, symbolic_arguments
varchar2(2560) not null)
Creating FND_INSTALL_PROCESSES table…

Running adtasktim.sql ..

Connected.
Connected.

PL/SQL procedure successfully completed.
Commit complete.
CREATE TABLE fnd_install_processes( worker_id number not null,
control_code varchar2(1) not null, status varchar2(1) not null,
context varchar2(80) not null, pdi_product varchar2(10) not null,
pdi_username varchar2(32) not null, command varchar2(30) not null,
file_product varchar2(10) not null, subdirectory varchar2(250) not null,
filename varchar2(60) not null, phase number not null,
install_group_num number not null, skip_flag varchar2(1), arguments
varchar2(1996), symbolic_arguments varchar2(1996), phase_name
varchar2(30), start_time date, end_time date, restart_time date,
elapsed_time number, restart_count number, defer_count number,
machine_name varchar2(32), local_node varchar2(1)) TABLESPACE
APPS_TS_TX_DATA initrans 255

INSERT INTO ad_timestamps (TYPE,ATTRIBUTE,TIMESTAMP) select
‘FND_INSTALL_PROCESSES’, ‘AD Administration’, sysdate from dual where not
exists (select ‘x’ from ad_timestamps where type = ‘FND_INSTALL_PROCESSES’
and attribute = ‘AD Administration’)

CREATE UNIQUE INDEX fnd_install_processes_u1 on
fnd_install_processes(worker_id) TABLESPACE APPS_TS_TX_IDX
storage(initial 4K next 4K)

GRANT ALL ON fnd_install_processes TO APPS WITH GRANT OPTION

GRANT ALL ON ad_util_params TO APPS WITH GRANT OPTION

Connecting to APPS……Connected successfully.

Connecting to APPLSYS……Connected successfully.

CREATE TABLE AD_DEFERRED_JOBS( phase number not null,
file_product varchar2(10) not null, subdirectory varchar2(250) not null,
filename varchar2(60) not null, arguments varchar2(1996),
start_time date, restart_time date, elapsed_time number,
restart_count number, defer_count number) TABLESPACE APPS_TS_TX_DATA
initrans 100 storage(initial 4K next 4K)

CREATE UNIQUE INDEX AD_DEFERRED_JOBS_U1 on AD_DEFERRED_JOBS
(phase,file_product,subdirectory,filename,arguments) TABLESPACE
APPS_TS_TX_IDX storage(initial 4K next 4K)

GRANT ALL ON AD_DEFERRED_JOBS TO APPS WITH GRANT OPTION

Connecting to APPS……Connected successfully.

Connecting to APPLSYS……Connected successfully.

INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (0, ‘W’, ‘W’, ‘UNDEF’, ‘UNDEF’,
‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, 0, 0,
rpad(‘-‘,100,’-‘),rpad(‘-‘,100,’-‘),’UNDEF’)

INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (1, ‘W’, ‘W’, ‘UNDEF’, ‘UNDEF’,
‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, 0, 0,
rpad(‘-‘,100,’-‘),rpad(‘-‘,100,’-‘),’UNDEF’)

INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (2, ‘W’, ‘W’, ‘UNDEF’, ‘UNDEF’,
‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, 0, 0,
rpad(‘-‘,100,’-‘),rpad(‘-‘,100,’-‘),’UNDEF’)

INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (3, ‘W’, ‘W’, ‘UNDEF’, ‘UNDEF’,
‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, 0, 0,
rpad(‘-‘,100,’-‘),rpad(‘-‘,100,’-‘),’UNDEF’)

INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (4, ‘W’, ‘W’, ‘UNDEF’, ‘UNDEF’,
‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, 0, 0,
rpad(‘-‘,100,’-‘),rpad(‘-‘,100,’-‘),’UNDEF’)

INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (5, ‘W’, ‘W’, ‘UNDEF’, ‘UNDEF’,
‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, 0, 0,
rpad(‘-‘,100,’-‘),rpad(‘-‘,100,’-‘),’UNDEF’)

INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (6, ‘W’, ‘W’, ‘UNDEF’, ‘UNDEF’,
‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, 0, 0,
rpad(‘-‘,100,’-‘),rpad(‘-‘,100,’-‘),’UNDEF’)

INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (7, ‘W’, ‘W’, ‘UNDEF’, ‘UNDEF’,
‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, 0, 0,
rpad(‘-‘,100,’-‘),rpad(‘-‘,100,’-‘),’UNDEF’)

INSERT INTO fnd_install_processes (worker_id, control_code, status,
context, pdi_product, pdi_username, command, file_product, subdirectory,
filename, phase, install_group_num, arguments,
symbolic_arguments,machine_name) VALUES (8, ‘W’, ‘W’, ‘UNDEF’, ‘UNDEF’,
‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, ‘UNDEF’, 0, 0,
rpad(‘-‘,100,’-‘),rpad(‘-‘,100,’-‘),’UNDEF’)

Connecting to APPS……Connected successfully.

Writing dependencies of jobs to run to appldep.txt file…

There are now 4 jobs remaining (current phase=admin):
0 running, 1 ready to run and 3 waiting.

Reading completed jobs from restart file (if any).

There are now 4 jobs remaining (current phase=admin):
0 running, 1 ready to run and 3 waiting.
Determining which java executables are supported by adJavaWorker…

Calling /u02/backup/appltrng/apps/tech_st/10.1.3/appsutil/jdk/jre/bin/java …
No method: publishApps in Class: oracle.apps.asg.setup.AsgRunInst

Starting worker processes.

Worker process 1 started.

Worker process 2 started.

Worker process 3 started.

Worker process 4 started.

Worker process 5 started.

Worker process 6 started.

Worker process 7 started.

Worker process 8 started.

Checking if all jobs have their actual and symbolic arguments in sync….

Done.
Reading jobs from FND_INSTALL_PROCESSES table …
Done reading jobs from FND_INSTALL_PROCESSES table …

Telling workers to read ‘todo’ restart file.
Done.
Connecting to APPLSYS……Connected successfully.
Starting phase 1000 (admin): Generate Form Libraries

Connecting to APPS……Connected successfully.
There are now 4 jobs remaining (current phase=admin):
0 running, 1 ready to run and 3 waiting.

Assigned: file HRLOCAL.pll on worker 1 for product au username APPLSYS.

Time is: Thu Jul 17 2014 13:08:00

Completed: file HRLOCAL.pll on worker 1 for product au username APPLSYS.

Time is: Thu Jul 17 2014 13:08:11

Connecting to APPLSYS……Connected successfully.
Starting phase 1002 (admin+2): Generate Form Files

Connecting to APPS……Connected successfully.
There are now 3 jobs remaining (current phase=admin+2):
0 running, 3 ready to run and 0 waiting.

Assigned: file PERWSDOR.fmx on worker 1 for product per username HR.

Time is: Thu Jul 17 2014 13:08:20

Assigned: file PERWSDOR.fmx on worker 2 for product per username HR.

Time is: Thu Jul 17 2014 13:08:20

Assigned: file PERWSDOR.fmx on worker 3 for product per username HR.

Time is: Thu Jul 17 2014 13:08:20

Completed: file PERWSDOR.fmx on worker 1 for product per username HR.

Time is: Thu Jul 17 2014 13:08:29

Completed: file PERWSDOR.fmx on worker 2 for product per username HR.

Time is: Thu Jul 17 2014 13:08:29

Completed: file PERWSDOR.fmx on worker 3 for product per username HR.

Time is: Thu Jul 17 2014 13:08:29
Telling workers to quit…

4 workers have quit. Waiting for 4 more.

All workers have quit.
Dropping FND_INSTALL_PROCESSES table…

Connecting to APPLSYS……Connected successfully.

DROP TABLE fnd_install_processes PURGE

DELETE FROM ad_timestamps WHERE TYPE = ‘FND_INSTALL_PROCESSES’
FND_INSTALL_PROCESSES table dropped.
Dropping AD_DEFERRED_JOBS table…

DROP TABLE AD_DEFERRED_JOBS PURGE
AD_DEFERRED_JOBS table dropped.

Connecting to APPS……Connected successfully.

Review the messages above, then press [Return] to continue.
Time is: Thu Jul 17 2014 13:08:54
Backing up restart files, if any……Done.

Connecting to APPLSYS……Connected successfully.

Generate Applications Files
—————————————-

1. Generate message files

2. Generate form files

3. Generate report files

4. Generate product JAR files

5. Return to Main Menu

 

 

 

 

 

Enter your choice [5] : 5

AD Administration Main Menu
————————————————–

1. Generate Applications Files menu

2. Maintain Applications Files menu

3. Compile/Reload Applications Database Entities menu

4. Maintain Applications Database Entities menu

5. Change Maintenance Mode

6. Exit AD Administration

 

 

 

 

Enter your choice [6] : 6
Connecting to APPS……Connected successfully.
Time is: Thu Jul 17 2014 13:09:02
Backing up restart files, if any……Done.
Time is: Thu Jul 17 2014 13:09:02

sqlplus -s APPS/***** @/u02/backup/appltrng/apps/apps_st/appl/ad/12.0.0/sql/adtimrpt.sql 48784 adt48784
Connected.

Spooling to adt48784.lst
Spooling to adt48784.csv
A job timing report has been generated for the current session.
You should check the file
/u02/backup/appltrng/apps/apps_st/appl/admin/EBSCLONE/out/adt48784.lst

for details.
Purging timing information for prior sessions.

sqlplus -s APPS/***** @/u02/backup/appltrng/apps/apps_st/appl/ad/12.0.0/sql/adtpurge.sql 10 1000
Connected.

Done purging timing information for prior sessions.

AD Administration is complete.

Errors and warnings are listed in the log file
/u02/backup/appltrng/apps/apps_st/appl/admin/EBSCLONE/log/hrlocal.log

and in other log files in the same directory.

 

asm spfile

The below article useful to know about asm spfile and How asm instance started if spfile in diskgroup without mount.

http://asmsupportguy.blogspot.in/2014/03/asm-spfile-in-disk-group.html

This article he explained for  normal redundancy . If you want to find the spfile on external redundancy level, you can use below command

[oracle@asmoracle ~]$ asmcmd lsdsk -G DATA
Path
/dev/oracleasm/disks/DISK1
/dev/oracleasm/disks/DISK2


[oracle@asmoracle ~]$ kfed read /dev/oracleasm/disks/DISK1 | grep -E 'spf|ausize'
kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000
kfdhdb.spfile: 1450 ; 0x0f4: 0x000005aa
kfdhdb.spfflg: 1 ; 0x0f8: 0x00000001

[oracle@asmoracle ~]$ kfed read /dev/oracleasm/disks/DISK2 | grep -E 'spf|ausize'
kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000
kfdhdb.spfile: 0 ; 0x0f4: 0x00000000
kfdhdb.spfflg: 0 ; 0x0f8: 0x00000000
[oracle@asmoracle ~]$ dd if=/dev/oracleasm/disks/DISK1 bs=1048576 skip=1450 count=1 | strings
+ASM.__large_pool_size=16777216
+ASM.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from in memory value
+ASM.asm_diskgroups='DATA','FRA'#Manual Mount
*.asm_diskstring='/dev/oracleasm/disks/*'
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/oracle'
*.instance_type='asm'
*.large_pool_size=12M
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
1+0 records in
1+0 records out
1048576 bytes (1.0 MB) copied, 0.054056 seconds, 19.4 MB/s

Force option in ASM

This below url is very useful to know about force option in asm

http://asmsupportguy.blogspot.com/2011/12/forcing-issue.html

Create diskgroup in ASM

Steps for creating diskgroup in ASM (Single Node)

 

Step 1: Add new HDD to server and done partition. Here I added two HDD

[root@asmoracle ~]# fdisk /dev/sde
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklab el
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-130, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-130, default 130):
Using default value 130

Command (m for help): p

Disk /dev/sde: 1073 MB, 1073741824 bytes
255 heads, 63 sectors/track, 130 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sde1 1 130 1044193+ 83 Linux

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.

WARNING: Re-reading the partition table failed with error 16: Device or resource busy.
The kernel still uses the old table.
The new table will be used at the next reboot.
Syncing disks.

Step 2 :  Just check existing Diskgroup in ASM

[root@asmoracle ~]# oracleasm listdisks
DISK1
DISK2

Step 3:  now try to create new disk in asm

[root@asmoracle ~]# oracleasm createdisk DISK3 /dev/sde1
Writing disk header: done
Instantiating disk: done

[root@asmoracle ~]# oracleasm createdisk DISK4 /dev/sdf1
Writing disk header: done
Instantiating disk: done

Step 4: Verifying asm disk label

[root@asmoracle ~]# oracleasm querydisk /dev/sde1
Device "/dev/sde1" is marked an ASM disk with the label "DISK3"
[root@asmoracle ~]# oracleasm querydisk /dev/sdf1
Device "/dev/sdf1" is marked an ASM disk with the label "DISK4"

Step 5 : listdisks

[root@asmoracle ~]# oracleasm listdisks
DISK1
DISK2
DISK3
DISK4

Step 6:  Checking diskgroup state

SQL> select path,header_status from v$asm_disk;

PATH
--------------------------------------------------------------------------------
HEADER_STATU
------------
/dev/oracleasm/disks/DISK4
PROVISIONED

/dev/oracleasm/disks/DISK3
PROVISIONED

/dev/oracleasm/disks/DISK2
MEMBER

/dev/oracleasm/disks/DISK1
MEMBER

 

PROVISINED -- It is available to be added diskgroup or create diskgroup. It's configuration done by ASMLIB

Step 7 : create diskgroup

SQL> CREATE DISKGROUP FRA EXTERNAL REDUNDANCY DISK '/dev/oracleasm/disks/DISK3','/dev/oracleasm/disks/DISK4';

Diskgroup created.

SQL> select path,header_status from v$asm_disk;

PATH
----------------------------------------------------------------------------------------------------
HEADER_STATU
------------
/dev/oracleasm/disks/DISK2
MEMBER

/dev/oracleasm/disks/DISK1
MEMBER

/dev/oracleasm/disks/DISK4
MEMBER

/dev/oracleasm/disks/DISK3
MEMBER

 

Patch applied or not in R12

you can get the patch applied details in EBS R12 from below command

 

select AP.PATCH_NAME, AP.PATCH_TYPE, AD.DRIVER_FILE_NAME, AD.CREATION_DATE, AD.PLATFORM,AL.LANGUAGE
from AD_APPLIED_PATCHES AP, AD_PATCH_DRIVERS AD, AD_PATCH_DRIVER_LANGS AL
where AP.APPLIED_PATCH_ID = AD.APPLIED_PATCH_ID
and AD.PATCH_DRIVER_ID = AL.PATCH_DRIVER_ID and AP.PATCH_NAME='17627621'

Compile pll file in R12

If you like to compile pll file in R12, you can use frmcmp_batch command instead of using  f60gen

 

Example :

cd $AU_TOP/resource

frmcmp_batch module=/u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/resource/HRLOCAL.pll userid=apps/apps output_file=/u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/resource/HRLOCAL.plx module_type=library batch=yes compile_all=special

Follow

Get every new post delivered to your Inbox.

Join 139 other followers