Scripts used for clearing the RCV stuck pending transactions Scenario: While receiving or correcting a PO, some time the transactions get stuck with out Processing due to delay in running…
Read MorePROFILE OPTIONS IN BILLS OF MATERIALS Profile Option User System Administrator Requirements User User Resp App Site Required? Default Value BOM: Check for Duplicate Configuration – Optional No BOM: Component…
Read MoreSTEP 1: CREATE ITEMS Responsibility: Inventory Navigation: Items > Master Items Select the Organization as “M1 – Seattle Manufacturing“ Create the below items; Item Item Template (Type) DYS_CAR Finished Goods…
Read MoreSetups Required: 1. Transaction Type: Create an order transaction type. Sales Document type should be “Sales Agreement“. Fulfillment flow: Sales Agreement – Generic Negotiation Flow: Negotiation Flow – Generic with…
Read MoreBack to Back Orders in Oracle Setups Required: Step1: Create Transaction type. Use Order Fulfillment flow as Order Flow – Generic. Use the Line flow and validate the workflow then…
Read MoreA Favicon (Favorite Icon), also known as a Shortcut Icon, Web site Icon, Tab Icon or Bookmark Icon, is a file containing one or more small icons, associated with a particular website or web page. A web designer can create this icon and upload it to a website (or web page) by several means, and graphical web browsers will then make use of it. Browsers that provide Favicon support typically display a page’s Favicon in the browser’s address bar and next to the page’s name in a list of bookmarks. Browsers that support a tabbed document interface typically show a page’s Favicon next to the page’s title on the tab. For applications which are using Universal Theme you don’t have to modify the Page Template anymore if you want to replace the default Favicon with a custom one. Steps: Step 1: Go to Shared Components > Images and upload your new favicon.ico file. Step 2: Then go to your application and the ‘Edit Application Definition’ button, then the Definition tab. Step 3: Scroll down to Substitutions. Add a new subsitution string called CUSTOM_FAVICON. Enter the substitution string as: #WORKSPACE_IMAGES#favicon.ico Click Apply Changes. Step 4: Navigate to Shared Components > Templates. Filter by ‘Page’ type. Step 5: Edit each of your page templates (tip: start with one that you can test). In the ‘Header’ definition, find the line: <link rel=”icon” href=”#IMAGE_PREFIX#favicon.ico” type=”image/x-icon”> <link rel=”shortcut icon” href=”#IMAGE_PREFIX#favicon.ico” type=”image/x-icon”> Change it to: <link rel=”icon” href=”&CUSTOM_FAVICON.” type=”image/x-icon”> <link rel=”shortcut icon” href=”&CUSTOM_FAVICON.” type=”image/x-icon”> OUTPUT: Before Adding Custom Favicon: After Adding Custom Favicon: ADDING A FAVICON TO APEX 5 UNIVERSAL …
Read MoreA good web design involves the better user interaction and ability to fetch the data in a better way. In Tabular Form user can add rows only by clicking Add Row Button every time. Using this technique user can add multiple entries without clicking Add Row Button and submit them simultaneously. This is a simple and effective solution for creating multiple entries where the number of rows to be entered is indeterminate. Step 1: Create Tabular Form Step 2: Create Select List in the Tabular Form (Ex: “P22_choose_no_of_rows_to_be_added”) Step 3: Write JavaScript Function in Page Header Step 4: Creation of Dynamic Action Step 5 : Call the function f_addRow() in Dynamic True Action Step 6: Write JavaScript in Cancel Button OUTPUT: 1. If No row Selected: 2. If No of rows Selected: 3. While Clicking Cancel Button
Read MoreMost of the Applications includes Accounts Reports like Employee Payroll Reports, Company Purchase Reports, Invoice Reports,etc. Now using this method user can add RUPEE symbol in your reports. Step 1: Create Report (Interactive Report (or) Classical Report) Step 2: Place the below SQL Query in Report Region Source SELECT ‘<span style=”font-weight:bold;”>?</span>’ || ‘ ‘ || CASE WHEN NVL (SUM (amount), 0) = 0 THEN ‘0.00’ ELSE TO_CHAR (NVL (SUM (amount), 0), ‘99999999999.99’) END amount FROM reimbursement_dtls OUTPUT:
Read MoreCoordinate Mapping: Line coordinates are used to specify the position of a line just as point coordinates (or simply coordinates) are used to specify the position of a point. User can draw multiple lines on an Apex Image Item and the Coordinates of all the drawn lines can be obtained and stored in Database Table. This can be acheived by using HTML,CSS, JavaScript. Steps To be followed : Step 1: To get Multiple Lines on your Apex Display Image Item place the following code in the page HTML Header. CODE: <!DOCTYPE HTML> <html lang=“en”> <head> <div id=“page”> <div id=“content”> <style> /* Lines can be styled with normal css: */ div.line{ –webkit–transform–origin: 0 50%; –moz–transform–origin: 0 50%; transform–origin: 0 50%; height: 2px; /* Line width of 3 */ background: red; /* Black fill */ opacity: 0.5; box–shadow: 0 0 8px #B99B7E; /* For some nice animation on the rotates: */ –webkit–transition: –webkit–transform 1s; –moz–transition: –moz–transform 1s; transition: transform 1s; } …
Read MoreHere is how to highlight form text items, which Value Required attribute is set to “Yes” and do not have any value. Step1:Create dynamic action to page zero Name: Highlight required Event: Change Selection Type: jQuery Selector jQuery Selector: input[type=’text’][required] Condition: -No Condition- Action: Execute JavaScript code Fire On Page Load: True Code: if(!$v(this.triggeringElement)){ $(this.triggeringElement).css({“background”:“#FFFF77”}); }else{ $(this.triggeringElement).css({“background”:“”}); } Selection Type: None Step2: Now run application and items having Value Required set to “Yes” background color is changed if item do not have any value. You can find Value Required setting from item attributes. OUTPUT:
Read More