EBS 12.1.3 Archives - Hey Alfredo...

Purging Oracle EBS Integrated SOA Gateway Tables

Alfredo April 30, 2017 0 Comments

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…
Read more

EBS 12.1.3

E-Business Suite, EBS 12.1.3, Integrated SOA Gateway, ISG

SQL Trace for Oracle MWA

Alfredo August 31, 2016 0 Comments

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…
Read more

EBS 12.1.3, MWA

EBS 12.1.3, msca, mwa, sql trace, wms

E-Business 12.1.3 Displaying Clear Text Password

Alfredo August 18, 2016 3 Comments

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…
Read more

EBS 12.1.3

adadmin, EBS 12.1.3, Oracle Forms, password, security

XLA_GLT Tables Not Being Dropped in EBS 12.1.3

Alfredo July 31, 2015 0 Comments

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…
Read more

EBS 12.1.3

11gR2, EBS 12.1.3, General Ledger, XLA_GLT