Thursday, September 2, 2021

Prebuilt Applications with blogging

 https://tedstruik-oracle.nl/ords/f?p=25384:1133::::::

 

Thursday, July 22, 2021

Oracle Apex Image Prefix.

 CD APEX21.1

CD APEX

CD UTILITIES

-----------  F:\apex_21.1\apex\utilities :

SQLPLUS /NOLOG

CONN SYS/SYS@ORCLPDB2 AS SYSDBA

@reset_image_prefix.sql

Enter the Application Express image prefix [/i/] /images211/

...Changing Application Express image prefix

NEW_IMAGE_P

/images211/

Wednesday, June 2, 2021

The connection pool named: |apex|rt| is not correctly configured, due to the following error(s): ORA-28000: The account is locked.

The connection pool named: |apex|rt| is not correctly configured, due to the following error(s): ORA-28000: The account is locked.







Check if there is any Locked User :

CONN SYS/SYS@ORCLPDB AS SYSDBA

select username, account_status, profile        from dba_users 
    where username in ('APEX_PUBLIC_USER','APEX_LISTENER','APEX_REST_PUBLIC_USER');  

Run the following  :

ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Apex123 ACCOUNT UNLOCK;
ALTER USER APEX_LISTENER IDENTIFIED BY Apex123 ACCOUNT UNLOCK;
ALTER USER APEX_REST_PUBLIC_USER identified BY Apex123 ACCOUNT UNLOCK;

ALTER USER APEX_200100 IDENTIFIED BY Apex123 ACCOUNT UNLOCK;
ALTER USER APEX_INSTANCE_ADMIN_USER IDENTIFIED BY Apex123 ACCOUNT UNLOCK; 


Windows :

Go to :  D:\ords\conf\ords\conf
Give Password at each xml file like : !Apex123 [Must add an ! exclamatory sign. before password. ]

Files are :

apex.xml
apex_al.xml
apex_pu.xml
apex_rt.xml

apex.xml :

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<comment>Saved on Wed Jun 02 22:29:52 BDT 2021</comment>
<entry key="db.password">!Apex123</entry>
<entry key="db.username">APEX_PUBLIC_USER</entry>
</properties>

apex_al.xml :

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<comment>Saved on Wed Jun 02 23:12:48 BDT 2021</comment>
<entry key="db.password">!Apex123</entry>
<entry key="db.username">APEX_LISTENER</entry>
</properties>

apex_pu.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<comment>Saved on Wed Jun 02 23:12:48 BDT 2021</comment>
<entry key="db.password">!Apex123</entry>
<entry key="db.username">ORDS_PUBLIC_USER</entry>
</properties>

apex_rt.xml :

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<comment>Saved on Wed Jun 02 23:12:48 BDT 2021</comment>
<entry key="db.password">!Apex123</entry>
<entry key="db.username">APEX_REST_PUBLIC_USER</entry>
</properties>

Now Uninstall ORDS with the following command :

D:
CD ORDS
"C:\Program Files\Java\jdk-15.0.1\bin\java" -jar ords.war uninstall

Now Install ORDS with following command :

"C:\Program Files\Java\jdk-15.0.1\bin\java" -jar ords.war install advanced

copy ords.war from 
D:\ords  
and paste to 
C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps

Now Restart Services :


















Now Restart Tomcat.


Now run Apex with ORDS :

localhost:8080/ords
or
127.0.0.1:8080/ords




Sunday, May 30, 2021

How to Integrate Oracle 10g Reports with Oracle Apex

Script 1:

var r_server = "http://192.168.100.100/reports/rwservlet?server=rep_appsrv1_asbiforms10&destype=cache&desformat";

var r_branch_code = $v("P100_BRANCH");

var r_emp_id = $v("P100_emp_NO");

var r_link = ""+r_server+"=pdf&userid=HR/HR@HR&REPORT=D:/A_REPORT/FUND_REPAYMENT_LETTER.rdf&P_BRANCH_CODE="+r_branch_code+"&P_REPAYMENT_NO="+r_emp_id+"";

window.open(r_link);

Script 2 :

var serIp = $v("P14_SERIP");

var catId = $v("P14_ITEM_CAT");
var scatId = $v("P14_ITEM_SUB_CAT");
var coaId = $v("P14_COA_TYPE");

var reportId = '&CATID='+catId+'&SCATID='+scatId+'&COAID='+coaId;


if ($v("14_RG")==1)
window.open(serIp+'COMPANY_INFO.rdf&SOMID=1');
else if ($v("14_RG")==2)
window.open(serIp+'DEPT_INFO.rdf');
else if ($v("14_RG")==3)
window.open(serIp+'DESIG_INFO.rdf');
else if ($v("14_RG")==4)
window.open(serIp+'LINE_INFO.rdf');
else if ($v("14_RG")==5)
window.open(serIp+'BLOCK_INFO.rdf');
else if ($v("14_RG")==6)
window.open(serIp+'BUYER_INFO.rdf');
else if ($v("14_RG")==7)
window.open(serIp+'SUPPLIER_INFO.rdf');
else if ($v("14_RG")==8)
window.open(serIp+'ITEM_INFO.rdf'+reportId);
else if ($v("14_RG")==9)
window.open(serIp+'CHART_OF_ACCOUNTS.rdf');

DECLARE
A VARCHAR2(100);
B VARCHAR2(100);
C VARCHAR2(200);
D VARCHAR2(200);
E NUMBER;
BEGIN
SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') INTO A FROM DUAL;
SELECT SUBSTR(A,0,3) INTO B FROM DUAL;
SELECT LENGTH(A) INTO E FROM DUAL;
SELECT LIC_LOCAL_IP,LIC_REAL_IP INTO C,D FROM ISP_RUNAUTO;

IF E>6 THEN
    IF B=192 THEN RETURN C; ELSE RETURN D; END IF;
ELSE
    RETURN C;
END IF;

END;


Monday, April 19, 2021

Oracle Apex Date Picker to Text Field Dynamic Action PLsql

 DECLARE

  V VARCHAR2(10):='';

  vAttdt date;

BEGIN

  vAttdt := :p44_attdt;

  :P44_ATTDT2:=TO_CHAR(VaTTDT,'RRRRMMDD');

END;