/***************************************************************************** *PURPOSE: SQL Query to List Oracle ERP Cloud Users and their Attached Roles * *AUTHOR: Shailender Thallam * *****************************************************************************/ SELECT pu.user_id, pu.username, ppnf.full_name, prdt.role_id,… Read More »SQL Query to List Oracle ERP Cloud Users and their Attached Roles
SELECT fcr.request_id , fcpt.user_concurrent_program_name || NVL2(fcr.description, ‘ (‘ || fcr.description || ‘)’, NULL) conc_prog , fu.user_name requestor , fu.description requested_by , fu.email_address , frt.responsibility_name requested_by_resp… Read More »SQL Query to Find Scheduled Concurrent Programs List
/******************************************************* *PURPOSE: SQL Query to find DFF Structure from backend* *AUTHOR: Shailender Thallam * *******************************************************/ SELECT apps.application_name "Application", d_flex.title "DFF Title", d_flex.application_table_name "Table Name", d_flex.context_user_override_flag… Read More »SQL Query to Find DFF Structure from backend
Sometimes we face a problem of SQL*Loader loading data into a wrong column OR only partial data gets loaded into a column. These issues might… Read More »Character Set in SQL*Loader
Here is a utility WINSCPPWD, a simple command line tool to recover WinSCP stored passwords. Here in this article I will explain how to use… Read More »Do you know how to Retrieve WinSCP Stored Passwords?
Script to RETRY workflow BEGIN wf_engine.handleerror ( itemtype => ‘OEOL’, itemkey => 2705276, activity => ‘SHIP_LINE’, command => ‘RETRY’, RESULT => NULL ); END; /… Read More »How to RETRY/SKIP a workflow from backend
Below are the different components of WebADI the can be migrated from one instance to another Integrators Contents Layouts Mappings Parameter List Components Integrator Command… Read More »FNDLOAD Commands to Migrate WebADI Objects
SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. Capabilities of SQL*Loader Can load data from multiple… Read More »SQL*Loader Concepts
To migrate an XMLP report we need below 4 objects LDT file for Concurrent Program LDT file for XMLP Template and Data Definition XML Data… Read More »FNDLOAD and XDOLoader to Migrate XMLP reports
/******************************************** *PURPOSE: To Delete Lookup or Lookup Code * *AUTHOR: Shailender Thallam * *********************************************/ SET serveroutput ON; — DECLARE CURSOR cur_lkp_values IS SELECT lookup_type,… Read More »PL/SQL Script to Delete Lookup or Lookup Code