Tag Archive: EBS 12.1.3

Purging Oracle EBS Integrated SOA Gateway Tables

If you happen to be using Oracle E-Business Suite Integrated SOA Gateway (ISG) you may at some point find yourself retaining way too much data.  Did you know that there is a seeded purge program available that will delete data from the underlying tables?  This is helpful to maintain the data at a reasonable size to help performance and minimize the storage footprint.   Observations My SOA purging journey began due to a performance related issue.  This occurred when I navigated to the Integrated SOA Gateway responsibility > SOA Monitor, it was taking upwards of 5 minutes to pull up that web page.  When I…
Read more

SQL Trace for Oracle MWA

Occasionally the need arises to enable SQL trace for Oracle Mobile Web Applications (MWA) for WMS or MSCA related E-Business Suite modules to track down the source of poor performing queries.  Enabling this is quite easy but may not be obvious when looking at the options in the configuration file.  This particular example is assuming E-Business Suite 12.1.3. Let’s take a look at the MWA configuration file (mwa.cfg) located in $INST_TOP/admin/install.  It’s interesting to note that the parameter that we modify to enable SQL Trace, mwa.LogLevel, doesn’t list the value we need for performing a SQL Trace.  It appears that the…
Read more

E-Business 12.1.3 Displaying Clear Text Password

Recently I came across a post in one of the LinkedIn groups that someone shared about discovering the apps password being displayed in clear text in Oracle E-Business Suite 12.1.3 when compiling Oracle Forms either by the adpatch or adadmin utilities.  The person had an SR open with Oracle Support on the issue and they provided them with a patch to resolve it.  Thankfully he shared the patch number with everyone. It seems that this security flaw was fixed sometime back but through some other set of patches must of broken this functionality.  I decided to test in a sandbox…
Read more

XLA_GLT Tables Not Being Dropped in EBS 12.1.3

The Problem Recently I was going through a list of our top largest tables in our E-Business Suite (12.1.3) database (11.2.0.3) and found many tables in the GL schema that began with XLA_GLT_*.  Looking into this further I found over 300 of these tables (which also had indexes and synonyms) consuming over 30 Gigs of space.     Research After doing some research on My Oracle Support I found several articles that helped explain what we are seeing.  One of them in particular was a direct match to our problem, “SLA: Temporary Tables XLA_GLT_ % Are no Longer Dropped (Doc…
Read more