Skip to content

Category: Apps R12.2

Integrated SOA Gateway (ISG) – 2 – Service Enablement in Oracle E-Business Suite

Published December 1, 2019 By Brijesh Gogia

We already described in earlier post what is web service. Service enablement is one of the “essential features”  or “process flow” in Oracle E-Business Suite Integrated SOA Gateway. You can say it is that “magic ingredient” which allows native packaged integration interface definitions written in PL/SQL, Java, and other formats and stored in Oracle Integration Repository to be transformed into Web services.

“Service enablement” involves:

  • Generating service artifacts, such as XSD
  • To validate XML messages, WSDL or WADL to describe the Web service,
  • Deploying web services on an application server so that the services are available to clients over the Web.
Continue ReadingIntegrated SOA Gateway (ISG) – 2 – Service Enablement in Oracle E-Business Suite
Leave a Comment

Integrated SOA Gateway (ISG) – 1 – fundamentals

Published November 30, 2019 By Brijesh Gogia

Before going into ISG Concepts, it is important to briefly understand what is a Web Service and some other related terms which can be new for beginner.

Web Services:

  • Web Service in simple terms is a “software system” for machine-to-machine interaction over a network.
  • Its interface is described in certain format which can be processed by machine.
  • WSDL is one kind of interface format which can be created using SOAP messages
  • WADL is another kind of interface format created using REST messages
  • Web Services are self-describing, reusable software components encapsulating discrete functionality. Example: Employee creation can be one self-contained web service.

Continue ReadingIntegrated SOA Gateway (ISG) – 1 – fundamentals

Leave a Comment

Oracle EBS R12 and TDE Tablespace Encryption

Published December 21, 2017 By Brijesh Gogia

Keeping data secure is one of the primary job of DBA. Oracle’s Transparent Data Encryption Tablespace Encryption option of Oracle Database 11g Enterprise Edition provides an excellent method to encrypt data at rest. This option works perfectly with Oracle EBS R12.

The TDE Tablespace Encryption option can be used to encrypt the tablespaces that store the content of your E-Business Suite application so you can encrypt the database files and any backups of these files. Good thing about TDE is you do not have to change any of your existing code as TDE is transparent to application.

Continue ReadingOracle EBS R12 and TDE Tablespace Encryption
3 Comments

EBS Database Parameter Settings Analyzer

Published July 18, 2017 By Brijesh Gogia

All Oracle Apps DBA must have referred below Note id at least once in their career. Most of us refer it  during installation and upgrade of Oracle EBS
application to verify if we have right set if database parameters defined for the optimum performance of EBS application.

Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1)

This document has all the required database parameters which are common to all the database release and which are required by EBS application. It also contains release specific database initialization parameters for different releases like 10g, 11g, 12c etc.

Continue ReadingEBS Database Parameter Settings Analyzer
Leave a Comment

Online Patching (ADOP) in Oracle EBS R12.2

Published February 21, 2016 By Brijesh Gogia

Online patching is supported by the capability of storing multiple application editions in the database, and the provision of a dual application tier file system. At any given point in time, one of these file systems is designated as run (part of the running system) and the other as patch (either being patched or awaiting the start of the next patching cycle).

Continue ReadingOnline Patching (ADOP) in Oracle EBS R12.2
32 Comments

Change weblogic user password in EBS R12.2

Published October 6, 2014 By Brijesh Gogia

EBS 12.2 uses WebLogic Server from Fusion Middleware 11g in place of OC4J 10g as part of the release’s internal technology stack.

Your organization’s security rule may demand changing password for important uerids at regular interval. This document describes the procedure to use if you need to change the password  of the Oracle WebLogic Server Administration user password at some time.

Continue ReadingChange weblogic user password in EBS R12.2
9 Comments