ERPstuff - Oracle EBS Community

This article walks through building a complete Generative AI Agent in Oracle APEX 26.1 using real sales data from the Oracle sample dataset. The agent uses Augment System Prompt tools to inject live context before every conversation and On Demand tools that the AI calls automatically when needed to ...

APEXlang with Oracle APEX 26.1 on Windows
Part 1: Setup and Configuration

A practical guide for Oracle developers on Windows including real errors encountered, exact fixes applied, and lessons learned along the way.

By Malik Sikandar Hayat | Oracle ACE Pro | ERPstuff.com | admin@erpstuff.com ...

Oracle APEX 26.1 is the latest release of Oracle's low code development platform. This article walks through the complete installation on Oracle Database 26ai Free edition on Windows including all errors encountered and how they were resolved.


What is Data Reporter

Data Reporter is a new ...

Oracle APEX 24.2 Patch 16 is a cumulative patch. This means it includes all fixes and updates from the previous patches in the 24.2 release series.

If you are currently on version 24.2.1/24.2.10 and want to upgrade to 24.2.16, you only need to apply Patch 16. There is no requirement to install each ...

If you want to install Oracle Forms 10g on windows 10,11 here are the steps you need to perform,

1. Get Oracle Forms 10g and it will have Disk_1 & Disk_2.

forms1.png

2. Now ideally you should double click setup.exe and installation should start and finish but this is not the case. Oralce forms ...

You will learn how to generate different report formats step by step, including:

Simple PDF report
Matrix (tabular) report
Master–Detail PDF report

The video focuses on structuring data properly and rendering it into well-formatted PDF documents using jsPDF, making it useful for ERP, reporting ...

Hi, You may be missing steps. thanks

Providing Captcha on your Oracle APEX login page is a security requirement which any public application must have to handle automated logins.


Captcha1.png

Best practices for CAPTCHA

Generate the code
Use a random string for the CAPTCHA Mix letters and numbers (avoid ambiguous characters ...

RMAN connection to target database
rman target /

Check database structure using RMAN
REPORT SCHEMA

Display current RMAN configuration
SHOW ALL

Enable automatic control file backup
CONFIGURE CONTROLFILE AUTOBACKUP ON

Set disk backup location format
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01 ...

https://ollama.com/

serve Start the Ollama service so models can run
Sample: ollama serve

create Build a new model from a Modelfile for custom LLMs
Sample: ollama create mymodel -f Modelfile

show Display full details of a model such as parameters and template
Sample: ollama show llama3

run ...

DECLARE
l_data VARCHAR2(4000);
l_qr_blob BLOB;
l_ean8 VARCHAR2(8);
BEGIN
FOR r IN (
SELECT empno,
NVL(ename, '') ename,
NVL(job, '') job
FROM emp
)
LOOP
IF :P27_BARCODE_TYPE = 'QRCODE' THEN
-- QR Code: can use full data
l_data := TO_CHAR(r.empno) || ',' || r.ename || ',' || r.job;
l ...

DECLARE
v_input VARCHAR2(4000) := :P30_DEPTNAME_MANUAL;
v_deptno NUMBER;
v_deptno_list VARCHAR2(4000);
v_exists NUMBER;
BEGIN
FOR rec IN (
SELECT TRIM(COLUMN_VALUE) AS dept_name
FROM TABLE(APEX_STRING.SPLIT(v_input, ':'))
WHERE TRIM(COLUMN_VALUE) IS NOT NULL
)
LOOP
-- Check if ...

Has your Google account been hacked? Don’t worry in this video I’ll show you how to recover your Gmail, YouTube channel, Google Drive, AdSense, and all linked services.

✔ Secure your Gmail after a hack and reset your password
✔ Recover a hacked YouTube channel and protect your content
✔ Regain ...

1)

BEGIN
DBMS_UTILITY.compile_schema
(
schema => 'your schema nme', compile_all => FALSE
);
END;
/

2)

SELECT 'ALTER ' || OBJECT_TYPE || ' ' || OWNER || '.' || OBJECT_NAME || ' COMPILE;'
FROM DBA_OBJECTS
WHERE STATUS = 'INVALID';

3)

SET SERVEROUTPUT ON
DECLARE
v_sql VARCHAR2(200);
BEGIN
FOR ...

You are welcome. thanks