Transforming Ideas into Innovation with Cloud, AI, and Data

 The Database Advanced Security Option (ASO) in Oracle E-Business Suite enhances data protection by enabling transparent data encryption (TDE) and network encryption. TDE helps secure sensitive data at rest—such as customer, financial, or HR data—by encrypting database files without requiring changes to applications. Network encryption ensures secure communication between the EBS application and the database by encrypting data in transit. Together, these features help organizations meet compliance requirements, mitigate the risk of data breaches, and strengthen the overall security posture of their Oracle EBS environments without impacting performance or user experience. Transparent Data Encryption (TDE) for Oracle E-Business Suite (EBS) Database is a crucial security feature that ensures sensitive data is encrypted at rest, helping organizations meet compliance, privacy, and regulatory requirements. Here’s a concise overview tailored to Oracle EBS: TDE is an Oracle Database feat...

 This blogpost will explain Adding a Managed Server to an Oracle E-Business Suite (EBS) 12.2 environment involves integrating an additional WebLogic managed server to improve scalability, load balancing, or for specific functional purposes. EBS 12.2 uses Oracle WebLogic Server as its application tier foundation. High-Level Steps to Add a Managed Server to EBS 12.2: 1. Prerequisites Ensure Oracle EBS 12.2 is fully installed and patched. The system has sufficient resources and the new managed server hostname/IP is resolvable. You have access to run and patch file systems. 2. Create the Managed Server in WebLogic Access the WebLogic Administration Console: URL: http://<host>:<port>/console Create a New Managed Server: Navigate to Environment > Servers > New . Provide the server name , listen address , and port . Assign it to the existing EBS WebLogic domain . Target the EBS Applications: Assign the EBS application deployments ...

In one of our csutomer Environment during the Oracle E-Business suite siwtchover activity we encounted the following error during exeuction of autoconfig. adcvmlog.xml renamed to /u01/oracle/PRODDR/db/tech_st/19c/appsutil/log/PROD_ERPAPPSdr01/06081214/adcvmlog.xml.06081215 [CVM Error Report] The following report lists errors encountered during CVM Phase /u01/oracle/PRODDR/db/tech_st/19c/appsutil/bin/txkCfgUtlfileDir.sh 1 No of scripts failed in CVM phase: 1 AutoConfig is exiting with status 1 AutoConfig execution completed on Sat Jun 8 12:15:08 2024 Time taken for AutoConfig execution to complete : 0 mins 23 secs Cause: UTL_FILE_DIR is obselete with Database 19c and hence autoconfig is not able to set/locate the correct utl_file_dir Solution: Need to set utl_file_directory as per the new tech stack tools and once the locations are set to valid directories autoconfig will be completed successfully. Script "txkCfgUtlfileDir.pl" will be used with thr...

Concurrent programs taking too long to complete and most of the time is spent in Output post processor Apply latest patch : 34091953 This patches creates a file oppjava.sh if you are on instance 12.2.5 or earlier Download 64 bit jre from the internet and place it in a location accessable by applmgr In my case I downloaded and unzipped it in below location /u25/TEST/JREOPP/JRE -bash-4.1$ cd /u25/TEST/JREOPP/JRE/ bin/ lib/ man/ release Welcome.html COPYRIGHT LICENSE README THIRDPARTYLICENSEREADME.txt -bash-4.1$ cd /u25/TEST/JREOPP/JRE/bin/ -bash-4.1$ ./java -version java version "1.8.0_202" Java(TM) SE Runtime Environment (build 1.8.0_202-b08) Java HotSpot(TM) 64-Bit Server VM (build 25.202-b08, mixed mode) -bash-4.1$ Open the oppjava.sh and modify JSERVJAVA parameter to the java location as seen below. JSERVJAVA=/u25/T...

Oracle EBS R12.1.3 clone configuration script failing while configuring config tools. This issue is reported on OracleEBS running on IBM-AIX 6.1. Environment details: OS Version             => IBM-AIX 6.1 (64-Bit) EBS version           => R12,1.3 Database Version   => 11.2.0.1 Error Stack while running adcfgclone.pl on appsTier: Setting LIBPATH to /oratest/R12_app/apps_st/comn/clone/oui/lib/aix Beginning application tier Apply - Mon Feb 2 11:11:30 2022 /oratest/R12_app/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /oratest/R12_app/apps_st/comn/clone/jlib/xmlparserv2.jar:/oratest/R12_app/apps_st/comn/clone/jlib/ojdbc14.jar:/oratest/R12_app/apps_st/comn/clone/jlib/java:/oratest/R12_app/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/oratest/R12_app/apps_st/comn/clone/jlib/oui/ewt3.jar:/oratest/R12_app/apps_st/comn/clone/jlib/oui/sha...

I received an Incident from one our customer that all standard concurrent requests in EBS R12.1.3  are not completing and its continuously in status "Running Normal" forever. This issue was reported on of their recently cloned TEST/UAT Environment. Environment details: EBS : 12.1.3 DB   : 12.1.0.2 OS   : IBM-AIX -6.1 (64-bit) If we check the log file for any standard concurrent request there is no error reported. Below is the concurrent manager logfile for Active users: Cocurrent log:  --------------------  +---------------------------------------------------------------------------+  Application Object Library: Version : 12.0.0  Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.  FNDSCURS module: Active Users  +---------------------------------------------------------------------------+  Current system time is 30-OCT-2021 16:25:07  +----------------------------------------------------...

If you are Installing Oracle E-Business suite R12.2 and encountered below mentioned error then its clear that there is a problem in your stage area. There are missing patches in your EBS Stage Area. Error Stack: Fatal Error: TXK Install Service oracle.apps.fnd.txk.config.ProcessStateException: Patch directory does not exist or not writable - /u01/ora_test/11.2.0/temp/test_erpnode3/patches/17693770 ## Node=NodeId=539 Type=18 TypeName=patch Name=17693770 RefId=217 State=init ConfigDoc=DB_HOME ParentDoc=null Topology=R12 Id= Unzip=true Validate=true Version=112030 PatchFileName=null at oracle.apps.fnd.txk.config.PatchNode.validatePatch(PatchNode.java:376) at oracle.apps.fnd.txk.config.PatchNode.processState(PatchNode.java:284) at oracle.apps.fnd.txk.config.PatchesNode.processState(PatchesNode.java:79) at oracle.apps.fnd.txk.config.InstallNode.processState(InstallNode.java:68) at oracle.apps.fnd.txk.config.TXKTopology.traverse(TXKTopology.java:594) at ...

I received  an Incident from one of our customer that they are not able to apply patch on 10.1.2 ( Developer) Oracle Home for their recently cloned EBS R12 Instance. The command "opatch lsinventory is working fine when trying to apply the actual patch then its failing for "MISSING_COMPONENT : oracle.developer.reports.core, 10.1.2.3.0". Though component is included in the Inventory. Output from opatch lsinventory command: [oradev@TESTERP[/oradev]# opatch lsinventory Oracle Interim Patch Installer version 1.0.0.0.57 Copyright (c) 2007 Oracle Corporation. All Rights Reserved.. We recommend you refer to the OPatch documentation under OPatch/docs for usage reference. We also recommend using the latest OPatch version. For the latest OPatch version and other support related issues, please refer to document 293369.1 which is viewable from metalink.oracle.com Oracle Home : /oradev/R12_app/apps/tech_st/10.1.2 Oracle Home Inventory : /oradev/R12_app/apps/tech_st/...

 FRM-92101 is a very generic Error and its reported on one of our Oracle E-Business suite customer who recently upgraded the Operating system from Solaris 10 to Solaris 11. We checked RDA and other OS pre-requisites there were no issues reported.  But after checking the logfiles we found some of the library files are missing. Cause: The required library files were missing and these files were present in the OS package "motif" Solution: Install the required "Motif toolkit " package on the Application Server. Search Package availability in repository: root@erpappst8:~# pkg search motif INDEX&nbsp  PACKAGE com.oracle.info.description set    Motif toolkit                                     pkg:/library/motif@2.1-11.4.21.0.1.69.0 pkg.description   pkg:/library/motif@2.1-11.4.21.0.1.69.0 pkg.description             set ...

New version of start CD has been release for Oracle EBS R12.2. Every new version will of start CD will included bug fixes and enhancements. Oracle always recommend to use the latest version of start CD for EBS Installations and upgrades. If you preparing a fresh stage then directly you can use "buildStage.sh" script from "start CD 12.2.0.49" for preparing your stage, If stage is already in place and you want to update it with the latest startCD then you can follow all listed below Instructions. STEPS: 1) Download patch form MOS (need valid CSI) 2) verify the version of existing start CD 3) Copy startCD-49 to Stage area  and rename/delete the existing "stardCD" directory 4) Run "builStage.sh" script to copy latest Tech Patches to Stage area. 1) Download patch form MOS (need valid CSI) You need to have a valid support contract to download this patch 2) verify the version of existing start CD You can verify version of startC...