R12 Oracle General Ledger Setup
r12-oracle-general-ledger-setup
Read MoreInventory Onhand By Location Report
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…
Read MoreBacklog Report With Freight Details
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…
Read MoreVLAN TRUNKING PROTOCOL IN NETWORK
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 the…
Read MoreNETWORK DYNAMIC ROUTING PROTOCOL
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…
Read MoreQuery to generate file in remote server when new record inserted into table.
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: 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-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 MoreHow to zip current running file with out any issues on prod weblogic servers
Issue:- How to zip current running file with out any issues on prod weblogic servers Alert:– Disk space alert >90% from weblgoic servers Error:– Some times .out file is consuming…
Read More