Project and Portfolio Management Practitioners Forum
cancel

Which sequence to use to populate transaction_id column in knta_users_int tabel?

Highlighted
Vibhor Dwivedi
Super Contributor.

Which sequence to use to populate transaction_id column in knta_users_int tabel?

I have to populate data in knta_users_int table.

For transaction_id column i have to use a sequence.

Is there any specific sequence is used by system to populate this column?
6 REPLIES
Erik Cole_1
Outstanding Contributor.

Re: Which sequence to use to populate transaction_id column in knta_users_int tabel?

No, each 'group' of records you are importing should have the same transaction_id.
Vibhor Dwivedi
Super Contributor.

Re: Which sequence to use to populate transaction_id column in knta_users_int tabel?

Is it required for a transaction_id to be unique ...

Or we can create a custom sequence and populate it starting from 1 (incrementing).

Regards,
Vibhor
Sangiliraja_1
Honored Contributor.

Re: Which sequence to use to populate transaction_id column in knta_users_int tabel?

Hi,

There is no sequence available for ready to use in PPM Schema. Based on the method of importing users to ppm, you can populate transaction id.

Yes all transaction id should be unique.


Thanks
Sangiliraja.P
Jim Esler
Acclaimed Contributor.

Re: Which sequence to use to populate transaction_id column in knta_users_int tabel?

The transaction_id in the knta_users_int table needs to be unique only when the entry is tied to entries in the knta_user_security_int table with that table's parent_transaction_id field. We use knta_interface_txns_s.nextval to get a unique value for this purpose.
Vibhor Dwivedi
Super Contributor.

Re: Which sequence to use to populate transaction_id column in knta_users_int tabel?

Thanks a lot
Vibhor Dwivedi
Super Contributor.

Re: Which sequence to use to populate transaction_id column in knta_users_int tabel?

..