Splitting of Shipment Lines
Splitting of order lines, this can be done during shipping last part of sales order, generally we come across this scenario, when we want to ship partial quantity when there…
Read MoreAGENT PATCHING from OEM Console
INTRODUCTION :- In this blog post, we will discuss Agent Patching briefly. While we typically perform patching from the backend, using the OEM Console for patch application can significantly expedite…
Read MoreInstallation of E-Business Suite Support Analyzer Bundle Menu Tool (DOC1939637.1)
Introduction:– EBS Support Analyzers are designed by Oracle Support to proactively assist with diagnosing issues and maintaining Oracle Application environments. Each analyzer is either a Java script or pl/sql package…
Read MoreHow to apply java certificate to jar files in Oracle E-Business suite – Step by Step
How to apply java certificate to jar files in Oracle E-Business suite – Step by Step Step1: Bringdown app services Step2: Backup below files: cp $NE_BASE/EBSapps/appl/ad/admin/adsign.txt $NE_BASE/EBSapps/appl/ad/admin/adsign.txt_before_migration cp $NE_BASE/EBSapps/appl/ad/admin/adkeystore.dat $NE_BASE/EBSapps/appl/ad/admin/adkeystore.dat_before_migration…
Read MoreTXK Delta 13 failed due to missing files
TXK Delta 13(32392507) plus critical TXK patches 33550674, 33535778 failed because of missing files adsign.txt and adkeystore.dat under $APPL_TOP_NE/ad/admin The Solution: The apply phase failed twice, once when looking for…
Read MoreAdop Phase=cutover Failing With AutoPatch – AidafoGetFileDbVersion: INFO: ORA-01403: No Data Found
AutoPatch – aidafoGetFileDbVersion: INFO: ORA-01403: no data found when apply adop phase=cutover failing with AutoPatch Please follow below steps to overcome this issue Confirm that value for READ_ONLY_FLAG and ENABLED_FLAG…
Read MoreDeep Dive – Data Dictionary Views
Introduction:- The current topic should be very familiar to the freshers and DBA’S as we know earlier. In general, The data dictionary is structured in tables and views, just like…
Read MoreRole of Global Names in Database Links
ROLE OF GLOBAL NAMES IN DATABASE LINKS Introduction:- This is mainly for Oracle DBA’S who are widely seen about Database links in their organizations, Let us understand closely about the…
Read MoreHow to run SQL tuning advisor manually in Oracle Database
Step 1: Get the hash value of the SQL using the SQL ID. Enter the SQL ID select a.plan_hash_value from v$sql a where sql_id=’&a’; Step 2: Create a tuning…
Read MoreEBS Workflow Mailer Command Line Java Diagnostic Tests for Office365,GMail,On-Premises Email Servers
EBS Workflow Mailer Command Line Java Diagnostic Tests for Office365,GMail,On-Premises Email Servers Very often in Workflow service requests, one will be requested to run Workflow Mailer Command Line Java Test…
Read More