Hi,We have SSO implemented and we run IFS 9 in premises. We upgraded from IFD 7.5 to 9 in November 2017. The IFS team dealing with the upgrade configured IFS for SSO. I don’t think it was a major challenge for them. If you want I can find the name of the person that was in charge of configuring SSO for us in IFS.Mig
Hi, If your projects are connected to the Sales contract Window, then you could create a shortcut using this advanced save search. The user has to enter the Project ID in the pop up window and then the sales contract connected will be retrieved by the shortcut CONTRACT_NO in ( select contract_no from ifsapp.contract_project where project_id = '&Project_Id')
Hi Steve, Many thanks, the deployment went through without errors. I don’t think I understand the rationale of the change though. Please see the main part of my SQL code with the IAL deployed successfully now. I only inserted the &AO.. in the nested API call, not everywhere. Miguel ifsapp.work_sched_assign_api.Get_Day_Sched_Code(COMPANY_ID,EMP_NO,ACCOUNT_DATE) SCHEDULE, NVL(IFSAPP.WORK_SCHED_ASSIGN_API.GET_SCHED_HOURS_DB(COMPANY_ID,EMP_NO,ACCOUNT_DATE,ACCOUNT_DATE),0) SCHED_HOURS, NVL(IFSAPP.TIME_PERS_DIARY_RESULT_API.GET_ABSENCE_HOURS(COMPANY_ID,EMP_NO,ACCOUNT_DATE,ACCOUNT_DATE),0) ABSENCE_HOURS, NVL(IFSAPP.TIME_PERS_DIARY_RESULT_API.GET_WAGE_HOURS(COMPANY_ID,EMP_NO,&AO..Wage_Group_API.Decode('Absemce'),'HOL',null,ACCOUNT_DATE,ACCOUNT_DATE),0) HOL_HOURS, NVL(IFSAPP.TIME_PERS_DIARY_RESULT_API.GET_WAGE_HOURS(COMPANY_ID,EMP_NO,&AO..Wage_Group_API.Decode('Absemce'),'SICK',null,ACCOUNT_DATE,ACCOUNT_DATE),0) SICK_HOURS, NVL(IFSAPP.TIME_PERS_DIARY_RESULT_API.GET_WAGE_
Hi, We have implemented a RMB>custom menu “Expense Sheet Details” from the Project Transactions screen that show the details of the expense sheet (an IFS Quick Report). Best regards Miguel
Hi Piotr. Thank you for your reply to my question. Yes IFS 9. I had count records in PROJECT_RESOURCE_SPREAD_WEEK and the records are 44,058,054 . No we don’t have any configured search domain options on ProjectResourceSpread . Kind regards, Miguel
Hi, Our DBA is checking on this number now. I think this might be related to projects having a long life and the view holding data at week level. I wonder how this view could cope if you are dealing with 100 of projects and trying to use the Resource Forecasting module and multi-company level. We are on UPD6. This amount of records is available in our TEST environment only were I have been testing the Resource Forecasting functionality. Kind regards Miguel
Hi Kevin Thank you for your suggestion. I have run the Direct option to activate the Key and the “eternity bar” is doing its thinking . It might take a while. I will revert back with my findings. Regards Miguel
Hi Kevin, the RowKey has activated ?? I don’t understand, however at least now I can attempt to add custom fields to a related IFS window. I will have to investigate further the size of this table/view. Many thanks for your help
Hi, Thank you for your reply. I have imported your custom menu. Did you see the menu available on a RMB in the race database, please let me know which company in the race database. Unfortunately the RMB>Menu is still not available for me, please see screenshot below. The custom menu is connected and I have ticked the appropriate box in the Properties windows, screenshots below. I have reload the configuration and also logout and login again, however the menu still doesn’t show. Kind regards Miguel
Hi, No it is not an “own process”, please see screenshot below. kind regards Miguel
sorry I should have shown the last part of that screenshot
It will be very useful to have specific information/documentation about IFS securities. We are in the middle of a project, updating IFS 9 from UDP6 to UDP17 and having a data dictionary about new database objects added by the updates will be very useful. A database model is another piece of documentation that could be very useful for reporting purposes. Many thanks Miguel
Hi,Thank you for your reply. Not sure if all the description of my case is showing fully in this portal. I want the chart in the child-lobby to be filtered by 2 parameters, Project_ID and Resource_ID, which are available in the master-lobby.Please see attached documentMany thanksMiguel
Hi,Brilliant !! … much appreciatedthat syntax is very peculiar, I have to say I am not a programmer but I can find my way around. Is there any simple reference material that you could share related to the syntax that you just shared in this case?Many thanksMiguel
Hi, Thank you for your reply. Not sure if all the description of my case is showing fully in this portal. I want the chart in the child-lobby to be filtered by 2 parameters, Project_ID and Resource_ID, which are available in the master-lobby. Please see attached document Many thanks Miguel Just add project ID to the link in URL Address: ifswin:Ifs.Fnd.CompositePageRenderer.PageContainer?page_id=LOBBY_ID&&RESOURCE_ID=$RESOURCE_ID$&&PROJECT_ID=$PROJECT_ID$ Excellent prompt support on this questions about Lobby syntax. It was a straight solution that was very much appreciated.
Thank you for your reply Mathias,Please see screenshot below, I thought the the document class was specified when you create the line in the IFS Windows below?Miguel
I understand that, I am just confused about the sequence of events around creating the repository lines in the first place.I mentioned in my original post that the second step of the wizard does not give me a LOV with our document classes, what do I do about that?Thanks
I will work through the wizard again without creating the line in the repository and I let you now how it goes.Many thanks for your adviceMiguel
Hi,Please see below. I have ignore step 2 of the wizardCould you please confirm that this looks OK?I only have 2 documents in Class APPE that I am happy to move from the Database to the FTP server.Now I get to step 3 however I don’t have steps 4 and 5 available?ThanksMiguel
I am concerned about the first screenshot (page 1/5 of the wizard) now showing the description of the Repository. Certainly I don’t want to move 600 GB worth of documents to the FTP so I must make sure that only the documents in Class APPE are to be movedthanksMiguel
OK, I see the repository description is blank in my settings. However, I need to make sure that only the class specified in APPE_R1 is going to be moved and the Wizard is not showing me much info about number of documents to be moved, etc.Miguel
APPE_R1 is linked to doc class APPE and we have 3 documents in the class as shown below
yes, so they reside in our DATABASE repository, which is in status Generating.I thought the process described would allow me to pull them from the DATABASE repo, obviously I have got that wrong. I am still stuck though, how do I move documents from the DATABASE repo to an FTP repo using the wizard?. It doesn’t look possible to move documents from a repository in status Generating, please see screenshot, only repos in status Usable are available in the first step of the Wizard.Do I have to change the status of the DATABASE repository to usable, is that advisable?ThanksMiguel
OK, I will try that, thank you later today.Please see below from F1, I don’t see any references about how to move documents from the BLOB/Database to an FTP repo and how to deal with the generating and usable status“Use step 1 to move files from one repository to another.If the wizard is launched from the navigator, then it is possible to select which repository to move from and which repository to move to. But if the wizard is launched through a right mouse button operation, it is not possible to select which repository you should move from this will be automatically selected depending on which repository or document class you launch the wizard from. The Move From Repository area has default list of repositories which are in Usablestate. The Move to Repository area has default list of repositories which are in Generating state. When the repository ID is selected, the rest of the values are automatically updated.”
Hi Mathias,I have changed the status of the BLOB repository (Database) to Usable., then save.Then I used the Change Document Repository wizard and I can see the DEFAULT repository as an option on the first section on page 1 of the Wizard.However in the second screenshot you can see how I am not able to select a document CLASS in the DEFAULT repository to be moved to a chosen new repository. There isn’t a list of values with all the classes available in the DEFAULT repository. We do have many document classes in the BLOB.So, I am still not able to move document classes from our BLOB to an FTP server.Could you please advise when you have a minute?Many thanksMiguel
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.
