Project and Portfolio Management Practitioners Forum
cancel

User open interface exapmples

Highlighted
Klyuev Yury
New Member.

User open interface exapmples

Do you have pl/sql examples ?
2 REPLIES
Klyuev Yury
New Member.

Re: User open interface exapmples

How can populate TRANSACTION_ID field ?
Jim Esler
Acclaimed 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]