I am trying to create a custom event on purchase order. First I have created two custom fields on purchase order header. One numeric field to enter the Fund allocation (Numeric ) To pick the total PO amount Expression Statement - Purchase_Order_API.Calc_Total_Gross_Incl_Chg(order_no)) Method signature Signature - Purchase_Order_Cfp.Get_CF$_Po_Full_Amount(v.objkey) Custom event -Fund Allocation should not be grater than the total po amount. Online Sql Statement DECLARE BEGIN IF ('&NEW:CF$_FUND_ALLOCATION' > '&PO_AMOUNT') THEN IFSAPP.Error_SYS.Record_General('Error', 'Fund Allocation can not exceed the PO amount'); END IF;END; When I activated the event I get the below error. table IFSAPP.PURCHASE_ORDER_CFT is mutating, trigger/function may not see itFailed executing statement (ORA-04091: table IFSAPP.PURCHASE_ORDER_CFT is mutating, trigger/function may not see it Please Help me with this
Is there an IFS overview or a db view to get the shop order operation scraped quantities with the entered scrap reason. ?Thank you
System has created an unusual posting error on UNRCPT- (Reverse Receipt for Purchase Order) . Any Idea about this posting. We have fallowed the usual purchase order receipt cancelation process. Thank You
Is there a way to find the page name or a form which a given view or a LU is utilized . Ex - View : CUSTOMER_ORDER & Lu : CustomerOrder used at Page Customer Order
Hi CommunityI need to create an email which triggers on their birthday. Any leads?
Adding more than one column in custom field reference LOV. I have created a persistent custom field with a Data type set to reference. I have linked a custom logical unit which has two columns to it. Is there a way to pick both the columns in LOV preview. ? Need the below in two columns. Not as concatenated to a single column.
On a custom event I have the following online SQL to trigger an Email on release of a purchase order. But the records in Curser is not picking on email body. DeclareCURSOR EXIST_A ISSELECT p.note_text ,p.currency_code , p.total_amt_at_auth FROM IFSAPP.PURCHASE_ORDER pWHERE p.order_no = '&NEW:ORDER_NO';BeginFOR REC_ IN EXIST_A LOOPIFSAPP.Command_SYS.Mail('noreply@xxxxx.lk' , 'kavindu@xxxxx.lk','Dear Sir Madam <br><br><br>New Order has been released.<br><br>Supplier: &SUPPLIER <br>PO_Note(s): REC_.note_text <br>Amount : REC_.total_amt_at_auth - REC_.currency_code <br><br><br>If you need further clarifications, please call the respective officer who is handling your account or email your queries to payment@empire.lk<br>Thank You<br>This is a System generated E-mail. Do not Reply', 'Error Ocured while sending Email', null, null, 'Cheque in progress - &SUPPLIER ',null,null,null,null,'MAIL_SENDER2');END LO
Already have an account? Login
No account yet? Create an account
Enter your 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.