For Example, two countries the Natural account for Cash Clearing account should hit 1460020, this is to identify the TnE Cash Reimbursements. The following configurations needs to be updates Manage…
Read MoreCash Management Reconciliation Error (Trying to match the lines and reconcile. However, system throws an error as it exceeds the limit of 10000.) Below attached error screenshot Solution Create…
Read MoreIntroduction/ Issue: Unable to Generate Accounting for Receipt GRNs Why we need to do / Cause of the issue: Unable to Generate Accounting for Receipt Accounting. Create Accounting for Receiving…
Read MoreIntroduction/ Issue: Employees Forced to Include At least One Aged Corporate Card Transactions. Why we need to do / Cause of the issue: Employee unable to claim expense due to…
Read More1. Overview This blog explains about, How to Set Current Record Color -Multi Color. 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Oracle FORMS 3. Use Case Create a Simple Tabular Block Create Visual Attribute with color Gray -Name it as ODD Create Visual Attribute with color Blue -Name it as Event In When-New-Record-InstanceCreate a Procedure 4. Architecture Oracle FORMS FORM Builder 5. Examples Step 1: Create one procedure in forms. Code: PROCEDURE Visual_attribute_dis_alt_rec IS cur_itm VARCHAR2 (80); cur_block VARCHAR2 (80) := :SYSTEM.Cursor_Block; curr_record NUMBER; BEGIN cur_itm := GET_BLOCK_PROPERTY (cur_block, FIRST_ITEM); WHILE (cur_itm IS NOT NULL) LOOP cur_itm := cur_block || ‘.’ || cur_itm; Curr_record := :SYSTEM.Cursor_Record; IF MOD (curr_record, 2) = 1 THEN SET_ITEM_INSTANCE_PROPERTY (cur_itm,…
Read More1. Overview This blog explains about, how we can Email validation using PLSQL function. 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Oracle PLSQL 3. Use Case To Create one function in database 18C 4. Architecture Oracle Database Using Database 18C ORALCE PL/SQL 5. Examples Step 1: Create one function in Database. Create one function in database. Code: CREATE FUNCTION f_email_validate (pi_email_id IN OUT VARCHAR2) RETURN BOOLEAN IS lv_n_check_len NUMBER; lv_b_check_in_at BOOLEAN; lv_b_check_in_dot BOOLEAN; lv_v_extn VARCHAR2 (10); BEGIN lv_n_check_len := LENGTH (pi_email_id); pi_email_id := LOWER (pi_email_id); SELECT REPLACE (pi_email_id, ‘ ‘, ”) INTO pi_email_id FROM DUAL; SELECT REPLACE (pi_email_id, ‘”‘, ”) INTO pi_email_id…
Read MoreIntroduction: This blog explains Network Access control list. What is an ACL? Access Control List is a Network security feature that filters traffic on Layer 3 (IP Address) and Layer…
Read More1. Overview This blog explains about, How to insert bulk records within a milli seconds by using Bulk Collect with FORALL. 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Oracle PLSQL 3. Use Case Create one procedure in database object. Run the procedure. 4. Architecture Oracle Database 18C PLSQL 5. Examples Step 1: Create one Procedure in Database object like below: CREATE OR REPLACE PROCEDURE increase_salary ( department_id_in IN employees.department_id%TYPE, increase_pct_in IN NUMBER) IS TYPE employee_ids_t IS TABLE OF employees.employee_id%TYPE INDEX BY PLS_INTEGER; l_employee_ids employee_ids_t; l_eligible_ids employee_ids_t; l_eligible BOOLEAN; BEGIN SELECT employee_id BULK COLLECT INTO l_employee_ids FROM employees WHERE department_id = increase_salary.department_id_in; FOR indx IN 1 .. l_employee_ids.COUNT LOOP check_eligibility (l_employee_ids (indx),…
Read More1. Overview This blog explains about, How to Use Webutil browse file from desktop to directory . 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Oracle FORMS 3. Use Case Create the form like the below. Use the below code In load file “button” using “when-button-pressed” trigger. 4. Architecture Oracle FORMS FORM Builder 5. Examples Step 1: Create one form like below: Step 2: using the below code In load file “button” using “when-button-pressed” trigger. Code: DECLARE l_userhome VARCHAR2 (200) := webutil_clientinfo.get_system_property (‘user.home’) || ‘\Desktop’; l_filename VARCHAR2 (200) := NULL; l_bare_filename VARCHAR2 (200) := NULL; l_fileprefix VARCHAR2 (200) := NULL; l_serverfilename VARCHAR2 (200) := NULL; l_upload_path VARCHAR2 (200) := NULL; l_version_path VARCHAR2 (200) := NULL; l_option_grade_path VARCHAR2 (200) := NULL; l_size_curve_path VARCHAR2 (200) := NULL; l_filesize NUMBER; al_con alert; l_status BOOLEAN;…
Read Moreoracle-ebs-query-to-concurrent-details-for-past-60-days SELECT distinct ft.user_concurrent_program_name “Concurrent Program Name”, fr.REQUEST_ID “Request ID”, to_char(fr.ACTUAL_START_DATE,’dd-MON-yy hh24:mi:ss’) “Started Date”, to_char(fr.ACTUAL_COMPLETION_DATE,’dd-MON-yy hh24:mi:ss’) “Completed Date”, decode(fr.PHASE_CODE,’C’,’Completed’,’I’,’Inactive’,’P’,’Pending’,’R’,’Running’,’NA’) “Phasecode”, decode(fr.STATUS_CODE, ‘A’,’Waiting’, ‘B’,’Resuming’, ‘C’,’Normal’, ‘D’,’Cancelled’, ‘E’,’Error’, ‘F’,’Scheduled’, ‘G’,’Warning’, ‘H’,’On Hold’,…
Read More