Yearly Archives: 2024

How do you query Employee Type Suppliers from the Suppliers form, called from a custom Inquiry responsibility

Solution:   1) Exclude the function ‘Supplier Full Access: Buyer View’ from the responsibility assigned to the user From a System Administrator responsibility Navigation: Security -> Responsibility -> Define Query…

Read More

Fixed Asset- Depreciation

Hi All Introduction:  Depreciation This Blog will explain about the Deprecation calculations What is Depreciation? Assets calculates depreciation using either the recoverable cost or the recoverable net book value as…

Read More

How To Achieve Serial Approval Between The Groups And First Responder Wins Within A Group

We  have 2 Approval Groups Approval Group-1 – Parallel Approval with First Responder Wins Employee-A Employee-B Approval Group-2 – Parallel Approval with First Responder Wins Employee-C Employee-D Requirement: When the…

Read More

Azure deployment of IaaC with Terraform

Azure deployment of IaaC with Terraform Introduction: In this blog, we will go through steps to deploy terraform for deploying infrastructure to Azure. Using below steps, we can deploy infrastructure…

Read More

All about txkCfgUtlfileDir.pl utility in Oracle 19c for EBS database

All about txkCfgUtlfileDir.pl utility in Oracle 19c for EBS database: Introduction: Recently, we upgraded our ERP system from version 12.1.0.2 to Oracle 19c in an OCI environment. One challenge we…

Read More

Password Generation

Introduction/ Issue:  Write the issue that you face or the issue that you want to provide a solution through this blog. Password generation based on input parameters (number of digits,…

Read More

Telephone Number Format

Introduction/ Issue:  Write the issue that you face or the issue that you want to provide a solution through this blog. Mobile number should be digits     Why we…

Read More

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 tables are not being purged…

Read More

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 SYSAUX tablespace can grow rapidly due to…

Read More

ORA-19809: limit exceeded for recovery files in dataguard

SYMPTOM  On primary database side, ORA errors in alert log:  Errors in file /u01/app/oracle/diag/rdbms/testdb001/TESTDB001/trace/TESTDB001_arc4_10114.trc:  ORA-07286:  cannot obtain device information.   ARC4: FAL archive failed with error 7286. See trace for details …

Read More