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

INTRODUCTION   This blog explains how we validate Third Party Registration in oracle apps     –****************************************************** — Checking Third [...]

INTRODUCTION   This blog explains how we validate Bill to customer in oracle apps   –****************************************************** — Bill To Customer Address [...]

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

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

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

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

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

Introduction  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’; [...]

By 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 based on [...]