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 Moreintroduction: 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 Moreblog-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 Moreblog-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 MoreIntroduction: 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 MoreWhy 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 Moreoracle-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 Morequery-to-find-form-responsibility-in-oracle-e-business-suite-ebs Query 1: SELECT function_id,USER_FUNCTION_NAME, FUNCTION_NAME, form_name FROM fnd_form_functions_vl fff, fnd_form ff WHERE fff.form_id = ff.form_id and form_name=’OEXOEORD’ Query 2: SELECT responsibility_name, menu_structure.PATH navigation FROM ( SELECT LEVEL padding, menu_id,…
Read More