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 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/ 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 MoreIntroduction: This SQL query is used to fetch the data Inventory Onhand By Location Cause of the issue: Business wants a report that details Inventory Onhand By Location How do…
Read MoreIntroduction: This SQL query is used to fetching the data Backlog Orders with freight Details Cause of the issue: Business wants a report that details of Backlog Orders…
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