Skip to content

Instantly share code, notes, and snippets.

View demasy's full-sized avatar
🎯
Focusing

Ahmed El-Demasy demasy

🎯
Focusing
13 followers · 97 following
View GitHub Profile
@demasy
demasy / statement.sql
Created August 25, 2021 10:22
Oracle Applications FND Concurrent Program SQL
SELECT FCP.APPLICATION_ID,
FAT.APPLICATION_NAME CONCURRENT_APPLICATION_NAME,
FCP.CONCURRENT_PROGRAM_ID,
FCP.CONCURRENT_PROGRAM_NAME,
FCPT.LANGUAGE,
FCPT.USER_CONCURRENT_PROGRAM_NAME CONCURRENT_NAME,
FCPT.DESCRIPTION,
FCP.EXECUTABLE_APPLICATION_ID,
FAT_EXE.APPLICATION_NAME EXECUTABLE_APPLICATION_NAME,
DECODE (FCP.ENABLED_FLAG, 'Y', 'Yes', 'No') ENABLED_FLAG,
@demasy
demasy / statement.sql
Last active August 25, 2021 10:20
Oracle Application FND Application SQL
SELECT FA.APPLICATION_ID,
FA.PRODUCT_CODE,
FA.APPLICATION_SHORT_NAME,
FAT.APPLICATION_NAME,
FAT.LANGUAGE
FROM FND_APPLICATION FA, FND_APPLICATION_TL FAT
WHERE 1 = 1
AND FA.APPLICATION_ID = FAT.APPLICATION_ID
AND ( UPPER (FAT.APPLICATION_NAME) LIKE '%' || UPPER (:1) || '%'
OR :1 IS NULL)
@demasy
demasy / statement.sql
Created August 25, 2021 10:18
Oracle Templates & Data Definition SQL
SELECT XTB.TEMPLATE_ID,
XTB.APPLICATION_ID TEMPLATE_APPLICATION_ID,
XTB.APPLICATION_SHORT_NAME,
FAT.APPLICATION_NAME TEMPLATE_APPLICATION_NAME,
XTB.TEMPLATE_CODE,
XTB.TEMPLATE_TYPE_CODE,
XTB.DEFAULT_LANGUAGE,
XTB.DEFAULT_TERRITORY,
XTB.OBJECT_VERSION_NUMBER,
XTB.START_DATE,
@demasy
demasy / javaController.java
Last active August 25, 2021 10:01
OAF Java Controller Methods
public void processRequest(OAPageContext pageContext, OAWebBean webBean) {
super.processRequest(pageContext, webBean);
}
public void processFormRequest(OAPageContext pageContext, OAWebBean webBean) {
super.processFormRequest(pageContext, webBean);
}
@demasy
demasy / OAF MDS APIs.sql
Created August 25, 2021 09:57
OAF MDS APIs
// Delete OAF Document API
DECLARE
L_DOCUMENT_PATH VARCHAR2 (300);
BEGIN
L_DOCUMENT_PATH := '/oracle/apps/fnd/framework/navigate/webui/customizations/org/204/NewHomePG';
JDR_UTILS.DELETEDOCUMENT (P_DOCUMENT => L_DOCUMENT_PATH);
END;
@demasy
demasy / Delete XDO Template API.sql
Created August 25, 2021 09:50
Delete XDO Template API
BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW ('<TEMPLATE_APP_NAME>', '<TEMPLATE_CODE>');
COMMIT;
END;
@demasy
demasy / Restart weblogic server.md
Last active September 27, 2021 10:34
Restart weblogic server on Oracle E-Business Suite in one line 
APPSUSER="APPS"

APPSPASS= <Enter Password>

WLSPASSWORD= <Enter Password>
@demasy
demasy / init the default author details for NPM package.json
Created April 25, 2021 09:13
init the default author details before publishing NPM packages to the registry must contain a package.json file
sudo npm config set init-author-name "Ahmed El-Demasy" -g
sudo npm config set init-author-email "ceo@egyptianprogrammers.com" -g
sudo npm config set init-author-url "https://github.com/demasy" -g
@demasy
demasy / Open SQL Developer on MacOS using Terminal
Last active April 25, 2021 08:57
Open SQL Developer on MacOS using Terminal
/Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper
zsh sqldeveloper.sh
@demasy
demasy / Environment Variables
Last active April 1, 2020 13:23
Environment variables for oracle installation on windows
NLS_LANG
AMERICAN_AMERICA.AR8MSWIN1256
ORACLE_HOME
C:\demasy\oracle\db
TNS_ADMIN
C:\demasy\oracle\network\admin