MAP member function are special functions used to compare objects.The MAP member functions are used for performing comparisons between a single attribute of an object instance to a single attribute…
Read MoreIn APEX 4.2, reports with some Chinese and other language characters gets replaced with inverted question marks if downloaded. This issue can be fixed using the below method. Steps: 1…
Read MoreFollow the below steps to achieve, the process of uploading a .XLSX file with multiple tabs with Select List in APEX using PL/SQL. ü Step 1 : Create an .XLSX…
Read MoreFollow the steps below to achieve, the process of uploading a .XLSX file in APEX ( 4,5 AND 18C) using PL/SQL. ü Step 1 : We need to create a…
Read MoreSELECT ppx.employee_number, ppx.full_name, ppx.email_address, …
Read More1. Log into Oracle and select iExp User. 1. Click Create Expense Report to begin the process. a. Track…
Read MoreResponsibility: – Internet Expenses Audit Manager Ø Log into Oracle and go to Internet Expenses Audit Manager Enter the expense number and click on go button. . Click on Apply button…
Read MoreFor both the manager approval and expense report audit/review, any credit card transactions designated as personal expenses will be listed as a separate negative…
Read MoreTo process a Company Pay expense report: 1. On a daily basis, obtain the credit card transactions data file from your credit card provider. 2. Load and validate your transactions. Visa VCF…
Read MoreEmail Validation Function using plsql function 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);…
Read More