ERPstuff - Oracle EBS Community

When you patch or upgrade Oracle APEX, Oracle creates a new internal schema whose name embeds the APEX version, e.g.

APEX release Internal schema
22.2 APEX_220200
23.1 APEX_230100
24.1 (future) APEX_240100

If you granted network‑access privileges to the old schema (via XML ACLs in 11 g or unified ...

1. Create an IG
2. Create a Text Item to Keep selected Values like in my case P2_SELECTED
3. Create Dynamic Action on IG > Selection Change IG and write following Javascript

var model = this.data.model;
var selectedRecords = this.data.selectedRecords;
var idList = [];

for (var i = 0; i ...

Got this error in Cloud Oracle APEX 24.2.0

1 error has occurred
Item ID (P9999_USERNAME) is not an item defined on the current page.

Login as Admin/Sys and apply following solution

BEGIN
DBMS_RESULT_CACHE.FLUSH;
END;

BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'ERPSTUFF'',
principal_type => xs_acl.ptype_db));
END;

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