The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday noon (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday noon (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

User open interface exapmples

Highlighted
Klyuev Yury
Acclaimed Contributor

User open interface exapmples

Do you have pl/sql examples ?
2 REPLIES
Klyuev Yury
Acclaimed Contributor

Re: User open interface exapmples

How can populate TRANSACTION_ID field ?
Jim Esler
Honored Contributor

Re: User open interface exapmples

You can get and capture a transaction id with commands along the lines of the following:

ksc_run_sql QUERY_STRING="select knta_interface_txns_s.nextval from dual" ENV_NAME="[SOURCE_ENV.ENVIRONMENT_NAME]"
ksc_store REQD.P.PARENT_TRANSACTION_ID=[SQL_OUTPUT]
//Add this to "OnDomLoad" event