Search This Blog

Showing posts with label System Administrator. Show all posts
Showing posts with label System Administrator. Show all posts

Sunday, May 24, 2020

EBS Integration Repository and eTRM


As a lot of companies and users shift their focus towards the Cloud Products, sometimes it's easy to forget that an enormous number of customer still utilize EBS and will continue to do so for years to come. As such, those customers will continue to integrate their EBS environments with other systems, like early payment engines, OCR engines, tax engines, third party SCM systems, other ERP's and more. The following two resources are extremely powerful when planning integration work for EBS, and I have leveraged them countless times.

First, I wanted to remind everyone that the Integration Repository responsibility in EBS is a great resource to see whether there is already an Oracle API to accomplish a specific task. Please make use of it when building solutions to address customer needs or if you have doubts in regards to whether the vendor you are working with for your project, or your own development team, is building a custom function for an existing standard function or procedure, as you always want to leverage seeded functionality that will be supported by Oracle and doesn't break when upgrades happen.

For those that are not familiar with the Integration Repository, you simply need to add it as a responsibility under your user and browse the different modules to drill down to the specific service interface you want to look at. Once you drill into a specific API, you will see a list of the details including function names, parameters, rules, and much more.

Browsing the repository:



  • I am showing Projects related API's in the screenshot.

Additionally, remember the Oracle eBusiness Suite Electronic Technical Reference Manual (eTRM), is also available to us with our Oracle Support accounts.

This one is especially useful to see EBS database design and dependency information, you can also browse the FND model and the Data Dictionary with it! This is an extremely powerful tool to see what happens to those database objects that you rely on when upgrades occur, as those changes will likely impact your custom concurrent programs, reports, alerts, and other extensions.


EBS Seeded Comparison Reports

Hello everyone, I haven’t written about EBS in a while since I’ve been focused on the Cloud products, but I wanted to bring to your attention the below seeded reports provided by Oracle which can be used to compare environments with different patch sets, to better assess the impact of applying those patches/upgrades and see differences at a low level. This is as relevant as ever since EBS patching hasn’t slowed down, and many new features continue to come in.

Below are descriptions of each report with the respective Oracle notes with all the relevant information. Most of the content and report description come straight from Oracle Support, the idea is to consolidate them here for your awareness.

They are all very useful, and one of them specially is of interest to me and I have used it extensively in order to compare different ATG versions to assess impact and help build a test plan. The ATG patch family is important because EBS continues to enhance through different avenues like enhanced Mobile support and the Enterprise Command Centers, and these rely heavily on your ATG readiness.

The EBS File Comparison Report provides a comprehensive comparison of file system artifacts between different Oracle E-Business Suite releases for important file types. As part of Oracle E-Business Suite upgrade planning, this report can assist customers to get a clear idea of "what is different in a new release" (additions, removals and modifications for Oracle E-Business Suite delivered files).

The report also covers some special artifacts that span the file system and database (for example, Oracle E-Business Suite delivered Oracle Application Framework (OAF) personalizations, Oracle Application Framework (OAF) based pages, Oracle Business Intelligence Publisher reports and so on).The EBS File Comparison Report is intended to complement other already available reports such as EBS Data Model Comparison report and EBS ATG Seed Data Comparison report.

The EBS data model comparison report provides the static database object definition changes between two EBS releases to help users to preview the database object definition changes before upgrading their instances from one release to another and understand the impact of the database object changes that may affect the customization or business flows. Users can select a product and navigate the database object definition differences for each supported database object type.

The EBS ATG Seed Data Comparison Report provides a static delta between different EBS releases by documenting the seed data changes delivered by the product data loader files (.ldt extension) based on EBS ATG loader control (.lct extension) files.

The below Oracle Notes cover how to install and navigate the reports. All of these Oracle docs continue to get updated as releases occur and support up to 12.2.9 has been delivered for each of the below:

o EBS Data Model Comparison Report Overview (Doc ID 1290886.1)
o EBS File Comparison Report [VIDEO] (Doc ID 1446430.1)
o EBS ATG Seed Data Comparison Report (Doc ID 1327399.1)

Tuesday, March 12, 2019

Cloud Security – A Reflection

The Gartner article by Jae Heiser, Analyze the Risk Dimensions of Cloud and SaaS Computing, was really relevant for me in the topic of Cloud security and the different implications of IaaS, PaaS and SaaS models from a risk management perspective. As more vendors move their solutions to the Cloud, forcing customers to adopt some sort of Cloud model, we are left struggling to figure out how security looks; it is certainly one of the toughest things to deal with in this space.

Heiser correctly points out that analyzing risks, when it comes to cloud computing, becomes complex given a lack of best practices on the method and content of a cloud services risk assessment. This is driven by the lack of transparency presented by service provides, particularly in a SaaS model. Under normal circumstances, where the organization has control, there is an expectation that the systems that are being evaluated are well proven and well understood, meaning we know where all the layers are located and privileged users are identifiable and supervised in many ways. When it comes to SaaS solutions, the system administrators are not known and many different layers of the architecture, like the services, network, the storage, the servers, and in many ways even the application, are black boxes, as far as the client is concerned. As Heiser notes, this concern is not so prevalent with an IaaS model, given customers control a lot more in terms of the data, the application, the virtual machines and they are actually responsible for monitoring and auditing to a large extent, and have the required access to perform such activities. Lastly, with PaaS, there is far more shared responsibility between the customer and the provider given where the security controls are located.

Again, with SaaS, the provider is responsible for pretty much all of the security functionality, the monitoring, and incident response. All this means is that you as a customer have minimal ability to add controls and other security mechanisms outside of functionality that is native to the application, as Heiser notes. Do you want to set up a custom alert when a financial period is opened or a user creates an invoice over a specified threshold? You better hope the application can do that out of the box, because you can’t extend it. Also with SaaS, design and build of any application related functionality is a black box for customers, and you may simply receive and email with the latest updates that will be released for your application the following month. Without this transparency there can be no expectation that functionality will remain the same, meaning we have to take into account security testing in the time allotted to us as users, in order to test whatever controls we do have access to before the updates get rolled out to your Production environment.

One important point Heiser talks about, which many don’t think about, is that often times your cloud providers are themselves a customer of an additional provider. So basically, your provider may own and support the application, but they may be using another provider for the infrastructure, the storage, etc. This is called a nested hosting arrangement, and it really complicates security even further. Everything that has been mentioned to this point has really been assuming that your SaaS application is fully supported by one vendor, but the risks are compounded, and the complexity increases many times over, when nested hosting is in place. Basically, you need to conduct a risk assessment of each and every provider involved in each layer of that cloud application (this may apply to more than just SaaS).

As Heiser reinforces, oftentimes there’s really nothing you can do given the lack of transparency in many areas, so you have to rely on your contract serving as a mechanism that ensures appropriate levels of security and service level expectations, at the risk of transparency and real control. This of course is all depending upon whether the legal system will enforce penalties for noncompliance and to what degree. Overall, it is very clear that security in the cloud is a behemoth of a problem, and it involves everything from risk assessment of your providers to controls, to auditing, to monitoring, and everything you can think of that’s security related and you were able to do in your On-Prem environments. It is worth noting that many vendors will work with you and provide evidence of whatever controls you ask of them, and you should, and they should be able to produce proof, also, certain providers have different tools that handle security within their suite of Cloud tools, which you can leverage to satisfy some additional controls.

References

Heiser, Jay. Analyze the Risk Dimensions of Cloud and SaaS Computing. Gartner. March 15th, 2013.

Tuesday, January 8, 2019

E-Business Suite Support Analyzer Bundle Menu Tool and Automatically Updating Analyzers

If you support Oracle EBS R12 then you are familiar with the Oracle Analyzers. They are essentially reports that were designed by Oracle Support to assist with diagnosing issues by providing detailed analysis and even some potential solutions, like applying a relevant generic data fix or suggesting a patch. These analyzers can also speed up your response time when creating an SR by providing the outputs for the relevant analyzers in a product family when you initiate the SR.

The issue with the Analyzers is that there are a lot of them, and maintaining them can become difficult. This is because Analyzers are basically scripts that can be ran manually by your DBA or can be setup to run as a concurrent program (not all Analyzers allow for this). What this means is that it's time consuming to install analyzers and configure them to be ran as concurrent programs and then keeping them up to date, as Oracle releases new versions of the packages behind said Analyzers rather often.

Here is where the Bundle Analyzer tool comes into play. It makes it easy to install all the available Analyzers from a menu that can be easily navigated and utilized by a System Administrator or DBA. You can also quickly load and register analyzers as concurrent programs and also have the ability to uninstall them. Basically, the tool provides a simple interface that makes it really easy to perform these tasks.

You also don't need to worry about data integrity, per Oracle, "Application data is not altered in any way when the Analyzer Bundle Menu is installed or when any Support Analyzer is run."

What this allows you to do, as a support team, is quickly spinning up the analyzers you want to use and update them on a regular basis, maybe when you do your releases, or anytime you wish and as time allows. One of the features of the tool is that you can bulk load all analyzers in a given EBS product family or even all analyzers in all families, as well as individual analyzers, if you don't want to complicate matters by having unnecessary capabilities.

The installation steps are very simple for any DBA or System Administrator, and all the steps are outlined in the below note provided by Oracle:

E-Business Suite Support Analyzer Bundle Menu Tool (Doc ID 1939637.1)

Now, while the Bundle tool greatly simplifies this effort of obtaining analyzers and updating them, there’s still manual work involved, and many of us have asked whether there's some way to automate this further.

In response, Oracle has now released a new feature allowing concurrent programs to be scheduled to address updating analyzers using the bundle tool. This can allow you to automate updating your existing analyzers on a regular basis without human intervention.

All the details in regards to this valuable enhancement to the Analyzer Bundle tool can be seen in the below note provided by Oracle. The note contains all the details around the two concurrent programs involved in the Auto Update feature and how it works.

E-Business Suite Support Analyzer Bundle AutoUpdate Concurrent Program (Doc ID 2377353.1)

This is an extremely powerful tool that can truly enhance your capabilities to support your customers proactively and I urge everyone to explore it.

Regards,

Julio