.XLSX UPLOAD IN APEX USING PL/SQL
Follow 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 MoreQuery to get employee details who are not submitted the iExpense details for approval
SELECT ppx.employee_number, ppx.full_name, ppx.email_address, …
Read MoreiExpense with Business and Personal expense validate and submit for approval
1. Log into Oracle and select iExp User. 1. Click Create Expense Report to begin the process. a. Track…
Read MoreiExpense report audit/review
Responsibility: – 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 MoreApprove and Review iExpense Reports
For 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 MoreiExpense Load credit card Expenses into Oracle and Payables
To 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 using PL/SQL Function
Email 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 MoreUsing Oracle Forms to load local files
using the below code In load file “button” using “when-button-pressed” trigger. DECLARE l_userhome VARCHAR2 (200) := webutil_clientinfo.get_system_property (‘user.home’) || ‘Desktop’; l_filename VARCHAR2 (200) := NULL; …
Read MoreLoad JSON File to Oracle table
For Example : 1) Sample Json:- { “department”: { “department_number”: 10, “department_name”: “ACCOUNTING”, “employees”: [ { “employee_number”: 7782, “employee_name”: “CLARK” }, …
Read MorePunchout in Oracle iProcurement
Punchout in Oracle iProcurement Punchout is an Oracle standard functionality to purchase an item directly from supplier’s website by a requester.In this feature, the supplier catalogue contains latest product…
Read More