Oracle Technical Information

Wednesday, 24 February 2016

Creating a Custom Application in Oracle E-Business Suite Release 12.2 (adsplice)

-Creating a Custom Application in Oracle E-Business Suite Release 12.2 (Doc ID 1577707.1)

This note describes the basic steps needed to create a custom application in Oracle E-Business Suite Release 12.2.

Create the schema in the database. I am creating a schema called 'tgc' and I use the same schema for all the custom application.

CREATE USER TGC IDENTIFIED BY tgc

DEFAULT TABLESPACE APPS_TS_TX_DATA

TEMPORARY TABLESPACE TEMP1

PROFILE DEFAULT

ACCOUNT UNLOCK;

GRANT CONNECT, RESOURCE TO TGC;

GRANT CREATE ANY CONTEXT TO TGC;

GRANT CREATE ANY TYPE TO TGC;

GRANT CREATE CLUSTER TO TGC;

GRANT CREATE DATABASE LINK TO TGC;

GRANT CREATE DIMENSION TO TGC;

GRANT CREATE INDEXTYPE TO TGC;

GRANT CREATE LIBRARY TO TGC;

GRANT CREATE MATERIALIZED VIEW TO TGC;

GRANT CREATE OPERATOR TO TGC;

GRANT CREATE PROCEDURE TO TGC;

GRANT CREATE PUBLIC SYNONYM TO TGC;

GRANT CREATE SEQUENCE TO TGC;

GRANT CREATE SYNONYM TO TGC;

GRANT CREATE TABLE TO TGC;

GRANT CREATE TRIGGER TO TGC;

GRANT CREATE TYPE TO TGC;

GRANT CREATE VIEW TO TGC;

Section 1: Create A Custom Application Using adsplice

a. download Patch 3636980 "Support Diagnostics (IZU) patch for AD Splice" from My Oracle Support.

b. Manually copy the three .txt files from the 3636980\izu\admin directory to your own temporary directory.

c. Rename izuprod.txt to <CUSTOM MODULE>prod.txt. In this example, we will be using "tgcprod.txt".

d. Rename izterr.txt to <CUSTOM MODULE>terr.txt. In this example, we will be using "tgcterr.txt".

e. Open newprods.txt in a text editor.

i) Change all references of "izu" to <custom module> and all references of "IZU" to <CUSTOM MODULE> (i.e. keep the case sensitivity).

In this example, we will be changing references of "izu" to be "tgc" and "IZU" to be "TGC".

In my example, I will change 'izu' to 'tgc' and 'IZU' to 'TGC'.

%%% Splicer control file format 12.0.A

# $Header: newprods.txt 120.1 2006/09/20 12:57:45 jaobrien noship $

# Section for Oracle Support Diagnostic Tools

product=tgc

base_product_top=*APPL_TOP*

oracle_schema=tgc

sizing_factor=100

main_tspace=APPS_TS_TX_DATA

index_tspace=APPS_TS_TX_IDX

temp_tspace=TEMP1

default_tspace=APPS_TS_TX_DATA

# end of Oracle Support Diagnostic Tools

ii) Change all references to prodid 278 to your own unique number.

It is recommended you pick a number above 50,000 that is not already in use. You can run the following SQL to find out if your selected custom application ID number is available:

SQL>select decode(count ,0, 'Selected number is Available', 'Selected number already in use') Status, &&enter_custom_applID selected_number
from
(
select count(*) as count from
(
select 'x' from fnd_oracle_userid
where oracle_id= &&enter_custom_applID
union
select 'x' from fnd_application
where application_id= &&enter_custom_applID
)
);

In this example, we will use a prodid of 500001.

g) Open tgcterr.txt in a text editor.

i) Change all references of "izu" to <custom module> and all references of "IZU" to <CUSTOM MODULE> (keeping the case sensitivity)

In this example, we will be changing references of "izu" to be "tgc" and "IZU" to be "TGC".

ii) Change the text "Oracle_Support_Diagnostic_Tools" to be "tgc_custom_app".

h. Copy the following text files to the $APPL_TOP/admin directory
tgcprod.txt
tgcterr.txt
newprods.txt

i. Change directory to the admin directory under $APPL_TOP

j. Run adsplice

adsplice must be run from the admin directory under APPL_TOP, and is invoked by running the adsplice command.

Note: In Oracle E-Business Suite Release 12.2, AD Splice first makes the new user edition-enabled, then enables Edition-Based Redefinition (EBR) for the custom objects.

[oracle@rp admin]$ adsplice

Redwood Shores, California, USA

AD Splicer

Version 12.2.0

NOTE: You may not use this utility for custom development

unless you have written permission from Oracle Corporation.

Your default directory is '/u01/oracle/TEST/fs1/EBSapps/appl'.

Is this the correct APPL_TOP [Yes] ?

AD Splicer records your AD Splicer session in a text file

you specify. Enter your AD Splicer log file name or press [Return]

to accept the default file name shown in brackets.

Filename [adsplice.log] : 11022015.log

************* Start of AD Splicer session *************

AD Splicer version: 12.2.0

AD Splicer started at: Wed Feb 11 2015 17:54:19

APPL_TOP is set to /u01/oracle/TEST/fs1/EBSapps/appl

Change DB = YES.

Please enter the name of the Oracle E-Business Suite System that this

APPL_TOP belongs to.

The Applications System name must be unique across all Oracle

Applications Systems at your site, must be from 1 to 30 characters

long, may only contain alphanumeric and underscore characters,

and must start with a letter.

Sample Applications System names are: "prod", "test", "demo" and

"Development_2".

Applications System Name [TEST] : TEST *

NOTE: If you do not currently have certain types of files installed

in this APPL_TOP, you may not be able to perform certain tasks.

Example 1: If you don't have files used for installing or upgrading

the database installed in this area, you cannot install or upgrade

the database from this APPL_TOP.

Example 2: If you don't have forms files installed in this area, you cannot

generate them or run them from this APPL_TOP.

Example 3: If you don't have concurrent program files installed in this area,

you cannot relink concurrent programs or generate reports from this APPL_TOP.

Do you currently have or want to install files used for installing or upgrading

the database in this APPL_TOP [YES] ? YES *

Do you currently have or want to install Java and HTML files for HTML-based

functionality in this APPL_TOP [YES] ? YES *

Do you currently have or want to install Oracle E-Business Suite forms files

in this APPL_TOP [YES] ? YES *

Do you currently have or want to install concurrent program files

in this APPL_TOP [YES] ? YES *

Please enter the name Oracle E-Business Suite will use to identify this APPL_TOP.

The APPL_TOP name you select must be unique within an Oracle E-Business Suite

System, must be from 1 to 30 characters long, may only contain

alphanumeric and underscore characters, and must start with a letter.

Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".

APPL_TOP Name [rp] : rp *

You are about to install or upgrade Oracle E-Business Suite product tables

in your ORACLE database 'TEST'

using ORACLE executables in '/u01/oracle/TEST/fs1/EBSapps/10.1.2'.

Is this the correct database [Yes] ?

AD Splicer needs the password for your 'SYSTEM' ORACLE schema

in order to determine your installation configuration.

Enter the password for your 'SYSTEM' ORACLE schema:

The ORACLE username specified below for Application Object Library

uniquely identifies your existing product group: APPLSYS

Enter the ORACLE password of Application Object Library [APPS] :

AD Splicer is verifying your username/password.

The status of various features in this run of AD Splicer is:

<-Feature version in->

Feature Active? APPLTOP Data model Flags

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

CHECKFILE Yes 1 1 Y N N Y N Y

PREREQ Yes 6 6 Y N N Y N Y

CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N

PATCH_TIMING Yes 2 2 Y N N Y N Y

PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y

SCHEMA_SWAP Yes 1 1 Y N N Y Y Y

JAVA_WORKER Yes 1 1 Y N N Y N Y

CODELEVEL Yes 1 1 Y N N Y N Y

Reading product information from file...

Reading language and territory information from file...

Reading language information from applUS.txt ...

Reading database to see what industry is currently installed.

Reading FND_LANGUAGES to see what is currently installed.

Currently, the following language is installed:

Code Language Status

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

US American English Base

Your base language will be AMERICAN.

Setting up module information.

Reading database for information about the modules.

Saving module information.

Reading database for information about the products.

Reading database for information about how products depend on each other.

Reading topfile.txt ...

Saving product information.

*** Edition Enabled User ***

Please enter the directory where your AD Splicer control file is located.

The default directory is [/u01/oracle/TEST/fs1/EBSapps/appl/admin] :

Please enter the name of your AD Splicer control file [newprods.txt] :

Processing file /u01/oracle/TEST/fs1/EBSapps/appl/admin/newprods.txt...

Loading information for product 'tgc'...

Warning: Because the database is in new tablespace mode, AD Splicer is ignoring the tablespace settings in your control file!

Successfully read file /u01/oracle/TEST/fs1/EBSapps/appl/admin/newprods.txt.

Verifying localizations...

Validating inter-product dependency information...

Re-organizing product information lists...

Adding new languages into FND_LANGUAGES...

Creating ORACLE usernames for products...

AD Splicer is creating or updating the ORACLE username TGC

with password ***** for tgc custom app tables.

Granting privileges for tablespaces...

Granting required system privileges and creating APPS*DDL packages...

sqlplus -s TGC/***** @/u01/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaddls.pls ***** TGC *****'

Done running adaddls.pls for TGC

sqlplus -s TGC/***** @/u01/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaaddls.pls ***** TGC *****'

Done running adaaddls.pls for TGC

sqlplus -s TGC/***** @/u01/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaddlb.pls ***** TGC *****'

Done running adaddlb.pls for TGC

sqlplus -s TGC/***** @/u01/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaaddlb.pls ***** TGC *****'

Done running adaaddlb.pls for TGC

Registering ORACLE usernames/passwords.

**Inserting application information for new products...

**** Running Seed Table Prepare for FND_APPLICATION ****

**** Running Seed Table Prepare for FND_APPLICATION_TL ****

INSERT INTO FND_OAM_CONTEXT_CUSTOM (OA_VAR,CTX_TYPE,OA_TYPE,NAME,DEFAULT_VALUE,TITLE,DESCRIPTION) VALUES ('c_tgc','A','PROD_TOP','c_tgc','/u01/oracle/TEST/fs1/EBSapps/appl/tgc/12.0.0','custom prod top tgc','this is spliced custom prod top') Temporarily resetting CLASSPATH to:

"/u01/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/java/adjava.zip:/u01/oracle/TEST/fs1/EBSapps/comn/util/jdk32/lib/dt.jar:/u01/oracle/TEST/fs1/EBSapps/comn/util/jdk32/lib/tools.jar:/u01/oracle/TEST/fs1/EBSapps/comn/util/jdk32/jre/lib/rt.jar:/u01/oracle/TEST/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/u01/oracle/TEST/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/u01/oracle/TEST/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/oracle/TEST/fs1/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/u01/oracle/TEST/fs1/EBSapps/comn/java/classes:/u01/oracle/TEST/fs1/EBSapps/10.1.2/forms/java:/u01/oracle/TEST/fs1/EBSapps/10.1.2/forms/java/frmall.jar:/u01/oracle/TEST/fs1/EBSapps/10.1.2/jlib/ewt3.jar:/u01/oracle/TEST/fs1/EBSapps/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar"

Calling /u01/oracle/TEST/fs1/EBSapps/comn/util/jdk32/jre/bin/java ...

Running fnd_application_pkg.add_language ...

**Updating product information for new products...

Populating INSTALL_GROUP_NUM column to FND_ORACLE_USERID table.

**Updating product dependency information...

Recording modules in the database...done.

**Updating Data Groups...

Reading existing data groups from database.

Registering any new data groups.

Registering any new data group units.

Updating Data Group "Standard" to point to

APPS #1 Account (ORACLE ID = 900)

Updating Patch Advisor tables to include new product information ..

sqlplus -s APPS/***** @/u01/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/sql/adpaseed.sql *****'

Done.

Saving module actions...done.

Saving product actions...done.

Making product top directory for product "tgc"...

Directory will be /u01/oracle/TEST/fs1/EBSapps/appl/tgc/12.0.0

Making directory "log" for product "tgc"...

Making directory "out" for product "tgc"...

Making directory "mesg" for product "tgc"...

Making directory "sql" for product "tgc"...

Creating stub file "sql/TGCNLINS.sql" for product "tgc"...

Making directory "admin/sql" for product "tgc"...

Creating stub file "admin/sql/TGCNLADD.sql" for product "tgc"...

Making directory "admin/driver" for product "tgc"...

Recording ADSPLICE action for product: tgc

Do you wish to regenerate your environment file [Yes] ?

Checking if AutoConfig is enabled....

Running AutoConfig on : All products ...

The log file is located at:

/u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/log/autoconfig_1.log

Please check the log file for more details about the run of AutoConfig.

If you added new products, use FNDCPASS to change their default passwords.

AD Splicer is complete.

Errors and warnings are listed in the log file

/u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/log/11022015.log

10. Check the adsplice and Autoconfig log file.

and in other log files in the same directory.

[oracle@rp admin]$ vi /u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/log/autoconfig_1.log

[oracle@rp admin]$ vi /u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/log/11022015.log

[oracle@rp admin]$ cd $TGC_TOP

Now you can verify that the Custom Product/ Application is in the database using the following queries:

select * from fnd_application where application_short_name = 'XXONT';
select * from fnd_product_installations where APPLICATION_ID = 50301;
select * from dba_users where username = 'XXONT';

$ env |grep XXONT
XXONT_TOP=/u01/app/oracle/fs1/EBSapps/appl/xxont/12.0.0
$
$ ls $XXONT_TOP
admin log mesg out sql

AD Splicer error "he file has format '%%% Splicer control file format 12.0.A"

If you face below error while running adsplice to create a new custom top.

Processing file /opt/oracle/TEST/fs2/EBSapps/appl/admin/newprods.txt...

AD Splicer error:
Incorrect format of file:

/opt/oracle/TEST/fs2/EBSapps/appl/admin/newprods.txt

'he file has format '%%% Splicer control file format 12.0.A
and this version of AD Splicer requires format '%%% Splicer control file format 12.0.A'

You should check the file
/opt/oracle/TEST/fs2/EBSapps/appl/admin/PROD/log/24022016.log

for errors.

Solution:
Edit the text files newprods.txt, izuprod.txt, izuterr.txt in Linux. Don't edit text files in Windows.

Retest the issue.

Friday, 1 January 2016

Oracle EBS Upload Customers through API in Trading Community Architecture

Oracle EBS Upload Customers through API in Trading Community Architecture:

Create Party
HZ_PARTY_V2PUB.create_organization(p_init_msg_list => FND_API.G_TRUE,
p_organization_rec => v_organization_rec,
x_party_id => v_party_id,
x_party_number => v_party_number,
x_profile_id => v_profile_id,
x_return_status => v_return_status,
x_msg_count => v_msg_count,
x_msg_data => v_msg_data);

HZ_CUST_ACCOUNT_V2PUB.create_cust_account(p_init_msg_list => FND_API.G_FALSE,
p_cust_account_rec => v_cust_account_rec,
p_organization_rec => v_organization_rec,
p_customer_profile_rec => v_customer_profile_rec,
p_create_profile_amt => FND_API.G_FALSE,
x_cust_account_id => v_cust_account_id,
x_account_number => v_account_number,
x_party_id => v_cust_party_id,
x_party_number => v_cust_party_number,
x_profile_id => v_cust_profile_id,
x_return_status => v_return_status,
x_msg_count => v_msg_count,

x_msg_data => v_msg_data);

HZ_LOCATION_V2PUB.create_location(p_location_rec => v_location_rec,
x_location_id => v_location_id,
x_return_status => v_return_status,
x_msg_count => v_msg_count,

x_msg_data => v_msg_data);

HZ_PARTY_SITE_V2PUB.create_party_site(p_party_site_rec => v_party_site_rec,
x_party_site_id => v_party_site_id,
x_party_site_number => v_party_site_number,
x_return_status => v_return_status,
x_msg_count => v_msg_count,
x_msg_data => v_msg_data);


HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_acct_site(p_init_msg_list => FND_API.G_TRUE,
p_cust_acct_site_rec => v_cust_acct_site_rec,
x_cust_acct_site_id => v_cust_acct_site_id,
x_return_status => v_return_status,
x_msg_count => v_msg_count,
x_msg_data => v_msg_data);

  -- create customer account site use
HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use(p_init_msg_list => FND_API.G_TRUE,
p_cust_site_use_rec => v_cust_site_use_rec,
p_customer_profile_rec => v_customer_profile_rec,
p_create_profile => FND_API.G_TRUE,
p_create_profile_amt => FND_API.G_FALSE,
x_site_use_id => v_ship_site_use_id,
x_return_status => v_return_status,
x_msg_count => v_msg_count,
x_msg_data => v_msg_data);

HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use(p_init_msg_list => FND_API.G_TRUE,
p_cust_site_use_rec => v_cust_site_use_rec,
p_customer_profile_rec => v_customer_profile_rec,
p_create_profile => FND_API.G_TRUE,
p_create_profile_amt => FND_API.G_FALSE,
x_site_use_id => v_bill_site_use_id,
x_return_status => v_return_status,
x_msg_count => v_msg_count,
x_msg_data => v_msg_data);

  -- create person
HZ_PARTY_V2PUB.create_person(p_init_msg_list => fnd_api.g_false,
p_person_rec => v_person_rec,
x_party_id => v_person_party_id,
x_party_number => v_person_party_number,
x_profile_id => v_person_profile_id,
x_return_status => v_return_status,
x_msg_count => v_msg_count,
x_msg_data => v_msg_data);

HZ_PARTY_CONTACT_V2PUB.create_org_contact(p_init_msg_list => fnd_api.g_false,
p_org_contact_rec => v_org_contact_rec,
x_org_contact_id => v_org_contact_id,
x_party_rel_id => v_party_rel_id,
x_party_id => v_contact_party_id,
x_party_number => v_contact_party_number,
x_return_status => v_return_status,
x_msg_count => v_msg_count,
x_msg_data => v_msg_data);

HZ_CUST_ACCOUNT_ROLE_V2PUB.create_cust_account_role(p_init_msg_list => FND_API.G_TRUE,
p_cust_account_role_rec => v_cust_account_role_rec,
x_cust_account_role_id => v_cust_account_role_id,
x_return_status => v_return_status,
x_msg_count => v_msg_count,
x_msg_data => v_msg_data);


HZ_CONTACT_POINT_V2PUB.create_contact_point(p_init_msg_list => fnd_api.g_false,
p_contact_point_rec => v_contact_point_rec,
p_edi_rec => v_edi_rec,
p_email_rec => v_email_rec,
p_phone_rec => v_phone_rec,
p_telex_rec => v_telex_rec,
p_web_rec => v_web_rec,
x_contact_point_id => v_contact_point_id,
x_return_status => v_return_status,
x_msg_count => v_msg_count,
x_msg_data => v_msg_data);


IBY_EXT_BANKACCT_PUB.create_ext_bank(p_api_version => 1.0,
p_init_msg_list => fnd_api.g_true,
p_ext_bank_rec => v_ext_bank_rec,
x_response => v_response,
x_bank_id => v_bank_id,
x_return_status => v_return_status,
x_msg_count => v_msg_count,

x_msg_data => v_msg_data);

IBY_EXT_BANKACCT_PUB.check_ext_bank_branch_exist(p_api_version => 1.0,
p_init_msg_list => fnd_api.g_true,
p_bank_id => v_ext_bank_branch_rec.bank_party_id,
p_branch_name => v_ext_bank_branch_rec.branch_name,
p_branch_number => null,
x_response => v_response,
x_branch_id => v_branch_id,
x_end_date => v_end_date,
x_return_status => v_return_status,
x_msg_count => v_msg_count,

x_msg_data => v_msg_data);

IBY_EXT_BANKACCT_PUB.create_ext_bank_branch(p_api_version => 1.0,
p_init_msg_list => fnd_api.g_true,
p_ext_bank_branch_rec => v_ext_bank_branch_rec,
x_response => v_response,
x_branch_id => v_branch_id,
x_return_status => v_return_status,
x_msg_count => v_msg_count,

x_msg_data => v_msg_data);

Oracle EBS, Oracle TCA Upload Cutomer through API

Tuesday, 20 October 2015

adapcctl Exiting with Status: 204

If mistakenly application Services bounced with root user. Then application will not start from oracle user and will throw this error:

adapcctl Exiting with Status: 204

Issue is httpd.pid file ownership changed to root and oracle cannot access it.

To resolve the issue:

stop the application services using adstpall.sh script.

change ownership to oracle ideally the whole folder.

Start the services using adstrtall.sh script.

Tags: adapcctl Exiting with Status: 204

Friday, 18 September 2015

Error connecting to database Ora-10

While viewing concurrent request output if you get the error message:

Error connecting to database <dbname>:Ora-10

set s_gwyuid_user APPLSYSPUB/<password>

RUN autoconfig

Test the issue.

Wednesday, 2 September 2015

Error Applying hrglobal.drv

Error:

*******FATAL ERROR*******
PROGRAM : (/d01/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Fri Aug 28 01:17:24 2015
FUNCTION: TXK::Process::run [ Level 3 ]
MESSAGES:
No create access for <stdout> /d01/oracle/TEST/fs1/inst/apps/TEST_erptest/logs/appl/rgf/df.out

STACK TRACE
at /d01/oracle/TEST/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168
TXK::Error::abort('TXK::Error', 'HASH(0xc0c5c0)') called at /d01/oracle/TEST/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299
TXK::Common::doError('TXK::Process=HASH(0x284ded8)', 'No create access for <stdout> /d01/oracle/TEST/fs1/inst/apps/...', undef) called at /d01/oracle/TEST/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314
TXK::Common::setError('TXK::Process=HASH(0x284ded8)', 'No create access for <stdout> /d01/oracle/TEST/fs1/inst/apps/...') called at /d01/oracle/TEST/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Process.pm line 342
TXK::Process::run('TXK::Process=HASH(0x284ded8)', 'HASH(0x2e06330)') called at /d01/oracle/TEST/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 2651
ADOP::GlobalVars::runDFCommand('/d01/oracle/TEST/fs1/inst/apps/TEST_erptest/logs/appl/rgf/df.out') called at /d01/oracle/TEST/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 2715
ADOP::GlobalVars::checkDiskSpaceOnUnix() called at /d01/oracle/TEST/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 2762
ADOP::GlobalVars::_CheckDiskSpace() called at /d01/oracle/TEST/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 2835
ADOP::GlobalVars::ValidateArgs('ADOP::GlobalVars') called at /d01/oracle/TEST/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/AdopMain.pm line 1463
ADOP::AdopMain::adopMain('ADOP::AdopMain') called at /d01/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 130

[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.

adop exiting with status = 255 (Fail)
[oracle@erptest TEST]$ adopscanlog -latest=yes
Scanning /d01/oracle/TEST/fs_ne/EBSapps/log/adop/adop_20150824_174044.log log file ...

/d01/oracle/TEST/fs_ne/EBSapps/log/adop/adop_20150824_174044.log:
-----------------------------------------------------------------

Lines #(14-18):
Validation successful. All expected nodes are listed in ADOP_VALID_NODES table.
[EVENT] [START 2015/08/24 17:43:29] Performing database sanity checks
[ERROR] The EBS Technology Codelevel Checker (available as Patch 17537119) needs to be run on the following nodes: <erptest>.
[PROCEDURE] [START 2015/08/24 17:43:34] Unlocking sessions table
[STATEMENT] Unlocking ad_adop_sessions table for erptest with wait interval of 60 seconds and number of tries 2

Resolution:
Check ownership of installation location and change it to oracle if required. Make sure all post install scripts are executed for the bug fixes and patches.

Tuesday, 1 September 2015

AD Auto Config (adautocfg) Steps/Procedure

AD Auto Config (adautocfg) Steps/Procedure in Oracle EBS R.12

Attention:

The database server and the database listener must remain available during the AutoConfig run. All the other database tier services should be shut down.
Running AutoConfig may change your existing environment files. After running AutoConfig, you should always set the environment before you run any Applications utilities, in order to apply the changed environment variables.

1) Set Enviornment of Apps Node
2) Stop Apps Node Services only . adstpall.sh
3) Set Enviornment for DB Node
4) run adautoconfig on DB Node
5) Chekc log file stored in: $ORACLE_HOME/appsutil/log/$CONTEXT_NAME
6) run adautoconfig on APPS Node from $COMMON_TOP/admin/scripts/
7) Start Apps Node Services

Tags: How to run adautoconfig, Steps to perform adautoconfig, adautoconfig log files location