Hi, Try the below code. I hope this code you are using on custom menu. declare info_ varchar2(4000); attr_ varchar2(200); Date_ date; CURSOR c1 IS SELECT * from PURCHASE_ORDER_LINE_ALL_CFV WHERE CF$_ID_DOCUMENT = &CF$_ID_DOCUMENT AND ORDER_NO = &ORDER_NO; rec_ c1%rowtype ; BEGIN OPEN c1; FETCH c1 INTO rec_; CLOSE c1; Date_ := &PLANNED_DELIVERY_DATE; client_sys.Clear_Attr (attr_) ; client_sys.Add_To_Attr('PLANNED_DELIVERY_DATE',Date_ ,attr_); ifsapp.purchase_order_line_api.Modify__(info_,rec_.objid ,rec_.objversion, ,'DO'); COMMIT; end; This is the most helpful solution as of now with only one complication that this is updating just the first line and when I try to add this solution inside a loop it is not updating
@amrflynn For the parameters where the & is added at the beginning, do you want to give values at the time of execution or do you need to fetch those also from the table? /Sangeetha Jayamaha So The thing here is that I want to use the date of the row in which I have document ID and copy that date to all the records with that document ID. I am not completely sure If I am right. Also I used count so that I can use that to catch lets say 5 records with same document id and I can execute it 5 times to update the planned delivery date of all 5 lines and the date it shall choose will be from the row on which I did the right click operation
The Select Statement is - SELECT CASE WHEN (A.AVAILABLE_QTY_ONHAND == A.TOTAL_SIM_DEMAND_QTY) THEN 'TRUE' ELSE 'FALSE' END FROM PART_AVAIL_STRUCTURE_FLAT_OV A WHERE A.TOP_CONTRACT = :TOP_CONTRACT AND A.TOP_PART_NO= :TOP_PART_NOAND A.TOP_ENG_CHG_LEVEL = :TOP_ENG_CHG_LEVEL AND A.TOP_BOM_TYPE = :TOP_BOM_TYPE AND A.TOP_ALTERNATIVE_NO = :TOP_ALTERNATIVE_NO AND A.STRUCTURE_SEQ_NO = :STRUCTURE_SEQ_NO AND A.PROJECT_ID = :PROJECT_ID AND A.ACTIVITY_SEQ = :ACTIVITY_SEQ Rest all settings are the standard settings that we do for a enumeration type of static custom field
Hi @amrflynn, Could you please share the screenshota of the select statement you have written and the setup of the custom field. Thanks, Nilushi Silva this is the select statement -SELECT CASE WHEN (A.AVAILABLE_QTY_ONHAND == A.TOTAL_SIM_DEMAND_QTY) THEN 'TRUE' ELSE 'FALSE' END FROM PART_AVAIL_STRUCTURE_FLAT_OV A WHERE A.TOP_CONTRACT = :TOP_CONTRACT AND A.TOP_PART_NO= :TOP_PART_NOAND A.TOP_ENG_CHG_LEVEL = :TOP_ENG_CHG_LEVEL AND A.TOP_BOM_TYPE = :TOP_BOM_TYPE AND A.TOP_ALTERNATIVE_NO = :TOP_ALTERNATIVE_NO AND A.STRUCTURE_SEQ_NO = :STRUCTURE_SEQ_NO AND A.PROJECT_ID = :PROJECT_ID AND A.ACTIVITY_SEQ = :ACTIVITY_SEQ rest all the setting are standard setting that we do for enumeration type of static custom field
Hi @amrflynn, Could you please share the screenshota of the select statement you have written and the setup of the custom field. Thanks, Nilushi Silva So the SQL statement is like this - SELECT CASE WHEN (A.AVAILABLE_QTY_ONHAND == A.TOTAL_SIM_DEMAND_QTY) THEN 'TRUE' ELSE 'FALSE' END FROM PART_AVAIL_STRUCTURE_FLAT_OV A WHERE A.TOP_CONTRACT = :TOP_CONTRACT AND A.TOP_PART_NO= :TOP_PART_NOAND A.TOP_ENG_CHG_LEVEL = :TOP_ENG_CHG_LEVEL AND A.TOP_BOM_TYPE = :TOP_BOM_TYPE AND A.TOP_ALTERNATIVE_NO = :TOP_ALTERNATIVE_NO AND A.STRUCTURE_SEQ_NO = :STRUCTURE_SEQ_NO AND A.PROJECT_ID = :PROJECT_ID AND A.ACTIVITY_SEQ = :ACTIVITY_SEQ I have included all the key columns here and accordingly filled in the arguments.As for the other setup, please see the attached image For some reason after first attempt the Enumeration text looked like this image below but instead it should have been like Checked State Represents “TRUE and unchecked “False”.-After this It was a standard setup of making field searchable a
To send the output of a SQL based quick report as an excel attachment to an email, i would suggest the following… In IFs Enterprise Explorer, open the “Explore Quick Reports” screen from the navigator Find the report in question, RMB, Export to excel… (If the quick report has filter parameters, enter the applicable data) You can then save the excel file somewhere (e.g. your desktop) then attach it to an email and send it. Hope that helps! I need to do this with the help of a custom event I can do it manually but this is a regular activity so I need to automate it with a custom event any ideas on how we can send excel attached in an email and send it to multiple users daily?
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.