Skip to content
Advertisements

Posts from the ‘EBS’ Category

Integrated SOA gateway page loading long time no response

When you try to open ‘Integrated SOA gateway page in EBS and loading  long time with no response”

 

Solution :

Run Gather schema statistics

exec fnd_stats.gather_schema_statistics(‘ALL’);

 

 

Advertisements

How to test REST Service (POST) for EBS 12.1/12.2

Step 1: Deployed rest service in EBS

(Create package & body for inserting data into table & Create Business entity, then you create pls & upload it & Deployed)

Give grant to specific user, That particular responsibility should be assigned to user.

Note the “Responsibility Key”

Step 2: Install Chrome Rest Service Client

Step 3:  Now you have WADL file for you deployed service

Step 4:  Example POST Data

Granted user credentials

POST Data

 

Parameter :

{

“xxace_main”: {

“@xmlns”: “http://ebsdevxxxx/webservices/rest/XXACETESTNEW/xxace_main/“,

“RESTHeader”: {

“Responsibility”: “20-LEBANON_AR”,

“RespApplication”: “AR”,

“SecurityGroup”: “STANDARD”,

“NLSLanguage”: “AMERICAN”

},

“inputParameters”: {

“P_CUSTOMER_NAME_1”: “Testing Done31”

}

}

}

 

 

oracle.apps.fnd.isg.common.error.ISGException: Could not find the package.

When you’re trying to deploy rest service , you might be get the below issue

 

Error in the generating PLSQL package oracle.apps.fnd.isg.common.error.ISGException: Error in the generating PLSQL package at oracle.apps.fnd.isg.app.common.designer.db.DBServiceDesigner.generateArtifacts(DBServiceDesigner.java:494) at oracle.apps.fnd.isg.app.ebs.designer.db.DBRestDesigner.generateService(DBRestDesigner.java:52) at oracle.apps.fnd.isg.app.common.designer.AbstractServiceDesigner.designService(AbstractServiceDesigner.java:34) at oracle.apps.fnd.isg.app.common.admin.ServiceAdministrator.generateService_Internal(ServiceAdministrator.java:453) at oracle.apps.fnd.isg.app.common.admin.ServiceAdministrator.generateNdeployService(ServiceAdministrator.java:154) at oracle.apps.fnd.isg.mgmt.server.AdminService$1GenerateNDeployTask.execute(AdminService.java:971) at oracle.apps.fnd.isg.mgmt.server.AdminService$1GenerateNDeployTask.execute(AdminService.java:953) at oracle.apps.fnd.isg.mgmt.server.ISGServerMBean$ThreadedTaskRunner.run(ISGServerMBean.java:114) at java.lang.Thread.run(Thread.java:745) Caused by: oracle.apps.fnd.isg.common.error.ISGException: Could not find the package. at oracle.apps.fnd.isg.app.common.designer.db.DBServiceDesigner.currentSchemaName(DBServiceDesigner.java:677) at oracle.apps.fnd.isg.app.common.designer.db.DBServiceDesigner.getSchemaName(DBServiceDesigner.java:616) at oracle.apps.fnd.isg.app.common.designer.db.DBServiceDesigner.generateArtifacts(DBServiceDesigner.java:127) … 8 more

Solution :

Please check your internal name, the internal should be a package name, it should not be an “apps.packagename”. remove apps from your pls file and upload again.

 

sqlplus: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file

When you’re doing clone on the Redhat 7, you may get the below error

 

“sqlplus: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file”

 

This is bug as per note Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)

 

you need to install “binutils” rpm package version as per noted in the documentation.

After installed also, you still get an error, you please reboot the machine and test.

 

 

 

 

Rest service configuration EBS 12.2

Follow the articles

Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2 (Doc ID 1311068.1)

  • Part B: Configuring Oracle E-Business Suite REST Services

If you can’t generate Ildt file after configured, you need to follow this document install PERL

https://docs.oracle.com/cd/E26401_01/doc.122/e20925/T511175T543269.htm#5464758

 

 

 

Why EBS URL not working after changed IP Address

Why EBS URL not working after changed IP Address?

 

Your system was configured using HOSTNAME of the machine, you plan to change the IP address of that machine, you changed and restarted the application also, Still Application URL not working, Why?

Stop the application & run autoconfig on the system and start the application, it will work.

Capture FND log error message

Step 1:

select max(log_sequence) from fnd_log_messages

Note the sequence number

Step 2:

Log in as a system administator

Profile –> System

FND: Debug Log Enabled –> Yes

FND: Debug Log Level  –> Statement or options

FND: Debug Log Module –> %

 

Step 3:

Reproduce the issue

 

Step 4:

select max(log_sequence) from fnd_log_messages

 

Step 5:

select * from fnd_log_messages where log_sequence between “first one” and ” last sequence”

 

Spool the file and analyze the log file if you can able to find any issue with this file.

 

RC-00203 RC-50004 AC-00005

I am trying to clone one of our production machines after I upgraded the database to 12.1.0.2.  This clone machine prepared by Veeam Backup. I think the below solution is applicable for VM clone also. Here While I am doing adcfgclone.pl steps, I am getting below issue

done: Port Pool 65 is free
Report file located at /appsutil/out/portpool.lst
RC-00203: Unable to create/write to file /appsutil/out/portpool.lst.
Complete port information available at /appsutil/out/portpool.lst
RC-50004: Error occurred in CloneContext:
AC-00005: No write permissions for creating the Context file – /appsutil/temp.xml
Raised by oracle.apps.ad.context.AppsContext
Check Clone Context logfile /u01/app/oracle/db/tech_st/12c/appsutil/clone/bin/CloneContext_0220023028.log for details.

ERROR: Context creation not completed successfully.
For additional details review the file /tmp/adcfgclone_23246.err if present.

 

Solution :

What I did

 

  1. I run adpreclone.pl on both application & database tier
  2. System Team Clone the machine using Veeam Backup
  3. Then I restored the database using backup copy, then I rename the database.
  4. Now I ran adcfgclone.pl steps, I am getting above issue.

On Database Tier node,

1. Set the ORACLE_HOME Path  environment on database tier, Database SID should be a new SID (renamed one)

2. Change hostname & IP address on new server

3. Set TNS_ADMIN Path –>

(copy the Production TNS _ADMIN path, to New path & modify the tnsnames.ora & listener.ora with new SID & hostname)

4. Start the listener

5. Once listener started, create a context file using by

perl adbldxml.pl

6. run auto config

perl adconfig.pl

7. Database configuration part finished

8. Go to application tier,

perl adcfgclone.pl appsTier

 

Can’t locate ADX/util/Sysutil.pm in @INC

When  I am trying to change hostname for EBS environment,  I used below command to remove server, I am getting below issues

[oraprod@ebsprodcl appsutil]$ ls
bin html install java LEBPROD_ebsprodleb.xml log media out perl scripts sql temp template
[oraprod@ebsprodcl appsutil]$ perl ./bin/adgentns.pl appspass=hqa523AceGr0uP contextfile=/u01/app/oracle/db/tech_st/12c/appsutil/LEBPROD_ebsprodleb.xml -removeserver
Can’t locate ADX/util/Sysutil.pm in @INC (@INC contains: /u01/app/oracle/db/tech_st/12c/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /u01/app/oracle/db/tech_st/12c/perl/lib/site_perl/5.14.1 /u01/app/oracle/db/tech_st/12c/perl/lib/5.14.1/x86_64-linux-thread-multi /u01/app/oracle/db/tech_st/12c/perl/lib/5.14.1 .) at ./bin/adgentns.pl line 82.
BEGIN failed–compilation aborted at ./bin/adgentns.pl line 82.

Solution :

Please check the perl path

& Environment also was set.

.bash_profile

 

PATH=$HOME/bin:/u01/app/oracle/db/tech_st/12c/perl/bin:$PATH
export PATH

. /u01/app/oracle/db/tech_st/12c/EBSPROD_ebsprodleb.env

 

The security token could not be authenticated or authorized

Client received SOAP Fault from server: The security token could not be authenticated or authorized Please see the server log to find more detail regarding the exact cause of the failure.Error while calling Oracle web service.

Solution:

SOAP Wsdl granted user password might be changed. Please check