Hi CommunityI need to create an email which triggers on their birthday. Any leads?
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 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
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
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
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.
Is there an IFS overview or a db view to get the shop order operation scraped quantities with the entered scrap reason. ?Thank you
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.