Showing posts with label EBS. Show all posts
Showing posts with label EBS. Show all posts

Preparing Oracle E-Business Suite 12.2 for the Next Generation Technology Stack


As Oracle E-Business Suite 12.2 customers prepare for the Next Generation Technology Stack, one of the most important activities is to understand both the environment readiness and the existing customization footprint.

A useful starting point is the TSUA Readiness Check, which validates the EBS environment and, at the end of the process, gathers information about customizations.

TSUA Readiness Check

Oracle provides the p38474509_R12_GENERIC package for the TSUA readiness check.

One important point for EBS administrators:

This is not a patch that needs to be applied using OPatch or ADOP.

The package can simply be extracted, and the readiness check can be executed directly.

After extracting the package, run:

./tsua readiness

The command starts validating the EBS environment against the prerequisites required for the Next Generation Technology Stack.

The readiness process checks several important components of the environment, including the operating system, database, EBS patch levels, AD, TXK, ATG_PF and System Schema Migration status.

For example, the readiness output may identify issues such as:

ERRORMSG: OS release check.
Minimum OS release required is Oracle Linux 8.7.

ERRORMSG: Minimum Database version of 19.31 or 23.26.2 is required.

ERRORMSG: EBS CPU version check.
Minimum EBS CPU Version required is April 2026 (2026.04).

ERRORMSG: AD version check.
Minimum AD version required is delta.18.

ERRORMSG: TXK version check.
Minimum TXK version required is delta.18.

ERRORMSG: ATG_PF version check.
Minimum ATG_PF version required is Delta.14.

ERRORMSG: EBS System Schema Migration Completion Patch Check.
EBS System Schema Migration is not complete.

These messages provide a clear picture of what needs to be addressed before proceeding.

For example, the environment may need:

  • An operating system upgrade

  • Database patching

  • Application of the required EBS CPU

  • AD and TXK updates

  • ATG_PF updates

  • Completion of EBS System Schema Migration

The Important Part

The tsua readiness process does more than just validate the environment.

At the end of the readiness process, TSUA gathers information about EBS customizations and generates adcustlist.rpt.

This makes the same readiness exercise useful for both technology-stack prerequisite validation and customization discovery.


Understanding adcustlist.rpt

The adcustlist.rpt report provides visibility into the customization footprint of the EBS environment.

It categorizes the identified customizations into five sections:

SECTION-1: C Customizations
SECTION-2: Java Customizations
SECTION-3: Jsp Customizations
SECTION-4: Forms Customizations
SECTION-5: Reports Customizations

This is particularly valuable for long-running EBS environments where customizations may have accumulated over several years.



Recommended Preparation Steps

The next steps should focus on understanding the customization impact and preparing well before the production update.

Step 1 – Run the Next Gen Tech Stack Readiness Checker Now

Do not wait until the actual technology-stack migration window.

Run:

./tsua readiness

Review all readiness errors and identify the prerequisite updates required for your environment.

Step 2 – Build a Complete Customization Inventory

Build a complete inventory of your customizations and source code based on:

  • Your existing customization inventory

  • The information provided in adcustlist.rpt

This is particularly important for older EBS environments where customizations may have been developed by different teams over many years.

Step 3 – Review Technology-Specific Compatibility

Review the compatibility requirements for each technology area and identify dependencies on the Classic Technology Stack.

Pay particular attention to:

  • C customizations

  • Java customizations

  • JSP customizations

  • Forms customizations

  • Reports customizations

  • Third-party libraries and dependencies

Step 4 – Recompile, Remediate and Test

Before the production update, recompile and, where necessary, remediate and test your customizations.

The objective should be to complete as much of this work as possible before the Next Generation Technology Stack becomes the production platform.


Why Start Early?

Starting this work early gives you time to understand the actual scope of your customization changes.

Instead of discovering a compatibility issue during the production technology-stack update, you can identify it earlier, obtain the required source code, remediate the customization, and complete functional testing.

This can significantly reduce the amount of work remaining when the Next Generation Technology Stack becomes available.

Final Takeaway

The preparation can be summarised simply:

Run TSUA → Review Readiness → Review adcustlist.rpt → Inventory Customizations → Check Compatibility → Recompile/Remediate → Test → Prepare for Production

The important point is that technology-stack readiness is not only about checking Oracle components and patch levels.

Your customization readiness is equally important.

Start early, understand what you have, identify what needs to change, and complete the remediation and testing before the production update.

The more you prepare today, the fewer surprises you will have during the Next Generation Technology Stack transition.

Oracle E-Business Suite 12.2 Next Generation Technology Stack: Understanding the Special Online Patching Cycle

In my previous article, I introduced Oracle's ๐—ก๐—˜๐—ซ๐—ง ๐—š๐—˜๐—ก๐—˜๐—ฅ๐—”๐—ง๐—œ๐—ข๐—ก ๐—ง๐—˜๐—–๐—›๐—ก๐—ข๐—Ÿ๐—ข๐—š๐—ฌ ๐—ฆ๐—ง๐—”๐—–๐—ž for Oracle E-Business Suite Release 12.2 and discussed the move to modern components such as WebLogic 14c, Oracle Fusion Middleware 14c, and Java 17.

While reviewing Oracle's documentation, I came across another interesting enhancement—not to the technology itself, but to the upgrade process.

Oracle has introduced a Special Online Patching Cycle that is used exclusively for upgrading to the Next Generation Technology Stack.

A Special Online Patching Cycle

It's important to clarify that Oracle has not changed the standard Online Patching (ADOP) cycle used for everyday patching and maintenance.

The familiar workflow remains:

Prepare → Apply → Finalize → Cutover → Cleanup

However, when upgrading from the Classic Technology Stack to the Next Generation Technology Stack, Oracle provides a dedicated online patching workflow.

In this special upgrade cycle, the traditional Apply phase is replaced by Technology Stack Update Assistant (TSUA).

The workflow becomes:

Prepare → TSUA → Finalize → Cutover → Cleanup → Synch

This workflow is designed specifically for the one-time migration to the Next Generation Technology Stack.

What is TSUA?

The Technology Stack Update Assistant (TSUA) is a new Oracle utility introduced specifically to simplify the migration from the Classic Technology Stack to the Next Generation Technology Stack.

Instead of using the standard Apply phase during this one-time migration, Oracle leverages TSUA as part of the Special Online Patching Cycle to automate and orchestrate the technology stack upgrade.

Behind the scenes, TSUA performs several critical tasks that would otherwise require significant manual effort, including:

  • Validates the environment by performing prerequisite checks and ensuring the system is ready for the upgrade.
  • Creates backups and installs the Next Generation Technology Stack software from the staged media.
  • Updates the application tier directory structure to align with the new technology stack.
  • Reconfigures the EBS middleware environment, including:
    • Updating the Oracle WebLogic Server (WLS) domain
    • Creating the Oracle HTTP Server (OHS) domain
    • Configuring the required Node Managers
  • Applies the migration patch along with any required co-requisite patches.
  • Regenerates Oracle Forms and Reports to ensure compatibility with the upgraded technology stack.

After TSUA completes successfully, the remaining online patching phases continue with:

  • Finalize
  • Cutover
  • Cleanup
  • Synch

Why Did Oracle Introduce This?

According to Oracle, this special online patching cycle is intended to make the technology stack migration:

  • Less disruptive
  • More streamlined
  • Capable of keeping users productive for most of the upgrade process
  • Simpler than performing a traditional EBS technology stack upgrade

Because the update leverages Online Patching, organizations can migrate to the Next Generation Technology Stack without requiring a major EBS upgrade.

Final Thoughts

One important point to remember is that TSUA does not replace the standard Apply phase for normal Oracle E-Business Suite patching.

Instead, it is part of a special online patching workflow introduced exclusively for migrating to the Next Generation Technology Stack.

This distinction is important for EBS administrators. Your regular ADOP patching process remains unchanged. TSUA comes into play only when performing the one-time transition from the Classic Technology Stack to Oracle's Next Generation Technology Stack.

As Oracle continues to modernize EBS 12.2, understanding this new upgrade workflow will help administrators plan and execute their technology stack migration with confidence.

Understanding the Oracle E-Business Suite 12.2 Technology Stack

 Oracle E-Business Suite (EBS) is one of the most widely deployed enterprise applications across industries. Behind every EBS environment is a collection of technology components that work together to deliver business functionality, manage user requests, and communicate with the database tier. This collection of components is known as the Oracle E-Business Suite Application Technology Stack.

What is the EBS Application Technology Stack?

The Application Technology Stack consists of the software components installed on the EBS application tier. These components are responsible for processing business logic, serving web pages, running forms and reports, and enabling communication between end users and the database.

For Oracle E-Business Suite Release 12.2, the technology stack includes:

  • Oracle Fusion Middleware (FMW)

  • Oracle WebLogic Server (WLS)

  • Oracle HTTP Server (OHS)

  • Oracle Developer (Forms and Reports)

  • Java Development Kit (JDK)

Together, these components provide the foundation required to run EBS applications efficiently and securely.

The Classic Technology Stack

Since the release of EBS 12.2, most environments have been running on what Oracle refers to as the Classic Technology Stack. This stack is built on Oracle Fusion Middleware 11g and Java 7.

The certified component versions are:

ComponentCertified Release
Oracle Fusion Middleware (FMW)11.1.1.9
Oracle WebLogic Server (WLS)10.3.6
Oracle HTTP Server (OHS)11.1.1.9
Oracle Developer (Forms and Reports)10.1.2
Java Development Kit (JDK)7

For many years, this technology stack has provided a stable and reliable platform for Oracle E-Business Suite deployments worldwide.

The Next Generation Technology Stack

As technology evolves, Oracle is modernizing the EBS application tier with a newer and more secure technology foundation known as the Next Generation Technology Stack.

The planned certified releases include:

ComponentPlanned Certified Release
Oracle Fusion Middleware (FMW)14.1.2
Oracle WebLogic Server (WLS)14.1.2
Oracle HTTP Server (OHS)14.1.2
Oracle Developer (Forms and Reports)14.1.2
Java Development Kit (JDK)17

This modernization introduces newer middleware and Java versions that align with current enterprise standards, helping organizations improve security, maintainability, and long-term supportability.

Why Does This Matter?

Many EBS customers continue to run mission-critical workloads on Release 12.2. Understanding the differences between the Classic and Next Generation Technology Stacks is important when planning upgrades, security initiatives, and future platform strategies.

Moving to the Next Generation Technology Stack provides organizations with:

  • Modern middleware architecture

  • Support for Java 17

  • Enhanced security capabilities

  • Improved compatibility with current infrastructure standards

  • Better long-term support from Oracle


What About Support for the Classic Technology Stack?

One of the most common questions among Oracle E-Business Suite administrators is whether upgrading to the Next Generation Technology Stack is mandatory.

The answer is yes—if organizations want to remain aligned with Oracle's long-term support strategy.

Oracle has indicated that EBS Release 12.2 production environments are expected to move to the Next Generation Technology Stack to ensure continued supportability in the future. Once the Next Generation Technology Stack becomes generally available, Oracle will publish a detailed support timeline outlining key milestones and support dates.

How Long Will the Classic Technology Stack Be Supported?

At the time of writing, Oracle has not announced an end date for error correction support for the Classic Technology Stack. However, Oracle has stated that an updated support roadmap will be provided following the general availability of the Next Generation Technology Stack.

For organizations currently running the Classic Technology Stack, this means there is no immediate deadline to migrate. However, IT teams should begin evaluating the impact of the upgrade, reviewing infrastructure requirements, and planning their modernization roadmap to avoid future support challenges.

Planning Ahead

While the Classic Technology Stack remains fully functional today, the introduction of the Next Generation Technology Stack signals Oracle's strategic direction for EBS 12.2. Organizations that proactively prepare for the transition will be better positioned to:

  • Maintain Oracle support eligibility

  • Benefit from newer middleware and Java technologies

  • Improve security and compliance posture

  • Reduce technical debt

  • Simplify future upgrades and maintenance

The move to the Next Generation Technology Stack should therefore be viewed not only as a technology upgrade, but as an important step in ensuring the long-term sustainability of Oracle E-Business Suite environments.

Final Thoughts

The Oracle E-Business Suite 12.2 Application Technology Stack is the foundation that powers the application tier of EBS environments. While the Classic Technology Stack has served organizations well for years, Oracle's Next Generation Technology Stack represents the future direction of EBS technology.

Organizations running EBS 12.2 should begin evaluating their technology stack roadmap and prepare for the transition to the newer platform to take advantage of modern security, performance, and support capabilities.

Creating Online-Patching-Compliant Table in Oracle E-Business Suite R12.2

Online patching introduced in Oracle E-Business Suite R12.2 fundamentally changed the way custom objects must be created and maintained. To ensure zero-downtime patching, every custom table must support Edition-Based Redefinition (EBR). This requires a base table, an editioning view, and an APPS synonym—created in a specific sequence using Oracle’s AD_ZD utilities.

This article provides a clear, step-by-step guide to creating an online-patching-compliant table along with its editioning view (EV) in R12.2. It also outlines how to manage future structural changes through XDF metadata or AD_ZD utilities.


1. Create the Base Table in the Owning Schema

Begin in the Run edition, logged in as the appropriate product schema (for example, APPLSYS or a custom application schema).
At this stage, only the base database objects are created.

Typical actions include:

  • Creating the table using standard DDL.

  • Defining supporting indexes.

  • Using APPS_TS_* tablespaces depending on the object type.

  • Preferring unique indexes instead of primary key constraints, in line with R12.2 object standards.

At this point, no editioning view exists. The table is still non-compliant with online patching.


2. Upgrade the Table to Create the Editioning View and APPS Synonym

Once the base table is ready, convert it into an online-patching-aware object using Oracle’s AD_ZD package:

EXEC AD_ZD_TABLE.UPGRADE('<OWNER_SCHEMA>', '<TABLE_NAME>');

This action generates two critical components:

  • Editioning View (EV):
    Created in the owning schema with the name <TABLE_NAME>#.
    This view becomes the layer through which the application interacts with the table.

  • APPS Synonym:
    A synonym named <TABLE_NAME> is created in the APPS schema, pointing to the EV.

From this point forward, all application components—Forms, OAF, PL/SQL APIs, reports—must reference the APPS synonym. This ensures that future table changes are transparently managed through the EV without breaking online patching rules.


3. Generate and Deploy the XDF Metadata

To package this custom table for deployment across environments, Oracle requires an XDF (XML Definition File) representation.

Steps:

  1. Insert at least one row into the new table (mandatory for XDF generation).

  2. Run xdfgen.pl from the Run edition to produce the .xdf file containing the metadata for the table, indexes, and associated objects.

  3. Include this .xdf in your custom application patch.

  4. During patch application, xdfcmp.pl automatically creates the base table and invokes AD_ZD_TABLE.UPGRADE, ensuring that the EV and APPS synonym are generated in all target instances.

This makes your object fully compliant with the R12.2 adoption and deployment model.


4. Managing Future Structural Changes

When enhancements or structural modifications are required—such as adding new columns—you must preserve online patching compliance.

Two methods are supported:

a. Preferred Method: Update via XDF

Modify the XDF file and apply it using xdfcmp.pl.
This ensures consistent behavior across environments and adheres to Oracle's standards.

b. Direct DDL in Development

If a table is altered manually in a development instance:

EXEC AD_ZD_TABLE.PATCH('<OWNER_SCHEMA>', '<TABLE_NAME>');

This regenerates the EV mapping to align it with the updated table structure.


Conclusion

Building online-patching-compliant objects is essential for long-term maintainability in Oracle E-Business Suite R12.2. By creating the base table, generating the editioning view through AD_ZD utilities, and managing future changes via XDF or AD_ZD_TABLE.PATCH, you ensure seamless behavior during both Run and Patch editions.


Edition-Based Redefinition (EBR) in Action: Resolving Synonym Translation Errors

While working with Oracle Applications schemas, you may encounter the error ORA-00980: synonym translation is no longer valid when accessing editioning views or objects through a synonym. This article explains a practical example of how this issue arises and how to resolve it.


Scenario

A user TEST tried to access the APPS schema object FND_USER_RESP_GROUPS_DIRECT using a synonym.

SQL> SHOW USER
USER is "TEST"

The user then connected and created a synonym for the editioning view:

SQL> CONN test/***
Connected.

SQL> CREATE OR REPLACE SYNONYM "FND_USER_RESP_GROUPS_DIRECT" FOR APPS.FND_USER_RESP_GROUPS_DIRECT;

Synonym created.

However, when querying the synonym, the following error occurred:

SQL> SELECT COUNT(1) FROM FND_USER_RESP_GROUPS_DIRECT;
SELECT COUNT(1) FROM FND_USER_RESP_GROUPS_DIRECT
                     *
ERROR at line 1:
ORA-00980: synonym translation is no longer valid

Root Cause

This issue happens because the TEST user is not edition-enabled, while the target object in the APPS schema is an editioning view.
Edition-based redefinition (EBR) in Oracle allows for multiple versions of application objects (like packages and views) across different editions.
When a non-editioned user tries to access editioned objects, Oracle cannot resolve the synonym, leading to this error.

To verify the editioning status of the user:

SQL> SELECT EDITIONS_ENABLED FROM DBA_USERS WHERE USERNAME='TEST';

E
-
N

The result N indicates the user is not edition-enabled.


Resolution

Enable editions for the user to allow access to editioned objects:

SQL> ALTER USER test ENABLE EDITIONS;

User altered.

Confirm the change:

SQL> SELECT EDITIONS_ENABLED FROM DBA_USERS WHERE USERNAME='TEST';

E
-
Y

Reconnect as the user and retry the query:

SQL> CONN test/***
Connected.

SQL> SELECT COUNT(1) FROM FND_USER_RESP_GROUPS_DIRECT;

  COUNT(1)
----------
     18916

The query now executes successfully.


Key Takeaway

When creating synonyms for editioning views in Oracle E-Business Suite or any EBR-enabled schema, ensure that the referencing user has editioning enabled.
Otherwise, Oracle will fail to translate the synonym, resulting in the ORA-00980 error.


Understanding Profile Option Values in Oracle E-Business Suite R12

In Oracle E-Business Suite R12, administrators often query the table FND_PROFILE_OPTION_VALUES to check profile settings at the user, responsibility, or site level. However, many times the VALUE column displays a lookup code instead of a readable description — making it hard to interpret.


For example if you query "FND: Debug Log Level" for user or site level from backend, it shows some numeric value.

Let’s look at how to find the actual meaning behind those coded values.


๐Ÿงฉ Step 1: Identify the Lookup Type

  1. Log in to EBS using the Application Developer responsibility.

  2. Navigate to:
    Profiles → System → Query the Profile Option -"AFLOG_LEVEL" (using its short name).

  3. In the results, note down the Lookup Type associated with that profile.


๐Ÿง  Step 2: Query the Lookup Meaning

Once you know the Lookup Type, use the following SQL query to decode the meaning: 

SELECT lookup_code,
       meaning,
       description
FROM   fnd_lookup_values
WHERE  lookup_type = 'AFLOG_LEVELS';


๐Ÿงพ Example

If a profile option value shows as ‘3’ or ‘4’ in FND_PROFILE_OPTION_VALUES, the above query helps you find out what those codes actually represent (for example, Statement or Exception).


✅ Summary

When you see cryptic values in FND_PROFILE_OPTION_VALUES, remember:

  • Use the Application Developer responsibility to find the Lookup Type.

  • Query FND_LOOKUP_VALUES to get the actual meaning.

This simple approach helps DBAs and support teams interpret configuration settings accurately — ensuring smoother troubleshooting and configuration validation.


Troubleshooting a Never-Ending Concurrent Program in Oracle EBS 12.2 – My Real-Time Experience

 Recently, while working on our Oracle E-Business Suite 12.2 environment, I encountered an interesting issue that I thought was worth sharing.

The Problem

A few of our custom concurrent programs were not completing. They were running forever, with no errors in the log files and no obvious clues in the usual diagnostic areas.

Like most DBAs would do, I checked:

  • Concurrent request log and output – nothing unusual.

  • Database session waits – nothing conclusive.

  • Trace files – no errors.

Eventually, I raised an Oracle SR to get assistance, but even after multiple attempts, we couldn’t pinpoint the issue.

The Breakthrough

Finally, I decided to take a different approach. I used the strace command on the Linux OS to trace the system calls of the concurrent program's process ID (PID).

What I saw was eye-opening — the process was generating a large number of file-related system calls, and one particular line caught my attention:

It was trying to write temporary files to a production directory path that did not exist in the cloned test server!

Root Cause

On further investigation, I discovered that the $APPLLKOR environment variable was pointing to a non-existing directory:

/usr/tmp/prod

This was a leftover from the production environment after the test instance was cloned. Since the directory did not exist on the test server, the concurrent programs were unable to write the required temporary files and got stuck.

The Fix

I corrected the $APPLLKOR variable in the environment file to point to a valid directory on the test server. After making this change, I restarted the EBS application services.

Immediately, the concurrent programs that were stuck started completing successfully!

Key Takeaways

  • Think beyond EBS and DB logs – sometimes the issue is at the OS or filesystem level.

  • strace is a powerful tool – it can reveal exactly what the process is trying to do at the system call level.

  • Post-clone checks are critical – always verify environment variables and directory structures after cloning from production.

This experience reinforced for me that troubleshooting sometimes requires going one level deeper and thinking outside the usual EBS framework.

Understanding Data Types in Oracle E-Business Suite

Oracle E-Business Suite (EBS) contains a wide range of data categories, each serving different purposes within the system. Recognizing these types helps in managing, optimizing, and archiving your data effectively.

1. Transient Data

This data is short-lived and typically used for intermediate processing. It includes:

  • Interface tables

  • Temporary tables

  • Working storage used during concurrent processing

2. System Audit and Diagnostic Data

Used primarily for monitoring and auditing purposes, this data supports:

  • User login tracking

  • Concurrent request history

  • Diagnostic logs for performance and troubleshooting

3. Transactional Data

This includes both fiscal and non-fiscal operational data, such as:

  • Invoices, orders, and payments

  • Workflow activities and logs supporting transaction processing

Transactional data tends to represent the highest volume in most EBS environments and is a common target for purging and archiving.

4. Master and Setup Data

This is critical reference and configuration data that drives transaction processing:

  • Suppliers, addresses, inventory items

  • Lookup codes and setup metadata configured by customers

While it can grow large in some instances, Master and Setup data is rarely purged and is typically smaller in size compared to transactional data.

5. Seed Data

Seed data is pre-populated during the initial installation of Oracle EBS and includes:

  • Default configuration

  • Lookup values

  • Standard setup definitions


๐Ÿ“Œ Data Volume Insights

  • Transactional data typically dominates in volume and is a primary candidate for performance tuning, archiving, or purging strategies.

  • Transient and audit data follow closely in volume and retention sensitivity.

  • Master, Setup, and Seed data, while essential, are generally more static and less suited for bulk deletion.

Understanding these classifications enables better data lifecycle management, performance tuning, and compliance planning in Oracle E-Business Suite environments.

How to Generate FRD Trace in Oracle E-Business Suite (EBS) 12.2.x

When troubleshooting forms-related issues in Oracle E-Business Suite (EBS) R12.2.x, capturing an FRD (Forms Runtime Diagnostics) trace can be invaluable. This post walks you through the step-by-step process to enable, capture, and clean up an FRD trace.


✅ Step A: Update ICX:Forms Launcher Profile

  1. Navigate to: EBS Home > System Administrator > Profile > System

  2. In the "Find System Profile Values" window:

    • Set Level to User

    • Enter the target username (who will reproduce the issue)

    • In the Profile field, enter: ICX: Forms Launcher, then click Find

  3. Update the profile value to:

    http://hostname:8000/forms/frmservlet?record=collect
    
  4. Save the changes and log out of EBS.


✅ Step B: Enable Java Console Logging

  1. On the client machine, open Control Panel > Java > Advanced

  2. Enable the options:

    • ✔ Show Console

    • ✔ Enable Tracing / Logging

  3. Now, log into EBS using the specified user.

  4. Launch a form and reproduce the issue.

  5. In the Java Console, verify that the string record=collect is present. This confirms that tracing is active.


✅ Step C: Retrieve the FRD Trace File

  1. Log in to the EBS application server (as the OS user, typically via SSH or PuTTY).

  2. Run the following commands:

$ echo $FORMS_TRACE_DIR
$ cd $FORMS_TRACE_DIR
$ ls -lrt *collect*
  1. Identify the generated trace file(s) containing collect in the name.


๐Ÿ”„ Step D: Revert Profile Changes

Once the trace is collected:

  1. Return to Profile > System in EBS.

  2. Search for the same ICX: Forms Launcher profile at the user level.

  3. Revert the URL back to the default:

    http://hostname:8000/forms/frmservlet
    
  4. Save and exit.


๐Ÿ’ก Constructing the Correct frmservlet URL

Having trouble forming the correct URL? Here are a few tips:

  • If you're using a Load Balancer, use the same base URL.

  • Match the protocol (http/https) and port used in your EBS login URL.

  • Simply replace the end of the URL with /forms/frmservlet

๐Ÿ“Œ Example:


If your login URL is:

https://oci-host.domain.com:4443/OA_HTML/AppsLocalLogin.jsp

Then your frmservlet URL becomes:

https://oci-host.domain.com:4443/forms/frmservlet

✅ Conclusion

Capturing FRD traces is a straightforward but powerful method for diagnosing runtime issues in Oracle EBS forms. Always remember to revert changes after trace collection to maintain system performance and user experience.

 

Diagnosing Stuck Threads in oacore on Oracle EBS 12.2

In Oracle EBS 12.2, system hangs, login failures, or forms not loading are often due to stuck threads in WebLogic’s oacore server. This guide outlines a systematic approach to diagnose and resolve such issues.


๐Ÿ” Step-by-Step Diagnostic Workflow

1. Review oacore Logs


Navigate to the oacore server logs (e.g., oacore_server?.log, -diagnostic.log, .out) under $EBS_DOMAIN_HOME/servers/oacore_server?/logs and look for stuck-thread warnings.

2. Detect Stuck Threads and Extract ECID


Search for lines like BEA-000337 indicating a thread has been busy for hundreds of seconds. Extract the ECID-Context, which contains a unique identifier for tracing the issue.

3. Use ECID to Query Active Sessions


Trim the ECID and query Oracle’s AWR or ASH views:

SELECT *
FROM gv$active_session_history
WHERE ecid LIKE '%<trimmed-ECID>%';

This identifies the user session and activity causing the problem.

4. Retrieve SQL Text and Bind Variables


Once you have the SQL_ID, run a query to pull the statement and bind values tied to the stuck session:

SELECT b.name, b.value_string, sq.sql_text, ...
FROM gv$sql_bind_capture b
JOIN gv$sql sq ON ...
WHERE sq.sql_id = '<SQL_ID>';

This helps pinpoint slow or errant SQL 

✅ Recommended Actions

  • Investigate the identified SQL in dev/test environments to optimize or refactor.

  • Adjust WebLogic thresholds, such as StuckThreadMaxTime, to reduce excessive thread hang behavior.

  • Open an SR with Oracle, including ECID thread dumps and session details, to assist with deeper root cause analysis.


Understanding Hot Patching and Downtime Mode in Oracle E-Business Suite R12.2


Introduction

In Oracle E-Business Suite (EBS) R12.2 environments, the ability to apply patches quickly during critical situations is essential. While earlier versions such as 11i and 12.1.3 supported “hot patching,” the introduction of the dual file system architecture in R12.2 imposes significant limitations.

Hot patching in R12.2 should not be considered unless explicitly permitted in the patch README or Oracle Support documentation.


Challenges and Risks of Hot Patching in R12.2

Applying patches directly to the run file system (hot patching) in R12.2 carries a number of risks:

  • Potential Runtime Failures: Hot patching may result in transaction failures due to invalid database objects or disrupted PL/SQL package states.

  • Code and Data Inconsistencies: Temporary inconsistencies between application code and database objects may occur, along with mismatches between patched components and cached data in the application server memory.

  • Execution Disruptions: Long-held locks on code or data may lead to execution failures and hinder business operations.

  • Resource Availability Delays: Patches that include downloadable resources (e.g., Forms client JAR files) may require WebLogic Managed Server restarts before becoming active.


Can a Hot Patch Be Aborted?

No. Unlike standard patching, hot patches cannot be aborted using adop phase=abort. If a hot patch fails, recovery options are extremely limited. The only viable remediation is to restore both the EBS database and the middle tiers from a full backup, making the risk of hot patching significantly higher.


A Safer Alternative: Downtime Mode Patching

Given the risks associated with hot patching, Oracle recommends using downtime mode patching during emergencies as a safer alternative. This method involves applying patches directly to the run file system and edition in a controlled downtime window.

Key Guidelines for Downtime Mode Patching:

  • Use apply_mode=downtime: Execute the ADOP patch application with apply_mode=downtime to ensure changes are made in a stable, non-live environment.

  • Ensure No Active Patch Cycles: Confirm that no other ADOP patching sessions are running to prevent conflicts.

  • Register Custom Code Directories: Any directories containing custom code on the application tier must be registered with a custom synchronization driver to support proper file system synchronization during the adop sync phase.


Important Warning

Most Oracle-delivered patches for EBS R12.2 are not tested for downtime or hot patch modes. Therefore, these methods should only be used in emergency situations and not adopted as part of regular maintenance procedures.


Conclusion

Hot patching in Oracle EBS R12.2 should be avoided unless explicitly advised by Oracle. When emergencies require immediate patching, downtime mode patching with proper precautions offers a more stable and supportable alternative. Always ensure full backups are in place before applying any non-standard patching strategies.


Accelerating Issue Resolution in Oracle E-Business Suite with Built-in Diagnostics

Effective troubleshooting of critical issues in Oracle E-Business Suite (EBS) is essential for maintaining business continuity. Leveraging diagnostic tools provided by Oracle Support can significantly reduce downtime and expedite resolution. We recently encountered a situation that underscores the importance of using these tools to address system-wide issues swiftly and efficiently.

Issue Encountered

Last week, we faced a widespread issue within Oracle E-Business Suite R12.2 where users were unable to view the output of concurrent programs. When selecting the "View Output" button, the system consistently displayed a blank page instead of the expected report output. The issue affected all users across the environment. Despite reviewing the available logs in detail, no actionable information could be gathered, prompting us to raise a Service Request (SR) with Oracle Support.

Diagnosis and Resolution via Oracle SR

During the diagnostic process, we discovered a built-in tool within EBS R12.2 named "FS Diagnostic Test Program." This utility proved invaluable in identifying the root cause of the issue.

The FS Diagnostic Test Program is designed to simulate file transfer operations typically handled by concurrent processing components such as FNDFS and FNDWRR.exe. It includes logic to generate diagnostic logs, facilitating easier debugging of issues related to output and log file delivery.

The program can be executed in various modes, controlled by the Mode parameter:

  • FULL – Executes all available tests (default)

  • FILE – Tests file copy operations

  • REQLOG – Verifies access to concurrent request log files

  • REQOUT – Verifies access to concurrent request output files

  • MGR – Tests viewing concurrent manager log files

  • RFILE – Tests remote file copying

We ran the diagnostic test using the appropriate modes and uploaded the results to the open Oracle SR. Based on the diagnostic output, Oracle Support was able to quickly analyze the issue and provide an effective solution.

Key Takeaway

This experience reinforced the value of leveraging built-in diagnostics to accelerate support resolution. Oracle Support can offer faster, more targeted assistance when provided with relevant diagnostic outputs upfront. We highly recommend incorporating tools like the FS Diagnostic Test Program into your standard troubleshooting toolkit when working with Oracle E-Business Suite R12.2.