sudo apt update
sudo dpkg --add-architecture i386
wget -O - https://dl.winehq.org/wine-builds/winehq.key | sudo apt-key add -
sudo apt update
sudo dpkg --add-architecture i386
wget -O - https://dl.winehq.org/wine-builds/winehq.key | sudo apt-key add -
openssl req -x509 -days 365 -newkey rsa:4096 -keyout demasy.key -out roketto.key.crt
openssl rsa -in roketto.key -out demasy.decrypted.key
openssl pkcs12 -export -in demasy.key.crt -inkey demasy.key -out demasy.pfx
sudo lsof -PiTCP -sTCP:LISTEN |
sudo rm -fr /Library/Internet\ Plug-Ins/JavaAppletPlugin.plugin | |
sudo rm -fr /Library/PreferencePanes/JavaControlPanel.prefPane | |
sudo rm -fr ~/Library/Application\ Support/Oracle/Java | |
cd /Library/Java/JavaVirtualMachines | |
sudo rm -rf <jdk-version>.jdk |
FND_CLIENT_INFO.SET_ORG_CONTEXT('101'); |
CREATE OR REPLACE FUNCTION APPS.hex2dec (hexval IN CHAR) | |
RETURN NUMBER | |
IS | |
i NUMBER; | |
digits NUMBER; | |
result NUMBER := 0; | |
current_digit CHAR (1); | |
current_digit_dec NUMBER; | |
BEGIN | |
digits := LENGTH (hexval); |
BEGIN | |
FOR AR_INV_DATA | |
IN (SELECT CUX.CUSTOMER_TRX_ID, CUX.TRX_NUMBER | |
FROM RA_CUSTOMER_TRX_ALL CUX | |
WHERE CUX.BATCH_SOURCE_ID = �REEM� | |
AND CUX.TRX_DATE <= TO_DATE ('01/05/2007', 'dd/mm/yyyy')) | |
LOOP | |
-- Set a proper where condition as your case | |
AR_TRANSACTION_PUB.DELETE_TRANSACTION ( | |
P_API_NAME => 'Maintain_Transaction', |
SELECT msib.ORGANIZATION_ID, | |
DECODE (USERENV ('LANG'), | |
'US', haou.ATTRIBUTE1, | |
'AR', haou.ATTRIBUTE2) | |
ORGANIZATION_NAME, | |
msib.INVENTORY_ITEM_ID, | |
msib.segment1 inv_num, | |
msib.DESCRIPTION, | |
msib.PRIMARY_UOM_CODE, | |
msib.PRIMARY_UNIT_OF_MEASURE, |
SELECT WR.TEXT Value | |
FROM WF_RESOURCES WR | |
WHERE 1 = 1 AND WR.LANGUAGE = USERENV ('LANG') AND WR.NAME = 'WF_VERSION' |
Exec WF_ENGINE.Background('WFVACXX', NULL, NULL, FALSE, TRUE, FALSE); |