ERPstuff - Oracle EBS Community

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

Upgrade your database. Thanks

Dear unable to understand as certificate file attached just rename it. Thanks

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

You can download here if ...