Skip to content
Advertisements

Archive for

DDL Extract for tables

DDL Extract for tables

 

ALL Tables from user

set heading off;
set echo off;
Set pages 999;
set long 90000;

spool export_tables_ddl.sql

select dbms_metadata.get_ddl(‘TABLE’,table_name,’TESTUSER’) from user_tables;

 

spool off

 

*table_name — Don’t mention anything

 

 

A table

select dbms_metadata.get_ddl(‘TABLE’,’EMPLOYEE’) from dual

 

*EMPLOYEE – table name

Advertisements

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