INTRODUCTION This blog explains how we cancel approved requisition in oracle apps PROCEDURE CANCEL_REQUISITION (P_BATCH_RUN_ID IN NUMBER,P_REQUISITION_NO IN VARCHAR) AS X_REQ_CONTROL_ERROR_RC VARCHAR2(500); LN_USER_ID NUMBER; …
Read MoreINTRODUCTION This blog explains how we validate Third Party Registration in oracle apps –****************************************************** — Checking Third Party Registration(GST) –****************************************************** BEGIN SELECT DISTINCT TRIM (TO_CHAR…
Read MoreINTRODUCTION This blog explains how we validate Bill to customer in oracle apps –****************************************************** — Bill To Customer Address Validation –****************************************************** BEGIN SELECT hcas.cust_acct_site_id –hcsu.site_use_id …
Read MoreINTRODUCTION This blog explains how we get complete order details about the for a sales order in oracle apps CODE SELECT OOH.ORDER_NUMBER , OOH.FLOW_STATUS_CODE HEADERSTATUS , OOH.ORDERED_DATE ORDER_DATE , OTT.NAME …
Read MoreRefresh Region On Interactive grid Save Introduction: If you want to perform any action after saving the interactive grid we can write custom dynamic action Steps to be followed: …
Read MoreIntroduction This blog explains to create floating/Fixed scrollbar for Classic report in Oracle APEX Paste the below code in “Execute when Page Loads“ $(function($) { var scrollbar = $(‘<div id=”fixed-scrollbar”><div></div></div>’).appendTo($(document.body));…
Read MoreIntroduction This blog explains to get the On hand quantity if a item in inventory for a specific date #Code# SELECT SUM (TRANSACTION_QUANTITY) TARGET_QTY FROM MTL_ONHAND_QTY_COST_V MOQV WHERE MOQV.ORGANIZATION_ID =…
Read MoreIntroduction This blog explains how to get pricelist details for an item #Code# SELECT QLH_TL.NAME “List Price” ,QLH_TL.DESCRIPTION “Description” ,QLH_TL.VERSION_NO “Version” ,QLH_B.LIST_TYPE_CODE “List Type” ,QLH_B.CURRENCY_CODE “Curr Code” ,MSI.SEGMENT1 “Item Number”…
Read MoreIntroduction This blog explains how to create user and add responsibility for a user from the backend. #Code# DECLARE lc_user_name VARCHAR2(100) := RAJAN_TEST’; lc_user_password VARCHAR2(100) := ‘Oracle123′; ld_user_start_date DATE :=…
Read MoreBy default IR region allows to either enable Download button to all users or disable Download button to all users. Suppose if there is a requirement to enable/disable download button…
Read More