The Syntax Blog

Where new ideas come alive.

Disk Space and Journaling Issues on the iSeries Operating System

by Jean Driscoll Senior Technical Consultant, Syntax Sometimes you come in on a Monday morning and nothing is working. Suddenly you have a P1 and many users and their managers calling. Most IT workers have been called in the middle of the night or have arrived at work walking into this situation. Data growth is […]

Identifying E-Business Suite 12.2 CPU Patches and Security Fixes Using the ECPUC Tool

A valuable new utility, EBS Critical Patch Update Checker (ECPUC), was released with the July 2023 CPU (Critical Patch Update). This utility brings some valuable functionality to your Oracle E-Business Suite environment. It is highly recommended that you incorporate ECPUC into your system to benefit from the following features: Accurately assess your EBS environment’s current […]

Identify and resolving record locks on iSeries

In all databases with multiple processes accessing the data, record locks occur. These come up in the alerts you get from the web and enterprise server logs. Message: 11812/10172 WRK:Starting jdeCallObject jdbodbc.C8416 ODB0000164 – STMT:00 [HY000][-913][2] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0913 – Row or object F0101 in PRODDTA type *FILE in use. Failed […]

Setting Up Self-Service Password Reset in JD Edwards EnterpriseOne

The Self-Service Password Reset capability available in JD Edwards EnterpriseOne allows users to reset their passwords without having to get an administrator involved. This allows users to avoid the downtime of waiting for an administrator and allows administrators to continue working on their tasks rather than stopping to reset a user’s password. With the ability […]

Improving EBS Performance with the Support Analyzer Bundle Menu Tool

Analyzers available within the Support Analyzer Bundle Menu Tool contain self-service health-check scripts that review data and analyze current configuration settings to help to optimize E-Business Suite system performance and keep Oracle software and systems healthy. These analyzers are designed to proactively assist in diagnosing and maintaining Oracle Application environments, identify many known issues across […]

Enhancing Oracle EBS Application Management: Capturing the Managed Server Name in the PROGRAM Column of the V$SESSION View

Author: Vineet Kumar Introduction As a Database Administrator (DBA) working with Oracle E-Business Suite (EBS) applications, ensuring the effective management and troubleshooting the environment is of paramount importance. One crucial aspect is capturing the managed server name in the PROGRAM column of the V$SESSION view. This enables improved configuration management and facilitates the identification and […]