EBS 12.2 Maintenance Guidance for Sequences

February 28, 2024 | 3 minute read
Elke Phelps
Product Management Director
Text Size 100%:

As an Oracle E-Business Suite (EBS) Applications DBA (Apps DBA), there are maintenance tasks that you should perform on a regular basis to ensure the overall health and performance of your EBS environment. General guidance for this activity is described in the Oracle E-Business Suite 12.2 Maintenance Guide

A critical maintenance task that you should perform is checking and managing the health of your EBS sequences. Many EBS customers have been running in production for many years – some for decades.  As a result, sequences in your EBS database may be nearing their maximum value.  

We are pleased to announce the publication of a new My Oracle Support (MOS) knowledge document and patch that includes sequence check scripts to assist EBS Apps DBAs with EBS 12.2 sequence management:

What is an Oracle Database Sequence?

A sequence is an Oracle database object from which multiple users can generate unique integers. For more information, see CREATE SEQUENCE, Oracle Database SQL Language Reference and Managing Sequences, Oracle Database Administrator’s Guide.

EBS uses sequences to automatically generate primary key values.

How Frequently Should You Check Your EBS Database Sequences?

Here are the guidelines for when to check your sequences:

How do You Proactively Manage Your EBS Sequences?

To proactively manage your EBS sequences, you should do the following:

  • Review all product-specific sequence management documentation and apply all sequence management patches provided for the products used in your instance to obtain the latest updates. See “Section 2: Apply Product-Specific Patches” in Managing Sequences in Oracle E-Business Suite Release 12.2 (MOS Note 2989870.1).

  • Use the diagnostic scripts provided by Oracle E-Business Suite to check the status of sequences in your environment and perform recommended actions. See “Section 3: Monitor Sequence Status” in Managing Sequences in Oracle E-Business Suite Release 12.2 (MOS Note 2989870.1).

  • Review the recommended guidance for cycling sequences in “Section 4: Manage Cycling Sequences” in Managing Sequences in Oracle E-Business Suite Release 12.2 (MOS Note 2989870.1).

References

Related Articles

Elke Phelps

Product Management Director

Elke is a Product Manager in the Oracle E-Business Suite Applications Technology Group.  She joined Oracle in 2011 after having been an Oracle customer and Oracle Technologist (Oracle Database Administrator, Oracle Applications DBA, Technical Architect and Technical Manager of an Oracle Applications DBA Team) since 1993.  As part of the Oracle E-Business Suite Applications Technology Product Management Team, her scope of responsibility includes security, database certifications and advanced architectures for on-premises and Oracle Cloud deployments.  She is a frequent contributor and editor of the Oracle E-Business Suite Technology Blog.

Elke is the lead author of the Oracle Applications DBA Field Guide (Apress 2006) and Oracle R12 Applications DBA Field Guide (Coqui Tech and Press 2010).  Elke is also the founder of the Oracle Applications User Group (OAUG) E-Business Suite Applications Technology Special Interest Group (SIG) and served as President of the SIG from February 2005 - August 2011.  Elke has been a speaker at the Oracle OpenWorld and Collaborate conferences since 2004.  Prior to joining Oracle, Elke was designated an Oracle ACE (2007) and Oracle ACE Director (2009).  She received the OAUG Oracle Ambassador of the Year award in 2015.

Elke has a Computer Science Degree and a Masters of Business Administration from the University of Oklahoma.  In her spare time, Elke enjoys traveling especially to Europe, Puerto Rico and the amazing US National Parks.  Elke also enjoys hiking, antiquing, gardening and cooking. 

 


Previous Post

EBS 12.2 Certified with Database Release Update 19.22 - All Platforms (Jan 2024)

Elke Phelps | 2 min read

Next Post


Quarterly EBS Upgrade Recommendations: February 2024

Elke Phelps | 4 min read