Skip to content
Advertisements

Posts from the ‘EBS’ Category

Junk character issue in R12 report

Our developer complaint about when they trying to take Oracle standard report with arabic format, They got output of report with junk character

 

Solution:

Login EBS, In home page , Select preference,

Client chracter encoding – Arabic(Windows)

Run Standard report using language settings — arabic

Advertisements

E-Business Suite 12.2.7 Now Available

Oracle announced that E-Business Suite 12.2.7 Now Available

Please refer
https://blogs.oracle.com/stevenchan/oracle-e-business-suite-1227-now-available

EBS 12.1.3 Data masking issue with 11.2.0.2

I tried to data mask the EBS 12.1.3 data with database version 11.2.0.2. but After i masked, I can’t open the application because of SYSADMIN and Guest user was missed. So I raised SR, As per support we need to upgrade database version to 11.2.0.3 otherwise we need to do backport activity. If your database version is 11.2.0.2, you need to check with Oracle support before you do data masking.

I upgraded to 12c, it’s working fine.

Configure Oracle EBS integrated soa gateway for SOAP services on 12.2.6

Here I am going to explain how to configure Oracle EBS integrated soa gateway for SOAP services on 12.2.6.

The E business suite integrated soa gateway configuration require a Oracle SOA suite  with weblogic on separate server.

Refer the document for how to install

Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2 (Doc ID 1311068.1)

In this note, Go to

Section 1: Configuring Oracle E-Business Suite Integrated SOA Gateway for SOAP Services on a New Installation of Release 12.2.3 or Higher

In this section , They mentioned to install oracle SOA suite server as per section 4

Here I had chosen  the below version of Oracle SOA suite to install on the separate server

  • For Oracle SOA Suite 11g and Oracle Applications Adapter 11g on Oracle WebLogic Server 11g

How to Install Oracle SOA Suite:

Download Oracle SOA Suite software from edelivery.oracle.com

Prepare a new linux server for Oracle SOA Suite

Complete  all the prerequisites on this server. (See my OBIEE installation guide for complete prerequisites activities)

Install  Oracle Database software and create a database for SOA Suite.

Install Jdk  (jdk-7u79-linux-x64.rpm)

Create repository creation for SOA

Select the below component while creating repository

–> AS Common Schemas –>  Metadata Services

–> SOA and BPM infrastructure –> SOA Infrastructure & Business Activity Monitoring & User Messaging Service

https://docs.oracle.com/cd/E21764_01/doc.1111/e14259/rcu.htm#RCUUG268

Install Oracle weblogic Server 10.3.6

Install Oracle SOA suite

http://docs.oracle.com/cd/E28280_01/install.1111/e13925/install.htm#INSOA209

Configure Oracle SOA Suite

http://docs.oracle.com/cd/E28280_01/install.1111/e13925/configure.htm#INSOA212

 

Integartion SOA gateway :

Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2 (Doc ID 1311068.1)

Go to Section 1.1: Setup Tasks on Oracle E-Business Suite Release 12.2.3 or Higher

Here you noted : ASADMIN password change, Try to change user management If you can’t see reset password field , change password using secutiry – users -define.

And also Weblogic and SOA gateway server address should be you mentioned which you are  installed Oracle SOA suite server and weblogic server address and ipaddress.

Section 1.2: Configuration Steps on Oracle SOA Suite to Integrate with Oracle E-Business Suite

Once done the above steps, you may go to Integrated SOA responsibility–> select your interface name or internal name  and regenerate the wsdl and deploy the SOAP service. please verify can you able to view wsdl file or not. If you can able to view wsdl  with soa suite server address, the SOAP service is working fine.

 

 

 

 

 

 

 

User ASADMIN does not have the privilege of deploying/undeploying composites

I am trying to deploy the SOAP service in ebs 12.2.6 with integrated SOA gateway. I can able to deploy the wsdl file but I can’t able to view wsdl files. The below error appeared when I try to open view wsdl file

“Failed to Load a composite for composite identified by default”

So I realized  the error seems to be part of SOA server. I looked the SOA server log from EM console. It shows below error

#
#SEARCH_CRITERIA
# START_TIME: 2016-11-17T11:16:46.968+03:00
# END_TIME: 2016-11-17T12:16:46.968+03:00
# MESSAGE_TYPES:INCIDENT_ERROR, ERROR, UNKNOWN

#SELECTED_TARGETS_LIST
# /Farm_base_domain/base_domain/soa_server1/soa-infra:oracle_soainfra
#

[2016-11-17T12:00:57.533+03:00] [soa_server1] [ERROR] [SOA-21537] [oracle.integration.platform.blocks.deploy.servlet] [host: dbs-10-1-4-201.tst.RUH.ace-ins.com] [nwaddr: 10.1.4.201] [tid: [ACTIVE].ExecuteThread: ‘2’ for queue: ‘weblogic.kernel.Default (self-tuning)’] [userId: ASADMIN] [ecid: 005GNi0iuAiESO15zvg8yW00004y00001p,1:26140:36] [APP: soa-infra] [DSID: 0000LXlX7_9EOP15zvg8yW1OBMle000006] Sending back error message: User ASADMIN does not have the privilege of deploying/undeploying composites. Only users of SOAAdmin/SOAOperator role are authorized to deploy/undeploy composites..
[2016-11-17T12:01:17.366+03:00] [soa_server1] [ERROR] [SOA-21537] [oracle.integration.platform.blocks.deploy.servlet] [host: dbs-10-1-4-201.tst.RUH.ace-ins.com] [nwaddr: 10.1.4.201] [tid: [ACTIVE].ExecuteThread: ‘0’ for queue: ‘weblogic.kernel.Default (self-tuning)’] [userId: ASADMIN] [ecid: 005GNi1pk8XESO15zvg8yW00004y00001q,1:26142:37] [APP: soa-infra] [DSID: 0000LXlXCYjEOP15zvg8yW1OBMle000007] Sending back error message: User ASADMIN does not have the privilege of deploying/undeploying composites. Only users of SOAAdmin/SOAOperator role are authorized to deploy/undeploy composites..

#
#MESSAGE_COUNT: 2
#

So The ASADMIN requires some privileges in SOA server for deploying services.

Solution :

SOA Server Enterprise Manager Console

–> Weblogic Domain –> <domain name>

–> Security –> Application roles

–> Application Stripe — soa-infra

Select SOAAdmin roleand click edit, and add user ASADMIN

Select SOAOperator role and click edit, and add user ASADMIN

 

Again now  I tried to deploy the services, it’s working fine.

Oracle EBS upgrade from 12.2.0 to 12.2.6

Here I am going to explain about how to upgrade from 12.2.0 to 12.26 version.

Well, I hope you’re now successfully completed 12.1.3 to 12.2 version upgrade .So What is the next step to follow

First Step is you need to enable online patching, P

Enable Online Patching :

follow the below document for enabling online patching

https://docs.oracle.com/cd/E26401_01/doc.122/e48839/T579510T580325.htm

1.Verify the database version

I hope you’re upgraded database to 11.2.0.4 or  12c while during upgrade 12.1.3 to 12.2

2.Ensure that the required Database patches for Release 12.2 have been applied

Database Preparation Guidelines for an E-Business Suite Release 12.2 Upgrade (Doc ID: 1349240.1)

check with checkMTpatch.sh, If you need to apply database patches or not. you please review the above document as well

3.Apply the latest Oracle E-Business Suite Online Patching Readiness and GSCC Report Patch

Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2 (Doc ID 1531121.1)

you need to apply the patch

  • 22200487:R12.AD.C Release 12.2 or higher

4.Run the Online Patching Enablement – Readiness Reports

Follow the instructions as per the document, you may get list or reports.  you may analyze the report and try to fix the EBS violations. If High priority violations, fix it before you start to apply enable online patch.

However , you should check with Oracle Support Team regarding those reports you got.

5.Fix Violations Listed in the Online Patching Readiness Report that Require Manual Intervention

Follow document

6. Verify database tablespace free space

Follow document

7. Run the Online Patching Enablement – Status Report

Follow document

8.Ensure that all middle-tier E-Business Suite services are shut down

Stop the service

9.Download and apply the Online Patching Enablement patch

Download and apply the Online Patching Enablement patch: 13543062:R12.AD.C. Use Autopatch in hotpatch mode to apply the patch (adpatch options=hotpatch,forceapply).

10. Compile Invalid Objects

connect with apps schema
exec sys.utl_recomp.recomp_parallel

Afterwards , follow the document and get the report again, try to fix the EBS violations.

Database Initialization Parameters

SQL> show parameter service_names

NAME TYPE VALUE
———————————— ———– ——————————
service_names string EBSUPGR, EBS_PATCH

SQL> show parameter recyclebin

NAME TYPE VALUE
———————————— ———– ——————————
recyclebin string OFF

If the _SYSTEM_TRIG_ENABLED parameter is set to false, then system triggers are not processed. The post Online Patching Enablement parameter must be set to true.

SQL> select x.ksppinm name,
y.ksppstvl value,
ksppdesc description
from x$ksppi x,
x$ksppcv y
where x.inst_id = userenv(‘Instance’)
and y.inst_id = userenv(‘Instance’)
and x.indx = y.indx
and x.ksppinm = ‘_system_trig_enabled’ 2 3 4 5 6 7 8 9 ;

NAME
——————————————————————————–
VALUE
——————————————————————————–
DESCRIPTION
——————————————————————————–
_system_trig_enabled
TRUE
are system triggers enabled

Upgrade to 12.2.6 :

follow the document
https://docs.oracle.com/cd/E26401_01/doc.122/e48839/T579510T579526.htm

Apply the Latest AD and TXK for Release 12.2

refer this document

Oracle E-Business Suite Release 12.2: Suite-Wide Release Update Pack and AD/TXK Delta Information (Doc ID 1583092.1)

Section 1: AD and TXK RUP Information

Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)

Please ensure required database patches applied or not (checkMTpatch.sh) and also check application patches as well (check MTpatch.sh)

Database parameter

SQL> show parameter optimizer_adaptive_features

NAME TYPE VALUE
———————————— ———– ——————————
optimizer_adaptive_features boolean FALSE

Apply the R12.AD.C.Delta.8 and R12.TXK.C.Delta.8 Release Update Packs

3.1 Path A — Upgrade and New Installation Customers

Stop the all services and Start up only the Oracle Weblogic Admin Server on the run edition application tier file system.

you should apply patch using adop, you can download those patches and put it in default $PATCH_TOP location.

remaining steps , follow the document 1617461.1

 

Mandatory Steps for Custom Schema Upgrade for 11i / 12.0 / 12.1

Follow the document

For creating a Custom application:

For the custom products that already exist, you must run adsplice on the Run File system to lay down the file system. For running adsplice, refer to

Creating a Custom Application in Oracle E-Business Suite Release 12.2(Doc ID: 1577707.1)

Apply the Latest Oracle E-Business Suite Release Update Pack for Release 12.2

please refer to Oracle E-Business Suite Release 12.2.6 Readme (Doc ID 2114016.1)

Once applied patches, you can see the application EBS version is upgraded to 12.2.6

Then  follow the Post upgrade steps

https://docs.oracle.com/cd/E26401_01/doc.122/e48839/T579510T579526.htm

Upgrade oracle ebs 12.1.3 to 12.2.0

Here I have demonstrated how to upgrade your current EBS version 12.1.3 to 12.2.0.  I will write next part how to upgrade from 12.2.0 to 12.2.6

Step by step document for upgrade database to 12.1.0.2 (Its required also, so download this document)

https://mohamedazar.files.wordpress.com/2015/07/12c-upgrade-overview-of-oracle-applications-121.pdf

 

Step by Step document for update ebs version 12.1.3 to 12.2.0

upgrade-oracle-ebs-12-1-3-to-12-2

Issue When Trying To Generate The Custom WSDL ServiceGenerationError: Error In Service GenerationJ2T-120, ERROR: Illegal Option “-plsqlname=object

Please follow the note id

Issue When Trying To Generate The Custom WSDL ServiceGenerationError: Error In Service GenerationJ2T-120, ERROR: Illegal Option “-plsqlname=object (Doc ID 1619940.1)

Generate WSDL Command Errors With Inserted value too large for column (Doc ID 1913216.1)

Note : please check translator.jar file permission ,If It doesn’t have group permission , please

chmod g+w translator.jar

EBS 12.2.5 Release Update Pack Available

EBS 12.2.5 Release Update Pack Available (Patch 1967645

ref link EBS 12.2.5

Service Provider Access resulted in exception ‘oracle.apps.fnd.soa.util.SOAException: SystemError: Error while sending message to server. http://host.domain:8065/webservices/SOAProvider/EbizAuth?Generate= 3527

I have cloned our production environment (EBS version 12.1.3, DB 11.2.0.2) and then I have upgraded the database from 11.2.0.2 to 12.1.0.2.

and later We have requirement to enable integrate SOA gateway. So We were applied all the applicable patches at Production environment and enabled SOA also. So I thinking I have to enable asadmin and then I can able to generate wsdl through SOA. But When I tried , I am getting below error

“Service Provider Access resulted in exception ‘oracle.apps.fnd.soa.util.SOAException: SystemError: Error while sending message to server. http://xxxxxxx:8065/webservices/SOAProvider/EbizAuth?Generate=3527&soa_ticket=..’ when attempting to perform ‘GENERATE’. Please view Service Provider logs for more details”

and

http://xxxxxxxx:8065/webservices/SOAProvider/?testquery also return http 404 error.

Usually If we will get the above error If asadmin inactive or apps schema role are not defined for asadmin, So change the asadmin password and then we added the asadmin password in $ORA_CONFIG_HOME/10.1.3/j2ee/oafm/config/system-jazn-data.xml and then restarted service, It will work.

But My case I did all the steps but Still I am getting error.

Solution :

When i upgraded the database 12c R2,  I was missed to add the below parameter in sqlnet.ora and sqlnet_ifile.ora file

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

After I have added the parameter in both files and restarted the application and database.

Its working fine