Yearly Archives: 2021

EBS R12.2 Log file locations

Category 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 More

R12.2 EBS Application Services

Group 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 More

Difference between R12.1 & R12.2

Category 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 More

Clone 19c Oracle Home

a. 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 More

tkprof multiple trace files

Introduction:  There are many times where DBA has to run tkprof for multiple trace files at one time and get them uploaded in Oracle SR.  Here, I will be sharing…

Read More

Sales Order Details

INTRODUCTION This blog explains  how we get complete order details about the for a sales order in oracle apps CODE SELECT OOH.ORDER_NUMBER , OOH.FLOW_STATUS_CODE      HEADERSTATUS , OOH.ORDERED_DATE          ORDER_DATE , OTT.NAME                 …

Read More

Attributes for Finished Goods Item

Field Name Level Values User Item Type Master FINISHED GOOD Item Status Org Active Inventory Item Master Yes Stockable Org Yes Transactable Org Yes Reservable Org Reservable Cycle Count Enabled…

Read More

When the Transactable Item Flag can be enabled

  The Transactable Flag for an Item can be enabled only if the Item has Stockable Flag Enabled.

Read More

Returnable Flag for an Item

  The Returnable Flag should be Enabled, If the Item is returnable after successfully completion of order.

Read More

Converting a physical standby database into snapshot standby database

What is snapshot standby database? It allows to perform read-write operation on the standby database.ie converting the physical standby to snapshot standby database. On that, we can do all types…

Read More