Rauf
VIP Member
I came across a case, to change Person Responsible (RPER) from Old Person(say AN8 = 111) to a New Person (say AN8 = 999).
He was responsible for about 60 projects in F43008. So if I use P43008, I should go to 60 records, then edit the line manually.
Instead, I just accessed the database directly, replaced the Old Person with New Person for the said 60 project.
Now, everything is done. But I see some issues in the orders. For some orders, the Old Person get a list of pending orders in P43081 (Orders Awaiting Approval) with 'Queued for Approval' selected, also the Row -> Status Summary says it is pending with the Old Person. But when he goes inside, all the line of the order having 'Approved' status, and the Form-> Approve button is disabled.
I am totally confused, there is no automatic triggers in the database table ? Any body, please advise to find out what is really happened.
He was responsible for about 60 projects in F43008. So if I use P43008, I should go to 60 records, then edit the line manually.
Instead, I just accessed the database directly, replaced the Old Person with New Person for the said 60 project.
Now, everything is done. But I see some issues in the orders. For some orders, the Old Person get a list of pending orders in P43081 (Orders Awaiting Approval) with 'Queued for Approval' selected, also the Row -> Status Summary says it is pending with the Old Person. But when he goes inside, all the line of the order having 'Approved' status, and the Form-> Approve button is disabled.
I am totally confused, there is no automatic triggers in the database table ? Any body, please advise to find out what is really happened.