Hi Fellow IFS Experts, We are facing a weird error with just one of our user who is trying to run a quick report but gets the error in the title of this post.Is there a way to fix it ? the quick report is just running the select * from LEDGER_ITEM3. It has become a pressing issue at this point because our work is hindered.Please help us If you can.
In the leave balance field no value is visible it shows up as blank but actually a value should be there can anyone help me understand why this is happening ?
HI Fellow IFS Experts, I am yet again stuck in a report problem as I have worked on it a handful times. How can we adjust a block/table to go up or down to make space for new elements like in this image below I need to remove the yellow space…. what should I do ? I would really appreciate if someone can help me with this.
Hi Fellow IFS Experts, I am stuck in a problem where I need to schedule a quick report to be sent to a user.i have followed this document to do so - https://docs.ifs.com/techdocs/Foundation1/040_administration/255_br_and_a/005_adhoc_reporting/030_scheduled_quickreports/default.htm#:~:text=be%20checked%20in.-,Schedule%20Quick%20Report,schedule%20an%20Application%20Server%20Task.Strangely I am getting the following error in the application message when the scheduled database task runs the Application Server task I created - Does anyone have any idea what might be causing this ? I am also attaching my appl. server task here -
Is it possible to copy a field called shipment id from collective invoice report to normal invoice report and how ? I havent had the chance to work on reports that often so I could really use some guidance from the experts here
We have created a custom menu that works correctly in english on purchase order screen but when the language changes to polish and we run the menu it gives the error “No version for a given stock item” for example that item is 12345.0000 What could be possibly causing this error ? from the error message it seems like something is missing but I am not sure how to check it.can someone help me ?
in a custom menu that we have designed there is a weird ORA-20110 error coming which says “NO VERSION FOR xxxxx.xxxxx PART”. it only appears in polish version of ifs. Can someone suggest how to fix it ?
getting following error while deleting the selected line.the concerned personnel wants to remove the prepayment connected to customer order which has not been invoiced yet.What might fix this error ?I would request you guys to have a look and chip in your inputs/suggestions.
I was trying to run a custom menu in which po date calculation api is calculating dates upon which I expect the modufy fucntion to modify calculated dates in the PO lines. The issue here is that I got this message even though I did not mess with anything standard can somebody please let me know what I might be doing wrong and how can I fix it ?
Hi Folks, Some customers are unable to recieve invoice in email while the others can… via tha PDF_REPORT_CREATED custom event.I want to know what all setup needs to be done other than setting up custom event action and setting up communication method in Customer Screen.I have looked up everything I could but one customer gets email via that setup and others just don’t.Please help!!! Best Regards,Flynn
Hello Community, Its my first time using the FND_Stream_API and I want to set up an event action that sends a stream message to the creator(a specific user) of Shop Order, everytime someone changes a particular date variable. All I know is that FND Stream API is the way to do it, but can someone please educate me the syntactical stuff so that I can build the script.
I am trying to call an API to calculate date in a custom menu but I think I am doing some syntax error.Can someone please let me know how to put parameters in an API call in IFS ? I saw that in the API definition out of lets say 16 parameters 6 are IN OUT type of parameters so I am putting just the 10 IN type of parameters. Can someone please suggest me what is the right way to do the above mentioned task in terms of syntax and stuff ?
I am trying to call an API to calculate date in a custom menu but I think I am doing some syntax error.Can someone please let me know how to put parameters in an API call in IFS ? I saw that in the API definition out of lets say 16 parameters 6 are IN OUT type of parameters so I am putting just the 10 IN type of parameters. We have got some brilliant IFS minds here so I thought I might take help from the community to get guided to a right path
Hi Folks,I am working on a problem to modify delivery dates for all the PO lines that have same doc ID using below script- declareinfo_ varchar2(4000);n1 varchar2(4000);CURSOR c1 ISSELECT COUNT(ORDER_NO) from PURCHASE_ORDER_LINE_ALL_CFVWHERE CF$_ID_DOCUMENT = &CF$_ID_DOCUMENTAND ORDER_NO = &ORDER_NO;BEGINOPEN c1; FETCH c1 INTO n1;CLOSE c1; FOR l1 IN n1 LOOP PLANNED_DELIVERY_DATE := &PLANNED_DELIVERY_DATE; ifsapp.purchase_order_line_api.Modify__(info_, &OBJID, &OBJVERSION, PLANNED_DELIVERY_DATE, 'DO'); COMMIT; END LOOP;end; now the only problem is that I get the error saying the ORA-06550: line 9, column 241:PLS-00456: item 'N1' is not a cursor. I need to know why am I getting this error this should not be an issue.I already tried using n1 as number in DECLARATION but that didnt solve the issue either.A little guidance or help would be much appreciated.
I am trying to set a True false (checkbox ticked for true condition and not ticked for false condition) type of enumeration based custom field on Multilevel Availability Check Screen in IFS but due to some reason the logic works fine at sql developer it shows value as false for some records and true for some records but in Front end I can see all of it gets ticked even If it is true or falseThis bothers me because I am not able to tell why is this happening, Someone Please give me some insights I am running out of patience. I really hope you understand my situation.This is the query I have written in Custom Field Select Statement -SELECT (CASE WHEN (MULTI_LEVEL_MSG_CONDITION IN ('Available + Open Supply covers Demand','Available covers Demand')) THEN 'TRUE' ELSE 'FALSE' END) "Availability" FROM PART_AVAIL_STRUC1931493261_CFV WHERE TOP_CONTRACT = :TOP_CONTRACT AND TOP_PART_NO = :TOP_PART_NO
I am trying to set up a custom field that is a checkbox which is going to be true if all the checkboxes are true at line level below or it wont get checked in the checkbox if even one of the values at line level has the checkbox unticked(due to line level logic) I tried to set that field as a read only field and wrote below script ( I am using using select statement as Implementation type) - select CASE WHEN((select count(CF$_TEST) from PART_AVAIL_STRUC1931493261_CFV J WHERE CF$_TEST = 'False' AND J.TOP_CONTRACT = :TOP_CONTRACT AND J.TOP_PART_NO = :TOP_PART_NO) > 0) THEN 'FALSE' ELSE 'TRUE' END FROM DUAL Now when I finish the process by selecting field type as enumeration and boolean where enumeration is FndBoolean I get the attached error Can somebody help me understand, where is the issue what I might be doing wrong ?
Hi Fellow Developers, I am trying to create a TRUE FALSE Enum based read only custom field in “Multilevel Availability Check” Screen at line level. The enum I created is a simple custom enumeration of 2 choices True and False. Since the field is read only I have written the Select Statement with a CASE that If a certain 2 column values match return TRUE or FALSE from that case but when I try to finish the field creation I get the error as attached.Can somebody tell me how to fix it ?
I need to send a quick report that I made via email to multiple users. Any Ideas on how to do that ? Can I send it as an excel file ?
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.
