Assignment Set Conversion
Assignment Set: Once sourcing rules has been defined, you must assign them to particular items and/or organizations. These assignments are grouped together in assignment sets. In an assignment set you…
Read MoreSourcing Rule Conversion
Sourcing Rule: Sourcing Rule Provides list of approved suppliers where we can rank the suppliers on a percentage basis. This is useful for the buyers/requestors at the time of making…
Read MoreLot-Wise Onhand Availability across Inventory Orgs
Standard functionality in the SO Form, provides the On-Hand visibility of an Item at the Specific Inventory Org (Ship From Org) level. In case the Visibility is required as per…
Read MoreDisplaying images in a Report
Purpose: This document shows user how to include images in report By assumption we will upload a image to work space and call that particular image through HTML using image name and displays in classical or interactive report. Another way is that, the user can able to retrieve images from the Database. Benefits: ØUser able to know prior information about subject ØFaster Turnaround. ØReport is used to get the information if user include an image.it will be more helpful. Steps to display images in report Step1: Create a new page Step 2: Create a region èreportèclassical or interactive reportèName for the reportèSQL queryè follow the below query Case and Decode both methods can be done. Based on Requirement modify the query. Example: CASE WHEN gender = ‘MALE’ AND emp_image IS NULL THEN ‘<img src=”#WORKSPACE_IMAGES#not_found_male.jpg” width=”75px;” height=”75px;”/>‘ // uploaded default male icon in workspace and checking for the condition image is available in table or not. WHEN gender = ‘FEMALE’ AND emp_image IS NULL THEN ‘<img src=”#WORKSPACE_IMAGES#not_found_female.jpg” width=”75px;” height=”75px;”/>’ // uploaded default Female icon in workspace ans checking for the condition image is available in table or not. WHEN emp_image IS NOT NULL // if the image already available in the database THEN ‘<img alt=”‘ //HTML tag || apex_escape.html_attribute (c.first_name) // this function returs name of the employee || ‘” title=”‘ || apex_escape.html_attribute (c.first_name) …
Read MoreRole based Authorization in Oracle APEX5
Objective: To implement Role based Authorization in Oracle APEX Application, in version 5. Application Item: USER_ROLE Table: ROLE_ACCESS_CONTROL The purpose of this table is to store the privileges on Regions, Buttons and Items, for each role. Page access is controlled through the Region access (Even if one Region in a Page is given access, its Page will appear; Components cannot be created without a “Region”;) Column Name Data Type Comments ROLE_ACCESS_ID NUMBER Primary Key USER_ROLE VARCHAR2(30) Role Name APP_ID NUMBER APEX System Variable PAGE_ID NUMBER APEX System Variable REGION_ID NUMBER APEX System Variable COMPONENT_ID VARCHAR2(30) APEX5 System Variable COMPONENT_NAME VARCHAR2(30) APEX5 System Variable…
Read MoreApex.server.process
This function calls a PL/SQL on-demand process defined on page or application level. It’s an wrapper of the jQuery.ajax function and supports all the setting the jQuery function provides but…
Read MoreCreate / Update Location API
We define a location in order to identify the exact address of an organization or employee work location. Locations can be local as well as global. Local locations are available…
Read MoreCreate Bank and Bank Branch Using API
When performing Master Data Migration for Supplier or Customer business also needs the migration of Associated Banks and Bank Branches.In order to perform this we need to migrate Banks, Bank…
Read MoreRestrict Copy Paste & Right Click In Apex Page
PURPOSE: The Purpose of this component is to restrict the copy option from the user level of apex page. SCENARIO : 1.Consider in our apex application we are providing any confidential message or data that should not be copied by user level,we can restrict by this component. 2.If we want to provide any notification message for restrict the copy option for that particular confidential page, we can use this component. STEPS TO DO: 1.Create a page in apex and use the region to display some text that to restrict copy option 2.In that region source type the script that given below and save the page and run it. SCRIPT EXPLANATION: We can restrict the copy option by these ways, 1.Restrict Ctrl+C Button. 2.Restrict Mouse Right click . This script will restrict these two ways, //Restrict Ctrl+C Button in javascript <head> <script language=”javascript”> <!– function Disable_Control_C() { var keystroke = String.fromCharCode(event.keyCode).toLowerCase(); if (event.ctrlKey && keystroke == ‘c’) { event.returnValue = false; alert(‘You can not copy here’); } } </script> </head> //This script will restrict the CTRL+C and stop the action in user level <body onkeydown=”javascript:Disable_Control_C()”> </body>…
Read MoreCreating Interactive Report as Excel format with applying font for particular column values
PURPOSE: If we want to show any report in excel format in page level with the different font of column values we can use this component script to achieve the scenario. Steps To Follow: Step 1 : Create a interactive report that we need to show in excel format Step 2 : In a report definition type the query base on the select list and dense_rank () method Step 3: You can use the HTML tags in the select list to show the name in different format that we need Excel Format Interactive Report Standard SELECT (‘<b>’ || col1 || ‘<b>’) “xxx”, (‘<b>’ || col2 || ‘<b>’) “yyy”, (‘<u>’ || col3 || ‘<u>’) “yyy”, (‘<i>’ || col4 || ‘<i>’) “yyy”,. . . FROM (SELECT DECODE (rk, 1, col1, ”) “xxx”, DECODE (rk, 1, col2 || ‘%’, ”) “yyy”, col3, col4, col5,col6 FROM (SELECT col1, col2, Col3,col4,col5,col6 DENSE_RANK () OVER (PARTITION BY col6 ORDER BY tablename1.ROWID) rk FROM t1, t2 WHERE t1.col1=t2.col1 AND condition1 AND condition2 AND condition3 AND condition4 )); Step 3 : Create a query based on this and modify the column name and enter the query in the report region Step 4 : After Entering the query go to Interactive report à Report Attributes change the Display Text As à Standard Report Column Step 5 : Now we can able to see the report in excel format Coding Explanation…
Read More