APPS Blogs

Ten Years and Counting

Steven Chan - 10 hours 56 min ago

This blog turned 10 this year.  When I started it in 2006 with this article, I had no idea that it would become what it is today.  Things certainly turned out differently than I expected. 


Photo credit: Fulvio Spada, Wikimedia Commons

This little blog now gets millions of visits a year.  It has helped us shape EBS to meet your needs better.  I've been schooled in the many ways that we can do things better for you.  I've been chastised for offhand editorial remarks and have learned to deal with hate mail.  I've learned how hard it is to be a journalist, to state just the facts and pare prose down to its simplest form, accessible to all (with this verbose article being an exception to that rule).

Over the years, I've had several people who have helped me paint this fence. Some of those people have since joined the ranks of Oracle's esteemed alumni.  Some still pitch in occasionally.  Either way, I'm grateful for their contributions over the years.  As with the Stone Soup parable, this little corner of the world is richer for their sharing their expertise with us.

I am sometimes mistaken as an expert, but the real experts are my colleagues and friends in the E-Business Suite division and our sister organizations across Oracle.  They deserve the real credit for all of their dedication, professionalism, and expertise. They are a brilliant team and I am always humbled by their desire to do the best for you.  I am privileged to work alongside them and talk about their achievements on their behalf.  Please join me in thanking all of them for their hard work in polishing EBS to a shine for you. 

And, of course, thank you for joining me on this journey.  I am fortunate to have many of the world's leading EBS experts as readers and friends, and they contribute to this blog in ways large and small.  This blog would not be the same without the lively interactions with all of you.  I look forward to seeing what lies down the road around the corner!

Categories: APPS Blogs

Database Vault 12.1.0.2 Certified with EBS 12.1 and 12.2

Steven Chan - Fri, 2016-12-02 02:05

Oracle Database Vault allows security administrators to protect a database from privileged account access to application data.  Database objects can be placed in protected realms, which can be accessed only if a specific set of conditions are met.

We are pleased to announce that Oracle Database Vault 12c 12.1.0.2 is now certified with Oracle E-Business Suite Release 12.2 and 12.1. To integrate Oracle Database Vault 12c with Oracle E-Business Suite Release 12.2 or 12.1, follow the instructions in the corresponding My Oracle Support Knowledge Document:



Note:  We deliver a default realm via two different patches for Oracle E-Business Suite 12.2 and 12.1 .  You may use the default realm as-is or choose a subset.

Pending Certifications with External Integrations

The following two configurations are still underway and pending:

  • Single Sign-On Integration with Oracle Access Manager
  • Oracle Discoverer

Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog. I'll post updates here as soon as soon as they're available.   

References

Related Articles

Categories: APPS Blogs

Which Oracle Internet Directory Patchsets Can Be Used With EBS?

Steven Chan - Thu, 2016-12-01 02:05
You can apply any Oracle Internet Directory (OID) bundle patchsets that have been certified at the fourth-level digit to a certified Oracle E-Business Suite release.  The fifth-level digit in OID versions is not relevant to E-Business Suite certifications. 

For example, we have certified EBS 12.2 with OID 11.1.1.9. All of the following Oracle Internet Directory patchsets will work with EBS 12.2:

  • Oracle Internet Directory 11.1.1.9.0 (documented certification)
  • Oracle Internet Directory 11.1.1.9.3
  • Oracle Internet Directory 11.1.1.9.160719

This is sometimes shown in our documentation in either of the following ways:

  • Oracle Internet Directory 11.1.1.9
  • Oracle Internet Directory 11.1.1.9.x

The absence of a fifth-digit or the presence of an 'X' in the fifth digit's place means any fifth-digit level updates may be applied to an Oracle Internet Directory environment integrated with EBS 12.2 without requiring a new certification.  This applies to all environments, including test and production environments.

Reference

Related Articles

Categories: APPS Blogs

Load-Balancing EBS 12.2 Environments

Steven Chan - Wed, 2016-11-30 02:06
You can use load-balancing routers (LBR) to protect your E-Business Suite 12.2 environment from system failures.  Load-balancers increase your environment's fault-tolerance and scalability by distributing load across a pool of servers. See: HTTP Layer Load-Balancing

HTTP Layer load-balancing is the most common method used in E-Business Suite environments. In this configuration, end-users navigate to a specific Web Entry Point that represents your E-Business Suite's domain name.  An HTTP Layer load-balancer routes all subsequent traffic for a specific user to a specific Web Node.

EBS LBR Architecture

HTTP Layer load-balancers may use heartbeat checks for node death detection and restart, and sophisticated algorithms for load-balancing.

DNS-Based Load-Balancing

When an end-user's browser attempts to access your E-Business Suite environment, your local Domain Name Server (DNS) can direct that user to a specific application server in a pool based on available capacity:


Traffic for that user's session will be handled by the application server 10.10.10.10, while other users' traffic may be directed to other application servers in the pool.  Like HTTP layer load-balancers, many DNS-based load-balancers use heartbeat checks against nodes and sophisticated algorithms for load-balancing.

Minimum Requirement:  Session Persistence

Oracle doesn't certify specific load-balancers or networking hardware with the E-Business Suite.  We've designed the E-Business Suite to be able to use load-balancers in general. Our instructions for configuring load-balancers should work for all standards-compliant networking solutions, whether they are hardware or software-based.

The minimum requirement is that a load-balancer support session persistence.  Persistence describes a mode where a client's initial HTTP connection is directed to a particular application server, and then subsequent HTTP requests from that client are directed to the same server.  As long as a load-balancer is able to handle session persistence (also referred to as "stickiness"), it's likely to work with the E-Business Suite.

Other load-balancing variations

EBS 12.2 can be deployed in a number of variations to handle specialized or advanced load-balancing requirements.  For details about implementing the following variations, see:

WLS Clusters: EBS 12.2 uses WebLogic Server.  It is possible to deploy multiple WebLogic Server instances in a cluster to increase scalability and fault-tolerance. A cluster appears to clients to be a single WebLogic Server instance. The server instances that constitute a cluster can run on the same machine, or be located on different machines. You can increase a cluster’s capacity by adding additional server instances to the cluster on an existing machine, or you can add machines to the cluster to host the incremental server instances. Each server instance in a cluster must run the same version of WebLogic Server.

Multiple Web Entry Points:  It is possible to configure the same EBS environment to have multiple web entry points (URLs).  For example, users might be able to access your EBS environment via the following different URLs:

  • store.company.com
  • recruitment.company.com

Functional redirection:  It is possible to direct users to specific servers based upon the functional responsibilities that they chose.  For example, manufacturing end-users may be directed to a different pool of servers than, say, HRMS end-users.

Related Articles

Categories: APPS Blogs

Automated Accountants: Personal Assistant Technology

David Haimes - Tue, 2016-11-29 07:22

robot-accountantIn my house, Alexa (aka Amazon Echo) is part of the family.  My young children check the weather whilst eating their breakfast, see how their favorite sports teams are doing, get some jokes, movie times and anything that pops into their head they will just “Ask Alexa”.  They also have a lot of fun seeing how Apple’s Siri and Alexa answer the same questions and which works better for what.  Observing these interactions and interacting myself has been a very good hands on research exercise and I have been thinking for a while of enterprise applications.

We can use personal assistant technology bots to use context and intelligence to provide a natural interface and increase participation in our cloud applications.We can increase participation on two groups of users

  • Casual Users
    • They have infrequent and limited interactions with the applications and do not have the time, or the training and familiarity with the capabilities to participate effectively.  They don’t know what information they can get, never mind how to get it.
  • Power Users
    • For these users it is about reducing the time it takes to do highly repetitive or UI intensive tasks.  This is like me at home getting sports scores or weather from Amazon Echo, I could easily look it up on my phone but it is easier to just say “Alexa, weather” whilst I am pouring my coffee.

I put together a team to enter a hackothon by our UX innovation team last month and we tried to focus on the former use case.  A high level manager who is very busy, runs a team of 50-100 people and manages to budgets but does not have a secretary.  We imagined her wanting to know details of budgets and implemented three flows

  1. Inquiry on remaining budget
  2. Details of who spent a budget on what
  3. Transfer funds from one budget to another (say from travel to computer hardware)

We spent a lot of time trying to make the interactions as natural as possible, so getting the natural language trained correctly was key and we also wanted to use Amazon Echo, IM and SMS messages to interact with the live data in an ERP Cloud environment.

It was a great experience and we learned a lot technically. but probably more of a revelation was the different design strategy for these types of interaction.  The other teams also did some amazing things(read the event review here) so we were pleased to pick up third place overall and the People’s Choice Award (voted on by all the participants).

I fully expect Automated Personal Assistants to be a key interaction model for Enterprise applications going forward, just as we are seeing them start to take off in the consumer space.   Exciting times.


Categories: APPS Blogs

EBS Presentations at December 2016 UK Oracle User Group Meeting

Steven Chan - Tue, 2016-11-29 02:05
Staff from Oracle E-Business Suite Development will be contributing to the APPS16 track of the UKOUG Conference & Exhibition 2016. The conference takes place at the International Convention Centre, Birmingham, England, and runs from Sunday 4th December to Wednesday 7th December.


Please bring your questions or issues about any aspect of running EBS: feel free to ask about overall strategy, specific deployment aspects, or anything else you want to know.

You'll also have the chance to attend numerous formal presentations from prominent Oracle speakers on many aspects of EBS. Here are some highlights.

On the Monday (5th), there is a great opportunity to hear the latest news from the general manager of EBS:

Another presentation that will be of particular interest to readers of this blog is:

General EBS presentations include:

And last but not least, don't miss the chance to hear about EBS Release 12.2 online patching feature from one of its architects:

You'll also be well placed to attend the TECH16 track, where you can learn about the latest developments in Oracle Database and other technologies.

We look forward to seeing you at APPS16!

References

Related Articles
Categories: APPS Blogs

Will EBS Work with Microsoft Unified Update Platform?

Steven Chan - Mon, 2016-11-28 02:00

Windows 10 logoMicrosoft is changing their packaging of major Windows 10 updates from full operating system downloads to smaller, incremental downloads.  This new delivery method is called the Unified Update Platform (UUP).

The new UUP delivery method will provide only the Windows 10 patches that have been released since the last time a desktop was updated.  Microsoft currently expects to switch to this new delivery method after the Windows 10 Creators Update is released in early 2017.

Will this work with EBS?

Yes.  Windows 10 is certified with all current EBS releases, including EBS 12.1 and 12.2.  This new delivery method is not expected to change that.

Microsoft emphasizes that nothing changes with Windows 10 itself -- this only modifies the way that Win10 patches are delivered:

It’s important to note that with UUP, nothing will look or behave differently on the surface, UUP is all underlying platform and service optimization that happens behind the scenes.

Related Articles

The preceding is intended to outline our general product direction.  It is intended for information purposes only, and may not be incorporated into any contract.   It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision.  The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Categories: APPS Blogs

Reminder: Upgrade to EM 12.1.0.5

Steven Chan - Fri, 2016-11-18 02:05

Oracle periodically produces Fusion Middleware patchsets -- cumulative collections of fixes -- between major product releases.  All Oracle customers have a limited amount of time to upgrade from the prior patchset when a later patchset is released.  This is called the "grace period."  You cannot request new patches for the prior patchset after the grace period ends.

Where are Fusion Middleware grace periods documented?

The specific grace periods for upgrading from one Fusion Middleware patchset to another are published here:

Do these apply to EBS customers?

Yes.  These dates apply to all Oracle customers, including E-Business Suite customers. 

What is the impact on EBS customers using Application Management Pack?

Enterprise Manager 12.1.0.5 was released in June 2015.  Oracle continued to create new patches for EM 12.1.0.4 until June 2016.  New patches for EM 12.1.0.4 are no longer available. New patches are being created only for EM 12.1.0.5.

EBS 12.1 and 12.2 customers who need new patches for their Enterprise Manager components must be on EM 12.1.0.5 and AMP 12.1.0.4 BP3, at minimum.  No new patches for earlier versions of AMP will be available.

EBS customers should consider upgrading to Enterprise Manager 13c and AMP 13.1 or higher:

Related Articles


Categories: APPS Blogs

Oracle Enterprise Manager 12.1 Support Dates Changed

Steven Chan - Thu, 2016-11-17 02:08

Two important changes have been made to Oracle Enterprise Manager 12.1 Lifetime Support dates:

  1. Extended Support fees have been waived for the first year up to October 31, 2017
  2. Extended Support now ends on October 31, 2020 (one extra year of Extended Support)

These changes are published here:

Impact on EBS customers

These support changes apply to E-Business Suite customers using Application Management Pack released as part of Oracle Application Management Suite for Oracle E-Business Suite. 

EBS customers should consider upgrading to Enterprise Manager 13c and AMP 13.1 or higher:


Categories: APPS Blogs

E-Business Suite Technology Codelevel Checker Updated for EBS 12.2

Steven Chan - Wed, 2016-11-16 02:05

The E-Business Suite Technology Codelevel Checker (ETCC) tool helps you identify missing application tier or database bugfixes that need to be applied to your E-Business Suite Release 12.2 system. ETCC maps missing bugfixes to the default corresponding patches and displays them in a patch recommendation summary.

What's New

ETCC was recently updated to include bug fixes and patching combinations for the following:

  • October 2016 WebLogic Server (WLS) Patch Set Update (PSU)
  • October 2016 Database Patch Set Update and Bundle Patch
  • July 2016 Database Patch Set Update and Bundle Patch
  • July 2016 Database Cloud Service (DBCS) / Exadata Cloud Service (ExaCS) service

Obtaining ETCC

We recommend always using the latest version of ETCC, as new bugfixes will not be checked by older versions of the utility. The latest version of the ETCC tool can be downloaded via Patch 17537119 from My Oracle Support.

Related Articles

References

Categories: APPS Blogs

DSTv28 Timezone Patches Available for E-Business Suite 12.1 and 12.2

Steven Chan - Tue, 2016-11-15 02:04
Hourglass iconIf your E-Business Suite Release environment is configured to support Daylight Saving Time (DST) or international time zones, it's important to keep your timezone definition files up-to-date. They were last changed in October 2016 and released as DSTv27.

DSTv28 is now available and certified with Oracle E-Business Suite Release 12.1 and 12.2. This update includes the timezone information from the IANA tzdata 2016g.  It is cumulative: it includes all previous Oracle DST updates. 

Is Your Apps Environment Affected?

When a country or region changes DST rules or their time zone definitions, your Oracle E-Business Suite environment will require patching if:

  • Your Oracle E-Business Suite environment is located in the affected country or region OR
  • Your Oracle E-Business Suite environment is located outside the affected country or region but you conduct business or have customers or suppliers in the affected country or region

The latest DSTv28 timezone definition file is cumulative and includes all DST changes released in earlier time zone definition files. DSTv27 includes changes to the following timezones since the DSTv24 release:

  • Asia/Rangoon
  • Asia/Istanbul
  • Europe/Istanbul
  • Turkey

What Patches Are Required?

In case you haven't been following our previous time zone or Daylight Saving Time (DST)-related articles, international timezone definitions for E-Business Suite environments are captured in a series of patches for the database and application tier servers in your environment. The actual scope and number of patches that need to be applied depend on whether you've applied previous DST or timezone-related patches. Some sysadmins have remarked to me that it generally takes more time to read the various timezone documents than it takes to apply these patches, but your mileage may vary.

Proactive backports of DST upgrade patches to all Oracle E-Business Suite tiers and platforms are not created and supplied by default. If you need this DST release and an appropriate patch is not currently available, raise a service request through support providing a business case with your version requirements.

The following Note identifies the various components in your E-Business Suite environment that may need DST patches:

What is the business impact of not applying these patches?

Timezone patches update the database and other libraries that manage time. They ensure that those libraries contain the correct dates and times for the changeover between Daylight Savings Time and non-Daylight Savings Time.

Time is used to record events, particularly financial transactions.  Time is also used to synchronize transactions between different systems.  Some organizations’ business transactions are more-sensitive to timezone changes than others. 

If you do not apply a timezone patch, and do business with a region that has changed their timezone definitions, and record a transaction that occurs at the boundary between the “old” and the “new” time, then the transaction may be recorded incorrectly. That transaction's timestamp may be off by an hour. 

For example:

  • An order is placed for a customer in a country which changed their DST dates in DST v27
  • The old Daylight Savings Time expiration date was Nov. 2
  • The new Daylight Savings Time expiration date is now October 31
  • An order is set to ship at 12am on November 1st
  • Under the old Daylight Savings Time rules, the revenue would be recorded for November
  • Under the new Daylight Savings Time rules, the revenue would be recorded for October

Related Article

Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog. I'll post updates here as soon as soon as they're available.   


Categories: APPS Blogs

Application Management Pack 13.1.1.1 Certified with Enterprise Manager 13.2

Steven Chan - Mon, 2016-11-14 02:05

In July 2016, we announced the general availability of Oracle Application Management Suite 13.1.1.1 for Oracle E-Business Suite as a plug-in for Enterprise Manager Cloud Control 13c. Application Management Suite 13.1.1.1 is now certified as a plug-in with Oracle Enterprise Manager Cloud Control 13c Release 2.

EM 13cR2 compatibility

We encourage all customers to upgrade to the latest release of Oracle Enterprise Manager 13.2 and Oracle Application Management Pack 13.1.1.1. If you are planning to manage Oracle E-Business Suite cloud environments, you must be on Oracle Enterprise Manager 13c and Oracle Application Management Pack Release 13.1.1.1.0 with latest patches listed in the Note below.

References

For release details and product documentation links, see:

Downloading this update

Oracle Application Management Suite for Oracle E-Business Suite can be downloaded and installed by:

Related Article


Categories: APPS Blogs

Troubleshooting Cloning Issues in EBS 12.1

Steven Chan - Tue, 2016-11-08 02:06

The Rapid Clone tool is used to create a working identical copy of an existing Oracle E-Business Suite 12.1 environment.  There are several ways of using Rapid Clone, including cloning a single node environment to another single node environment, adding additional nodes to an existing environment, and reducing nodes when cloning a multinode environment to a single node clone. 

Cloning EBS 12.1.3

The guide to using Rapid Clone in EBS 12.1 environments is:

When things go wrong

Given the variety of ways that this tool can be used, it is inevitable that some things might not go as expected.  When that happens, it's helpful to have a troubleshooting framework to narrow down the possible root causes and identify a solution. 

If you've encountered a problem with Rapid Clone, your first stop should be:

This excellent Note covers the most-common questions and issues associated with Rapid Clone, such as:

  • Location of cloning log files
  • Missing prerequisite patches
  • Preparing the source system's database and application tiers
  • The expected layout of the cloning stage area for both the applications and database tiers
  • Execution of the cloning process
  • Inventory registration issues
  • Common issues when cloning the database tier
  • Known issues

Related Articles


Categories: APPS Blogs

New OA Framework 12.2.4 Update 13 Now Available

Steven Chan - Mon, 2016-11-07 10:39

Web-based content in Oracle E-Business Suite 12 runs on the Oracle Application Framework (OAF or "OA Framework") user interface libraries and infrastructure.   Since the release of Oracle E-Business Suite 12.2 in 2013, we have released several updates to Oracle Application Framework to fix performance, security, and stability issues. 

These updates are provided in cumulative Release Update Packs, and cumulative Bundle Patches that can be applied on top of the Release Update Pack. "Cumulative" means that the latest RUP or Bundle Patch contains everything released earlier.

The latest OAF update for EBS 12.2.4 is now available:


Where is the documentation for this update?

Instructions for installing this OAF Release Update Pack are here:

Who should apply this patch?

All EBS 12.2.4 users should apply this patch.  Future OAF patches for EBS 12.2.4 will require this patch as a prerequisite. 

What's new in this update?

Fixes are included for following critical issues:

    • When Descriptive Flexfield (DFF) is rendered in an advanced table, some of its segments may not be displayed, and instead other columns of the table get repeated.
    • Unable to attach the Font message choice drop-downs such as Font, Color and Size to Message Rich Text Editor (MRTE).

    This is a cumulative patch for EBS 12.2.4.  It includes updates previously released as Bundle 11 and patch 24007747.

    This Bundle Patch requires the R12.ATG_PF.C.Delta.4 Release Update Pack as a mandatory prerequisite.

    Related Articles


    Categories: APPS Blogs

    Achieving Optimal Performance with Oracle E-Business Suite

    Steven Chan - Fri, 2016-11-04 02:05

    Our Applications Performance Group ensures that the E-Business Suite runs at peak performance in all circumstances.  This team has helped tune the E-Business Suite environments of world's largest companies to handle staggering amounts of transactional volume in multi-terabyte databases.  This group also publishes our official Oracle Apps benchmarks, white papers, and performance metrics.

    This team has collected the latest tips for optimizing EBS performance here:

    This presentation covers the following areas:

    • Optimizing Applications Tier
    • Optimizing Database Tier
    • Optimizing EBS on Real Application Clusters (RAC)
    • Optimizing EBS on Engineered Systems (e.g. Exadata)
    • Optimizing EBS using Database In-Memory
    • Optimizing EBS data management 

    Concurrent Manager Workload settings

    This is a concrete and practical collection of tips that are useful for all ranges of EBS environments.  Some specific topics covered include:

    • Using optimal FND Debug logging settings for the Apps tier
    • Optimizing Workflow processes through purging and deferred activities
    • Sizing guidelines for middle tier concurrency for JVMs, Forms
    • Dealing with network latency and bandwidth constraints
    • Tuning init.ora parameters, including SGA and PGA memory sizing
    • Best practices for gathering applications statistics
    • Archiving and purging tips
    • ... and much more...

    Related Articles


    Categories: APPS Blogs

    Will Windows Monthly Rollups Work with EBS?

    Steven Chan - Thu, 2016-11-03 02:05

    Microsoft logoMicrosoft announced that they will release security and reliability patches in a single Monthly Rollup update instead of as individual patches.  They also announced the availability of a single Security-only rollup. 

    This change was effective from October 2016 onwards and applies to:

    • Windows 7 Service Pack 1 (SP1)
    • Windows 8.1
    • Windows Server 2008 R2
    • windows Server 2012
    • Windows Server 2012 R2

    Compatibility with Oracle E-Business Suite

    Microsoft Monthly Rollups and Security-only updates are intended to be backwards-compatible with all applications. Existing Windows functionality does not change.

    It is expected that these updates will be fully-compatible with Oracle E-Business Suite 12.1 and 12.2.  We expect that we will do periodic testing of selected updates, but will do not expect to release regular certification announcements for them. 

    EBS customers do not have to wait for explicit certification announcements before applying Microsoft Monthly Updates or Security-only updates to their Windows desktops or servers.

    Related Articles



    Categories: APPS Blogs

    Is Oracle E-Business Suite FIPS 140 Certified?

    Steven Chan - Wed, 2016-11-02 02:05

    Customers frequently ask whether Oracle E-Business Suite is certified with the FIPS standards. 

    The Federal Information Processing Standards (FIPS) Publication 140-2 defines US Federal standards for cryptographic-based security systems.  FIPS Publications are issues by the National Institute of Standards and Technology (NIST).

    From our Oracle E-Business Suite Security FAQ (Note 2063486.1)

    The cryptographic modules in Oracle E-Business Suite currently cannot be considered FIPS certified. Some elements of the Oracle E-Business Suite Release 12.1.3 technology stack have been FIPS certified; however, some of the cryptographic libraries that are used by Oracle E-Business Suite have not been FIPS certified. Additionally, some of the cryptographic libraries that have been FIPS certified have had patches issued since certification, which technically takes them out of compliance.

    Specifically, the cryptographic libraries that Oracle HTTP Server (OHS) uses for SSL/TLS traffic were FIPS certified. However, there have been a variety of security and non-security related patches in that area that technically take it out of compliance, and it has not been recertified since those patches have been issued. Oracle E-Business Suite also makes use of other cryptographic libraries for variety of usages that have not been FIPS certified.  Oracle does not currently plan to certify all of the cryptographic libraries currently used by Oracle E-Business Suite.


    Categories: APPS Blogs

    Which Oracle Database Patchsets Can Be Used With EBS?

    Steven Chan - Tue, 2016-11-01 02:05

    Oracle versions numbers can be very long.  Complicating matters further, different product families within Oracle use the version hierarchy differently.  This can make it confusing to determine whether a specific product update has been certified with Oracle E-Business Suite.

    Oracle Database update numbers can be daunting.  However, it might be reassuring to learn that the fifth-level digit in Oracle Database version is not relevant to E-Business Suite certifications.  In other words, you can apply any database patchsets that have been certified at the fourth-level digit. 

    For example, we have certified EBS 12.2 with Database 12.1.0.2. All of the following Oracle Database patchsets will work with EBS 12.2:

    • Oracle Database 12.1.0.2.0 (documented certification)
    • Oracle Database 12.1.0.2.160419 (April 2016 Database Proactive Bundle Patch)
    • Oracle Database 12.1.0.2.160719 (July 2016 Database Proactive Bundle Patch)

    This is sometimes shown in our documentation in either of the following ways:

    • Oracle Database 12.1.0.2
    • Oracle Database 12.1.0.2.x

    The absence of a fifth-digit or the presence of an 'X' in the fifth digit's place means any fifth-digit level updates may be applied to an Oracle Database for EBS 12.2 without requiring a new certification.  This applies to all environments, including test and production environments.

    Related Articles

    Categories: APPS Blogs

    Upgrading to EBS 12.2 With a Non-APPS Schema

    Steven Chan - Mon, 2016-10-31 02:06

    An Oracle database stores the objects associated with a single installation of Oracle E-Business Suite. Product code objects are stored in the APPS schema; product data objects are stored in the relevant base product schemas. Product code objects include packages, procedures, functions, triggers, views, materialized views, java classes, and queues.

    EBS APPS schema

    What does the APPS schema do?

    The APPS schema has access to the complete Oracle E-Business Suite data model. Oracle E-Business Suite responsibilities connect to an APPS schema, and the environment variable FNDNAM is set to the name of the APPS schema. The APPS schema owns all the code objects for the Oracle E-Business Suite, and has access to all data objects. There is one APPS schema for every product installation group.

    Utilizing a single schema that has access to all objects avoids cross-product dependencies, and creates a hub-and-spoke access model rather than the spider web model that would otherwise be needed. The APPS schema also improves the reliability of and reduces the time needed for installation, upgrading, and patching, by eliminating the need for cross-product grants and synonyms.

    It wasn't always "APPS"

    Older versions of EBS were delivered with a different default schema name: APPS_FND.  Some older versions even allowed you to override the default name of the schema prior to installation.

    Recent versions of Oracle E-Business Suite use the APPS schema by default.  It is not possible to change the name of the APPS schema.

    Hardcoded references to APPS are not permitted

    We have many upgrade-related scripts, tools, and utilities.  All of these standard EBS tools are required to handle any EBS schema name, regardless of whether it is named APPS, APPS_FND, or something else.  There should be no hardcoded references to, say, the APPS schema. This development standard is enforced by regular automated scans of the entire EBS source code.

    Earlier versions of some EBS upgrade scripts may have had hardcoded references to APPS.  Running an upgrade to, say, EBS 12.2 against an EBS environment with an EBS schema named APPS_FND would fail in certain circumstances.  This is not expected behavior.  We would regard that as a bug that needs to be fixed immediately.

    All E-Business Suite scripts with hardcoded APPS schema references have since been superceded by later versions that can handle any EBS schema names.  To avoid issues with non-standard schema names, make sure that you're using the latest Rapid Install and AD/TXK utilities.  Click on the "Upgrade Recommendations" link in the sidebar of this site for pointers to the latest utilities.

    Known issues

    It is possible to integrate E-Business Suite environments with Oracle Identity Manager (OIM), which offers connectors that handle user provisioning.  Those OIM connection scripts still contain hardcoded references to the APPS schema (bug 24613821). 

    Getting support

    If you encounter any issues with non-standard EBS schema names, please log a formal Service Request with Oracle Support. You are welcome to drop me a line or post a comment here, too, if your schema-related SR gets stuck in the pipeline for some reason.

    References

    Categories: APPS Blogs

    Oracle Student Cloud’s aka Oracle CX for Higher Education

    OracleApps Epicenter - Sat, 2016-10-29 06:53
    Oracle Student Cloud’s new Oracle CX for Higher Education uses Oracle’s intuitive mobile technology to help recruiters boost their pipeline by targeting and qualifying best-fit prospects via social, email, and SMS CRM capabilities. Oracle Student Recruiting Cloud’s embedded analytics also help improve forecasting and monitor and optimize recruiters’ performance in their territories. Student Engagement broadly […]
    Categories: APPS Blogs

    Pages

    Subscribe to Oracle FAQ aggregator - APPS Blogs