SELECT hou.name operating_unit, xep.name legal_entity, cebb.bank_name, cebb.bank_number, cebb.bank_branch_name, cebb.bank_branch_number, cebb.bank_branch_type, — Branch type indicates which list the bank routing number is on. Valid types are ABA, CHIPS, SWIFT, OTHER. cbv.address_line1,…
Read MoreINTRODUCTION This blog explains how we cancel approved requisition in oracle apps PROCEDURE CANCEL_REQUISITION (P_BATCH_RUN_ID IN NUMBER,P_REQUISITION_NO IN VARCHAR) AS X_REQ_CONTROL_ERROR_RC VARCHAR2(500); LN_USER_ID NUMBER; …
Read MoreINTRODUCTION This blog explains how we validate Third Party Registration in oracle apps –****************************************************** — Checking Third Party Registration(GST) –****************************************************** BEGIN SELECT DISTINCT TRIM (TO_CHAR…
Read MoreINTRODUCTION This blog explains how we validate Bill to customer in oracle apps –****************************************************** — Bill To Customer Address Validation –****************************************************** BEGIN SELECT hcas.cust_acct_site_id –hcsu.site_use_id …
Read MoreCategory Location Start/Stop Logfiles $INST_TOP/logs/appl/admin/log Log files for OPMN and OHS processes $IAS_ORACLE_HOME/ instances//diagnostics/logs Weblogic Nodemanager $FMW_HOME/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.log Apache Logs $IAS_ORACLE_HOME/instances//diagnostics/logs/OHS/EBS_web_/*log OPMN Logs $IAS_ORACLE_HOME/instances//diagnostics/logs/OPMN/opmn/ Weblogic Logs $IAS_ORACLE_HOME/../wlserver_10.3/common/nodemanager $EBS_DOMAIN_HOME/servers/oa/logs/ $EBS_DOMAIN_HOME/servers/forms/logs/ $EBS_DOMAIN_HOME/servers/AdminServer/logs/* $EBS_DOMAIN_HOME/sysman/log/*
Read MoreGroup Services Scripts Purposes Root Services Node Manager adnodemgrctl.sh WLS Node Manager controls server instances within a domain providing automatic restart functionality. Web Administration Services WebLogic Admin Server adadminsrvctl.sh WLS…
Read MoreCategory 12.1 12.2 Forms & Reports, Developer Home, Tools Home 10.1.2 – ORACLE_HOME 10.1.2 ORACLE_HOME OC4J/OHS/OPMN 10.1.3 – IAS-ORACLE_HOME OPMN, oacore-oc4j, oafm-oc4j, forms-oc4j, etc Fusion Middleware – OHS/WLS OHS –…
Read Morea. Create a gold image of the 19c Oracle Home. $ cd $ORACLE_HOME/ $./runInstaller -createGoldImage -destinationLocation /u03/database19c -silent $./runInstaller -createGoldImage -destinationLocation /u03/database19c -silent Successfully Setup Software. Gold Image location: /u03/database19c/db_home_2018-02-26_22-47-54PM.zip…
Read MoreINTRODUCTION: The below steps shows how to decrypt the weblogic password for oracle Apps R12.2 STEP 1: Connect to instance as applmgr and source the ENV. su – applmgr .…
Read MoreINTRODUCTION: The below steps shows us how to run a concurrent program in a custom manager, STEP 1: Navigate to System Administrator->Concurrent->Program->Define STEP 2: Create a custom manager as per…
Read More