Nurturing Culture and Values
A company’s success is often attributed not only to its innovative products or services but also to the strength of its organizational culture. Doyensys stands out for its unique and…
Read MoreRevolutionizing Medical Device Operations: Doyensys’ Successful Cloud Migration Journey
Doyensys, a global IT services powerhouse, has recently achieved a significant milestone with the successful execution of a groundbreaking upgrade and migration project for a leading medical device manufacturer in…
Read MoreXML Bursting via Alerts
Initially there was an alert in the system but due to alignment Issues we planned to go with trigger and XML Bursting. As there was already Alert in the system…
Read MoreOracle / PLSQL: LISTAGG Function
Oracle / PLSQL: LISTAGG Function how to use the Oracle/PLSQL LISTAGG function with syntax and examples. Description The Oracle/PLSQL LISTAGG function concatenates values of the measure_column for each GROUP based on the order_by_clause. Syntax The syntax…
Read MoreTricentis Tosca – Templates
introduction: Tosca test case templates are pre-defined structures that outline the general flow of test steps required for a particular testing scenario. These templates serve as blueprints for generating concrete…
Read MoreCreate User and Add Responsibility from Backend
blog-2-create-user-and-add-responsibility-from-backend Query: declare v_user_name varchar2(30) :=’AJ_TEST’; — User Name v_password varchar2(30) :=’johnytips’; — Password — List of responsibilities to be added automatically cursor cur_get_responsibilities is select resp.responsibility_key ,resp.responsibility_name ,app.application_short_name…
Read MoreScript to Create Responsibility using API
blog-1-script-to-create-responsibility-using-api Query: CREATE TABLE APPS.XXRAN_RESPONSIBILITY_TAB ( RESP_NAME VARCHAR2(100 BYTE), APPLICATION VARCHAR2(50 BYTE), RESP_KEY VARCHAR2(40 BYTE), MENU_NAME VARCHAR2(60 BYTE), DATA_GROUP VARCHAR2(40 BYTE), REQ_GROUP VARCHAR2(50 BYTE), STATUS VARCHAR2(1 BYTE), ERROR_MSG VARCHAR2(240 BYTE)…
Read MoreVLAN TRUNKING PROTOCOL IN NETWORK
Introduction: This blog explains about the feature of VLAN TRUNKING Protocol on Network. Why VTP IS REQUIRED ? Traditionally, when there are multiple SWITCHES /Lan devices between the…
Read MoreNETWORK DYNAMIC ROUTING PROTOCOL
Why Dynamic routing protocol? During the early days of the network, static routing was in the play. But later at the stage when the network start to grow static routing…
Read MoreQuery to generate file in remote server when new record inserted into table.
oracle-ebs-query-to-generate-file-in-remote-server-when-new-record-inserted-into-table Script 1: CREATE OR REPLACE DIRECTORY XDMC_OUTBOUND AS ‘XX_TEST/outbound/CUST_PO’; / Script 2: CREATE OR REPLACE PROCEDURE APPS.XDMC_PO_FILE_GEN( p_cust_po_number IN VARCHAR2, p_status OUT NOCOPY VARCHAR2 ) AS v_file UTL_FILE.FILE_TYPE; lc_filedir …
Read More