I am upgrading an Oracle APEX application - used by our Call Center to make calls - that was initially built using APEX version 4.1.
I am in the process of upgrading/redesigning the application to the latest APEX version. I have upgraded up to version 18.1.
I have a JavaScript - embedded in my APEX application - that is designed to initiate an IVR (Interactive Voice Response) call-out process within an Oracle APEX (version 18.1) application. Please find attached the original JavaScript (built in APEX version 4.1) and the updated JavaScript (with APEX version 18.1).
Below is a breakdown of what the JavaScript does.
Explanation of the IVR (Interactive Voice Response) Call-out Process JavaScript
I have a JavaScript - embedded in my APEX application - that is designed to initiate an IVR (Interactive Voice Response) call-out process within an Oracle APEX (version 18.1) application. Here is a breakdown of what the script does:
- Function Definition: The script defines a JavaScript function named ‘start_ivr_call_out’, which takes two parameters: ‘emp_id’ (employee ID) and ‘app_user’ (application user).
- Setting Form Values: Inside the function, it sets the value of two form elements (‘P29_EMP_ID’ and ‘P29_APP_USER’) with the provided ‘emp_id’ and ‘app_user’ respectively:
document.getElementById('P29_EMP_ID').value = emp_id;
document.getElementById('P29_APP_USER').value = app_user;
- Confirmation Prompt: It displays a confirmation dialog to the user using the ‘confirm’ function, confirming whether the IVR call should be submitted. The confirmation message includes the ‘emp_id’.
- Handling Confirmation: If the user confirms (‘r == true’), the script proceeds with making the IVR call-out.
- It initializes an AJAX request using ‘htmldb_Get’ to a specific application process named ‘IVR_CALL_OUT’.
- It adds parameters (‘P29_EMP_ID’ and ‘P29_APP_USER’) to the AJAX request, presumably to pass the employee ID and application user to the server-side process.
- It executes the AJAX request with ‘ajaxRequest.get()’.
- It displays an alert message indicatingthat the IVR call-out was made successfully, including the employee ID and application user.
- It initializes another AJAX request to a different application process named ‘UPDATE_DCT_CALL_QUEUE’, though this request does not seem to be executed.
- Cancellation Handling: If the user cancels the confirmation prompt (‘r == false’), it displays an alert indicating that the call was canceled.
Overall, this script allows users to initiate an IVR call-out from an Oracle APEX application, confirming the action with a dialog and updating form values accordingly before making the request to the server.
My issue: The application that I am upgrading was originally built in version pre-4.1. I am currently rebuilding the application in version 18.1. The JavaScript that I am having issues with was also built in Oracle APEX version pre-4.1. When I imported this JavaScript in the Oracle APEX version 18.1, it started giving me issues by throwing error messages.
Error Message: “Error in making IVR call:”
What I need: I need your help in fixing/rebuilding the JavaScript so it can function properly by initiating IVR Call-out from the Oracle APEX application.
JavaScript for IVR Call-out application_with_APEX_V4-1.txt
JavaScript for IVR Call-out application_with_APEX_V_18-1.txt