20120104-4

20120104

tcode

https://docs.google.com/document/d/1NzHNi9PSit0sXgpDsfhs0k3-c1u55G8BDy79j0KW1mk/edit

Oracle ebs clone - step by step

________________________________________
Step 1       clone Application
________________________________________
su - applprd
cd $ADMIN_SCRIPTS_HOME
pwd
/oracle/prd/applprd/inst/apps/prd_erp1/admin/scripts
perl adpreclone.pl appsTier


output file in
    cd $COMMON_TOP
    pwd
    /oracle/prd/applprd/apps/apps_st/comn
        output
            clone




________________________________________
Step 2       clone Database
________________________________________
su - oraprd
cd $ORAQCLE_HOME
cd appsutil
cd scripts
cd $CONTEXT_NAME
pwd
/oracle/prd/oraprd/db/tech_st/10.2.0/appsutil/scripts/prd_erp1
perl adpreclone.pl dbTier

output
    /oracle/prd/oraprd/db/tech_st/10.2.0/appsutil/    clone


________________________________________
Step 3  showdown Application
______________________________________

su - applXXX

cd /oracle/       redhat/inst/apps/VIS_erpvis /admin/scripts/
cd /oracle/       vision/inst/apps/VIS_erpvis /admin/scripts/
cd /oracle/demo/appldemo/inst/apps/demo_erpvis/admin/scripts
   /oracle/tst/appltst  /inst/apps/tst_erp1   /admin/scripts
pwd
ls -l
./adstpall.sh apps/apps


________________________________________
Step 4  showdown
______________________________________

su - oraXXX

cd /oracle/       vision/db/tech_st/10.2.0/appsutil/scripts/VIS_erpvis/
cd /oracle/demo/orademo/db/tech_st/10.2.0/appsutil/scripts/demo_erpvis/
cd /oracle/tst /oratst/db /tech_st/10.2.0/appsutil/scripts/tst_erp1

./addlnctl.sh stop VIS
./addlnctl.sh stop demo

./addbctl.sh stop immediate



________________________________________
Step 5  Copy File to target system
______________________________________

*
cd $APPL_TOP
pwd
/oracle/uat/appluat   /apps/apps_st/appl
/oracle/prd/applprd  /apps/apps_st/appl
/oracle/redhat/       apps/apps_st/appl
/oracle/dev  /appldev/apps/apps_st/
mv appl appl_bak_2007


cd /oracle/prd/applprd/apps/apps_st/
scp -r -P2200 ./appl root@192.168.64.19:/oracle/dev/appldev/apps/apps_st/
-------------------------------------------------------------------------------------------------


*
cd /oracle/dev/appldev/apps/apps_st/
mv comn comn_bak_2007

cd $COMMON_TOP/
pwd
/oracle/uat/appluat/apps/apps_st/comn/

cd /oracle/prd/applprd/apps/apps_st/
scp -r -P2200 ./comn root@192.168.64.19:/oracle/dev/appldev/apps/apps_st/


-------------------------------------------------------------------------------------------------

#  Tech Stack
    * <AS Tools ORACLE_HOME>     /oracle/dev/appldev/apps/tech_st/10.1.2
    * <AS Web IAS_ORACLE_HOME>   /oracle/dev/appldev/apps/tech_st/10.1.3


cd /oracle/prd/applprd/apps/tech_st/
scp -r -P2200 ./10.1.2 root@192.168.64.19:/oracle/dev/appldev/apps/tech_st/
scp -r -P2200 ./10.1.3 root@192.168.64.19:/oracle/dev/appldev/apps/tech_st/






Copy the database (DBF) files from the source to the target system
/oracle/prd/oraprd/db/apps_st/data/


cd /oracle/dev/oradev/db/tech_st/
scp -r -P2200 ./10.2.0 root@192.168.64.19:/oracle/dev/oradev/db/tech_st/




________________________________________
Step 6  Configure
______________________________________

su - oraXXX
cd $ORACLE_HOME
pwd
/oracle/uat/orauat/db/tech_st/10.2.0
cd appsutil
cd clone
cd bin
perl adcfgclone.pl dbTier




su - applXXX








date > date1.txt
tar -cvzf /oracle/backup/20071221/oraprd__db__apps_st.tgz  /oracle/prd/oraprd/db/apps_st > oraprd__db__apps_st.log 2> oraprd__db__apps_st2.log
tar -cvzf /oracle/backup/20071221/oraprd__db__tech_st.tgz  /oracle/prd/oraprd/db/tech_st > oraprd__db__tech_st.log 2> oraprd__db__tech_st2.log
tar -cvzf /oracle/backup/20071221/applprd__apps.tgz /oracle/prd/applprd/apps > applprd__apps.log 2> applprd__apps2.log
tar -cvzf /oracle/backup/20071221/applprd__inst.tgz /oracle/prd/applprd/inst > applprd__inst.log 2> applprd__inst2.log
date > date2.txt





















--------------------------------------
screen dump
--------------------------------------



[oradef@erp4 bin]$
[oradef@erp4 bin]$ pwd
/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/bin
[oradef@erp4 bin]$ ls
adcfgclone.pl  adchkutl.sh  adclonectx.pl  adclone.pl  CloneContext_12190839.log
[oradef@erp4 bin]$ perl adcfgclone.pl dbTier

Using Java from /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/bin/../jre
Enter the APPS user password:

JDBCCLASSES = /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc14.jar
XMLPCLASSES = /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar
LOCAL_CPATH = /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/java:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc14.jar

First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:

oradef
 = oradef

dba
 = dba

Running:
/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/java:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile.lst -stage /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone   2> /tmp/adcfgclone.err; echo $? > /tmp/adcfgclone.res
Enter the APPS password : apps

Log file located at /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/bin/CloneContext_03161446.log

Provide the values required for creation of the new Database Context file.

Target hostname (virtual or normal) [erp4]:

Target instance is a Real Application Cluster (RAC) instance (y/n) [n]:n

Target System database name:def

Target system base directory for source homes:/oracle/def/oradef

Target system utl_file accessible directories list:/usr/tmp/def

Number of DATA_TOP's on the target system [4]:1

Target system DATA_TOP 1:/oracle/def/oradef/db/apps_st/data

Target system RDBMS ORACLE_HOME directory:/oracle/def/oradef/db/tech_st/10.2.0

Do you want to preserve the Display set to null (y/n) [y] ?:n

Target system Display [erp4:0.0]:erp4:1.0

Do you want the the target system to have the same port values as the source system (y/n) [y] ?:n

Clone Context uses the same port pool mechanism as the Rapid Install.
Once you choose a port pool, Clone Context will validate the port availability.

Enter the port pool to be used for the target system node [0-99]:
1

Checking the port pool 1
done: Port Pool 1 is free
Report file located at /oracle/def/oradef/db/tech_st/10.2.0/appsutil/temp/portpool.lst
Complete port information available at /oracle/def/oradef/db/tech_st/10.2.0/appsutil/temp/portpool.lst

Creating the new Database Context file from :
  /oracle/def/oradef/db/tech_st/10.2.0/appsutil/template/adxdbctx.tmp

The new database context file has been created :
  /oracle/def/oradef/db/tech_st/10.2.0/appsutil/def_erp4.xml

Log file located at /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/bin/CloneContext_03161446.log
Check logfile /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/bin/CloneContext_03161446.log for details.

Running Rapid Clone with command:
perl /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/bin/adclone.pl java=/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/bin/../jre mode=apply stage=/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/oracle/def/oradef/db/tech_st/10.2.0/appsutil/def_erp4.xml showProgress contextValidated=true
Running:
perl /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/bin/adclone.pl java=/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/bin/../jre mode=apply stage=/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/oracle/def/oradef/db/tech_st/10.2.0/appsutil/def_erp4.xml showProgress contextValidated=true

XMLPARSER: /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar
JDBC: /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc14.jar
CLASSPATH: /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc14.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/java:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/oui/ewt3.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/oui/share.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/oui/srvm.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/ojmisc.jar
OUI CLASSPATH: /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/oui/ewt3.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/oui/xmlparserv2.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/oui/share.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/oui/srvm.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/ojmisc.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc14.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/java
Setting LD_LIBRARY_PATH to /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/oui/lib/linux
Beginning database tier Apply - Mon Mar 16 14:49:12 2009
/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.installer.oui_loc=/oracle/def/oradef/db/tech_st/10.2.0/oui -classpath /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc14.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/java:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/oui/ewt3.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/oui/share.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/oui/srvm.jar:/oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTier -e /oracle/def/oradef/db/tech_st/10.2.0/appsutil/def_erp4.xml -stage /oracle/def/oradef/db/tech_st/10.2.0/appsutil/clone   -showProgress
APPS Password : Log file located at /oracle/def/oradef/db/tech_st/10.2.0/appsutil/log/def_erp4/ApplyDBTier_03161449.log
  -     15% completed

Completed Apply...
Mon Mar 16 15:07:01 2009

Starting database listener for def:
Running:
/oracle/def/oradef/db/tech_st/10.2.0/appsutil/scripts/def_erp4/addlnctl.sh start def

You are running addlnctl.sh version 120.1

Logfile: /oracle/def/oradef/db/tech_st/10.2.0/appsutil/log/def_erp4/addlnctl.txt

Starting listener process def ...


Listener def has already been started.


addlnctl.sh: exiting with status 0


*********************************************************************************************
*********************************************************************************************
*********************************************************************************************
*********************************************************************************************
*********************************************************************************************
*********************************************************************************************












[root@erp4 apps]# su - appldef
-bash: /oracle/def/appldef/apps/apps_st/appl/APPSdef_erp4.env: No such file or directory
[appldef@erp4 ~]$ cd /oracle/def/appldef/apps/apps_st/comn/clone/bin/
[appldef@erp4 bin]$ pwd
/oracle/def/appldef/apps/apps_st/comn/clone/bin
[appldef@erp4 bin]$ ls
adaddnode.pl  adcfgclone.pl  adchkutl.sh  adclonectx.pl  adclone.pl

[appldef@erp4 bin]$ perl adcfgclone.pl appsTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.20.12000000.11

Enter the APPS password :

Running:
/oracle/def/appldef/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /oracle/def/appldef/apps/apps_st/comn/clone/jlib/java:/oracle/def/appldef/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/oracle/def/appldef/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /oracle/def/appldef/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_17899.lst -stage /oracle/def/appldef/apps/apps_st/comn/clone  2> /tmp/adcfgclone_17899.err; echo $? > /tmp/adcfgclone_17899.res

Log file located at /oracle/def/appldef/apps/apps_st/comn/clone/bin/CloneContext_03161521.log

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [erp4] :

Target System Database SID : def

Target System Database Server Node [erp4] :

Target System Base Directory : /oracle/def/appldef

Target System Forms ORACLE_HOME Directory [/oracle/def/appldef/apps/tech_st/10.1.2] :

Target System Web ORACLE_HOME Directory [/oracle/def/appldef/apps/tech_st/10.1.3] :

Target System APPL_TOP Mountpoint [/oracle/def/appldef/apps/apps_st/appl] :

Target System COMMON_TOP Directory [/oracle/def/appldef/apps/apps_st/comn] :

Target System Instance Home Directory [/oracle/def/appldef/inst] :

Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [disabled] :

Do you want to preserve the Display [erp1:1.0] (y/n) ? : n

Target System Display [erp4:0.0] : erp4:1.0

RC-00217: Warning: Configuration home directory (s_config_home) evaluates to /oracle/def/appldef/inst/apps/def_erp4. A directory with this name already exists and is not empty.

Do you want to continue (y/n) ?  : y


Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 1

Checking the port pool 1
done: Port Pool 1 is free
Report file located at /oracle/def/appldef/inst/apps/def_erp4/temp/portpool.lst
Complete port information available at /oracle/def/appldef/inst/apps/def_erp4/temp/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /usr/tmp/def
3. /oracle/def/oradef/db/tech_st/10.2.0/appsutil/outbound/def_erp4
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 2

Backing up /oracle/def/appldef/inst/apps/def_erp4/appl/admin/def_erp4.xml to /oracle/def/appldef/inst/apps/def_erp4/appl/admin/def_erp4.xml3.bak

Creating the new APPL_TOP Context file from :
  /oracle/def/appldef/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp

The new APPL_TOP context file has been created :
  /oracle/def/appldef/inst/apps/def_erp4/appl/admin/def_erp4.xml

Log file located at /oracle/def/appldef/apps/apps_st/comn/clone/bin/CloneContext_03161521.log
Check Clone Context logfile /oracle/def/appldef/apps/apps_st/comn/clone/bin/CloneContext_03161521.log for details.

Running Rapid Clone with command:
perl /oracle/def/appldef/apps/apps_st/comn/clone/bin/adclone.pl java=/oracle/def/appldef/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/oracle/def/appldef/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/oracle/def/appldef/inst/apps/def_erp4/appl/admin/def_erp4.xml showProgress contextValidated=true
Running:
perl /oracle/def/appldef/apps/apps_st/comn/clone/bin/adclone.pl java=/oracle/def/appldef/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/oracle/def/appldef/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/oracle/def/appldef/inst/apps/def_erp4/appl/admin/def_erp4.xml showProgress contextValidated=true
APPS Password :

Beginning application tier Apply - Mon Mar 16 15:22:50 2009

/oracle/def/appldef/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.installer.oui_loc=/oui -classpath /oracle/def/appldef/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/oracle/def/appldef/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/oracle/def/appldef/apps/apps_st/comn/clone/jlib/java:/oracle/def/appldef/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/oracle/def/appldef/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/oracle/def/appldef/apps/apps_st/comn/clone/jlib/oui/share.jar:/oracle/def/appldef/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/oracle/def/appldef/apps/apps_st/comn/clone/jlib/ojmisc.jar  oracle.apps.ad.clone.ApplyAppsTier -e /oracle/def/appldef/inst/apps/def_erp4/appl/admin/def_erp4.xml -stage /oracle/def/appldef/apps/apps_st/comn/clone    -showProgress
APPS Password : Log file located at /oracle/def/appldef/inst/apps/def_erp4/admin/log/ApplyAppsTier_03161522.log
  /     73% completed

Completed Apply...
Mon Mar 16 15:27:52 2009

Starting application Services for def:
Running:
/oracle/def/appldef/inst/apps/def_erp4/admin/scripts/adstrtal.sh -nopromptmsg

You are running adstrtal.sh version 120.13.12000000.3

Executing service control script:
/oracle/def/appldef/inst/apps/def_erp4/admin/scripts/adopmnctl.sh start
script returned:
****************************************************

You are running adopmnctl.sh version 120.4.12000000.3

Starting Oracle Process Manager (OPMN) ...

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /oracle/def/appldef/inst/apps/def_erp4/logs/appl/admin/log/adopmnctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/oracle/def/appldef/inst/apps/def_erp4/admin/scripts/adapcctl.sh start
script returned:
****************************************************

You are running adapcctl.sh version 120.6.12000000.2

Starting OPMN managed Oracle HTTP Server (OHS) instance ...

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /oracle/def/appldef/inst/apps/def_erp4/logs/appl/admin/log/adapcctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/oracle/def/appldef/inst/apps/def_erp4/admin/scripts/adoacorectl.sh start
script returned:
****************************************************

You are running adoacorectl.sh version 120.11.12000000.2

Starting OPMN managed OACORE OC4J instance  ...

adoacorectl.sh: exiting with status 0

adoacorectl.sh: check the logfile /oracle/def/appldef/inst/apps/def_erp4/logs/appl/admin/log/adoacorectl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/oracle/def/appldef/inst/apps/def_erp4/admin/scripts/adformsctl.sh start
script returned:
****************************************************

You are running adformsctl.sh  version 120.12.12000000.3

Starting OPMN managed FORMS OC4J instance  ...

adformsctl.sh: exiting with status 0

adformsctl.sh: check the logfile /oracle/def/appldef/inst/apps/def_erp4/logs/appl/admin/log/adformsctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/oracle/def/appldef/inst/apps/def_erp4/admin/scripts/adoafmctl.sh start
script returned:
****************************************************

You are running adoafmctl.sh version 120.6.12000000.2

Starting OPMN managed OAFM OC4J instance  ...

adoafmctl.sh: exiting with status 0

adoafmctl.sh: check the logfile /oracle/def/appldef/inst/apps/def_erp4/logs/appl/admin/log/adoafmctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/oracle/def/appldef/inst/apps/def_erp4/admin/scripts/adalnctl.sh start
script returned:
****************************************************

adalnctl.sh version 120.3

Checking for FNDFS executable.
Starting listener process APPS_def.

adalnctl.sh: exiting with status 0


adalnctl.sh: check the logfile /oracle/def/appldef/inst/apps/def_erp4/logs/appl/admin/log/adalnctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/oracle/def/appldef/inst/apps/def_erp4/admin/scripts/adcmctl.sh start
script returned:
****************************************************

You are running adcmctl.sh version 120.14

Starting concurrent manager for def ...
Starting def_0316@def Internal Concurrent Manager
Default printer is noprint

adcmctl.sh: exiting with status 0


adcmctl.sh: check the logfile /oracle/def/appldef/inst/apps/def_erp4/logs/appl/admin/log/adcmctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/oracle/def/appldef/inst/apps/def_erp4/admin/scripts/jtffmctl.sh start
script returned:
****************************************************

You are running jtffmctl.sh version 120.3

Validating Fulfillment patch level via /oracle/def/appldef/apps/apps_st/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for def on port 9301 ...

jtffmctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


All enabled services for this node are started.

adstrtal.sh: Exiting with status 0

adstrtal.sh: check the logfile /oracle/def/appldef/inst/apps/def_erp4/logs/appl/admin/log/adstrtal.log for more information ...

[appldef@erp4 bin]$

oracle ebs password demo Vision Password

Oracle EBS demo Vision Password

Application uat   apps/apps

Operating Unit Username/Password
Vision ADB APPS/APPS
sysadmin/sysadmin
mfg/welcome
operations/welcome
services/welcome
mrc/welcome
hrms/welocme

oracle EBS API, (ON HAND) = (ATR) + (SOFT RESERV) + (pending transaction for the item)

Oracle ERP  standard order 

 Calculation On hand qty


(ON HAND) = (ATR) + (SOFT RESERV) + (pending transaction for the item)

Using this formula ATR is reverse calculated in the form.

Try running the below SQL to see soft and hard reservations.

(SELECT MSI.SEGMENT1,

HARD.STAGED_FLAG,

SUM(HARD.RESERVATION_QUANTITY)RESV_QTY

FROM APPS.MTL_SYSTEM_ITEMS_B MSI,

APPS.MTL_RESERVATIONS HARD

WHERE MSI.ORGANIZATION_ID = :ORG

AND HARD.STAGED_FLAG = 'Y' --HARD RESERVATION

AND MSI.INVENTORY_ITEM_ID = HARD.INVENTORY_ITEM_ID

AND MSI.SEGMENT1 = :ITEM

GROUP BY MSI.SEGMENT1,HARD.STAGED_FLAG)

(SELECT MSI.SEGMENT1,

SOFT.STAGED_FLAG,

SUM(SOFT.RESERVATION_QUANTITY) RESV_QTY

FROM APPS.MTL_RESERVATIONS SOFT,

APPS.MTL_SYSTEM_ITEMS_B MSI

WHERE MSI.ORGANIZATION_ID = :ORG

AND SOFT.STAGED_FLAG IS NULL ---SOFT RESERVATION

AND MSI.INVENTORY_ITEM_ID = SOFT.INVENTORY_ITEM_ID

AND MSI.SEGMENT1 = :ITEM

GROUP BY MSI.SEGMENT1,SOFT.STAGED_FLAG);

Order Management Tables.

Entered

oe_order_headers_all 1 record created in header table

oe_order_lines_all Lines for particular records

oe_price_adjustments When discount gets applied

oe_order_price_attribs If line has price attributes then populated

oe_order_holds_all If any hold applied for order like credit check etc.

Booked

oe_order_headers_all Booked_flag=Y Order booked.

wsh_delivery_details Released_status Ready to release

Pick Released

wsh_delivery_details Released_status=Y Released to Warehouse (Line has been released to Inventory for processing)

wsh_picking_batches After batch is created for pick release.

mtl_reservations This is only soft reservations. No physical movement of stock

Full Transaction

mtl_material_transactions No records in mtl_material_transactions

mtl_txn_request_headers

mtl_txn_request_lines

wsh_delivery_details Released to warehouse.

wsh_new_deliveries if Auto-Create is Yes then data populated.

wsh_delivery_assignments deliveries get assigned

Pick Confirmed

wsh_delivery_details Released_status=Y Hard Reservations. Picked the stock. Physical movement of stock

Ship Confirmed

wsh_delivery_details Released_status=C Y To C:Shipped ;Delivery Note get printed Delivery assigned to trip stopquantity will be decreased from staged

mtl_material_transactions On the ship confirm form, check Ship all box

wsh_new_deliveries If Defer Interface is checked I.e its deferred then OM & inventory not updated. If Defer Interface is not checked.: Shipped

oe_order_lines_all Shipped_quantity get populated.

wsh_delivery_legs 1 leg is called as 1 trip.1 Pickup & drop up stop for each trip.

oe_order_headers_all If all the lines get shipped then only flag N

List of Important Table

Autoinvoice

wsh_delivery_details Released_status=I Need to run workflow background process.

ra_interface_lines_all Data will be populated after wkfw process.

ra_customer_trx_all After running Autoinvoice Master Program for

ra_customer_trx_lines_all specific batch transaction tables get populated

Price Details

qp_list_headers_b To Get Item Price Details.

qp_list_lines

Items On Hand Qty

mtl_onhand_quantities TO check On Hand Qty Items.

Payment Terms

ra_terms Payment terms

AutoMatic Numbering System

ar_system_parametes_all you can chk Automactic Numbering is enabled/disabled.

Customer Information

hz_parties Get Customer information include name,contacts,Address and Phone

hz_party_sites

hz_locations

hz_cust_accounts

hz_cust_account_sites_all

hz_cust_site_uses_all

ra_customers

Document Sequence

fnd_document_sequences Document Sequence Numbers

fnd_doc_sequence_categories

fnd_doc_sequence_assignments

Default rules for Price List

oe_def_attr_def_rules Price List Default Rules

oe_def_attr_condns

ak_object_attributes

End User Details

csi_t_party_details To capture End user Details

Sales Credit Sales Credit Information(How much credit can get)

oe_sales_credits

Attaching Documents

fnd_attached_documents Attched Documents and Text information

fnd_documents_tl

fnd_documents_short_text

Blanket Sales Order

oe_blanket_headers_all Blanket Sales Order Information.

oe_blanket_lines_all

Processing Constraints

oe_pc_assignments Sales order Shipment schedule Processing Constratins

oe_pc_exclusions

Sales Order Holds

oe_hold_definitions Order Hold and Managing Details.

oe_hold_authorizations

oe_hold_sources_all

oe_order_holds_all

Hold Relaese

oe_hold_releases_all Hold released Sales Order.

Credit Chk Details

oe_credit_check_rules To get the Credit Check Againt Customer.

Cancel Orders

oe_order_lines_all Cancel Order Details.

API

create or replace function

gobo_get_available(in_item_id in number,in_from_org_id in number) return number as

--傳入item_id與org_id,返回可用庫存

avai_qty number;

begin

select nvl(sum(nvl(moq.transaction_quantity,0)),0)

-nvl(sum(nvl(mr.reservation_quantity,0)),0) into avai_qty

from mtl_onhand_quantities moq,

mtl_reservations mr,

mtl_item_revisions mir,

mtl_secondary_inventories ms

where moq.inventory_item_id=nvl(in_item_id,-1)

and moq.organization_id=nvl(in_from_org_id,-1)

and mr.staged_flag is null

and mr.organization_id=moq.organization_id

and mr.inventory_item_id=moq.inventory_item_id

and ms.organization_id(+)=moq.organization_id

and ms.secondary_inventory_name(+)=moq.subinventory_code

and ms.reservable_type(+) = 1

and nvl(mr.revision,'-1')=mir.revision(+)

and mir.inventory_item_id(+)=mr.inventory_item_id

and mir.organization_id(+)=mr.organization_id

and sysdate <= nvl(mir.ecn_initiation_date(+),sysdate)

and sysdate >= nvl(mir.implementation_date(+),sysdate);

if avai_qty is null then

avai_qty:=0;

end if;

return avai_qty;

end;

/---------------------------------

SELECT SUM(moq.transaction_quantity)

INTO p_onhand_qty

FROM mtl_onhand_quantities moq

WHERE moq.organization_id = p_inv_org_id

AND moq.subinventory_code = p_subinv

AND nvl(moq.locator_id, -1) = nvl(p_locator_id, -1)

AND moq.inventory_item_id = p_item_id

AND moq.lot_number = p_lot_number;

SELECT SUM(mr.primary_reservation_quantity)

INTO p_res_qty

FROM mtl_reservations mr

WHERE mr.organization_id = p_inv_org_id

AND mr.subinventory_code = p_subinv

AND mr.supply_source_type_id = 13

AND nvl(mr.locator_id, -1) = nvl(p_locator_id, -1)

AND mr.inventory_item_id = p_item_id

AND mr.lot_number = p_lot_number;

RETURN nvl(p_onhand_qty, 0) - nvl(p_res_qty, 0);