ERPstuff - Oracle EBS Community

Oracle Database 23ai

Oracle Database 23ai introduces a powerful integration of AI within enterprise databases. Unlike public Large Language Models such as ChatGPT, Cohere, Google Gemini, or Meta LLaMA, which are limited to their training data, Oracle 23ai enables the enhancement of LLMs with real ...

It is very normal to use Interactive Report and process selective records by giving checkboxes to users. Users can select single, multiple or can use select all and then process selected lines. By default till Oracle APEX 24.2.5 this functionality is not avaiable so here are the steps to enable such ...

Select calendar region then attriburtes and Initialization JavaScript Function

function(poptions) {

// Show weekends
poptions.weekends = true;

// Days of the week: 0=Sun, 1=Mon, 2=Tue, 3=Wed, 4=Thu, 5=Fri, 6=Sat
poptions.firstDay = 1;

// Show week numbers in the calendar
poptions ...

In Oracle APEX if you need to refresh Dynamic Content Region on the Source/calling page when a called dialog page closed then following these steps,

begin
DBMS_ERRLOG.CREATE_ERROR_LOG (dml_table_name => 'EMP');
end;

it will create table for dataload error,

CREATE TABLE "ERR$_EMP"
( "ORA_ERR_NUMBER$" NUMBER,
"ORA_ERR_MESG$" VARCHAR2(2000),
"ORA_ERR_ROWID$" UROWID (4000),
"ORA_ERR_OPTYP$" VARCHAR2(2),
"ORA_ERR_TAG$" VARCHAR2(2000 ...

{with/}
TYPE:=INITIAL
IMAGE:=#AVATAR#
SIZE:=t-Avatar--lg
SHAPE:=t-Avatar--circle
CSS_CLASSES:=u-color-29
{apply THEME$AVATAR/}

misc.defaultPage=apex configuration

Oracle REST Data Services Configuration Files Guide

1: Run the Interactive report and go to Actions button
2: Select Rows per page choose desired value
3: select Save Report and select default report settings for all users

Setting up Cohere AI in Oracle APEX

Step 1
Register and get API from Cohere.com

Step 2
Download and install SSL certificates from Cohere.com and install in your Oracle Wallet.

VIDEO: Oracle Wallet Creation, SSL Certificate Import, and Secure Web Services Integration in Oracle APEX
https://youtu ...

Dear there is a Plugin just use it. thanks

Step 1
On calling page inline add this

.no-close .ui-dialog-titlebar-close {
display: none;
}

Step 2
then on the dialog page properties go to Dialog > CSS Classes > Enter no-close

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 ...

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 ...

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 ...