Preventive Maintenace Work Order
Breakdown Maintenance A.1 N> Enterprise Asset Management > Work Order Sub Menu > Work Order Definition >Open A.2 Click NEW for creation of New work order A.3 Enter…
Read MoreInventory Item Product Variant Setups Creation
This document provides detailed steps on how to create the Style Item and SKU Items from UI. The Style items can be used to group similar items (called SKUs or…
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 MoreLogistics Network Modeling-Oracle Cloud Transportation Management
Introduction Logistics Network Modeling is an essential feature of Oracle Transportation Management. It allows for the simulation of multiple scenarios and the analysis of the best fit solution without having…
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 MoreSTEPS TO PERFORM REVALUATION IN FUSION APPLICATION
Introduction/ Issue Revaluation is a process of adjusting the accounted value of foreign currency denominated balances according to current conversion rates. Revaluation adjustments represent the difference in the value of…
Read More