ERPstuff - Oracle EBS Community

SELECT *
FROM apps.ad_applied_patches where patch_name = :Patch_Number

To show how to send an E-Mail with attachments greater than 32KB using UTL_SMTP package. When using UTL_MAIL or UTL_SMTP package to send an E-Mail with attachment, there is a limitation that the size of the attachment cannot exceed 32KB because maximum size of a variable in PL/SQL cannot be more tha...

DECLARE
dummy NUMBER;
BEGIN
SELECT count(*) INTO dummy FROM dual;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
NULL;
END;

pdf junk letters.png 1 - Update the custom file so changes aren't lost when autoconfig is run as below, grep customfile= $APPL_TOP/APPS$CONTEXT_NAME.env 2 - Take path of echo $FND_TOP 3 - Add following with proper FND_TOP path taken in step 2, IX_PRINTING=" <value of $FND_TOP> /resource/ixlib....

Dear All, Please find the Oracle presentation explaining Oracle APEX features with few important links. Thanks Oracle APEX Security Scanner Utility https://apexsec.recx.co.uk/ How to secure your environment https://insum.ca/oracle-apex-security-where-do-start/ The official Oracle APEX Documentation ...

$ cd /tmp $ wget http://mirror.squ.edu.om/apache/tomcat/tomcat-9/v9.0.30/bin/apache-tomcat-9.0.30.tar.gz tar –xf apache-tomcat-9.0.30.tar.gz now move apache-tomcat-9.0.30 to /opt/tomcat or your tomcat folder. sudo mv apache-tomcat-9.0.30 /opt/tomcat/ sudo chown –R tomcat:tomcat /opt/tomcat sudo sh -...

firewall-cmd --zone=public --permanent --add-port=8080/tcp

firewall-cmd –-reload

now try to open tomcat using your machine name or IP address with port 8080

http://XXXX:8080

apache.png 1- Here are two files in which you have to make changes, sudo nano /opt/tomcat/latest/webapps/host-manager/META-INF/context.xml sudo nano /opt/tomcat/latest/webapps/manager/META-INF/context.xml In the above both files change below as by default only these pages can open on localhost. <Co...

The following will install tomcat and any dependency including java as well. [root@erpstuff ~]# sudo yum install tomcat Loaded plugins: langpacks, ulninfo Resolving Dependencies --> Running transaction check ---> Package tomcat.noarch 0:7.0.76-10.el7_7 will be installed --> Processing Dependency: to...

Recommended column details FILENAME: ICON_NAME in the example below. Tracks the actual filename so that downloads of the file are given an appropriate name. Without this attribute a download link would not know what filename to download a file as. BLOB: ICON_BLOB in the example below. The Binary La...

1. Download http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html 2. Unzip and upload the apex folder in oracle home. 3. As sys user, @apexins.sql SYSAUX SYSAUX TEMP /i/ 4. Upload images in application server folder like in tomcat /apache-tomcat-9.0.14/webapps/i and if not appl...

If you are developing XML report in BI Publisher using word and you get the error "BIP desktop :Could not find the main class. Program will exit". Then open Word and in menu open BI Publisher and click options > Preview and check Java version. It should be min 1.8 and a few other settings ...

l_cm_app_rec.cm_customer_trx_id := P_cn_CUSTOMER_TRX_ID; l_cm_app_rec.cm_trx_number := NULL; -- Credit Memo Number l_cm_app_rec.inv_customer_trx_id := P_inv_CUSTOMER_TRX_ID; l_cm_app_rec.inv_trx_number := NULL; -- Invoice Number l_cm_app_rec.amount_applied := P_vn_AMOUNT_DUE_REMAINING; l_cm_app_rec....

The following sample was to send email based on user request by SMS using APEX emails while you can change as per your scenario, PROCEDURE r12_new_password (errbuf OUT VARCHAR2, retcode OUT VARCHAR2, argument1 IN VARCHAR2 -- userid ) IS v_user_name VARCHAR2 (30) := UPPER (argument1); v_new_password ...

How to audit/list failed/unsuccessful login attempts for Standalone E-Business Suite R12. Setup done: Profile Option related to sign-on Auditing in R12. a) Sign-On:Audit Level -> allows you to select a level at which to audit users who sign on to Oracle Applications. You can set this profile option ...