blog-2-create-user-and-add-responsibility-from-backend   Query: declare v_user_name varchar2(30) :=’AJ_TEST’;   — User Name v_password  varchar2(30) [...]

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 [...]

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 [...]

r12-oracle-general-ledger-setup

 Introduction: 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 we solve: Create [...]

Introduction:   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 How do we [...]

  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 [...]

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 were being a problem such [...]

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: [...]

query-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 [...]