Project and Portfolio Management Practitioners Forum
cancel

Inserting Notes to Tables

Highlighted
Lizabeth
Super Contributor.

Inserting Notes to Tables

Hello,

We are trying to add notes by inserting them directly into Base Tables. I had the following concerns with the same -

1. We are using the Sequence 'KNTA_NOTE_ENTRIES_S' to populate the note_entry_id column, However it shows a different value in the database when I insert the notes through 'Requests' than what it shows when I do a 'SELECT KNTA_NOTE_ENTRIES_S.CURRVAL'. I Hope this is accepatble.

2. I Hope there is just one table that needs to be updated 'knta_note_entries'

3. I Hoep there are no issues seen when inserting directly to base tables.

Thanks for all your help.