Thomas,That is the ticket. I will add to your answer to make it a bit better:TRUNC(My_Date_column) BETWEEN COALESCE(&absence_period.date_from, add_months(TRUNC(SYSDATE,'MM'), -1)) AND COALESCE(&absence_period.date_to, TRUNC(SYSDATE,'MM')-1) &absence_period.date_to (this is a generic date field, but can use a date field straight from the table and it will use the column name as the prompt for the parameter box.) Doing it this way puts a option box at the end of the parameter box that allows the user to select the date using calendar control. Can use it with NVL also.
Hi Charith,I am using IFS10, but not sure what the update level is. Should be the latest since we have just acquired it (hence the learning curve). I have checked the system parameter that you mentioned and it is not IFSINFO, but when I changed the view to what it is (BELL1INFO)I am still getting the same error.
Charith,Ok, I have created the same IAL as you suggested and used the debugger (for those who don’t see tools, Ctrl+Shift+D will get you there). Here is what I got for the SQL statement in the debugger:select * from &AO.bell1app.ronv_test FETCH NEXT 40 ROWS ONLYand still got the ‘not properly ended’ error in the DS Designer.Just to be thorough I did the following selects (got the same error for all):select order_no from ifsapp.customer_orderselect order_no from &AO.customer_orderselect order_no from Bell1App.customer_order Ron
Yes, thank you for the help. I felt like I was running in circles for this.Ron
Charith,I just realized something, I was using bell1app rather than bell1info. When I put Bell1info into the view, the sql statement in the debugger looks like this:select * from bell1info.ronv_test FETCH NEXT 40 ROWS ONLYwhich looks correct from you answer, but I am getting this error:Instead of the other one. Thanks,RonV
I sure can. So, the bell1info would go in the view area of the data source designer: This is what I have for the IAL and the DS Designer and when I click on the preview I get the error I pasted before. Before instead of Bell1info I was using ifsinfo or bell1app.Data Source Designer IAL
I did not. Missed that step completely. When I do I get the following:when I click ok I get:
I see said the blind man as he picked up his hammer and saw. OK, that is what I was doing wrong. I did not deploy the IAL and I was using the wrong prefixes. I am now getting data in my preview. I did say I was new to IFS correct? Thank you very much for the help and I hope this interaction will help others.Thanks,RonV
Well it is fun discovering things. As well as frustrating when the discovery eludes. Have a good day.Thanks,RonV
I was just overthinking it. Using the “In Use” flag and the Layout Order I was able to make my custom layout be used rather than the native report.
We have not figured out how to do what we wanted, but we did have a method to sort of get to where we wanted. How we did it was by creating a custom menu event to call the report we wanted and taking away permissions away for the IFS Operational Report. So now the users only have our custom report as the option for printing the PO Report.
Malindu Fernando - Thank you for the answer. That did work. I first tried to just install the new version (and it asks to uninstall the old) so thought that might be good enough. It was not. I had to completely uninstall (now the newest version) and reinstall. Then it came up and worked as expected.
We want coordinator from the purchase order to have their org_code displayed. This would be the the authorize_code field from the Purchase_order_line_all view. So if the authorizer/coordinator was JMONTANA from Maintenance, we want to have that org_code displayed on the line with the other data. Something like:This ‘Maint’ org_code is hardcoded so is the same for all lines. This is just for example purposes.The authorize_code from the Purchase_order_line_all view matches up to the person_id in the Company_pers_assign_act view which holds the org_code we want.
Robert,Thank you very much for the help. I had been having no luck figuring that out by myself. I hope you have a wonderful day.Thanks,Ron
Tomas,We have a user defined Payment Method of ‘EMPTY’. That was throwing the same error, though I had that hardcoded and not being pulled from the file. I tried putting EMPTY in the indicated text box and got the following error: Same error when using CHK.Error MessageThanks for the suggestions, Ron
Tomas,Looks like I needed to put in both the Payment Institute and the Payment Method. I worked it down to the bare bones of what was needed, entered payment institute and payment method and was able to upload the data.Thanks for the help, Ron
Tomas,Sorry, I clicked on the wrong reply for answer. Is there a way to remove that and put yours as best?Ron
We had this same problem. We found our problem was due to permissions on the table. Once the permissions were set, then we stopped getting this error.I see you modified the permissions in the ‘Presentation Objects by Component’ Tab. Did you try changing the permissions in the ‘Database Objects’ Tab?
This is not really an answer, but we switched to a line graph and the dates are in the correct order. Until the question gets answered, this might be an acceptable work around.Also, when switching to a line chart, do not use a number in the order by clause of the data source. Use the actual statement. The number worked for the bar chart, but stopped the line chart from rendering.Thanks,Ron
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.
