Concurrent Program Failure with Error “FDPSTP failed due to ORA-20100”
User Submitted concurrent Program “XXFM TBI DEBIT CONTROL” in DEV environment after Clone. Program failure happening with Below Error. [...]
Oracle EBS
Challenges and Solutions from working on Oracle E-Business Suite.
Shipment Tracking Number Update using API
procedure xxdm_upd_ship_num_in_orcl(p_delivery_detail_id NUMBER, p_thirsd_party_tracking_number VARCHAR2) is l_index NUMBER; l_msg_return NUMBER; [...]
By Gobinath
Posted sys.wrm$_wr_control( ACTIVE_SESSION_HISTORY)Does Not Get Purged Based upon the Retention Policy
It appears there is an issue with the purging mechanism of AWR (Automatic Workload Repository) tables in Oracle databases. The main problem is that the [...]
By Gobinath
Posted AWR Snapshots to Reduce Space Usage of SYSAUX Tablespace
AWR (Automatic Workload Repository) snapshots can be used to reduce the space usage of the SYSAUX tablespace by periodically purging older snapshots. The [...]
Oracle Data Guard Physical Standby switchover using DGMGRL:-
Oracle Data Guard Physical Standby switchover using DGMGRL:- Performing a Oracle Data Guard Switchover Using DGMGRL Step1:-Check the Primary [...]
Concurrent Program Failure with Error “FDPSTP failed due to ORA-20100”
User Submitted concurrent Program “XXFM TBI DEBIT CONTROL” in DEV environment after Clone. Program failure happening with [...]
Shipment Tracking Number Update using API
procedure xxdm_upd_ship_num_in_orcl(p_delivery_detail_id NUMBER, p_thirsd_party_tracking_number VARCHAR2) is l_index NUMBER; l_msg_return NUMBER; [...]
By Gobinath
Posted sys.wrm$_wr_control( ACTIVE_SESSION_HISTORY)Does Not Get Purged Based upon the Retention Policy
It appears there is an issue with the purging mechanism of AWR (Automatic Workload Repository) tables in Oracle databases. The main problem is [...]
By Gobinath
Posted AWR Snapshots to Reduce Space Usage of SYSAUX Tablespace
AWR (Automatic Workload Repository) snapshots can be used to reduce the space usage of the SYSAUX tablespace by periodically purging older [...]
Oracle Data Guard Physical Standby switchover using DGMGRL:-
Oracle Data Guard Physical Standby switchover using DGMGRL:- Performing a Oracle Data Guard Switchover Using DGMGRL Step1:-Check the [...]
Reinstate Failed Primary Database using Flashback:-
Reinstate Failed Primary Database using Flashback:- Methods to Reinstate database using Flashback:- 1) Using DGMGRL 2) Using [...]
Edition-Based Redefinition[EBR] –Granualar access in EBS R12
Introduction: Edition-Based Redefinition is an essential feature in Oracle, designed for oracle database administrators, developers who manage [...]
Overview of Block Volume in Oracle Cloud Infrastructure
INTRODUCTION: In today’s world, businesses create and uses a huge amount of data, so they need storage solutions that are both efficient [...]
Comparison Between File Storage and Block Volume in OCI
Introduction: In cloud computing, choosing the right storage solution is important to ensure good performance, manage costs, and handle data [...]
Unable to apply the receipts getting Error ACC DATE NOT IN OPEN PD
Unable to apply the receipts getting Error ACC DATE NOT IN OPEN PD Error message:- This error appears when Accounting Periods are not open in [...]