Project and Portfolio Management Practitioners Forum
cancel

need insert any notes to KNTA_NOTES

Highlighted
Semenov Alexand
Acclaimed Contributor.

need insert any notes to KNTA_NOTES

Good day all. Help me please.
I need insert any notes to KNTA_NOTES.
I have an table component in request. in this table comp allow any task+notes. User can change notes and click button ob WF step. After this notes for any chaget tasks can be apdatind.
My samle SQL in attach. This working only if changing 1 task.
Thanks in advice!!!
4 REPLIES
Semenov Alexand
Acclaimed Contributor.

Re: need insert any notes to KNTA_NOTES

Hi all.
I change my query
(
INSERT
INTO ITG_NOTES (NOTE_ID,VERSION,NOTE_TYPE,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,NOTE_TEXT,OWNER_ID)
select
itguser.ITG_NOTES_S.NEXTVAL ......

) and all working fine.
We try kRunCacheManager.sh but it not help us.

We find any problem again.

We update table from user who have rights for update DB (ITGUSER).If i chech my insert with help another query then all fine but if i chech my insert from another user who have't rights for update DB query not show inserting result. I think this mean that we can se change from interface and from my reports and portlets.
Why? How i can solve this?
Thanks in advice!!!!!
Semenov Alexand
Acclaimed Contributor.

Re: need insert any notes to KNTA_NOTES

Hi!
solved by adding

commit; in end of query.

I have next trouble:how run this from PPM?
Thanks in advice.
Semenov Alexand
Acclaimed Contributor.

Re: need insert any notes to KNTA_NOTES

Hi ALL.
I modify my query and all OK.
Any question:How i can run this query from PPMC execution step for example or any variant.
Thanks in advice!!!!!!
Raj Ghimire
Outstanding Contributor.

Re: need insert any notes to KNTA_NOTES

Probably the most common would be to create a short PL/SQL function and run the function from the execution step with proper values provied in the form of TOKENs. I have also seen people run scripts from execution steps directly utilizing WF Step Commands to create, run and delete scripts after execution.
Thanks.
-Raj