Cannot Generate a PLSQL Service due to Error: J2T-120, ERROR: Illegal option (Doc ID 1621794.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle E-Business Suite Integrated SOA Gateway - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Installation Issues

When attempting to generate a service,
the following error occurs.

ERROR
-----------------------

ISG_SERVICE_GENERATE_ERROR :
Error in the generating PLSQL package oracle.apps.fnd.isg.common.error.ISGException: ISG_SERVICE_GENERATE_ERROR :
Error in the generating PLSQL package
at oracle.apps.fnd.isg.app.common.designer.db.DBServiceDesigner.generateArtifacts(Unknown Source)
at oracle.apps.fnd.isg.app.soa.designer.db.DBSoapDesigner.generateService(Unknown Source)
at oracle.apps.fnd.isg.app.common.designer.AbstractServiceDesigner.designService(Unknown Source)
at oracle.apps.fnd.isg.app.common.admin.ServiceAdministrator.generateService_Internal(Unknown Source)
at oracle.apps.fnd.isg.app.common.admin.ServiceAdministrator.generateService(Unknown Source)
at oracle.apps.fnd.isg.mgmt.server.AdminService$1GenerateTask.execute(Unknown Source)
at oracle.apps.fnd.isg.mgmt.server.AdminService$1GenerateTask.execute(Unknown Source)
at oracle.apps.fnd.isg.mgmt.server.ISGServerMBean$ThreadedTaskRunner.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)

Caused by: oracle.apps.fnd.isg.common.error.ISGException:
J2T-120, ERROR: Illegal option "-plsqlname=objectid" ignored
at oracle.apps.fnd.isg.fmw11.designer.jca.util.JPublisher.getWrapperProcName(Unknown Source)
at oracle.apps.fnd.isg.fmw11.designer.jca.util.DataAccess.generateJPubWrapper(Unknown Source)
at oracle.apps.fnd.isg.fmw11.designer.db.DBArtifactsGenerator.generateArtifacts(Unknown Source)
...
...

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. 1. Integrated SOA Gateway
2. Integration Repository
3. Find the service
4. Click on Generate


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms