Overview In order to disable New Record Button, Clear Button and Delete Button, Please follow below step Write the code in the Form Level Trigger (WHEN-NEW-BLOCK-INSTANCE) IF :XXBEX_PRO_BUDGET_HEADER_V.PROJECT_STATUS IN (‘PROJECT…
Read MoreWhen the Disposition Fields = (‘Complete’,’Accept’,’Accept with Variance’,’Reject’) Then Disable or READ ONLY the DFF Help -> diagnose -> custom code-> personalize Condition: Trigger Event: WHEN-NEW-ITEM-INSTANCE Trigger Object: GMDQSMPL.SAMPLE_NO Condition:…
Read MoreOverview Requirement: We have to change the “type” field LOV query for populating the custom values. To achieve this we have to follow the below process. Step-1: Login into the application…
Read MoreOverview Sometimes having a requirement to display all block data whenever form is open. In order to achieve please follow below step, Open Form builder> Open your custom form >Go…
Read MoreOnce any environment get refreshed in EBS, a new dbc file will be generated. Some times we will receive 500 internal error. To over come this we need to replace…
Read MoreIn OAF page, if user want to know how many characters entered in message text input field. Below is the code we need to use in process request. String…
Read MoreSuppose if we want to call any external URL in OAF page. So you can call as like below. urlname = https://www.google.com/ pageContext.sendRedirect(urlname);
Read MoreIntroduction: The following script is to validate if there are any corrupted rowids in FND_LOBS table Why we need to do this? When we run this validation script it will…
Read MoreSELECT * FROM (SELECT POH.SEGMENT1 PO_NUMBER, PRL.RELEASE_NUM RELEASE_NUM, DECODE ( PRL.PO_RELEASE_ID, NULL, POH.clm_document_number, POH.clm_document_number || ‘-‘ || TO_CHAR (PRL.RELEASE_NUM) ) DISPLAY_PO_NUMBER, POL.LINE_NUM LINE_NUM, POL.ITEM_ID ITEM_ID, POL.ITEM_REVISION ITEM_REVISION, POL.ITEM_DESCRIPTION ITEM_DESCRIPTION, POL.VENDOR_PRODUCT_NUM…
Read MoreSELECT DISTINCT RHI.SHIPMENT_NUM, RHI.SHIPPED_DATE, RHI.EXPECTED_RECEIPT_DATE, RHI.FREIGHT_CARRIER_CODE, RHI.INVOICE_NUM, RHI.WAYBILL_AIRBILL_NUM, RHI.NUM_OF_CONTAINERS, RHI.FREIGHT_TERMS, RHI.BILL_OF_LADING, RHI.PACKING_SLIP, RHI.PACKAGING_CODE, POV.VENDOR_NAME, POV.SEGMENT1 VENDOR_NUMBER, PVS.VENDOR_SITE_CODE, RHI.SPECIAL_HANDLING_CODE, RHI.TAR_WEIGHT, RHI.TAR_WEIGHT_UOM_CODE, RHI.NET_WEIGHT, RHI.NET_WEIGHT_UOM_CODE, RHI.COMMENTS, ” CANCELLATION_STATUS, ” PROCESSING_STATUS, RHI.VENDOR_ID, RHI.VENDOR_SITE_ID, NULL…
Read More