Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to create a JIRA issue using PLSQL code. Whre JIRA is remote server?

We have a requirement to create an issue through PLSQL when a concurrent Job completed in oracle apps. 

I am new to using REST APIS of JIRA. So some one could provide me the details oe existing code to use how to creata a JIRA issue through PLSQL code using BAsic authentication?

3 answers

1 accepted

Thanks Raj for the documents. Really they helpful to understand basic concepts, but need clarifications on below.

1)  Actually when we try to connect to Webservice through REST API using utl_http package we require a certificate to be attached with it.. So is this certificate required for JIRA services also?

2) I could see sample code to create an issue in n Curl,node.js,Java,Python and PHO languages..Can we use any of this code directly in PLSQL?

3) Is there any sample Java code which can create an issue in JIRA that will be called through PLSQL:

 

Any how thanks much for the documents.

@Rudrama Devi Hi, did you get any progress? I am trying to same thing. Could you help me?

Hi @Rudrama Devi,

I need to create an issue through PLSQL too. I tried UTL_HTTP but cannot get result. Did you get some progress? If so, could you help me? h.ozankurt@gmail.com

Hi Ozan,

 

Based on our analysis we found 2 solutions to integrate Oracle EBS with JIRA

Option 1: Intrgrate Oracle EBS with JIRA through e-mail handler. This is simple. We have to create shared outlook email box and attch it to JIRA project.This is working fine.

Oprion 2: Through PLSQL code .. Our progress on this is 

        We tried sample code and it was failing due to wrong certitificate. So currently we are trying to get correct .pks certificate with ,immediate server details,private key etc. Hoping this will work beacuse we are only getting getting invalid certificate error.Will update you once we tested with new certificate.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you