When 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 MoreIntroduction: This Post illustrates the steps required to check the stuck records in Inventory transactions. Scripts: –Unprocessed Material Transactions SELECT * FROM mtl_material_transactions_temp WHERE organization_id = (SELECT organization_id FROM apps.org_organization_definitions…
Read More