ERPstuff - Oracle EBS Community

In this video, we dive into the new Database Object Dependencies feature introduced in Oracle APEX 24.2. Discover how this powerful tool can help you track and manage the relationships between your APEX applications and the underlying database objects. Learn when and where to use it, explore its ...

Description: In this video, we will walk you through the process of modifying and customizing Oracle APEX Pages and Reports, with a focus on adding new columns to a table and displaying them in various types of reports. You’ll learn how to: Add a Column to an Existing Table Step-by-step instructions ...

Explanation Video Common Name: Enter the fully qualified domain name that you need to secure (www.yourdomain.com). Organizational Unit: Enter a department such as 'Security' or 'IT'. Organization: Enter the full legal name of your organization (DigiCert, Inc.). Locality/City: Enter the city or ...

If you are using Oracle APEX with Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - Production Version 23.6.0.24.11 then if you deleted a process in a page and created new but still that delete process code will be working in the background. This issue noticed in APEX 24.1.4 in the cloud ...

In this article you will be learning about JWT and when and why to use it and then we will discuss and share sample code of using Oracle APEX standard features handling JWT encoding and decoding with easy and comfort. Introduction to JWT (JSON Web Token) JWT (JSON Web Token) is a compact, URL-safe ...

Dear All, If you are applying for jobs but not receiving responses, please review the following points to ensure your application aligns with expectations: Improperly Written CV: Ensure your CV is well-organized, concise, and tailored to the job you’re applying for. Mismatch in Qualifications: Avoid ...

Press F12 and in Console paste following code, if (navigator.storage && navigator.storage.estimate) { const quota = await navigator.storage.estimate(); // quota.usage -> Number of bytes used. // quota.quota -> Maximum number of bytes available. const percentageUsed = (quota.usage / quota.quota ...

Oracle APEX Intro Urdu.jpg Welcome to our introductory video on Oracle APEX In this video, we will cover the basics of Oracle APEX, a powerful low-code platform for building web applications. Whether you are new to Oracle APEX or just getting started with web development, this session is perfect ...

Offline-First Approach in Oracle APEX.jpg Video Recording (Urdu/Hindi): https://youtu.be/fBkVlgJhnrQ Video Recording (English):https://youtu.be/5Pt7KwLKujI This Progressive Web Application (PWA) demo showcases an offline-first approach, enabling users to save data locally even when there’s no a ...

In this youtube video , I provide an in-depth explanation of Oracle SQL Analytic (Window) Functions, covering the following functions: AVG, MAX, MIN, LAG, LEAD, ROW_NUMBER, RANK, and DENSE_RANK. These functions are powerful tools for performing advanced queries and calculations across rows within a ...

APEX$TASK_PK If a primary key column has been defined, this bind variable contains the primary key value. APEX$TASK_PK can also be used as a bind variable in any PL/SQL query used by Task Definition Actions and Task Definition Participants. When used as a bind variable, the syntax is :APEX$TASK_PK ...

SELECT * FROM apex_release; Upgrade @apexins.sql sysaux sysaux temp /i @apex_rest_config.sql Patch Starting ORDS service ords --config D:\Oracle_19c\ords\config serve There is a problem with your environment because the Application Express files have not been loaded. Please verify that you have ...

First of all, we need to understand differences between these two methods used to implement security while doing integration of two applications. Once understanding is established then it will be very easy to implement one of them as per your requirements in Oracle APEX. In is topic we will be doing ...

SELECT fcpa.concurrent_request_id request_id, PUBLISHER_RETURN_RESULTS, fcp.node_name node_name, fcp.logfile_name logfile_path FROM fnd_conc_pp_actions fcpa, fnd_concurrent_processes fcp WHERE fcpa.processor_id = fcp.concurrent_process_id -- AND fcpa.action_type = 6 AND fcpa.concurrent_request_id ...

Generation of QR code, EAN8 and Code128 was offered by Oracle first time in Oracle APEX release 23.2. You can use PL/SQL to generated using provided package APEX_BARCODE. Here I have provided code the way you can generate these code and practice in your Oracle APEX instance. Classic Report basrcodes ...