Hi DMThere is no error text message on the posting error screen and that is why I could not locate the problem. The invoice status is printed.
Hi DMThanks for you reply. However I searched for the name POSTING in the debug console text and could not locate it. How are you able to say that there is a posting error. Please let me know. I request IFS to look into this process to improve the error message with the exact column name where there could be error. There are so many issues we are facing in this area and it is taking lot of time since the debug information is enormous and it does not point to the exact column error. I am attaching the complete debug information for you to check and point me which line says that posting error. Thanks a lot for the help .
Hi Jiriwhat I found is that if the salary field is having more than 2 decimals this error happens. For now I am filtering that employee's data from my query. This is just a workaround but honestly I am still not sure how to solve this problem. If some new employee is added with salary information running into more than 2 decimals than my query needs change again.
Hi ChanakaMy query matches yours. I observed some inconsistency in displaying data with the NVL date functionalities. sometimes it displays data by taking the defaults and some times does not. Btw the version you are running is slightly different from the customer version as can be seen above.
Hi ChanakaThanks for the reply. I am not using context substitute variables at all. I am just using simple nvl such as belowI even tried oracle COALESCE function , but that also did not help. WHERE company = nvl('&COMPANY', Company)and HR_BP = nvl('&HR_BP', HR_BP) AND trunc(start_date) > = nvl(to_date('&START_DATE', 'DD/MM/YYYY'), trunc(start_date)) AND trunc(end_date) < = nvl(to_date('&END_DATE', 'DD/MM/YYYY'), trunc(end_date))ORDER BY EMPLOYEE_ID Below is the cloud version I am working
Hi MiLenLI removed the spaces to make it single line code. Unfortunately IAL screen does not display the code so i cannot prove it that is doing as you suggested. Meanwhile regarding BR excel login i tried as you suggested but i get the following error. I can use the same link on EDGE to open the client screens
Hi MiLeNLI tried the LOAD option of the existing IAL by squeezing the long SQL statement into a single line but still the client truncates the code i guess since I cannot see the loaded code, Here is the error i get when I click on DEPLOY. I ran the query in pl/sql to make sure there is no syntax error as seen below. execution is taking long time though. Can you kindly answer the remaining questions i have.Quick report is getting aborted it query exceeds 300 seconds, Need help to know how to give permissions to newly created IAL's in CLOUD. in IFS BUSINESS REPORTER (EXCEL ADD ON) what is the link we have to provide for opening the IFS CLOUD application access. Thanks in advance. Appreciate your guidance
Ok Got it. Thanks I will try this. Appreciate your time and help.
Oh NO my question is you are editing it using notepad++ but coming to re deployment how are you doing it.
Oh OK so you are editing the IAL file using the developer studio not on the cloud (front end screen). Is that correct?
Hi MiLenL Thanks a lot for the clarification and for sharing the document that provides valuable information. I appreciate your help on it. I could not understand the statement you marked on IAL picture that says “For Longer statements edit the file and use the possibility to load it”How to do this? is it possible to show me an example? That would be really helpful to have one single IAL if I understand to fit the large size into one IAL by editing.
Hi TracyThanks for the update. However customer insisted on IAL creations. will you or some one help with the other issues I mentioned above. I also have one more question.How do we provide permission grants to those NEW IAL's that i created for users?. If possible can i request IFS to consider increasing the IAL size to 32000. I think it should not be that difficult to do that. Thanks
Hmm That is interesting but I am sorry I don't have an answer. Let's hope some one from IFS will answer this.
Yes you can add custom fields to standard IFS screens. Here are the steps. Open the screen where you wish to add a custom field (you should be logged in as APPOWNER for allowing users to access those fields) and do RMB , click on Custom objects as shown below
Hi CurtisI solved the problem as explained below. When we create custom fields the system stores the columns alphabetically so i have to redo all the custom fields by adding C1_ before the column name. so in order to display Object_id first I have to rename the feild as C1_Object_id and Fixed asset description as C2_Fixed_asset_description and so on…Then the custom form is updated and it shows as needed. Rest is as explained above.
I have same issue which i resolved as advised above but now the user wants to display the second column first and the description of the first column next. Please advice how to do it. Here is the screen shots. I wish to have object ID display first and then the fixed asset description next. Appreciate the help.
No I am still waiting some one from IFS R&D to help us
Hi ADNANI created a Link List element and one of those had negative Cash value (example -1223939393.90) the lobby does not show the negative values. IFS 10 version. Here is my community forum link which is not solved yet. Appreciate if you can help with this. Link list -VE value not display
Hi CharithThanks for the response but that did not work. The negative number is more than 6 digit size along with two decimals. Here is my testing as per your suggestion. Cash is still not showing anything. I riverted back to 4 *1 but still issue is there
Hi DumeeshaMy page is not a counter but a list. I tried the examples given in the Aurena list elements of IFS examples but the difference is mine is a custom page and my lobby is on the custom page for the list of csr orders based on a criteria. Regards
Hi DumeeshaCan you provide a example of navigating to a page by filtering on a particular column. The IFS documentation is not working . I gave the aurena custom page path(the one you solved in another case) as suggested in the IFS document added $filter MCHCODE example they gave but that just populates all the rows. Thanks
Hi Dumeesha, EntNadeelThanks for the advice. I will check. Regards/Rk
thank you Dumeesha .I will refer it.
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.
