ERPstuff - Oracle EBS Community

Log Tables


CREATE TABLE "HR_ACTION_LOG"
( "ACTION_ID" NUMBER GENERATED ALWAYS AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE NOKEEP NOSCALE NOT NULL ENABLE,
"ACTION_TYPE" VARCHAR2(100) NOT NULL ENABLE,
"EMPLOYEE_ID" NUMBER ...

Account Locked.png

ORDS was unable to make a connection to the database. ORDS is not able to proxy to the target user because that user is locked. The connection pool named: |ocid1.autonomousdatabase.oc1.ap-singapore-1.anzwsljrlyho3maabqiziwev3vw2bcrqwsilatu6o76vmnyvj7gmzqzez5ra|re| had the ...

Create a page item P1_LOCAL_IP on the page and paste following code in a dynamic action or page load,

(function () {
const pc = new RTCPeerConnection({
iceServers: []
});

pc.createDataChannel("");

pc.onicecandidate = function (event) {
if (!event.candidate) {
pc.close();
return ...

Oracle APEX MCQ Practice Quizzes with Certificates and Leaderboard

Test and sharpen your Oracle APEX knowledge with our free practice quizzes. Seven topic based quizzes, each with a large pool of questions, instant feedback, a downloadable certificate, and a public leaderboard so you can see how ...

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