Blog / Category
Oracle Apps
16 articles in this category
Understanding Histogram Skew in Oracle – Why It Matters and How to Fix It
Understanding Histogram Skew in Oracle – Why It Matters and How to Fix It Introduction One of the most common reasons for sudden SQL performance degradation in…
Oracle Enterprise Manager – WebTier / OHS Fails to Start
Oracle Enterprise Manager – WebTier / OHS Fails to Start Introduction A common issue in Oracle Enterprise Manager Cloud Control (OEM 13c) is the sudden failure…
Fixing FRM-92101 Error After Re-Enabling a Custom Concurrent Program in Oracle EBS
Introduction During a recent Oracle E-Business Suite (EBS) maintenance activity, we needed to re-enable a custom concurrent program that had been disabled for a…
Web Services : SOAP, REST Services
Web Services : SOAP, REST Services Introduction: Web Services are services offered over the web that enable communication between different applications. They a…
Personalization Migration: ADF to Redwood Page
Introduction: Migrating personalization from ADF page (Classic UI) to Redwood UI Why we need to do: Oracle is modernizing its Fusion Applications UI/UX,…
ERP Cloud Financials Fusion – Cash Management Auto Reconciliation
ERP Cloud Financials Fusion – Cash Management Auto Reconciliation Introduction Bank Statement Reconciliation – Match Statement Lines and Transactions – Automati…
Delete the concurrent programs
Delete the concurrent programs Prerequisites: If the concurrent program is not in use, the program details need to be entered in the lookup and then this concur…
ECC Developer Page Is Blank After Performing New Installation
Introduction:- Oracle Enterprise Command Centers can be integrated to the Oracle E-Business Suite which enables enterprises to have real-time operational data a…
Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time
Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time Use-Case: In general during the migrati…
Managing EBS Concurrent Processing and Cleaning concurrent processing tables
Managing Oracle E-Business Suite Concurrent Processing and Cleaning concurrent processing tables Introduction: Oracle E-Business Suite (EBS) is a comprehensive…
Ship Confirm
Sample script for Ship confirm PROCEDURE xx_bdg_ship_confirm ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id NUMBER ) AS x_return_status VARCHAR2 (2); x_m…
Pick Release
Sample script for Pick Release PROCEDURE xx_bdg_sin_delv_picrelease ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id NUMBER ) AS x_return_status VARCHAR2 (…
EBS R12.2 ADOP phases and parameters
EBS R12.2 ADOP phases and parameters 1) Prepare – Starts a new patching cycle. Syntax: adop phase=prepare 2) Apply – Used to apply a patch to the patch file sys…
To recover Concurrent Manager – Concurrent Manager recovery Wizard – EBS 11i/R12
Concurrent Manager Recovery Wizard – Oracle Applications Manager Troubleshooting and Diagnostics Follow the below steps to use the Concurrent Manager Recovery W…
How To Clear BNE Cache in EBS 11i/R12
GOAL: To clear BNE cache in EBS environment Solution: To Clear BNE cache: A. Releases prior to 12.2.7 Using System Administrator responsibility: Login to the ap…
Oracle Apps(EBS) – AR Receipt Register Query with Bank statement Header and Line Details
Below query is useful when you required Non Misc Receipts Along with Bank Statement Header , Line Details and Activity name ( like Receipt Write off) SELE…