Project and Portfolio Management Practitioners Forum

Inserting Notes to Tables

Super Contributor.

Inserting Notes to Tables


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.