Search found 2099 matches
- Wed Jul 09, 2025 2:31 am
- Forum: Oracle APEX
- Topic: FBR Pakistan API Call
- Replies: 2
- Views: 318
Re: FBR Pakistan API Call
Dear unable to understand as certificate file attached just rename it. Thanks
- Mon Jul 07, 2025 12:14 pm
- Forum: Oracle APEX
- Topic: FBR Pakistan API Call
- Replies: 2
- Views: 318
FBR Pakistan API Call
First register and get token which might take some time may be upto 2 days,
User Manual
https://download1.fbr.gov.pk/Docs/20256251162757102DIUserManualV1.4.pdf
Technical Document
https://download1.fbr.gov.pk/Docs/20256201364855300TechnicalDocumentationforDIAPI.pdf
there are two instance/url ...
User Manual
https://download1.fbr.gov.pk/Docs/20256251162757102DIUserManualV1.4.pdf
Technical Document
https://download1.fbr.gov.pk/Docs/20256201364855300TechnicalDocumentationforDIAPI.pdf
there are two instance/url ...
- Tue Jul 01, 2025 4:26 am
- Forum: Oracle APEX
- Topic: Keeping Network ACLs Alive Across Oracle APEX Upgrades
- Replies: 0
- Views: 283
Keeping Network ACLs Alive Across Oracle APEX Upgrades
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 ...
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 ...
- Fri May 23, 2025 2:38 am
- Forum: Oracle APEX
- Topic: Process only Selected Rows in IG Solution
- Replies: 0
- Views: 615
Process only Selected Rows in IG Solution
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 ...
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 ...
- Fri May 23, 2025 1:48 am
- Forum: Oracle APEX
- Topic: Item ID (P9999_USERNAME) is not an item defined on the current page
- Replies: 0
- Views: 118
Item ID (P9999_USERNAME) is not an item defined on the current page
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;
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;
- Thu May 22, 2025 2:48 am
- Forum: Oracle APEX
- Topic: Allow all hosts and ports using ACL
- Replies: 0
- Views: 134
Allow all hosts and ports using ACL
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;
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;
- Sat May 17, 2025 3:56 am
- Forum: Oracle APEX
- Topic: Vector Embedding using ONNX Model in Oracle 23ai
- Replies: 0
- Views: 134
Vector Embedding using ONNX Model in Oracle 23ai
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 ...
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 ...
- Thu May 15, 2025 3:21 am
- Forum: Oracle APEX
- Topic: How to add select or select all checkboxes in Interactive Report?
- Replies: 0
- Views: 168
How to add select or select all checkboxes in Interactive Report?
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 ...
- Mon May 05, 2025 11:27 am
- Forum: Oracle APEX
- Topic: Weekends and Time range in Calendar?
- Replies: 0
- Views: 214
Weekends and Time range in Calendar?
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 ...
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 ...
- Sat May 03, 2025 2:48 am
- Forum: Oracle APEX
- Topic: Refresh Dynamic Contents region on Dialog Page Close
- Replies: 0
- Views: 214
Refresh Dynamic Contents region on Dialog Page Close
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,
- Thu Apr 10, 2025 3:27 am
- Forum: Oracle APEX
- Topic: Creating DML Error log table for Dataload errors
- Replies: 0
- Views: 741
Creating DML Error log table for Dataload errors
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 ...
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 ...
- Tue Apr 08, 2025 12:35 pm
- Forum: Oracle APEX
- Topic: Avatar in classic report
- Replies: 0
- Views: 454
Avatar in classic report
{with/}
TYPE:=INITIAL
IMAGE:=#AVATAR#
SIZE:=t-Avatar--lg
SHAPE:=t-Avatar--circle
CSS_CLASSES:=u-color-29
{apply THEME$AVATAR/}
TYPE:=INITIAL
IMAGE:=#AVATAR#
SIZE:=t-Avatar--lg
SHAPE:=t-Avatar--circle
CSS_CLASSES:=u-color-29
{apply THEME$AVATAR/}
- Thu Mar 27, 2025 5:35 am
- Forum: Oracle APEX
- Topic: Disabled lnading page
- Replies: 0
- Views: 3500
- Wed Mar 19, 2025 4:13 am
- Forum: Oracle APEX
- Topic: Pagination in Interactive Report or limits records to display
- Replies: 0
- Views: 1171
Pagination in Interactive Report or limits records to display
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
2: Select Rows per page choose desired value
3: select Save Report and select default report settings for all users
- Sun Mar 16, 2025 8:17 am
- Forum: Oracle APEX
- Topic: Setting up cohere AI HTTP 401: Unauthorized?
- Replies: 0
- Views: 1168
Setting up cohere AI HTTP 401: Unauthorized?
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 ...
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 ...