Hi,
We use the revisions of Inventory Parts to keep the revision our customer is on (Field ENG_REVISION), so when we do an internal revision of our Product Structure we would like to keep the customer revision the same.
For this I started out doing a custom event to copy the ENG_REVISION field from the previous revision, but I am hitting the mutating error.
Below is the code I am using for now, and attached is the event ID and all its parameters.
I have read that there are workarounds if trying to use background jobs, but don’t exactly know and understand how to go about doing so.
Would appreciate any help!
Thanks in advance,
Mendes
DECLARE new_Eng_Revision VARCHAR2(20) := ''; CURSOR get_last_revision OPEN get_last_revision; p3_ := 'ENG_REVISION' || chr(31) || new_Eng_Revision || chr(30) ||'ENG_REVISION_DESC'|| chr(31) || new_Eng_Revision_Desc || chr(30); --p0 -> __lsResult END; |
Best answer by Hans Andersen
View original