Query for Approval groups
SELECT pcr.control_rule_id, pcga.control_group_name, pcr.object_code, pcr.rule_type_code, pcr.amount_limit, ( segment1_low || ‘.’ || segment2_low …
Read MoreQuery for Approval Assignments
SELECT hou.NAME operating_unit, pj.NAME job, pcf.control_function_name, pcga.control_group_name, TO_CHAR (ppca.start_date, ‘DD-MON-YY’) start_date, TO_CHAR (ppca.end_date, ‘DD-MON-YY’) end_date FROM apps.po_position_controls_all ppca, …
Read MoreHow to rectify FUN_INTER_PAY_NOT_VALID error in create accounting
During month close an error with invoices/receipts/transactions “FUN_INTER_PAY_NOT_VALID” is a blocker for the close. When this error occurs for AR, follow below steps to identify and fix this issue. Step…
Read MoreQuery to find list of suppliers who has attachments
Often times you might have to find a list of suppliers who has a specific attachment. For example, if you need to find list of suppliers who has attached with…
Read MoreSearch bar for Tabular form with auto complete option for Date values
Requirement: Tabular form Search bar Challenges faced: On default, in tabular form Oracle apex didn’t provided the Search option. Solution: 1. Created a page level select list item to display all the column names. 2. Created a text item (which will act as select list also on selecting date value in previous item) for user to enter the search value. 3. Created 2 buttons, one for searching and other to clear the previously entered value. 4. Modified the existing report query as SELECT NULL, delivery_item_id, master_item_id, delivery_pdvd_id, item_id, program_name, output_name, title, “Item_type”, “Theme”, “Unique_Replicate_Indicator”, “Replicate_of”, rerun, validation_type, “Hold”, “Hold Status”, developer_id, dev_proj_complete_date, dev_status, dev_pending_reason, dev_act_complete_date, dev_status_comments, validator_id, valid_proj_complete_date, valid_status, valid_pending_reason, valid_act_complete_date, valid_status_comments, reviewer_id, review_proj_complete_date, review_status, review_pending_reason, review_act_complete_date, review_status_comments, validation_program_name, dev_check, valid_check, review_check, overall_check, cdars_standards, “Role”, general_comments, SEQUENCE, gc FROM (SELECT ROWNUM rnum, NULL, delivery_item_id, master_item_id, delivery_pdvd_id, item_id, program_name, output_name, title, “Item_type”, “Theme”, “Unique_Replicate_Indicator”, “Replicate_of”, rerun, validation_type, “Hold”, “Hold Status”, developer_id, dev_proj_complete_date, dev_status, dev_pending_reason, dev_act_complete_date, dev_status_comments, validator_id, valid_proj_complete_date, valid_status, valid_pending_reason, valid_act_complete_date, valid_status_comments, reviewer_id, review_proj_complete_date,…
Read MoreShrinking of Navigation Menu on page load
Requirement: Navigation menu should be shrinking on page load. Challenges faced: In Oracle Apex 5, universal theme the navigation menu is strengthening on default page load. If we want to shrink the menu we need to click on the navigation menu controller. Resolution: 1. Created a dynamic action with event as page load and condition as JavaScript Expression and value as $(‘#t_Button_navControl’).attr(‘aria-expanded’) === “true”. 2. A true action is provided with JavaScript code as $(‘#t_Button_navControl’).click(); Output:
Read MoreDisplaying of 7 Consecutive Dates in Report Header
Step 1: Create a date field for selecting the date. Step 2: Create a report for displaying the data in those dates. Step 3: Enter the following code in the page header Code: $(function() { var month = new Array(); month[0] = “Jan”; month[1] = “Feb”; month[2] = “Mar”; month[3] = “Apr”; month[4] = “May”; month[5] = “Jun”; month[6] = “Jul”; month[7] = “Aug”; month[8] = “Sep”; month[9] = “Oct”; month[10] = “Nov”; month[11] = “Dec”; var from_date = $(“#P215_FROM_DATE”).val(); //alert(‘from_date’+from_date); var sec_date = new Date(from_date); //alert(‘sec_date’+sec_date)); sec_date.setDate(sec_date.getDate() + 1); //alert(sec_date.setDate(sec_date.getDate() + 1));…
Read MoreRemoval of close button from Select2 plugin
Requirement: The users who completed their tasks in selected Delivery PDVD must not be deleted from team allocation. Select2 plugin was used for selecting multiple users, which will have a cross button to remove the users. The cross button must be disabled for the users who completed their tasks in the selected Delivery PDVD Challenges faced: Select2 is an external plugin for selecting multiple values at a time. On default plugin don’t have any option to remove the close button. Solution: 1. Created a page level item to get all the completed users for selected Delivery PDVD. 2. Created a dynamic action with event as on Page load and called a JavaScript function. 3. Added JavaScript code in the page header to check the users from the previous page item and removed the close icon. function remove_close() { var a=$(“#P94_ROLE”).val(); //alert(a); if (a.length!=0) { var numbers = a.toString().split(‘,’); for(var i = 0; i < numbers.length; i++) { var b=numbers[i]; $(“ul.select2-choices li”).each(function(){ var s= $(this).text(); s=s.trim() if (s==b) { var z=$(this).find(“div”).next().removeClass(“select2-search-choice-close”); //alert(‘s = ‘+s); } …
Read MoreHOLD / UNHOLD in APEX Report
In Report Attributes, Call below function in link – URL function fun(a) { //alert(a); var str = a.substring(4); // alert(str); str =…
Read More