People and Culture Blog

Prevent the APEX application from being opened in multiple tabs with the same Session state

1. Overview This document talks about prevent opening Oracle APEX application in multiple tabs with the same session state. 2. Technologies and Tools Used The following technologies have been used…

Read More

SharePlex reports out-of-sync conditions

How SharePlex reports out-of-sync conditions For all objects except those involved in transformation, SharePlex verifies that the source and target data in a given operation are synchronized before posting the…

Read More

Invalid receipt due to previous pay from customer and customer site issue for receipt

Issue ; while closing the AR period we could see one receipt in in valid status in subledger period close exception report.   Fix ; we have data fix for…

Read More

Steps to start/stop Workflow Notification Mailer–backend

  Steps to start/stop Workflow Notification Mailer   Check workflow mailer service current status   SQL> select running_processes from fnd_concurrent_queues where concurrent_queue_name = ‘WFMLRSVC’;   RUNNING_PROCESSES —————– 1 Number of…

Read More

21c New Feature – Result Cache for Standby Database

Oracle 21c introduces the ability to improve the performance of queries executed on the read-only active Standby Database by enabling the use of the Result Cache feature to store query…

Read More

ORA-17629: Cannot connect to the remote database server | Active Duplicate on RAC

If you got this error in the RMAN active duplication of RAC database fails on restart operation with the following error messages: RMAN-03002: failure of Duplicate Db command at 02/17/2021 15:12:11…

Read More

The Store Record X Could Not Be Found

Shutdown manage servers and Admin server, clear below extension file on under domain home. Clear temp and cache of manage and admin servers   find . -name “*.DAT” -print find…

Read More

Life At Doyensys – Bhagavathy Ramachandran M

We at Doyensys, believe in the fact that every employee possesses their own set of strengths and efficiencies. It is those values of our employees that has kept us growing…

Read More

Auto Refresh Report and Hide Processing Spinners in Oracle Apex

Overview This document explains how to auto refresh report after a specified interval and hide processing spinners in oracle apex. Technologies and Tools Used The following technologies have been used…

Read More

FIND APEX USERS LOGIN DETAILS

Description: Following sql script is used to find the Application Express users , who all are logged in previous days or specific period (months , years) . Steps: 1.Login as…

Read More