ERPstuff - Oracle EBS Community

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

Paste the following code in the Theme Roller or Incline CSS of login page,

.t-Login-region {
position: fixed;
top: 25%;
left: 2%;
}

If you are connected with Oracle EBS R12 instance and trying to get data but it is showing no record then do this setting,

1. select * from hr_operating_units;
no data

2.ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN';

select * from nls_session_parameters;

3. select * from hr_operating_units;
Now it ...

Please check my video on SSL,

https://youtu.be/77jfvRe2GqQ

This topic will help you to reset or continue Oracle identity sequences without dropping the table or manually altering internal sequences.

What is an Identity Column?

An identity column in Oracle is used to automatically generate sequential values, typically for a primary key. When you define ...

You skipped ACL or wrongly configured your database not allowing your code to go out im simple words

My Video explaining ACL
https://youtu.be/XKmI4s4pIDA


ORA-29273: HTTP request failed
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES", line 681
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES ...

main post above update you can find detail at the bottom. thanks

zainhanaan wrote: Thu Jul 24, 2025 6:24 pm what about 11g and 12.1 . your mention code is for oracle apex only

A Master-Detail relationship is a common design pattern in application development where two sets of data are related hierarchically. In this context, the Master represents a high-level record, such as an Invoice, while the Detail contains the associated lower-level records, such as the Invoice ...