Upgrade 12.0.0 to 12.0.4

Hi Friends,

I install 12.0.0 in HPUX-PA-RISC(64-bit). I was doing cloning without following cloning doc and prerequisites(406982.1) and failed to do so.AS per cloning doc I planned to upgrade (RUP2)12.0.2 but finally I decided directly upgrade to 12.0.4 .Refer note (402308.1) and metalink note
(465776.1)
Below are the steps I follow in upgrade.

1> Take cold backup of the application as well as database . After completion start the application and database
2> Download patch RUP4(6435000).
3> Also download one prerequisite patch for this.R12.AD.A.DELTA.4(6510214).
4> Put your application in Maintenanace mode using 'adadmin' utility.
5> Note down your release_name from fnd_product_groups and patch_evel for AD from fnd_product_installations.
5> Install prerequisite patch of RUP4 i.e.R12.AD.A.DELTA.4(6510214) using adpatch . Dont merge this patch with RUP4.
6> Verify ad_bugs and fnd_product_installations table that this patch has applied successfuly.
7> Compile apps scehma using adadmin.
8> Now start applying 6435000 patch using adpatch . I did not specify any option becuase this is a major upgrade .Let patch decide what to do.
9> After fininshing the copy portion , This patch will run more than 18000 jobs . Will take more than 14 hrs without fail.
10>After completion of these jobs this patch drops the fnd_install_processes and ad_deferred_jobs and creates again fnd_install_processes and ad_deffered_jobs to run 250 and 900 jobs for compile pl/sql and compile forms.
11>During this patch the time consuming task is gather stats and adutlrcmp.sql for compiling objects.(took more than 5 hours ).
After completion of this patch verify the log files.. and check ad_bugs and fnd_product_groups table.

Major issues I faced
1> when patch starts compiling invalid objects taking more than 2.5 hrs and hang on library cache locks. I was trying to skip the worker but on backendside script is still running. And I am not able to kill this sql properly because this script already ran 2.5 hrs.Then I planned to abort my adpatch session.I killed my adpatch session.Dont worry guys this will not harm anything.Then I find this compilation script and write exit; in the first line. worker will read this file from the first line and exit this file and start execution next steps.YOu can compile manually after completion of this patch.

2>Second script is gather stats took time ,the procedure I followed , choose 6th option from adctrl and status goes to failed for this worker then I edit the gather stat sql with exit; in the first line and restart the worker.It will automatically exit the script and move on.
you can find above scripts in $AD_TOP/patch/sql

3> I also faced below error frequently

/d04/apoc/apps/tech_st/10.1.3/appsutil/jdk/jre/bin/java ...Exception in thread "main" java.sql.SQLException: Io exception: Socket read timed outat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:439)at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)at java.sql.DriverManager.getConnection(DriverManager.java:525)at java.sql.DriverManager.getConnection(DriverManager.java:171)

Then I shutdown my other R12 instance running on same server will resolve my issue and I restarted my patch.

Note:

1>If you killed your adpatch seesion. then try using previous session to start.
2>If you are planning to apply this from the scratch then drop fnd_install_processes and ad_deferred_jobs table but use adpatch options=nocopyportion and edit your compilation script and gather stat scripts with exit; in the first line.(nocopyportion is used because you save your more than 1.5 hrs becaue copying is already done in the previous session and no need to choose start previous session.)
3>After successfully completion of this patch my apache is not coming up. Then I applied patch (6616965). This problem occurs only in HPUX platform

If you have any questions please write me....

Cloning concepts for R12 will come in next post.....

Thanks

--Guru

Function is not available for this responsibility

Hi Friends,
I was getting one problem after creating the custome top,generating custom forms and custom reports.Everything I have checked like Menus,functions,submenus,resgister custom top in system Adminstrator responsibility.But still I am getting some error while clcking the menu or submenu in custom responsibility.Error message is "Function is not available for this responsibility.Contact your system Administrator or change the responsibility"

Solution:
Put entry of the custom top in the default.env file under $INST_TOP/ora/10.1.2/forms/server.
eg:XXXX_TOP=$APPL_TOP/xxxx/12.0.0 (better write full path of $APPL_TOP insted of writing $APPL_TOP)

If still the same error comes then bounce the application.

To create Cusotm Top refer below link
http://oracleapplicationguru.blogspot.com/2008/03/how-to-create-custom-top-in-r12.html

Leave your commnets if this article solve your problem.
Regards
--Guru

How to create Custom Top in R12

Hi Readers,

Following are the common steps to create custom Top.
Step 1> Create the directory structure.
$ cd $APPL_TOP
$ mkdir xxxx
$ cd xxxx
$ mkdir 12.0.0
$ cd 12.0.0
$ mkdir admin
$ mkdir bin
$ mkdir froms
$ mkdir patch
$ mkdir reports
$ cd admin
$ mkdir sql
$ cd forms
$ mkdir US (for custom forms)
$ cd patch
$ mkdir 115
$ cd 115
$ mkdir import (for ldt files)
$ cd ..
$ cd reports
$ mkdir US (for your custom reports)

Step2>
Now create a tablespace and schema for custom top (xxxx)
sql>create tablespace xxxx datafile 'xxxx1.dbf' size 1000m;
sql>create user xxxx identified by xxxx default tablespace xxxx1.dbf;

Step 3>
Register and add datagroup of custom user and custom Application with Oracle application using system admin responsibility.
Security-->Oracle-->Register (register xxxx user)
Security-->Oracle-->DataGroup (add custom application under datagroup)
Application-->Register (register custom application)

Step 4>
Now add the custom top in environment file under $APPL_TOP.
set XXXX_TOP=$APPL_TOP/xxxx/12.0.0export XXXX_TOP

Step 5>
Open another session and login again using 'applmgr' and verify $ XXXX_TOP is working or not.

Now your custom top has created. Now functional and technical team will create custom reports(rdf's) and custom forms(fmb,fmx) and place into the custom Top directories respectively. After that they will create functions,menus,resposibilites,make executables etc. Till this point your custom top ,responsibility,forms,functions,executables,functions has done .Now the time to open custom responsibility and check whether everything working right.

Leave your commnets if this article helpful to you.
Regards
--Guru

Compile forms in R12

Hi friends,
You can use below syntax to compile a form in R12.
$>frmcmp_batch FORM_name.fmb userid=APPS/APPS output_file=/d02/oracle/VIS12/apps/apps_st/appl/XXXXX/12.0.0/forms/US/FORM_name.fmx module_type=form compile_all=special

OR you can refer my other article
http://oracleapplicationguru.blogspot.com/2008/02/frm-91500-unable-to-startcomplete-build.html

Regards
--Guru

Remote Diagnostinc Agent(RDA) Patch for 12.0.3

What is RDA?
Remote Diagnostic Agent (RDA) is a set of command-line diagnostic scripts that are executed by an engine written in the Perl programming language.RDA gather detailed information about an Oracle environment. Output of this RDA scripts is useful to see the whole system configuration.

Why use RDA?
Oracle strongly encourages the use of Remote Diagnostic Agent (RDA) diagnostics collectionsbecause it provides a comprehensive picture of the Oracle Apps environment. Providing RDA diagnostic output is really helpful when you log a TAR. The output of this RDA script isminimize the problem resolution .RDA collections are essential for the following types of tars:
· Performance issues
· Installation/configuration issues
· ORA-600, ORA-7445, and ORA-3113 errors
· Upgrade, migration, and linking issues
· Database and Development API issues
· Forms and reports issues
· Development / Discoverer Server issues
· Oracle Application Server / Fusion Middleware issues
· Other corrective issues

To get all this we need to apply below patches in the environment

1>R12.IZU.A.DELTA.3 PAtch no. 6265820( main patch) following is the prerequiste.
2>IZU Splice Preparation Tasks for R12.IZU Splice Preparation Tasks before upgrading to R12.IZU.A.Delta.3 .Patch no 6280873.

Above both patch need to apply in 12.0.3 to run the RDA. Please read the readme.txt before applying any patch
Refer MEtalink id's 167000.1, 314422.1

Leave your coments if this article is helpful for you.

Reagrds

--Guru

After cloning Application is not opening in 11.5.8

Hi Readers,

I just faced one error after cloning of 4node architecture.

Node A-DB tier, Node B-Conc/admin,
Node C-Secondary form,Node D-Primary

I have done everything correctly what I used to do for cloning. But my application is not opening i.e URL ....NodeD:8000 and getting the below error on Primary NodeD after running adstrtal.sh ,other components are running fine except Apache.

adapcctl.sh version 115.43
Starting Apache Web Server Listener (dedicated HTTP) ...
adapcctl.sh: exiting with status 3

How I resolved the issue...........................

I just modified the xml file under $APPL_TOP/admin of Node D(primary) and changed 'http1312' to 'ias102'

before modify:
config_option type="techstack" oa_var="s_techstack">http1312

after modify:
config_option type="techstack" oa_var="s_techstack">ias1022

Note: You can also verify the xml file of Node C.The entry for s_techstack should be same as 'ias1022'

Finally run adautocfg.sh under $COMMON_TOP/admin/scripts/ and bounce the application.
If article is useful dont forget to write the comments
Regards
--Guru

General Categories in an ERP

Just to enhance the knowledge of APPS DBA
FINANCE
1.General Ledger
2.Accounts Payable (A/P)
3.Accounts Receivable (A/R)
4.Fixed Assets
5.Cost Accounting
6.Cash Management
7.Budgeting
8.Financial Reporting
9.Project Accounting
QUALITY MANAGEMENT
1.Customer return file
2.Damaged material
3.Inspection required
4.Automated inspection criteria
5.Inspection disposition with audit trail
6.Quantity rejected
7.Reject reason codes
8.Defective or excess material return processing
MANUFACTURING MANAGEMENT
1.Product Costing
2.Production Planning
3.Formulas/Recipes
4.Process Model
5.Material Management
INVENTORY MANAGEMENT
1.Inventory Management
2.Processing Requirements
3.Data Requirements
4.Locations and Lot Control
5.Forecasting
6.Reservations and Allocations
7.Inventory Adjustments
PURCHASING MANAGEMENT
1.Vendor and Supplier Profile
2.Supplier Rating and Profile
3.Requisitions and Quotations
4.Purchase Orders
5.Prices and Discounts
6.Vendor Contracts and Agreements
7.Purchase Order Management
SALES MANAGEMENT
1.Pricing and Discounting
2.Customer Service and Returned Goods Handling
3.Customer Relationship Management (CRM) and E-commerce Requirements
HUMAN RESOURCE MANAGEMENT
1.Personnel Management
2.Benefits
3.Payroll
4.Employee Self-Service
5.Health and Safety

Please leave your comments after reading any article.
Regards
--Guru

Change logo in 11.5.10.2

When you open Oracle Application,your first step would be to open the URL hostname.domainname:port . You will get the first screen .When this url opens below files will come into picture.
1>apptitle.html
2>applist.html
3>appdet.html
4>appsmed3.gif
Location of these files are:cd $COMMON_TOP/portal/(context_name)
You see the Oracle Application logo on the left hand side on this screen. How to change this logo and if you place your mouse pointer on this logo you will see [Oracle Application]. When you click on this loge, will take you to oracle.com How to change this logo and the respective links.
To do this we need to modify only two files appsmed3.gif and apptitle.html
Step 1> Replace appsmed3.gif with your logo
Step 2> Modify the following italic lines in apptitle.html href="xyz.oracle.com/applications/index.html"
target=_top.........appsmed3.gif" xyz...."[Oracle Applications]"
Dont'confuse xyz etc.... this site is not allowing me to write any html syntax
Step3>Bounce the apache and clear the cache and see the diffrence.

Reagrds
--Guru

xhost: unable to open display in HPUX

Hi folks,
Some times you will not be able to set the display using below commands in HPUX
export DISPLAY=ipaddress:0.0 'or'
export DISPLAY=ipaddress 'or'
export DISPLAY=ipaddress:0 'or'
export DISPLAY=hostname:0.0
and
xhost +
xhost +hostname etc.

Simply run below command in a single line to run xhost + successfully
nohup /usr/bin/X11/Xvfb :0 -screen 2 1024x800x8 -pn -fp /usr/lib/X11/fonts/misc -sp /etc/X11/SecurityPolicy & export DISPLAY=$(hostname):0.0

Thanks
--Guru

Multi Node to Single Node in 11i

Multi Node to Single node in 11i
Apps-11.5.10.2 DB-9.2.0.6
Architecture- NODE A- Apps(Conc/Rep/admin),DB
NODE B- Apps(forms/web)
Purpose: Convert NODE A + NODE B = NODE A (multi node to single node)
Few easy steps to achieve this using "appsTier merge" and "appltop merge"
Prerequisties- Application tier patches- 4038964 and 4175764 AND AD Minipack AD.I.2 or more(would suggest apply latest one i.e AD.I.delta.6 (6502082)) . Better apply on both apps node with below syntax of adpatch
adpatch options=nocopyportion,nodatabaseportion,nogenerateportion,hotpatch
verify above patches and patch_level from table ad_bugs and fnd_products_installations .
Step 1> Login to NODE A as applmgr, run adadmin for maintain snapshot information.APPS & DB should be up & running till end.
Step 2> Now run adpreclone using merge option $COMMON_TOP/admin/scripts/
perl adpreclone.pl appsTier merge
This command will run adgenhfver.pl from $AD_TOP/bin
Note: At this point you may get error like "Could not create the high water mark manifest....."
update AD patch set level AD.I.2 to higher(eg: AD.I.delta.6)
Then, Re-Run snapshot and again run 'perl adpreclone.pl appsTier merge'
Let it complete, This script will take time to complete and run below sqls.
--adgenhfver.pl from $AD_TOP/bin
--$AD_TOP/patch/115/sql/admsnlst.sql (PL/SQL script to create manifest file used for merging APPL_TOPs)this script also create hfilever_appl_top.txt in appl-top/admin/out directory
--at last adclone.pl will run
Step 3> Login to NODE B as applmgr, run adadmin for maintain snapshot information.APPS & DB should be up & running till end.
Step 4> Now we will merge APPL_TOP using perl adpreclone.pl appltop merge
Let it run ...same sqls will run as in Step 2. But this script create 'appl' folder in "$COMMON_TOP/clone"
Step 5> Shutdown the APPS TIER on NODE A and NODE B using adstpall.sh
Step 6> Copy 'appl' folder recursively from NODE B to NODE A '$COMMON_TOP/clone/'
Step 7> Final step is to run adcfgclone.pl on NODE A.
perl adcfgclone.pl appsTier and pass the parameters as per NODE A respectively.

Thanks
--Guru