Hi Daniel,Thanks for your response, how do I make the part as ‘In Inventory’ ?Cheers
Here is the code:DECLAREto_user_name_ varchar2(2000) :=null ;Group_Person_id_ varchar2(2000);Cursor c1 is SELECT PERSON_ID FROM DOCUMENT_GROUP_MEMBERS WHERE GROUP_ID='X_APPROVAL_MAINT';BEGINFor cur_group in c1 loopGroup_Person_id_ := Group_Person_id_ || cur_group.Person_id || ';' ;End loop;If Nvl('&NEW:PERSON_ID',' ') = ' ' Then to_user_name_ := Group_Person_id_ ;Else to_user_name_ := IFSAPP.PERSON_INFO_API.Get_User_Id('&NEW:PERSON_ID') ;End If;--IFSAPP.Error_SYS.Record_General(' ', to_user_name_ );COMMAND_SYS.mail(from_user_name_ =>'#USER_ID#', to_user_name_ => to_user_name_ , text_ => 'Work Order Requires Approval - '|| '&NEW:DESCRIPTION' || '<br> <br>' || 'Click Here to View: <br>' || chr(10) || 'https://pa-ifs-ext-v.portav.co.uk:48080/client/runtime/Ifs.Fnd.Explorer.application?url=ifsapf%3AtbwApproval%3FACTION%3Dpopulate' , subject_ => 'Work Order Requires Approval - ' || '&NEW
I have found the issue, syntax error on my Endif should have been end if
Screen shot attached
I have deleted the migration job and recreated and it it all working now.
When the job has completed it is as if the cusom fields file has not actioned.
Thanks for your reply. I have been looking at this document and all appears to be ok. I also have other migration jobs with custom fields and they are working fine.
Hello Joe - I am not getting the error and the record is created
Hello both - I have amended to ‘Before’ but still the record is created
Thanks - Is there a way to turn off the auto sequence
Thanks, Ihave made the change but the record is being created still
Thanks for the response, I am getting the following error now.
Thanks @ThushAsanka I was missing the = sign, all good now.
Hi @AanHGTS, Would you be able to provide the syntax needed to do this please
Hi @ThushAsanka , I have tried that but I am getting the same error message.
I have tried that but it has made no difference
Thanks for your response Nipun, I can view the page with no issues - there just dosen’t seem to be able to click on the Oppo number
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.