• State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 14 subscribers
  • Views 7623 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SOA Gateway Integration Interfaces

tootricky
over 7 years ago

Has anyone configured Stat for managing ISG Integration Interfaces (ildt files)?

 

Ideally we'd like to have Stat generate the ildt files but, if that is not feasible, we're happy to upload from Working.  Our current process is as follows:

Undeploy Integration
Migrate Database Objects
Upload Integration to ISG (using FNDLOAD)
Deploy Integration

I'm not sure how essential the undeploy is, as development has been by a third party, but, I suspect it could be done following the migration of the DB objects.  If so, it should be straightforward enough to have Stat call a shell script that performs the undeploy, the FNDLOAD and the deploy.

Thanks,
Nic

  • 0 over 7 years ago

    Hi Nic,

    In 2014, I created a Stat custom object named: SOA-Gateway PLS that calls a shell script I wrote to handle creating the ildt using irep_parser.pl and then uploads using FNDLOAD using lct file: wfirep.lct. So for us it handles most of the steps needed to handle our SOA Gateway needs. It is not handling the SOA Generate and SOA Deploy on the app servers. Also we have multiple App Servers so deploying on the 2nd app server requires us to use tar and ftp after deploying on the 1st app server and untar and run SOA Deploy on the 2nd app server. Also the needed grants have to be done manually. We do not undeploy on the target. Almost done with a complete solution that includes handling SOA Generate and Deploy on the app servers. Have not figured out how to automate the grants.

    Our solution is based on Oracle Doc ID 556540.1 "Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12"

    Also this link may help:  http://dborgstrom.blogspot.com/2011/08/how-to-create-custom-integration.html


    Hope this helps.

    Tom Shaw

  • 0 over 7 years ago
    Hi Tom,

    I don't know why, but I figured you might have looked at this :) would you be prepared to share any of the work you did? I have a script that runs the undeploy, the FNDLOAD, and the deploy - although we are getting a Java error, for which I have raised an SR with Oracle.

    Thanks,
    Nic
  • 0 over 7 years ago
    Hi Nic,

    A while ago I sent you a Stat community friend request, if you accept the request we can exchange messages regarding this topic.

    Thanks.
  • 0 over 7 years ago
    Hi Tom,

    My apologies, I thought I had already accepted. Have now accepted :)

    Thanks,
    Nic