Skip to content
Advertisements

Posts from the ‘EBS’ Category

ORACLE E-BUSINESS SUITE 12.2.8 RELEASE UPDATE

Oracle is pleased to announce the availability of Oracle E-Business Suite 2018 innovations, which include Oracle E-Business Suite 12.2.8 and other 2018 updates delivered prior to 12.2.8

Refer  :

http://www.oracle.com/us/products/applications/ebs-2018-innovations-5119373.pdf

https://community.oracle.com/thread/4176619

http://learn.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=904&get_params=cloudId:243,objectId:22957

 

Advertisements

ons port connection refused

When I try to open forms, I am getting the below issue

 

FRM-92102: A network error has occurred.
The Forms Client has attempted to reestablish its connection to the Server 1 time(s) without success.
Please check the network connection and try again later.

Details…
Java Exception:
java.io.FileNotFoundException: http://ebsuat.xxx.xx:8005/foms/x

 

So I checked the logfile in opmn.log, it shows

” [ons-connect] Connection e5e,ebsuat.xxxx.xxx,6265 connect (Connection refused) ‘

[appluat@ebsuat scripts]$ netstat -anp | grep 6265
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 127.0.0.1:6265 0.0.0.0:* LISTEN 1213/opmn

 

Solution :

Please check the hostname entry with localhost, If its, Please remove the hostname entry line on localhost

restart application

[appluat@ebsuat scripts]$ netstat -anp | grep 6265
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 10.1.xxx.xx:6265 0.0.0.0:* LISTEN 1213/opmn

 

Now I can able to open the forms

libXtst.so.6: undefined reference to `__stack_chk_fail@GLIBC_2.4′

When we try to rebuild the forms or reports, you may get the below issues

“[appluat@ebsuat lib]$ make -f ins_reports.mk install
rm -f /u01/EBSUAT/apps/tech_st/10.1.2/lib//librwu.so; \
rm -f /u01/EBSUAT/apps/tech_st/10.1.2/lib//librw.so
rm -f rwsutil.o rwspid.o ; \
/usr/bin/ar x /u01/EBSUAT/apps/tech_st/10.1.2/lib//librwu.a rwsutil.o rwspid.o ; \
(LD_OPTIONS=”-z muldefs”; \
/usr/bin/gcc -m32 -o /u01/EBSUAT/apps/tech_st/10.1.2/lib//librwu.so -shared -L/u01/EBSUAT/apps/tech_st/10.1.2/lib/ -L/u01/EBSUAT/apps/tech_st/10.1.2/lib/stubs/ rwsutil.o rwspid.o \
-lm /u01/EBSUAT/apps/tech_st/10.1.2/lib/libclntsh.so -lpthread -Wl,-rpath,/usr/X11R6/lib -L/usr/X11R6/lib -lXm -lXt -lX11 -lm -lXp -lXext `cat /u01/EBSUAT/apps/tech_st/10.1.2/lib/sysliblist` -lc )
rm -f zrhitem.o zrhcursor.o; \
/usr/bin/ar x /u01/EBSUAT/apps/tech_st/10.1.2/lib//librw.a zrhitem.o zrhcursor.o
rm -f rwbuilder
gcc -m32 -o rwbuilder -L/u01/EBSUAT/apps/tech_st/10.1.2//lib/ -L/u01/EBSUAT/apps/tech_st/10.1.2/lib/ -L/u01/EBSUAT/apps/tech_st/10.1.2/lib//stubs -rdynamic -Bdynamic -L/u01/EBSUAT/apps/tech_st/10.1.2/jdk/jre/lib/i386 -L/u01/EBSUAT/apps/tech_st/10.1.2/jdk/jre/lib/i386/server -L/u01/EBSUAT/apps/tech_st/10.1.2/jdk/jre/lib/i386/native_threads -ljvm rxmasb.o /u01/EBSUAT/apps/tech_st/10.1.2/reports/lib/ui10.o /u01/EBSUAT/apps/tech_st/10.1.2/reports/lib/uiicxd.o /u01/EBSUAT/apps/tech_st/10.1.2/reports/lib/rwsng.o /u01/EBSUAT/apps/tech_st/10.1.2/reports/lib/rwscl.o /u01/EBSUAT/apps/tech_st/10.1.2/reports/lib/rwssc.o /u01/EBSUAT/apps/tech_st/10.1.2/reports/lib/rwssc0.o /u01/EBSUAT/apps/tech_st/10.1.2/reports/lib/rwsdt.o /u01/EBSUAT/apps/tech_st/10.1.2/reports/lib/rwscr.o -lrw /u01/EBSUAT/apps/tech_st/10.1.2/lib//librw.a -lobx -lnn -lrws -lde /u01/EBSUAT/apps/tech_st/10.1.2/lib//libzrc.a -lrws -lucol -luicc -lca -lmma -lmmiw -lmmov -lmma -lmmos -lmmoi -lmmia -lmmft -lmmcm -lvgs -luihx -luc -luipr -luimotif -lot -lrem -lree -lrec -luiimg -luimotif -luipr -luiimg -luc -lrem -luimotif -luia -ltknqap -luipr -luimotif -lutt -lix -lixd -lrod -lror -lros -lrod -lror -lros -lrod -luat -ldfc -lutc -lutj -lutl -lutsl -lpls10 -lplp10 /u01/EBSUAT/apps/tech_st/10.1.2/lib/libplc10.a -lpls10 -lplp10 -lslax10 -lsql10 -lclntsh `cat /u01/EBSUAT/apps/tech_st/10.1.2/lib/ldflags` -lnsslb10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /u01/EBSUAT/apps/tech_st/10.1.2/lib/ldflags` -lnsslb10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lmm -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /u01/EBSUAT/apps/tech_st/10.1.2/lib/ldflags` -lnsslb10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /u01/EBSUAT/apps/tech_st/10.1.2/lib/ldflags` -lnsslb10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /u01/EBSUAT/apps/tech_st/10.1.2/lib/sysliblist` -Wl,-rpath,/u01/EBSUAT/apps/tech_st/10.1.2/lib,-rpath,/u01/EBSUAT/apps/tech_st/10.1.2/jdk/jre/lib/i386:/lib:/usr/lib -lm `cat /u01/EBSUAT/apps/tech_st/10.1.2/lib/sysliblist` -ldl -lpthread -lm -L/u01/EBSUAT/apps/tech_st/10.1.2/lib -L/u01/EBSUAT/apps/tech_st/10.1.2/lib/stubs/ -lsnls10 -lpthread -ljvm -lhpi -Wl,-rpath,/usr/X11R6/lib -L/usr/X11R6/lib -lXm -lXt -lX11 -lm -lXp -lXext /u01/EBSUAT/apps/tech_st/10.1.2/lib//librw.a -lnsl
/usr/lib/libXtst.so.6: undefined reference to `__stack_chk_fail@GLIBC_2.4′
/usr/lib/libXtst.so.6: undefined reference to `__fprintf_chk@GLIBC_2.3.4′
/usr/lib/libXtst.so.6: undefined reference to `__sprintf_chk@GLIBC_2.3.4′
collect2: ld returned 1 exit status
make: *** [rwbuilder] Error 1″

 

Solution :

Oracle Forms Upgrade to 10.1.2.3 fails with error /usr/lib/libXtst.so.6: undefined reference (Doc ID 1120527.1)

 

 

OUI to the latest version on EBS 12.1.3

you must required to upgrade OUI to latest version on EBS Version while Deploying JRE native for Windows Client, Here If you need to execute runInstaller like below

 

./runInstaller -ignoreSysPrereqs -invPtrLoc /u01/EBSUAT/apps/tech_st/10.1.2/oraInst.loc

 

 

Deploying JRE for Windows Clients in Oracle E-Business Suite Release 12

Deploying JRE for windows clients in Oracle E-Business suite release 12.1.3 Follow the document

  1. Follow the document
Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 (Doc ID 393931.1) . 

 

Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 (Doc ID 437878.1)

 

2. Steps

Upgrade latest OUI 6640838 and then applying below patches use by opatch 6880880 with 10.1.0.0.0

Upgrade Patch :

Apply patch  14825718

Apply overlay patch 26825525

and follow post installation steps on 437878.1

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’);

 

 

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