Skip to Main Content

Java and JavaScript in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

JavaScript not functioning properly

ballaketMay 24 2024 — edited May 24 2024

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:

  1. 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).
  2. 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;

  1. 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’.
  2. Handling Confirmation: If the user confirms (‘r == true’), the script proceeds with making the IVR call-out.
    1. It initializes an AJAX request using ‘htmldb_Get’ to a specific application process named ‘IVR_CALL_OUT’.
    2. 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.
    3. It executes the AJAX request with ‘ajaxRequest.get()’.
    4. It displays an alert message indicatingthat the IVR call-out was made successfully, including the employee ID and application user.
    5. It initializes another AJAX request to a different application process named ‘UPDATE_DCT_CALL_QUEUE’, though this request does not seem to be executed.
  3. 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

Comments
Post Details
Added on May 24 2024
0 comments
176 views