Thanks for the reply but that screen only copies inventory parts? We need to do sales and purchase as well :(
Nevermind, I fixed it by using an explicit cursor: DECLARE info_ VARCHAR2(2000); attr_ VARCHAR2(2000); automatic_pay_auth_flag_db VARCHAR2(1):= '1'; CURSOR get_supp IS SELECT * FROM IDENTITY_INVOICE_INFO where automatic_pay_auth_flag_db != '1'; rec_ get_supp%ROWTYPE; BEGIN OPEN get_supp; LOOP FETCH get_supp INTO rec_; EXIT WHEN get_supp%NOTFOUND; Client_SYS.Clear_Attr(attr_); Client_SYS.Add_To_Attr('AUTOMATIC_PAY_AUTH_FLAG_DB',automatic_pay_auth_flag_db,attr_); IDENTITY_INVOICE_INFO_API.Modify__(info_,rec_.objid,rec_.objversion,attr_,'DO'); END LOOP; CLOSE get_supp; COMMIT;END;
Hi @signils , “Attribute types retrieved from the view definition in IFS/Foundation. P = Parent Key. Means that this column is retrieved from somewhere else. K = Key. Means that this is a key column in this view. M = Mandatory. Column must have a value. I = Insert allowed U = Update allowed.” Kind Regards Ozgun Bal Thanks but just need more clarification about : P = Parent Key. Means that this column is retrieved from somewhere else. Somewhere else as in?
THANK YOU
Please help!!!!
Thank you so much!!!
Hi @signils, These 2 views are associated with FIN_NOTE_TEXT_API and FA_OBJECT_NOTE_API respectively. So in simpler terms, you can call for the FA_OBJECT_NOTE_API.New___ method within the Insert___ procedure of the FIN_NOTE_TEXT_API. This a bit tricky thing and needs to be handled very carefully. Or you can develop a custom procedures in both APIs to be called within once a new record is inserted in to FIN_NOTE_TEXT_API. This is not that tricky and safer if you know what you are doing. Else you can use a trigger in FIN_NOTE_TEXT_Tab to call the FA_OBJECT_NOTE_API.New___ method or directly insert into FA_OBJECT_NOTE_Tab. This is not the best way and personally I advise you not to go this route. I hope this helps. Best Regards, Charana Thanks for responding mate. I checked within the Insert___ procedure of the FIN_NOTE_TEXT_API and there was no mention of FA_OBJECT_NOTE_API.New___We are not allowed to create or modify the API’s as client is strict about it.
Thanks yasas. I cant access those links though, how do I get access?
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.