News, views, tips and tricks on Oracle and other fun stuff

Handy Oracle EBS Trading Community Architecture (TCA) Diagram

Via Puneet Rajkumar.

Comments Off on Handy Oracle EBS Trading Community Architecture (TCA) Diagram | Filed in Oracle | Tags:

The Easy Way to Mask Sensitive Data in Cloned Oracle E-Business Suite Environments

Elke Phelps:

You can use the Oracle Data Masking Pack with Oracle Enterprise Manager today to scramble sensitive data in cloned environments. Due to data dependencies, scrambling E-Business Suite data is not a trivial task.  The data needs to be scrubbed in such a way that allows the application to continue to function. 
Using the Data Masking Pack in E-Business Suite environments is now easier with the release of new set of templates for E-Business Suite databases:

Oracle E-Business Suite Release 12.1.3 Template for Data Masking Pack (Patch13898999)

This template works with the Oracle Data Masking Pack and Oracle Enterprise Manager to obscure sensitive E-Business Suite information that is copied from production to non-production environments. 

Note that this not a free feature. You must purchase licenses for Oracle Enterprise Manager and the Oracle Data Masking Pack plug-in. The EBS template is included in the pack’s license.

Comments Off on The Easy Way to Mask Sensitive Data in Cloned Oracle E-Business Suite Environments | Filed in Oracle | Tags: ,

Fusion is just like E-Business Suite… Not!

For all of you EBS gurus out there, take comfort in knowing that there are similarities between Fusion and EBS. Not everything is similar though, and in some cases, it may be easier to forget your knowledge of “how EBS does it” and learn “how Fusion does it” without trying to translate.

via Oracle Fusion Financials Blog.

Comments Off on Fusion is just like E-Business Suite… Not! | Filed in Oracle | Tags:

Upgrading from Oracle E-business Suite to Fusion Apps

Debra Lilley:

There is a third issue, after support cost, and availability, there is the big issue around the upgrade path. Oracle have always said that there would be an upgrade path from the latest two releases which at the time was 11.5.10 and 12.0, but now we also have 12.1 so there is only a path from 12.0 onwards. Is this fair, well I am not sure, in most cases I see the move to Fusion Apps as a replacement is not the best thing for an organisation, especially one who has not already moved to R12, so not having the option is not a problem.
I think a lot of people will take Fusion but in small steps, taking the co-existence route, after perhaps adopting some technology first, over time. 
Comments Off on Upgrading from Oracle E-business Suite to Fusion Apps | Filed in Oracle | Tags: ,

How To Create and Use Custom Business Events in Oracle E-Business Suite

Oracle Workflow, a component of Oracle E-Business Suite, lets you set up subscriptions to business events which can launch workflows or enable messages to be propagated from one system to another when business events occur.

The Oracle Workflow Business Event System is an application service that leverages the Oracle Advanced Queuing (AQ) infrastructure to communicate business events between systems.

Predefined events are provided with some Oracle E-Business Suite products. For example, the “Create Person Event” ( is the name of a seeded business event in the Receivables application. The event is triggered when a person party record is created within the Trading Community Architecture (TCA).

Not all events are seeded. However, Oracle gives you the option to create a custom event. An example would be an event that is triggered when an invoice is matched to a purchase order.

In this article, I will show you how to create and use a custom business event. I will go through the following steps:

  1. Create a custom business event
  2. Create a subscription to the event
  3. Raise the event from PL/SQL
  4. Consume the event in PL/SQL

    Continue reading…

Comments Off on How To Create and Use Custom Business Events in Oracle E-Business Suite | Filed in Oracle | Tags: ,

For those of you keeping the faith with Oracle EBS 11i, it’s time to upgrade

Floyd Teter on Oracle E-Business Suite:

Here’s the upshot for those of you “keeping the faith” with 11i. The iceberg is melting, the curtain is coming down, the lights are dimming, the fat lady is singing. The later versions of 11i were good things…we got bundles of value out of 11i…but, like it or not, it’s winding down in favor of a better product in R12.1.3. It’s time to upgrade. Frankly, the longer you keep the faith with 11i, the more you’ll miss out on the value of the new products…and the more it will cost when you do make the move.
Comments Off on For those of you keeping the faith with Oracle EBS 11i, it’s time to upgrade | Filed in Oracle | Tags:

Best Practices for Oracle E-Business Suite Performance Tuning

Steven Chan:

Isam Alyousfi and Lester Gutierrez are key members of our Applications Performance Group. They recently presented their popular session covering performance tuning tips for all layers of the E-Business Suite at OAUG/Collaborate earlier this year. […] This presentation is chock full of tips, pointers, and hard-won knowledge. It represents the distillation of countless performance-related Service Requests and customer escalations. If you’re grappling with performance issues in your environment, or simply trying to squeeze more performance out of existing hardware, I’d strongly recommend downloading this presentation.

Tuning All Layers Of E-Business Suite – Performance Topics

Comments Off on Best Practices for Oracle E-Business Suite Performance Tuning | Filed in Oracle | Tags: , ,

Oracle EBS Customization and Extension – OAF vs ADF vs APEX vs Forms

Andries Hanekom:

The E-Business Suite Technology Group recently released a whitepaper: Extending E-Business Suite 12.1.3 using Oracle Application Express. In summary, “This new whitepaper outlines how to extend Oracle E-Business Suite 12.1.3 (and higher) functionality using Oracle Application Express. Recommended architecture and security considerations are discussed in detail.” For some time now EBS customers have used APEX to extend EBS, with the release of this whitepaper the EBS Tech group has acknowledged the growing use of APEX to extend EBS and have provide recommendations and guidelines for integration.

What’s this all about some might ask, is Oracle moving to incorporate APEX as part of the standard EBS tech stack? What about OAF? Isn’t Fusion Applications build on ADF, so what’s up? Well when it comes to Oracle EBS extension and customization, OAF is till the top dog, the E-Business Suite Technology Group continues to recommend OAF for EBS extensions.
Comments Off on Oracle EBS Customization and Extension – OAF vs ADF vs APEX vs Forms | Filed in Links, Oracle | Tags: , , ,

5 Recent Oracle Security Related Documents

  1. Oracle Applications 11i Encrypted Password String Disclosure (PDF): An undisclosed security vulnerability exists in Oracle Applications 11i that may allow an unauthenticated, internal attacker to obtain Oracle Applications’ user account encrypted password strings, which in turn can be decrypted using previously published information. An attacker can potentially obtain either any user’s password or the Oracle Applications’ main database account password (APPS).

  2. Building an Audit Trail in an Oracle Applications Environment (PDF): Sarbanes-Oxley’s section 404 requires a company’s key systems be audited. However, many companies have “unauditable” systems and don’t even know it. This paper explores methods by which companies can create an auditable system by implementing various levels of audit trails in Oracle Applications.

  3. Dissecting the Redo Logs (PDF): This paper delves into the guts of the undocumented binary format of the redo logs and shows the forensics examiner, if there is evidence to be found, how to find it and how it can be integrated into a time line of events. It also explores how an attacker can attempt to cover their tracks and how to spot this.

  4. Locating dropped objects (PDF): This paper shows, even when an object has been dropped and purged from the system there will be, in the vast majority of cases, fragments left “lying around” which can be sewn together to build an accurate picture of what the actions the attacker took. Perhaps, depending upon how quickly an investigation takes place from the incident in question, even all data pertaining to the dropped object or objects may still be found.

  5. Isolating Evidence of Attacks Against the Authentication Mechanism (PDF): This paper looks at attacks against the authentication mechanism and evidence to check whether a logon attempt was successful or not. It also looks at other attacks leveled at the authentication process including SID guessing, user enumeration and brute forcing of passwords over the network. Moreover, the paper looks at the differences between a logon attempt via the FTP and Web services provided with the XML Database and directly with the RDBMS itself.

1 Comment | Filed in Oracle, Security | Tags: , ,

Oracle E-Business Suite Release 12 Electronic Technical Reference Manual Up And Running

We are in the process of upgrading our Oracle E-Business Suite (EBS) from 11.0.3 to 11.5.10 (more on that later). So, I frequently visit the EBS Electronic Technical Reference Manual (eTRM) to browse and try to understand the data models, database design and APIs of some EBS modules. When I logged in this morning I noticed that the eTRM for EBS release 12 had been posted. I thought of sharing this news with you.

Note: you need a Metalink account in order to be able to browse the eTRM.

Comments Off on Oracle E-Business Suite Release 12 Electronic Technical Reference Manual Up And Running | Filed in Oracle | Tags: