Skip to content

Archive for

Aug 25

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

 

Still, if you have an issue, Functional Administrator — Clear cache & restart the application service.

Aug 20

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

Aug 18

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