Posts from the ‘EBS’ Category

Upgrade oracle ebs 12.1.3 to 12.2.0

Here I have demonstrated how to upgrade your current EBS version 12.1.3 to 12.2.0.  I will write next part how to upgrade from 12.2.0 to 12.2.6

Step by step document for upgrade database to 12.1.0.2 (Its required also, so download this document)

Click to access 12c-upgrade-overview-of-oracle-applications-121.pdf

Step by Step document for update ebs version 12.1.3 to 12.2.0

upgrade-oracle-ebs-12-1-3-to-12-2

Please be note :

1. As per below document, We need to reconfigure rapid install, the steps on finishing upgrade

section 11:

https://docs.oracle.com/cd/E26401_01/doc.122/e73540/T660854T660862.htm

2. Don’t start the service, you can continue to proceed next step of Enable online patching

Issue When Trying To Generate The Custom WSDL ServiceGenerationError: Error In Service GenerationJ2T-120, ERROR: Illegal Option “-plsqlname=object

Please follow the note id

Issue When Trying To Generate The Custom WSDL ServiceGenerationError: Error In Service GenerationJ2T-120, ERROR: Illegal Option “-plsqlname=object (Doc ID 1619940.1)

Generate WSDL Command Errors With Inserted value too large for column (Doc ID 1913216.1)

Note : please check translator.jar file permission ,If It doesn’t have group permission , please

chmod g+w translator.jar

EBS 12.2.5 Release Update Pack Available

EBS 12.2.5 Release Update Pack Available (Patch 1967645

ref link EBS 12.2.5

Service Provider Access resulted in exception ‘oracle.apps.fnd.soa.util.SOAException: SystemError: Error while sending message to server. http://host.domain:8065/webservices/SOAProvider/EbizAuth?Generate= 3527

I have cloned our production environment (EBS version 12.1.3, DB 11.2.0.2) and then I have upgraded the database from 11.2.0.2 to 12.1.0.2.

and later We have requirement to enable integrate SOA gateway. So We were applied all the applicable patches at Production environment and enabled SOA also. So I thinking I have to enable asadmin and then I can able to generate wsdl through SOA. But When I tried , I am getting below error

“Service Provider Access resulted in exception ‘oracle.apps.fnd.soa.util.SOAException: SystemError: Error while sending message to server. http://xxxxxxx:8065/webservices/SOAProvider/EbizAuth?Generate=3527&soa_ticket=..’ when attempting to perform ‘GENERATE’. Please view Service Provider logs for more details”

and

http://xxxxxxxx:8065/webservices/SOAProvider/?testquery also return http 404 error.

Usually If we will get the above error If asadmin inactive or apps schema role are not defined for asadmin, So change the asadmin password and then we added the asadmin password in $ORA_CONFIG_HOME/10.1.3/j2ee/oafm/config/system-jazn-data.xml and then restarted service, It will work.

But My case I did all the steps but Still I am getting error.

Solution :

When i upgraded the database 12c R2,  I was missed to add the below parameter in sqlnet.ora and sqlnet_ifile.ora file.

If sec_case_sensitive_logon to False

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

If sec_case_sensitive_logon to True

SQLNET.ALLOWED_LOGON_VERSION_SERVER=10

After I have added the parameter in both files and restarted the application and database.

Its working fine

How to assign user management responsibility to user

1. Log in as sysadmin
2. Go to User management responsibility
3. In users tab –> username –> Select your username
4. Assign role –> Security Administrator
5. Apply

APP-RG-09518 : An error occurred while creating a database link

When creating a database link in General Ledger FSG Transfer Program to copy FSGs from one instance to another the following error may be encountered:

APP-RG-09518 : An error occurred while creating a database link

Create a dblink like below

GL –> setup–> database links

Database name : SID

Description : null

connect string : (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ipaddress)(PORT=1586))(CONNECT_DATA=(service_name=xxxxxxx)(instance_name=xxxxxx)))

domain name : aceins.com  (Ensure that there is no dash (-) in the domain name and the domain is not blank)

apps : apps username

apps : apps password

Still issues, please see the note

Support note : FSG: Transfer Program APP-RG-09518 : An Error Occurred While Creating A Database Link (Doc ID 1124483.1)

oracle applications r12 auto start on linux

Step 1: connect as a database os user

su – oradev

startDB.sh edit and saved

#!/bin/sh
. /u01/EBSDEV/db/tech_st/11.2.0/EBSDEV_ebsdev.env
/u01/EBSDEV/db/tech_st/11.2.0/appsutil/scripts/EBSDEV_ebsdev/addbctl.sh start
/u01/EBSDEV/db/tech_st/11.2.0/appsutil/scripts/EBSDEV_ebsdev/addlnctl.sh start EBSDEV

stopDB.sh edit and saved

#!/bin/sh
. /u01/EBSDEV/db/tech_st/11.2.0/EBSDEV_ebsdev.env
/u01/EBSDEV/db/tech_st/11.2.0/appsutil/scripts/EBSDEV_ebsdev/addbctl.sh stop
/u01/EBSDEV/db/tech_st/11.2.0/appsutil/scripts/EBSDEV_ebsdev/addlnctl.sh stop EBSDEV

give execute permission chmod 750 for both file

Step 2: connect as applmgr os user

startAPP.sh edit and saved

#!/bin/sh
. /u01/EBSDEV/apps/apps_st/appl/APPSEBSDEV_ebsdev.env
$ADMIN_SCRIPTS_HOME/adstrtal.sh apps/apps

stopAPP.sh edit and saved

#!/bin/sh
. /u01/EBSDEV/apps/apps_st/appl/APPSEBSDEV_ebsdev.env
$ADMIN_SCRIPTS_HOME/adstpall.sh apps/apps

give execute permission chmod 750 for both file

Step 3: as root, please create file and

/etc/init.d/startEBSDEV

#!/bin/sh
#
# /etc/init.d/R12_EBSDEV
#

### BEGIN INIT INFO
# Provides: Oracle Applications
# Required-Start: $syslog $network $xvfbserver
# Required-Stop:
# Default-Start: 3 5
# Default-Stop: 0 1 2 6
# Description: Start the Oracle Applications server
### END INIT INFO

case “$1” in
start)
su oradev -c “/u01/EBSDEV/scripts_oracle/startDB.sh”
su appldev -c “/u01/EBSDEV/scripts_apps/startAPP.sh”
#rc_status -v
;;
stop)
su appldev -c “/u01/EBSDEV/scripts_apps/stopAPP.sh”
su oradev -c “/u01/EBSDEV/scripts_oracle/stopDB.sh”
#rc_status -v
;;

*)
echo “Usage: $0 {start|stop}”
exit 1
;;
esac

Step 4:

chmod 750 /etc/init.d/startEBSDEV

chkconfig –add /etc/init.d/startEBSDEV

Reference Link

How to get the list of users assigned with responsibilities as per Operating Unit

Query :

SELECT hou.NAME,fpov.profile_option_value org_id,frv.responsibility_name, d.full_name,a.USER_NAME, b.START_DATE,b.end_date
FROM apps.hr_organization_units hou,
apps.fnd_profile_options_vl fpo,
apps.fnd_profile_option_values fpov,
apps.fnd_responsibility_vl frv,apps.FND_USER a,apps.FND_USER_RESP_GROUPS_all b,apps. per_all_people_f d,apps.FND_RESPONSIBILITY_TL res
WHERE
fpov.level_value = frv.responsibility_id and b.responsibility_id = res.responsibility_id
and a.USER_ID=b.USER_ID and b.RESPONSIBILITY_ID=frv.RESPONSIBILITY_ID and a.employee_id=d.person_id
AND fpo.profile_option_id = fpov.profile_option_id
AND fpo.user_profile_option_name = ‘MO: Operating Unit’
AND fpov.profile_option_id = fpo.profile_option_id and res.language = ‘US’
AND hou.organization_id = TO_NUMBER (fpov.profile_option_value)
and sysdate between d.effective_start_date and d.effective_end_Date
and sysdate between nvl(a.start_date,sysdate) and nvl(a.end_date,sysdate) and sysdate between nvl(frv.start_date,sysdate) and nvl(frv.end_date,sysdate)
group by a.USER_NAME,frv.responsibility_name, fpov.profile_option_value , hou.NAME,d.full_name,b.START_DATE,b.end_date
ORDER BY frv.responsibility_name

Why users or sysadmin login is taking time

If users or sysadmin user trying to login in r12, Its taking time for login process. The problem most probably its is something to do with profile option. Please make sure the debug and diagnostics is not enable at the user level for sysadmin user or users.

and  please look this note also

How to Purge WFERROR (System: Error) Workflow Items? (Doc ID 804622.1)

ora-20011-Approximate ndv failed : ora-00600

When you’re run adstats.sql script on database, you should get this error if not set the ORA_NLS10 path in environment. So please set the path and restart the database

ORA_NLS10=/u01/app/oracle/db/tech_st/12c/nls/data/9idata; export ORA_NLS10